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))
{
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数据库详细教程