query .java ~~~ package zyw.crud; import java.sql.*; public class query { public static void main(String[] args) throws SQLException, ClassNotFoundException { // 1、注册数据库的驱动 Class.forName("com.mysql.jdbc.Driver"); // 2.获取数据库连接 String url="jdbc:mysql://122.14.200.136:3306/javadb"; Connection connection = DriverManager.getConnection(url, "root", "6a133f0024"); //3.获取操作数据库的对象 Statement statement= connection.createStatement(); String sql = "select * from xuesheng"; ResultSet resultSet=statement.executeQuery(sql); //4.遍历结果集，取出数据 while (resultSet.next()){ String name=resultSet.getString("xingming"); Integer age=resultSet.getInt("nianling"); System.out.println("姓名："+name+"年龄："+age); } //5.关闭对象 resultSet.close(); statement.close(); connection.close(); } } ~~~