java获取Mysql连接

四、获取连接

1. 完整写法

• 按照以上的逻辑我们可以写出如下的代码：

@Test
public void testConnection1() throws Exception{
   //1.数据库连接的4个基本要素：
   String url = "jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai";
   String user = "root";
   String password = "root";
   //8.0之后名字改了  com.mysql.cj.jdbc.Driver
   String driverName = "com.mysql.cj.jdbc.Driver";

   //2.实例化Driver
   Class clazz = Class.forName(driverName);
   Driver driver = (Driver) clazz.newInstance();
   //3.注册驱动
   DriverManager.registerDriver(driver);
   //4.获取连接
   Connection conn = DriverManager.getConnection(url, user, password);
   System.out.println(conn);
}