Python语言技术文档

微信小程序技术文档

php语言技术文档

jsp语言技术文档

asp语言技术文档

C#/.NET语言技术文档

html5/css技术文档

javascript

点击排行

您现在的位置:首页 > 技术文档 > jsp技巧

以IP与Port建立与SQLSERVER的连接

来源:中文源码网    浏览:341 次    日期:2024-03-28 17:39:40
【下载文档:  以IP与Port建立与SQLSERVER的连接.txt 】


以IP与Port建立与SQLSERVER的连接
package jsp;import java.sql.*; // JDBC packagepublic class sql_data {String url = "jdbc:inetdae:192.168.2.70?sql7=true"; // use your hostname and port number String login = "sa"; // use your login hereString password =""; // use your password herepublic Connection connection = null;public Statement st = null;public ResultSet rs = null;public sql_data(){try {Class.forName("com.inet.tds.TdsDriver").newInstance(); DriverManager.setLoginTimeout(10);} catch(Exception e) {e.printStackTrace();}}public void sqlclose() {try { st.close();connection.close();}catch(SQLException ex) { System.err.println("sqlclose: " + ex.getMessage());}}public ResultSet executeQuery(String sql) { try {connection = DriverManager.getConnection(url,login,password);connection.setCatalog( "register");st = connection.createStatement();rs = st.executeQuery(sql);} catch(SQLException ex) { System.err.println("aq.executeQuery: " + ex.getMessage());}return rs;}}

相关内容