import java.sql.*;
public class DBConnection {
// 联接数据库的驱动程序,缺省值
private String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
// 联接数据库的URL,缺省值
private String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=×××";
// 联接数据库的用户与口令
private String user = "sa";
private String password = "sa";
public DBConnection() throws Exception {
// 装载驱动程序
Class.forName(driverName).newInstance();
}
public Connection getConnection() throws Exception {
return DriverManager.getConnection(url, user, password);
}
/**
* 用于测试连接的主函数
* @param args
* @throws Exception
*/
public static void main(String[] args) throws Exception {
DBConnection dbconnection = new DBConnection();
dbconnection.getConnection();
System.out.println("Connection OK!");
}
}