在执行
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();后光标并没有指向数据栏!