当MySQL的版本超过6及以上是使用jdbc链接数据库的URL

当MySQL的版本超过6及以上是使用jdbc链接数据库的URL

package com.linruozhuo.jdbc;

import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

import org.junit.Test;

import com.mysql.jdbc.Driver;


public class TestJavaJdbc {

	@Test
	public void test() throws SQLException {
		Driver driver  = new Driver();
		
		String url = "jdbc:mysql://localhost:3306/goods";
		
		Properties properties = new Properties();
		
		properties.put("user", "root");
		properties.put("password", "123456");
		
		Connection connect = driver.connect(url,properties);
		
		System.out.println(connect);
	}
	
	public Connection getConnect() throws Exception {
		String driverClass = null;
		String url = null;
		String user = null;
		String password = null;
		
		InputStream inputStream = getClass().getClassLoader().getResourceAsStream("jdbc.properties");
		
		Properties properties = new Properties();
		properties.load(inputStream);
		driverClass = properties.getProperty("driver");
		url = properties.getProperty("url");
		user = properties.getProperty("user");
		password = properties.getProperty("password");
		
		Properties info = new Properties();
		info.put("user", user);
		info.put("password", password);
		
//      一下两种都可以获得驱动链接	
//		Class.forName(driverClass);
//		Connection connection = DriverManager.getConnection(url, user, password);
		com.mysql.cj.jdbc.Driver driver = (com.mysql.cj.jdbc.Driver) Class.forName(driverClass).newInstance();
		Connection connection = driver.connect(url, info);
		
		return connection;
		
	}
	@Test
	public void testGetConnection() throws Exception {
		System.out.println(getConnect());
	}

	
}

下面是jdbc.properties文件
请注意driver的写法

driver = com.mysql.cj.jdbc.Driver
//driver = com.mysql.jdbc.Driver(低版本使用这样的)
//下面的URL加上了时区serverTimezone：中国的有两个表示：Asia/Shanghai或者Asia/Hongkong
url = jdbc:mysql://127.0.0.1:3306/YOU-DATANAME?characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&useSSL=false&allowPublicKeyRetrieval=true
user = root
password = 123456