package学生信息管理系统;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;/***数据库链接测试*@authorDimple**/publicclass连接{Connectionco...
package 学生信息管理系统;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
* 数据库链接测试
* @author Dimple
*
*/
public class 连接 {
Connection connection;
static {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
System.out.println("数据库加载成功!");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
Connection getConn(){
String url="jdbc:sqlserver://localhost:1433;DatabaseName=sstudent";
String userName="sa";
String passWord="123456";
try {
connection=DriverManager.getConnection(url,userName,passWord);
if (connection!=null) {
System.out.println("链接成功!");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return connection;
}
public static void main(String[] args) {
Test test=new Test();
Connection con=test.getConn();
try {
System.out.println(con.getCatalog());
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
展开