本文整理匯總了Java中javax.sql.rowset.CachedRowSet.insertRow方法的典型用法代碼示例。如果您正苦於以下問題：Java CachedRowSet.insertRow方法的具體用法？Java CachedRowSet.insertRow怎麽用？Java CachedRowSet.insertRow使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類javax.sql.rowset.CachedRowSet的用法示例。
在下文中一共展示了CachedRowSet.insertRow方法的6個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Java代碼示例。
示例1: commonCachedRowSetTest0053
import javax.sql.rowset.CachedRowSet; //導入方法依賴的package包/類
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0053(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.undoInsert();
// Check to make sure the row is no longer there
assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
assertFalse(findRowByPrimaryKey(rs, rowToInsert, 1));
rs.close();
}
示例2: commonCachedRowSetTest0044
import javax.sql.rowset.CachedRowSet; //導入方法依賴的package包/類
@Test(dataProvider = "rowsetUsingCoffeeHouses",
expectedExceptions = SQLException.class)
public void commonCachedRowSetTest0044(CachedRowSet rs) throws Exception {
rs.insertRow();
rs.undoDelete();
rs.close();
}
示例3: commonCachedRowSetTest0047
import javax.sql.rowset.CachedRowSet; //導入方法依賴的package包/類
@Test(dataProvider = "rowsetUsingCoffeeHouses",
expectedExceptions = SQLException.class)
public void commonCachedRowSetTest0047(CachedRowSet rs) throws Exception {
rs.insertRow();
rs.undoUpdate();
rs.close();
}
示例4: commonCachedRowSetTest0050
import javax.sql.rowset.CachedRowSet; //導入方法依賴的package包/類
@Test(dataProvider = "rowsetUsingCoffeeHouses",
expectedExceptions = SQLException.class)
public void commonCachedRowSetTest0050(CachedRowSet rs) throws Exception {
rs.insertRow();
rs.undoInsert();
rs.close();
}
示例5: 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();
}
示例6: 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();
}