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(); } } ~~~