IDEA使用JDBC连接MySQL数据库

import java.sql.*;

public class db {
    public static void main(String[] args) throws Exception{
        //加载数据库驱动程序
        try{
            Class.forName("com.mysql.cj.jdbc.Driver");
        }catch (ClassNotFoundException cne){
            cne.printStackTrace();
        }
        String dburl = "jdbc:mysql://127.0.0.1:3306/movie?&useSSL=false&serverTimezone=UTC";
        String sql = "SELECT * FROM admin";
        try(    Connection conn = DriverManager.getConnection(dburl,"root","123456");
                Statement stmt = conn.createStatement();
                ResultSet rst = stmt.executeQuery(sql)) //执行sql

        {
            while (rst.next()){
                System.out.println(rst.getInt(1)+"\t"+
                        rst.getString(2)+"\t"+rst.getString(3)+
                        "\t"+rst.getFloat(4) + "\t" + rst.getInt(5)
                );
            }

        }catch (SQLException se){
            se.printStackTrace();
        }

    }
}

IDEA使用JDBC连接MySQL数据库详细教程