java.sql.ResultSet.getRow()方法的使用及代码示例

x33g5p2x  于2022-01-28 转载在 其他  
字(6.1k)|赞(0)|评价(0)|浏览(348)

本文整理了Java中java.sql.ResultSet.getRow方法的一些代码示例,展示了ResultSet.getRow的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。ResultSet.getRow方法的具体详情如下:
包路径:java.sql.ResultSet
类名称:ResultSet
方法名:getRow

ResultSet.getRow介绍

[英]Gets the number of the current row in the ResultSet. Row numbers start at 1 for the first row.
[中]获取结果集中当前行的编号。第一行的行号从1开始。

代码示例

代码示例来源:origin: querydsl/querydsl

@Override
public int getRow() throws SQLException {
  return rs.getRow();
}

代码示例来源:origin: codingapi/tx-lcn

@Override
public int getRow() throws SQLException {
 return delegate.getRow();
}

代码示例来源:origin: spring-projects/spring-framework

/**
 * @see java.sql.ResultSet#getRow()
 */
@Override
public int getRow() throws InvalidResultSetAccessException {
  try {
    return this.resultSet.getRow();
  }
  catch (SQLException se) {
    throw new InvalidResultSetAccessException(se);
  }
}

代码示例来源:origin: alibaba/druid

@Override
public int getRow() throws SQLException {
  try {
    return rs.getRow();
  } catch (Throwable t) {
    throw checkException(t);
  }
}

代码示例来源:origin: stackoverflow.com

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
}

代码示例来源:origin: apache/ignite

@Override public void run() throws Exception {
    rs.getRow();
  }
});

代码示例来源:origin: spring-projects/spring-batch

/**
 * 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.");
    }
  }
}

代码示例来源:origin: stackoverflow.com

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;
}

代码示例来源:origin: apache/hive

/**
 * 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;
 }
}

代码示例来源:origin: hibernate/hibernate-orm

@Override
public int getRowNumber() throws HibernateException {
  try {
    return getResultSet().getRow() - 1;
  }
  catch (SQLException sqle) {
    throw convert( sqle, "exception calling getRow()" );
  }
}

代码示例来源:origin: alibaba/druid

@Override
public int resultSet_getRow(ResultSetProxy rs) throws SQLException {
  if (this.pos < filterSize) {
    return nextFilter()
        .resultSet_getRow(this, rs);
  }
  return rs.getResultSetRaw()
      .getRow();
}

代码示例来源:origin: jphp-group/jphp

@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);
  }
}

代码示例来源:origin: apache/drill

@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 ) );
}

代码示例来源:origin: com.h2database/h2

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}'").

代码示例来源:origin: wildfly/wildfly

int row=resultSet.getRow();
log.error("%s: failed deserializing row %d: %s; removing it from the table", local_addr, row, e);
try {

代码示例来源:origin: Meituan-Dianping/Zebra

@Override
public int getRow() throws SQLException {
  return innerResultSet.getRow();
}

代码示例来源:origin: apache/ignite

/**
 * @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;
}

代码示例来源:origin: apache/ignite

assert !rs.isFirst();
assert !rs.isLast();
assert rs.getRow() == 0;
assert rs.isFirst();
assert !rs.isLast();
assert rs.getRow() == 1;
assert !rs.isFirst();
assert rs.isLast();
assert rs.getRow() == 2;
assert !rs.isFirst();
assert !rs.isLast();
assert rs.getRow() == 0;

代码示例来源:origin: nutzam/nutz

int rowCount = rs.getRow();
LoopScope ls = LoopScope.eval(pager, rowCount);
if (rs.absolute(ls.start + 1))

代码示例来源:origin: apache/ignite

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());

相关文章

微信公众号

最新文章

更多

ResultSet类方法