JDBC 链接Mysql 做了一次查询

import java.sql.*;

public class Select_jdbc {
    public static final String DBDRIVER="org.gjt.mm.mysql.Driver";
    public static final String DBURL="jdbc:mysql://127.0.0.1:3306/shuai";
    public static final String DBUSER="root";
    public static final String DBPASS="root";
    public static void main(String[] args) throws Exception {
        Connection conn=null;//创建数据库连接
        Statement stmt=null;//数据库的操作
        ResultSet rs=null;//保存查询结果
        String sql="SELECT * FROM h_user";
        Class.forName(DBDRIVER);
        conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);//连接数据库时 要写上连接的地址用户名和密码
        stmt=conn.createStatement();//实例化stmt对象
        rs=stmt.executeQuery(sql);//实例化Resultset对象
        while (rs.next()) {
            String id=rs.getString(1);//取得id内容
            String name=rs.getString(2);
            String pass=rs.getString(3);
            String age=rs.getString(4);
            String d=rs.getString(5);
            System.out.print("编号:"+id+" ");
            System.out.print("姓名:"+name+" ");
            System.out.print("密码:"+pass+" ");
            System.out.print("年龄:"+age+" ");
            System.out.println("生日:"+d);
            System.out.println("--------------------");
        }
        rs.close();
        stmt.close();
        conn.close();
    }
}