Java Code Examples for javax.sql.rowset.CachedRowSet#getString()
The following examples show how to use
javax.sql.rowset.CachedRowSet#getString() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
| Source File: CommonCachedRowSetTests.java From jdk8u60 with GNU General Public License v2.0 | 5 votes |
|
@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();
}
Example 2
| Source File: CommonCachedRowSetTests.java From openjdk-jdk9 with GNU General Public License v2.0 | 5 votes |
|
@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();
}
Example 3
| Source File: CommonCachedRowSetTests.java From openjdk-jdk9 with GNU General Public License v2.0 | 5 votes |
|
@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();
}
Example 4
| Source File: CommonCachedRowSetTests.java From openjdk-jdk9 with GNU General Public License v2.0 | 5 votes |
|
@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();
}
Example 5
| Source File: CommonCachedRowSetTests.java From openjdk-jdk8u-backup with GNU General Public License v2.0 | 5 votes |
|
@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();
}
Example 6
| Source File: CommonCachedRowSetTests.java From openjdk-jdk8u-backup with GNU General Public License v2.0 | 5 votes |
|
@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();
}
Example 7
| Source File: CommonCachedRowSetTests.java From hottub with GNU General Public License v2.0 | 5 votes |
|
@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();
}
Example 8
| Source File: CommonCachedRowSetTests.java From openjdk-jdk8u with GNU General Public License v2.0 | 5 votes |
|
@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();
}
Example 9
| Source File: CommonCachedRowSetTests.java From jdk8u_jdk with GNU General Public License v2.0 | 5 votes |
|
@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();
}
Example 10
| Source File: CommonCachedRowSetTests.java From openjdk-jdk8u with GNU General Public License v2.0 | 5 votes |
|
@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();
}
Example 11
| Source File: CommonCachedRowSetTests.java From jdk8u_jdk with GNU General Public License v2.0 | 5 votes |
|
@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();
}
Example 12
| Source File: CommonCachedRowSetTests.java From jdk8u60 with GNU General Public License v2.0 | 5 votes |
|
@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();
}
Example 13
| Source File: CommonCachedRowSetTests.java From jdk8u60 with GNU General Public License v2.0 | 5 votes |
|
@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();
}
Example 14
| Source File: CommonCachedRowSetTests.java From TencentKona-8 with GNU General Public License v2.0 | 5 votes |
|
@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();
}
Example 15
| Source File: CommonCachedRowSetTests.java From jdk8u-jdk with GNU General Public License v2.0 | 5 votes |
|
@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();
}
Example 16
| Source File: CommonCachedRowSetTests.java From TencentKona-8 with GNU General Public License v2.0 | 5 votes |
|
@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();
}
Example 17
| Source File: DefaultAdaptor.java From kylin-on-parquet-v2 with Apache License 2.0 | 5 votes |
|
/**
* Get All columns for sql case sensitive
* @return
* @throws SQLException
*/
public List<String> listColumns() throws SQLException {
List<String> ret = new ArrayList<>();
if (columnsCache == null || columnsCache.size() == 0) {
CachedRowSet columnsRs = null;
try (Connection conn = getConnection();
ResultSet rs = conn.getMetaData().getColumns(null, null, null, null)) {
columnsRs = cacheResultSet(rs);
}
while (columnsRs.next()) {
String database = columnsRs.getString("TABLE_SCHEM") != null ? columnsRs.getString("TABLE_SCHEM")
: columnsRs.getString("TABLE_CAT");
String table = columnsRs.getString("TABLE_NAME");
String column = columnsRs.getString("COLUMN_NAME");
String cacheKey = joiner.join(config.datasourceId, config.url, database, table, "columns");
List<String> cachedColumns = columnsCache.getIfPresent(cacheKey);
if (cachedColumns == null) {
cachedColumns = new ArrayList<>();
columnsCache.put(cacheKey, cachedColumns);
logger.debug("Add column cache for table {}.{}", database, table);
}
if (!cachedColumns.contains(column)) {
cachedColumns.add(column);
}
ret.add(column);
}
} else {
for (Map.Entry<String, List<String>> entry : columnsCache.asMap().entrySet()) {
ret.addAll(entry.getValue());
}
}
return ret;
}
Example 18
| Source File: DefaultAdaptor.java From kylin with Apache License 2.0 | 5 votes |
|
@Override
public List<String> listColumns(String database, String tableName) throws SQLException {
List<String> ret = new ArrayList<>();
CachedRowSet columnsRs = getTableColumns(database, tableName);
while (columnsRs.next()) {
String name = columnsRs.getString("COLUMN_NAME");
if (StringUtils.isNotBlank(name)) {
ret.add(name);
}
}
return ret;
}
Example 19
| Source File: CommonCachedRowSetTests.java From dragonwell8_jdk with GNU General Public License v2.0 | 5 votes |
|
@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();
}
Example 20
| Source File: CommonCachedRowSetTests.java From hottub with GNU General Public License v2.0 | 5 votes |
|
@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();
}
