@Override public int getRow() throws SQLException { return rs.getRow(); }
@Override public int getRow() throws SQLException { return delegate.getRow(); }
/** * @see java.sql.ResultSet#getRow() */ @Override public int getRow() throws InvalidResultSetAccessException { try { return this.resultSet.getRow(); } catch (SQLException se) { throw new InvalidResultSetAccessException(se); } }
@Override public int getRow() throws SQLException { try { return rs.getRow(); } catch (Throwable t) { throw checkException(t); } }
ResultSet rs = ps.executeQuery(); int rowcount = 0; if (rs.last()) { rowcount = rs.getRow(); rs.beforeFirst(); // not rs.first() because the rs.next() below will move on, missing the first element } while (rs.next()) { // do your standard per row stuff }
@Override public void run() throws Exception { rs.getRow(); } });
/** * Check the result set is in sync with the currentRow attribute. This is * important to ensure that the user hasn't modified the current row. */ private void verifyCursorPosition(long expectedCurrentRow) throws SQLException { if (verifyCursorPosition) { if (expectedCurrentRow != this.rs.getRow()) { throw new InvalidDataAccessResourceUsageException("Unexpected cursor position change."); } } }
private int getRowCount(ResultSet resultSet) { if (resultSet == null) { return 0; } try { resultSet.last(); return resultSet.getRow(); } catch (SQLException exp) { exp.printStackTrace(); } finally { try { resultSet.beforeFirst(); } catch (SQLException exp) { exp.printStackTrace(); } } return 0; }
/** * Try to obtain the current size of the specified {@link ResultSet} by jumping to the last row * and getting the row number. * * @param rs * the {@link ResultSet} to get the size for * @return the size, or -1 if it could not be obtained */ int getSize(ResultSet rs) { try { if (rs.getType() == rs.TYPE_FORWARD_ONLY) { return -1; } rs.last(); int total = rs.getRow(); rs.beforeFirst(); return total; } catch (SQLException sqle) { return -1; } // JDBC 1 driver error catch (AbstractMethodError ame) { return -1; } }
@Override public int getRowNumber() throws HibernateException { try { return getResultSet().getRow() - 1; } catch (SQLException sqle) { throw convert( sqle, "exception calling getRow()" ); } }
@Override public int resultSet_getRow(ResultSetProxy rs) throws SQLException { if (this.pos < filterSize) { return nextFilter() .resultSet_getRow(this, rs); } return rs.getResultSetRaw() .getRow(); }
@Override public Memory key(Environment env, Memory... args) { try { return resultSet != null ? LongMemory.valueOf(resultSet.getRow() - 1) : Memory.NULL; } catch (SQLException e) { throw new WrapSqlException(env, e); } }
@Test public void test_getRow_isOneBased() throws Exception { Connection connection = connect(); Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery( "VALUES (1), (2)" ); // Expect 0 when before first row: assertThat( "getRow() before first next()", resultSet.getRow(), equalTo( 0 ) ); resultSet.next(); // Expect 1 at first row: assertThat( "getRow() at first row", resultSet.getRow(), equalTo( 1 ) ); resultSet.next(); // Expect 2 at second row: assertThat( "getRow() at second row", resultSet.getRow(), equalTo( 2 ) ); resultSet.next(); // Expect 0 again when after last row: assertThat( "getRow() after last row", resultSet.getRow(), equalTo( 0 ) ); resultSet.next(); assertThat( "getRow() after last row", resultSet.getRow(), equalTo( 0 ) ); }
buff.append("<td>"). append("<img onclick=\"javascript:editRow("). append(rs.getRow()). append(",'${sessionId}', '${text.resultEdit.save}', " + "'${text.resultEdit.cancel}'"). "title=\"${text.resultEdit.edit}\" border=\"1\"/>"). append("<img onclick=\"javascript:deleteRow("). append(rs.getRow()). append(",'${sessionId}', '${text.resultEdit.delete}', " + "'${text.resultEdit.cancel}'").
int row=resultSet.getRow(); log.error("%s: failed deserializing row %d: %s; removing it from the table", local_addr, row, e); try {
@Override public int getRow() throws SQLException { return innerResultSet.getRow(); }
/** * @throws Exception If failed. */ @Test public void testNavigation() throws Exception { ResultSet rs = stmt.executeQuery("select * from TestObject where id > 0"); assert rs.isBeforeFirst(); assert !rs.isAfterLast(); assert !rs.isFirst(); assert !rs.isLast(); assert rs.getRow() == 0; assert rs.next(); assert !rs.isBeforeFirst(); assert !rs.isAfterLast(); assert rs.isFirst(); assert !rs.isLast(); assert rs.getRow() == 1; assert rs.next(); assert !rs.isBeforeFirst(); assert !rs.isAfterLast(); assert !rs.isFirst(); assert rs.isLast(); assert rs.getRow() == 2; assert !rs.next(); assert !rs.isBeforeFirst(); assert rs.isAfterLast(); assert !rs.isFirst(); assert !rs.isLast(); assert rs.getRow() == 0; }
int rowCount = rs.getRow(); LoopScope ls = LoopScope.eval(pager, rowCount); if (rs.absolute(ls.start + 1))
assertFalse(rs.isFirst()); assertFalse(rs.isLast()); assertEquals(0, rs.getRow()); assertTrue(rs.isFirst()); assertFalse(rs.isLast()); assertEquals(1, rs.getRow()); assertFalse(rs.isFirst()); assertFalse(rs.isLast()); assertEquals(2, rs.getRow()); assertFalse(rs.isFirst()); assertTrue(rs.isLast()); assertEquals(3, rs.getRow()); assertFalse(rs.isFirst()); assertFalse(rs.isLast()); assertEquals(0, rs.getRow());