用IP与Port建立与SQLSERVER的连接

发布时间：2020-12-12 12:46:13 所属栏目：MsSql教程来源：网络整理

导读：package?jsp; import?java.sql.*;?//?JDBC?package public?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?here String?password?="";?//?use?your?

package?jsp;
import?java.sql.*;?//?JDBC?package
public?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?here
String?password?="";?//?use?your?password?here
public?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;
}

关注微信号：javalearns ?随时随地学Java

或扫一扫

随时随地学Java

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!