编写JDBC程序实现数据库查询

//编写JDBC程序实现数据库查询
package qqq;
import java.sql.*;
public class Example01 {
    public static void main(String args[]) {
        Statement stmt = null;
        ResultSet rs = null;
        Connection conn = null;

        try {
            //1.注册数据库驱动
            /* Driver driver = new Driver();
            DriverManager.registerDriver(driver);*/
            Class.forName("com.mysql.jdbc.Driver");
            //2、获取链接对象
            String url = "jdbc:mysql://localhost:3306/jdbc";
            String username = "root";
            String password = "root";
            conn = DriverManager.getConnection(url, username, password);
            //3、获取操作数据库对象
            stmt = conn.createStatement();
            //4、向数据库发送查询语句
            String sql = "select * from users";
            rs = stmt.executeQuery(sql);
            //5、遍历结果集，获取查询数据
            while (rs.next()) {
                //跳转到下一行，某一行的值遍历完毕后会跳到下一行
                int id = rs.getInt(1);//getInt("id")
                String name = rs.getString("name");
                String psw = rs.getString(3);
                String email = rs.getString(4);
                Date date = rs.getDate(5);
                System.out.println(id + " " + name + " " + psw + " " + email + " " + date);
            }
        } catch (Exception e) {
            throw new RuntimeException(e);
            } finally {
            //关闭链接
            if (rs != null) {
                try {
                    rs.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                rs=null;
            }

            if (stmt != null) {
                try {
                    stmt.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                stmt=null;
            }

            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                conn=null;
            }
        }
    }
}

数据库页面

运行结果