packagejsp;
importjava.sql.*;//JDBCpackage
publicclasssql_data{
Stringurl="jdbc:inetdae:192.168.2.70?sql7=true";//useyourhostnameandportnumber
Stringlogin="sa";//useyourloginhere
Stringpassword="";//useyourpasswordhere
publicConnectionconnection=null;
publicStatementst=null;
publicResultSetrs=null;
publicsql_data(){
try{
Class.forName("com.inet.tds.TdsDriver").newInstance();
DriverManager.setLoginTimeout(10);
}catch(Exceptione){
e.printStackTrace();
}
}
publicvoidsqlclose(){
try{
st.close();
connection.close();
}
catch(SQLExceptionex){
System.err.println("sqlclose:"+ex.getMessage());
}
}
publicResultSetexecuteQuery(Stringsql){
try{
connection=DriverManager.getConnection(url,login,password);
connection.setCatalog("register");
st=connection.createStatement();
rs=st.executeQuery(sql);
}
catch(SQLExceptionex){
System.err.println("aq.executeQuery:"+ex.getMessage());
}
returnrs;
}
}
【以IP与Port建立与SQLSERVER的连接】相关文章：
★ JSP内置对象:Request和Response的简单介绍及使用
★ jsp连接MySQL操作GIS地图数据实现添加point的功能代码