SQL数据库连接代码

public class TestDBConn {
public Connection conn(){
String driverClassName=
"com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url="jdbc:sqlserver//localhost:1433;databaseName=TestData";
String user1="sa";
String password="123456";
Connection conn=null;
try {
Class.forName(driverClassName);
} catch (ClassNotFoundException e) {
System.out.println("链接错误!!!");
}
try {
conn=DriverManager.getConnection(url, user1, password);
} catch (SQLException e) {
System.out.println("链接失败!!!");
}
return conn;
}

}

相关文档
最新文档