以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;}}