JDBC2 查询数据

public class JDBCUtil {
    private static String url = "jdbc:mysql://localhost:3306/db-test";
    private static String user = "root";
    private static String password = "root";

    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        //1、加载驱动（可以省略）
        Class.forName("com.mysql.cj.jdbc.Driver");
        //2、获取连接Connection
        Connection conn = DriverManager.getConnection(url, user, password);
        //3、获取Statement对象
        Statement stmt = conn.createStatement();
        //4、执行SQL语句并处理结果
        String sql="select * from tb_book";
        //rs表示从数据库中查询到的数据的集合，它有一个默认指向第一条数据之前的指针
        ResultSet rs = stmt.executeQuery(sql);
        //rs.next():指针向下移动一行，并判断该行是否有数据，有则返回true，没有返回false
        while (rs.next()){
            int id = rs.getInt("id");
            System.out.print(id+"\t");
            String name = rs.getString("name");
            System.out.print(name+"\t");
            String author = rs.getString("author");
            System.out.print(author+"\t");
            Date birth = rs.getDate("birth");
            System.out.print(birth+"\t");
            BigDecimal price = rs.getBigDecimal("price");
            System.out.println(price);
        }

        //5、释放资源（释放顺序与创建顺序相反）

        try {//try-catch-finally
            if (rs != null) {
                rs.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (stmt != null) {
                    stmt.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                try {
                    if(conn !=null){
                        conn.close();
                    }
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
    }