本文整理汇总了Java中javax.sql.rowset.CachedRowSet.absolute方法的典型用法代码示例。如果您正苦于以下问题：Java CachedRowSet.absolute方法的具体用法？Java CachedRowSet.absolute怎么用？Java CachedRowSet.absolute使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类javax.sql.rowset.CachedRowSet的用法示例。
在下文中一共展示了CachedRowSet.absolute方法的5个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: compareRowSets
import javax.sql.rowset.CachedRowSet; //导入方法依赖的package包/类
private void compareRowSets(CachedRowSet crs, CachedRowSet crs1) throws Exception {
int rows = crs.size();
assertTrue(rows == crs1.size());
ResultSetMetaData rsmd = crs.getMetaData();
compareMetaData(rsmd, crs1.getMetaData());
int cols = rsmd.getColumnCount();
for (int row = 1; row <= rows; row++) {
crs.absolute((row));
crs1.absolute(row);
for (int col = 1; col <= cols; col++) {
compareColumnValue(JDBCType.valueOf(rsmd.getColumnType(col)),
crs, crs1, col);
}
}
}
示例2: commonCachedRowSetTest0054
import javax.sql.rowset.CachedRowSet; //导入方法依赖的package包/类
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0054(CachedRowSet rs) throws Exception {
int rowToDelete = 1961;
assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
// Add new row
rs.moveToInsertRow();
rs.updateInt(1, rowToDelete);
rs.updateString(2, "GOTHAM");
rs.updateInt(3, 3450);
rs.updateInt(4, 2005);
rs.updateInt(5, 5455);
rs.insertRow();
rs.moveToCurrentRow();
// check that the number of rows has increased
assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
assertTrue(findRowByPrimaryKey(rs, rowToDelete, 1));
rs.absolute(COFFEE_HOUSES_ROWS + 1);
rs.deleteRow();
// Check to make sure the row is no longer there
//assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
assertFalse(findRowByPrimaryKey(rs, rowToDelete, 1));
rs.setShowDeleted(true);
rs.absolute(COFFEE_HOUSES_ROWS + 1);
rs.undoDelete();
// check that the row is back
assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
assertTrue(findRowByPrimaryKey(rs, rowToDelete, 1));
rs.close();
}
示例3: commonCachedRowSetTest0055
import javax.sql.rowset.CachedRowSet; //导入方法依赖的package包/类
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0055(CachedRowSet rs) throws Exception {
int rowToInsert = 1961;
assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
// Add new row
rs.moveToInsertRow();
rs.updateInt(1, rowToInsert);
rs.updateString(2, "GOTHAM");
rs.updateInt(3, 3450);
rs.updateInt(4, 2005);
rs.updateInt(5, 5455);
rs.insertRow();
rs.moveToCurrentRow();
// check that the number of rows has increased
assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
assertTrue(findRowByPrimaryKey(rs, rowToInsert, 1));
rs.absolute(COFFEE_HOUSES_ROWS + 1);
// Save off the original column values
String f2 = rs.getString(2);
int f3 = rs.getInt(3);
rs.updateString(2, "SMALLVILLE");
rs.updateInt(3, 500);
// Validate the columns have been updated
assertTrue(rs.columnUpdated(2));
assertTrue(rs.columnUpdated(3));
// Undo the update and validate it has taken place
rs.absolute(COFFEE_HOUSES_ROWS + 1);
rs.undoUpdate();
assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
assertFalse(findRowByPrimaryKey(rs, rowToInsert, 1));
rs.close();
}
示例4: commonCachedRowSetTest0056
import javax.sql.rowset.CachedRowSet; //导入方法依赖的package包/类
@Test(dataProvider = "rowsetUsingCoffees")
public void commonCachedRowSetTest0056(CachedRowSet rs) throws Exception {
String coffee = "Hazelnut";
int sales = 100;
int id = 200;
Object[] updatedPkeys = {1, id, 3, 4, 5};
// Change the coffee name and sales total for row 2 and save the
// previous values
rs.absolute(2);
int origId = rs.getInt(1);
String origCoffee = rs.getString(2);
int origSales = rs.getInt(5);
rs.updateInt(1, id);
rs.updateString(2, coffee);
rs.updateInt(5, sales);
// MetaData should match
try ( // Get the original original RowSet and validate that the changes
// are only made to the current, not the original
ResultSet rs1 = rs.getOriginal()) {
// MetaData should match
compareMetaData(rs.getMetaData(), rs1.getMetaData());
assertTrue(rs1.isBeforeFirst());
assertTrue(rs1.getConcurrency() == ResultSet.CONCUR_UPDATABLE);
assertTrue(rs1.getType() == ResultSet.TYPE_SCROLL_INSENSITIVE);
rs1.absolute(2);
// Check original rowset is not changed
assertTrue(rs1.getInt(1) == origId);
assertTrue(rs1.getString(2).equals(origCoffee));
assertTrue(rs1.getInt(5) == origSales);
assertEquals(getPrimaryKeys(rs1), COFFEES_PRIMARY_KEYS);
// Check current rowset
assertTrue(rs.getInt(1) == id);
assertTrue(rs.getString(2).equals(coffee));
assertTrue(rs.getInt(5) == sales);
assertEquals(getPrimaryKeys(rs), updatedPkeys);
}
rs.close();
}
示例5: commonCachedRowSetTest0057
import javax.sql.rowset.CachedRowSet; //导入方法依赖的package包/类
@Test(dataProvider = "rowsetUsingCoffees")
public void commonCachedRowSetTest0057(CachedRowSet rs) throws Exception {
String coffee = "Hazelnut";
int sales = 100;
int id = 200;
Object[] updatedPkeys = {1, id, 3, 4, 5};
// Change the coffee name and sales total for row 2 and save the
// previous values
rs.absolute(2);
int origId = rs.getInt(1);
String origCoffee = rs.getString(2);
int origSales = rs.getInt(5);
rs.updateInt(1, id);
rs.updateString(2, coffee);
rs.updateInt(5, sales);
// MetaData should match
try ( // Get the original original row and validate that the changes
// are only made to the current, not the original
ResultSet rs1 = rs.getOriginalRow()) {
// MetaData should match
compareMetaData(rs.getMetaData(), rs1.getMetaData());
assertTrue(rs1.isBeforeFirst());
assertTrue(rs1.getConcurrency() == ResultSet.CONCUR_UPDATABLE);
assertTrue(rs1.getType() == ResultSet.TYPE_SCROLL_INSENSITIVE);
rs1.next();
assertTrue(rs1.isFirst() && rs1.isLast());
assertTrue(rs1.getRow() == 1);
// Check original row is not changed
assertTrue(rs1.getInt(1) == origId);
assertTrue(rs1.getString(2).equals(origCoffee));
assertTrue(rs1.getInt(5) == origSales);
// Check current row
assertTrue(rs.getInt(1) == id);
assertTrue(rs.getString(2).equals(coffee));
assertTrue(rs.getInt(5) == sales);
assertEquals(getPrimaryKeys(rs), updatedPkeys);
}
rs.close();
}