错误原因:未指定行
错误代码:
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();
}
}