JDBC 连接MySQL8.0数据库

首先先导入MySQL驱动 mysql-connector-java-8.0.11.jar

mysql-connector-java-8.0.11.jar下载

解压后打开

	@Test
	public void connection5() throws Exception{
		
		//1.读取配置文件中的4个基本信息
		InputStream is = ConnectionTest.class.getClassLoader().getResourceAsStream("jdbc.properties");
  //或       FileInputStream is = new FileInputStream(new File("src/jdbc.properties"));
		
		Properties pros = new Properties();
		pros.load(is);
		
		String user = pros.getProperty("user");
		String password = pros.getProperty("password");
		String url = pros.getProperty("url");
		String driverClass = pros.getProperty("driverClass");
		
		//2.加载驱动
		Class.forName(driverClass);
		
		//3.获取连接
		Connection conn = DriverManager.getConnection(url,user,password);
		System.out.println(conn);
		
	}

其中，配置文件声明在工程的src目录下：【jdbc.properties】

user=root
password=123456
url=jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=Asia/Shanghai
driverClass=com.mysql.cj.jdbc.Driver

方式二

	@Test
	public void connection() throws SQLException {
		
		Driver driver = new com.mysql.cj.jdbc.Driver();
		
		String url ="jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=Asia/Shanghai";
		Properties info = new Properties();
		info.setProperty("user", "root");
		info.setProperty("password", "123456");
		
		Connection conn = driver.connect(url,info);
		
		System.out.println(conn);
		
	}

注：这里连接的是test数据库