【JDBC】用Java连接MySQL，并遍历打印结果集时，出现错误：Before start of result set

错误原因：未指定行

错误代码：

import java.sql.*;

public class Test {
    private static String mysqlURL = "jdbc:mysql://localhost:3306/test?useSSL=false";
    private static String user = "root";
    private static String passwd = "123456";
    private static Connection connection;
    private static Statement statement;
    public static void main(String[] args) throws SQLException, ClassNotFoundException {
        Class.forName("com.mysql.jdbc.Driver");
        connection = DriverManager.getConnection(mysqlURL, user, passwd);
        statement = connection.createStatement();
        String sql = "SELECT * FROM tale LIMIT 10";
        ResultSet resultSet = statement.executeQuery(sql);
        do {
            System.out.println(resultSet.getString(4));
        }while (resultSet.next());
        connection.close();
    }
}

解决方式：在do while遍历之前，加入resultSet.first()

import java.sql.*;

public class Test {
    private static String mysqlURL = "jdbc:mysql://localhost:3306/test?useSSL=false";
    private static String user = "root";
    private static String passwd = "123456";
    private static Connection connection;
    private static Statement statement;
    public static void main(String[] args) throws SQLException, ClassNotFoundException {
        Class.forName("com.mysql.jdbc.Driver");
        connection = DriverManager.getConnection(mysqlURL, user, passwd);
        statement = connection.createStatement();
        String sql = "SELECT * FROM tale LIMIT 10";
        ResultSet resultSet = statement.executeQuery(sql);
        resultSet.first();
        do {
            System.out.println(resultSet.getString(4));
        }while (resultSet.next());
        connection.close();
    }
}