废话不说,代码如下:
public class ConnectionDB {
/**
* 连接数据库
* @return
*/
public static Connection connectDB() {
//驱动程序名
String driver = "com.mysql.jdbc.Driver";
//Oracle:String driver = "oracle.jdbc.driver.OracleDriver";
//SQLServer:String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
// URL指向要访问的数据库名
String url = "jdbc:mysql://127.0.0.1:3306/student";
//Oracle:String url = "jdbc:oracle:thin:@127.0.0.1:1521:数据库名";
//SQLServer:String url = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=数据库名";
// MySQL配置时的用户名
String user = "root";
// MySQL配置时的密码
String password = "root";
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, password);
return conn;
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
}