自用！！！JDBC连接mysql8.0以上版本

package com.jdbc;import com.mysql.cj.jdbc.Driver;import java.sql.*;public class Jdbc {public static void main(String[] args) throws ClassNotFoundException, SQLException {//1、加载驱动try {Class.forName("com.mysql.cj.jdbc.Driver");//现在使用这种方式来加载驱动&＃xff0c;Class.forName反射里常用到} catch (ClassNotFoundException e) {e.printStackTrace();}//2、用户信息和UrlString url &＃61; "jdbc:mysql://localhost:3306/jdbcstudy?useUnicode&＃61;true&characterEncoding&＃61;utf8&useSSL&＃61;false&serverTimezone&＃61;GMT%2B8";String username &＃61; "root";String password &＃61; "110221";//3、连接成功&＃xff0c;数据库对象Connection connection &＃61; DriverManager.getConnection(url, username, password);//4、执行SQL对象Statement statement &＃61; connection.createStatement();//5、执行SQL的对象 去执行SQL&＃xff0c;可能存在结果&＃xff0c;查看返回结果String sql &＃61; "SELECT * FROM users";ResultSet resultSet &＃61; statement.executeQuery(sql);while (resultSet.next()){System.out.println("id &＃61; "&＃43;resultSet.getObject("id"));System.out.println("name &＃61; "&＃43;resultSet.getObject("NAME"));System.out.println("pwd &＃61; "&＃43;resultSet.getObject("password"));System.out.println("email &＃61; "&＃43;resultSet.getObject("email"));System.out.println("birthday &＃61; "&＃43;resultSet.getObject("birthday"));}//6、释放连接resultSet.close();statement.close();connection.close();}
}