结果集是仅前进的。如果要导航回第一条记录,则需要创建
可滚动的结果集 。
// Create a scrollable result setStatement stmt = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);ResultSet resultSet = stmt.executeQuery("SELECt * FROM my_table");// Move cursor forwardwhile (resultSet.next()) { // Get data at cursor String s = resultSet.getString(1);}// Move cursor backwardwhile (resultSet.previous()) { // Get data at cursor String s = resultSet.getString(1);}// Move cursor before first recordresultSet.beforeFirst(); //required statement in this case


