JDBC中的ResultSet结果集详解

遍历结果集（游标）获取记录；

import java.sql.*;

public class ResultSetDemo {
    public static void main(String[] args) throws SQLException {
        Connection con = null;
        Statement statement = null;
        ResultSet res =null;
        try {
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/db1", "root", "admin");
            String sql = "select * from account";
            statement = con.createStatement();
            res = statement.executeQuery(sql);

//            if(res.next()){
//                res.next();
//                System.out.println(res.getInt(1));
//                System.out.println(res.getString("name"));
//                System.out.println(res.getInt(3));
//            }
            //循环判断结果集是否有下一行，获取数据
            //循环判断游标是否是最后一行末尾，如果不是就进入while循环获取数据并打印数据，
            while (res.next()){
                System.ou