executeQuery() 查询结果为什么要用rs.next()

在执行

ResultSet rs = ps.executeQuery();

后 报错：

java.sql.SQLException: Before start of result set
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)

但是加上 re.next()之后就可以使用 这是为什么呢？

java.sql

Interface ResultSet

boolean

Method Detail

next

public boolean next()

throws SQLException

Moves the cursor down one row from its current position. A ResultSet cursor is initially positioned before the first row; the first call to the method next makes the first row the current row; the second call makes the second row the current row, and so on.

If an input stream is open for the current row, a call to the method next will implicitly close it. A ResultSet object's warning chain is cleared when a new row is read.

Returns:

true if the new current row is valid; false if there are no more rows

Throws:

原因是执行完ResultSet rs = ps.executeQuery();后光标并没有指向数据栏！