时间: 2021-07-31 作者:daque
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;}}