本文整理了Java中java.sql.ResultSet.getRow
方法的一些代码示例,展示了ResultSet.getRow
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。ResultSet.getRow
方法的具体详情如下:
包路径:java.sql.ResultSet
类名称: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());
内容来源于网络,如有侵权,请联系作者删除!