Javaweb12——JDBC02演示Select

package com.jdbc.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class SelectCommand {
    public static void main(String[] args) throws Exception{
        String sql = "SELECT * FROM dept";
        String url = "jdbc:mysql://localhost:3306/test?useSSL=false";

        Class.forName("com.mysql.jdbc.Driver");

        Connection con = DriverManager.getConnection(url,"root","douqiyuan");

        PreparedStatement ps = con.prepareStatement("");

        //返回的是临时表时 使用ResultSet接口 并且使用PreparedStatement的executeQuery方法而非executeUpdate方法
        ResultSet res = ps.executeQuery(sql);

        //读取数据行
        while (res.next()) {
            int DEPTNO = res.getInt("DEPTNO");
            String DNAME = res.getString("DNAME");
            String LOC = res.getString("LOC");
            System.out.println("部门编号:"+DEPTNO+",部门名称:"+DNAME+",部门地址:"+LOC);
        }
        //System.out.println(res);   这条语句如果有会输出res的内存地址
        if(res != null) {
            res.close();
        }
        if(ps != null) {
            ps.close();
        }
        if(con != null) {
            con.close();
        }

    }
}