JDBC连接MySQL8.0.15

mysql8.0.15的jre下载地址:https://dev.mysql.com/downloads/file/?id=484819

package cn.itsorce.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Jdbc {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		//加载数据库驱动
		String driver = "com.mysql.cj.jdbc.Driver";
		// 获取mysql连接地址
		String url = "jdbc:mysql://localhost:3306/myjava?useSSL=false&serverTimezone=UTC";
		// 数据库用户名
		String username = "root";
		//	数据库密码
		String password = "12345678";
		// 获取一个数据连接
		Connection conn = null;
		
		try {
			Class.forName(driver);
			// 连接mysql数据库
			conn = DriverManager.getConnection(url, username, password);
			if (!conn.isClosed()) {
				System.out.println("连接成功!");
			}
			
			Statement statement = conn.createStatement();
			String sql = "select * from product";
			
			ResultSet resultSet = statement.executeQuery(sql);
			while(resultSet.next()){
				String id = resultSet.getString("id");
				String name = resultSet.getString("productName");
				System.out.println(id + "   " + name);
			}
			resultSet.close();
			conn.close();
			
			
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			System.out.println("数据库驱动加载失败! 请检查mysql connect包是否导入");
			e.printStackTrace();
		}catch (SQLException e) {
			// TODO Auto-generated catch block
			// 数据库连接异常
			e.printStackTrace();
		}finally{
			System.out.println("数据库数据获取成功!");
		}
		
		
	}


}