首先建立工程,之后建立student包
package student;
import java.sql.*;
public class Connect {
static public Connection getconn() {
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=student";//1433在sql的配置管理器中设置
String userName = "sa";//sql身份验证需要设置为SQL Server 身份验证
String userPwd = "123456";
Connection db = null;
try {
Class.forName(driverName);
System.out.println("加载驱动成功!");
} catch (Exception e) {
e.printStackTrace();
System.out.println("加载驱动失败!");
}
try {
db = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("连接数据库成功!");
} catch (Exception e) {
e.printStackTrace();
System.out.print("SQL Server连接失败!");
}
return db;
}
}