本文整理匯總了Java中javax.sql.rowset.CachedRowSet.getInt方法的典型用法代碼示例。如果您正苦於以下問題：Java CachedRowSet.getInt方法的具體用法？Java CachedRowSet.getInt怎麽用？Java CachedRowSet.getInt使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類javax.sql.rowset.CachedRowSet的用法示例。
在下文中一共展示了CachedRowSet.getInt方法的3個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Java代碼示例。
示例1: 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();
}
示例2: 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();
}
示例3: 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();
}