ider 与 MySQL数据库的连接

package com.company;

import java.sql.*;

public class TestJDBCPro {
    //1.加载驱动
    //2.建立数据库连接
    //3.发送SQL
    //4.执行SQL语句并且把结果返回
    //5.关闭资源

    private Connection connection;
    private Statement statement;
    private ResultSet resultSet;

    //对Connection,Statement,ResultSet 进行声明处理

    public static void main(String[] args) throws SQLException, ClassNotFoundException {
        new TestJDBCPro().query();
    }


    public void query() throws ClassNotFoundException, SQLException {
        //目的：执行查询语句
        String sql = "SELECT `id`,`name`,`age` FROM stu;";
        //在编程中尽量减少*的使用
        Class.forName("com.mysql.cj.jdbc.Driver");
        connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc?useSSL=false&serverTimezone=UTC","root","123456");
        //注意：连接数据库端口号，如果有报错。观察报错的问题，极大概率会出现时区问题；
        statement = connection.createStatement();
        //发送数据到数据库
        resultSet = statement.executeQuery(sql);
        //返回当前页面
        while (resultSet.next()) {
            int id = resultSet.getInt("id");
            String name = resultSet.getString("name");
            int age = resultSet.getInt("age");

            //打印输出语句
            System.out.println(id+" "+name+" "+age);
        }

        resultSet.close();
        statement.close();
        connection.close();
    }
}