@Override public void beforeFirst() throws SQLException { rs.beforeFirst(); }
@Override public void beforeFirst() throws SQLException { delegate.beforeFirst(); }
/** * @see java.sql.ResultSet#beforeFirst() */ @Override public void beforeFirst() throws InvalidResultSetAccessException { try { this.resultSet.beforeFirst(); } catch (SQLException se) { throw new InvalidResultSetAccessException(se); } }
@Override public void beforeFirst() throws SQLException { try { rs.beforeFirst(); } 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.beforeFirst(); } });
private int[] findMaxLength(ResultSet resultSet) throws SQLException { ResultSetMetaData rsmd = resultSet.getMetaData(); int columnCount = rsmd.getColumnCount(); int[] columnSizes = new int[columnCount + 1]; for (int i = 1; i <= columnCount; i++) { columnSizes[i] = Math.max(columnSizes[i], rsmd.getColumnLabel(i).length()); } while (resultSet.next()) { for (int i = 1; i <= columnCount; i++) { String value = resultSet.getString(i); if (value != null) columnSizes[i] = Math.max(columnSizes[i], value.length()); } } resultSet.beforeFirst(); return columnSizes; }
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 void beforeFirst() { try { getResultSet().beforeFirst(); } catch (SQLException sqle) { throw convert( sqle, "exception calling beforeFirst()" ); } }
@Override public void resultSet_beforeFirst(ResultSetProxy rs) throws SQLException { if (this.pos < filterSize) { nextFilter() .resultSet_beforeFirst(this, rs); return; } rs.getResultSetRaw() .beforeFirst(); }
@Override public void beforeFirst() { try { getResultSet().beforeFirst(); } catch (SQLException e) { throw getSession().getFactory().getSQLExceptionHelper().convert( e, "exception calling beforeFirst()" ); } currentRow = null; currentPosition = 0; }
@Override public String getString() { try { StatementBuilder buff = new StatementBuilder("("); result.beforeFirst(); ResultSetMetaData meta = result.getMetaData(); int columnCount = meta.getColumnCount(); for (int i = 0; result.next(); i++) { if (i > 0) { buff.append(", "); } buff.append('('); buff.resetCount(); for (int j = 0; j < columnCount; j++) { buff.appendExceptFirst(", "); int t = DataType.getValueTypeFromResultSet(meta, j + 1); Value v = DataType.readValue(null, result, j + 1, t); buff.append(v.getString()); } buff.append(')'); } result.beforeFirst(); return buff.append(')').toString(); } catch (SQLException e) { throw DbException.convert(e); } }
@Override public String getString() { try { StatementBuilder buff = new StatementBuilder("("); result.beforeFirst(); ResultSetMetaData meta = result.getMetaData(); int columnCount = meta.getColumnCount(); for (int i = 0; result.next(); i++) { if (i > 0) { buff.append(", "); } buff.append('('); buff.resetCount(); for (int j = 0; j < columnCount; j++) { buff.appendExceptFirst(", "); int t = DataType.convertSQLTypeToValueType(meta.getColumnType(j + 1)); Value v = DataType.readValue(null, result, j + 1, t); buff.append(v.getString()); } buff.append(')'); } result.beforeFirst(); return buff.append(')').toString(); } catch (SQLException e) { throw DbException.convert(e); } }
try { ResultSet rs = ((ValueResultSet) v).getResultSet(); rs.beforeFirst(); ResultSetMetaData meta = rs.getMetaData(); int columnCount = meta.getColumnCount(); rs.beforeFirst(); } catch (SQLException e) { throw DbException.convert(e);
sfuFut0.get(); rs.beforeFirst();
try { ResultSet rs = ((ValueResultSet) v).getResultSet(); rs.beforeFirst(); ResultSetMetaData meta = rs.getMetaData(); int columnCount = meta.getColumnCount(); rs.beforeFirst(); } catch (SQLException e) { throw DbException.convert(e);
try { ResultSet rs = ((ValueResultSet) v).getResultSet(); rs.beforeFirst(); ResultSetMetaData meta = rs.getMetaData(); int columnCount = meta.getColumnCount(); rs.beforeFirst(); } catch (SQLException e) { throw DbException.convertToIOException(e);
@Override public void resultSet_beforeFirst(ResultSetProxy rs) throws SQLException { if (this.pos < filterSize) { nextFilter() .resultSet_beforeFirst(this, rs); return; } rs.getResultSetRaw() .beforeFirst(); }