第十一章 JDBC与MySQL数据库(4)——查询操作之顺序查询

import java.sql.*;
public class Example1 {
  public static void main(String[] args) {
    System.out.println();
    Connection con = null;
    Statement sql;
    ResultSet rs;
    try {
      Class.forName("com.mysql.jdbc.Driver");   //加载JDBC-MySQL驱动
    }
    catch (Exception e) {}
    String uri = "jdbc:mysql://localhost:3306/students?useSSL=true";
    String user = "root";
    String password = "";
    try {
      con = DriverManager.getConnection(uri, user, password);  //连接代码
    }
    catch (SQLException e) {}
    try {
      sql = con.createStatement();
      rs=sql.executeQuery("SELECT * FROM mess");  //查询mess表
      while(rs.next()) {
        String number = rs.getString(1);
        String name = rs.getString(2);
        Date date = rs.getDate(3);
        float height = rs.getFloat(4);
        System.out.printf("%s\t",number);
        System.out.printf("%s\t",name);
        System.out.printf("%s\t",date);
        System.out.printf("%.2f\n",height);
      }
      con.close();     //关闭连接
    }
    catch(SQLException e) {
      System.out.println(e);
    }
  }
}