不需odbc可由ip地址与端口号建立与sqlserver的连接.txt

来自「Java技术大合集,所有常用的技术在里面都有简单例子」· 文本 代码 · 共 63 行

作者：jspfuns
日期：2000-8-9 11:30:11
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 here
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);

// connection = DriverManager.getConnection(url,login,password);

// DatabaseMetaData conMD = connection.getMetaData();

// connection.setCatalog( "register");

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