在获取连接对象的三种方式中,我使用的是8.0版本的数据库,
因此在注册驱动是的文件路劲为:com.mysql.cj.jdbc.Driver;
DriverManager获取连接数据库对象为:
“jdbc:mysql://localhost:3306/db3 “+”?useSSL=false&serverTimezone=UTC&characterEncoding=utf8”;
package com;
import org.junit.Test;
import java.io.BufferedInputStream;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;
public class Hello1 {
@Test //入门案例--获取连接对象方式3
public void fun3(){
try {
//1.注册驱动 Driver
Class.forName("com.mysql.cj.jdbc.Driver");
//2.DriverManager获取连接数据库对象
String url = "jdbc:mysql://localhost:3306/db3 " +
"?useSSL=false&serverTimezone=UTC&characterEncoding=utf8";
//3.使用类加载器加载jabc.properties文件,返回一个字节流,和Properties关联在一起
InputStream is = Hello1.class.getClassLoader().getResourceAsStream("jdbc.properties");
/*FileInputStream f = new FileInputStream("jdbc.properties");*/
Properties p = new Properties();
p.load(is);
Connection con = DriverManager.getConnection(url,p);
System.out.println(con);
} catch (Exception e) {
e.printStackTrace();
}
}
@Test //入门案例--获取连接对象方式2
public void fun2(){
try {
//1.注册驱动 Driver
Class.forName("com.mysql.cj.jdbc.Driver");
//2.DriverManager获取连接数据库对象
String url = "jdbc:mysql://localhost:3306/db3 " +
"?useSSL=false&serverTimezone=UTC&characterEncoding=utf8";
//3.创建Properties对象,关联用户名和密码
Properties p = new Properties();
p.setProperty("user","root");
p.setProperty("password","123456");
Connection con = DriverManager.getConnection(url, p);
System.out.println(con);
} catch (Exception e) {
e.printStackTrace();
}
}
@Test //入门案例--获取连接对象方式1
public void fun1(){
try {
//1.注册驱动 Driver
Class.forName("com.mysql.cj.jdbc.Driver");
//2.DriverManager获取连接数据库对象
String url = "jdbc:mysql://localhost:3306/db3 " +
"?useSSL=false&serverTimezone=UTC&characterEncoding=utf8";
Connection con = DriverManager.getConnection(url, "root", "123456");
System.out.println(con);
} catch (Exception e) {
e.printStackTrace();
}
}
}