ResultSet: getInt(String columnName)

 
import javax.sql.rowset.CachedRowSet;

public class Main {
  

  public static void main(String[] args) throws Exception {
    CachedRowSet rs;
    String ROWSET_IMPL_CLASS = "com.sun.rowset.CachedRowSetImpl";
    
    
    Class c = Class.forName(ROWSET_IMPL_CLASS);
    rs = (CachedRowSet) c.newInstance();

    rs.setUrl("jdbc:postgresql:dbname");
    rs.setUsername("username");
    rs.setPassword("password");

    rs.setCommand("select * from members where name like ?");
    rs.setString(1, "I%");

    rs.execute();

    while (rs.next()) {
      if (rs.getInt("id") == 42) {
        rs.setString(1, "newString");
        rs.updateRow(); // Normal JDBC

        rs.acceptChanges();
      }
    }
    rs.close();
  }
}

Related examples in the same category

1.	ResultSet.CLOSE_CURSORS_AT_COMMIT
2.	ResultSet.CONCUR_READ_ONLY
3.	ResultSet.CONCUR_UPDATABLE
4.	ResultSet.HOLD_CURSORS_OVER_COMMIT
5.	ResultSet.TYPE_SCROLL_INSENSITIVE
6.	ResultSet.TYPE_SCROLL_SENSITIVE
7.	ResultSet: TYPE_FORWARD_ONLY
8.	ResultSet: absolute(int row)
9.	ResultSet: beforeFirst()
10.	ResultSet: cancelRowUpdates()
11.	ResultSet: close()
12.	ResultSet: deleteRow()
13.	ResultSet: first()
14.	ResultSet.getAsciiStream(int columnIndex)
15.	ResultSet: getBinaryStream(int columnIndex)
16.	ResultSet: getBigDecimal(int columnIndex)
17.	ResultSet: getBlob(int columnIndex)
18.	ResultSet: getBlob(String colName)
19.	ResultSet: getBytes(int columnIndex)
20.	ResultSet: getClob(int columnIndex)
21.	ResultSet: getConcurrency()
22.	ResultSet: getDate(int columnIndex)
23.	ResultSet: getDouble(String columnLabel)
24.	ResultSet: getInt(int columnIndex)
25.	ResultSet: getMetaData()
26.	ResultSet: getObject(int columnIndex)
27.	ResultSet: getObject(String columnLabel)
28.	ResultSet: getRef(int columnIndex)
29.	ResultSet: getRow()
30.	ResultSet: getShort(String columnLabel)
31.	ResultSet: getString(int columnIndex)
32.	ResultSet: getString(String columnLabel)
33.	ResultSet: getTime(int columnIndex)
34.	ResultSet: getTimestamp(int columnIndex)
35.	ResultSet: getType()
36.	ResultSet: getWarnings()
37.	ResultSet: insertRow()
38.	ResultSet: isAfterLast()
39.	ResultSet: isBeforeFirst()
40.	ResultSet: isFirst()
41.	ResultSet: last()
42.	ResultSet: moveToInsertRow()
43.	ResultSet: next()
44.	ResultSet: previous()
45.	ResultSet: refreshRow()
46.	ResultSet: relative(int rows)
47.	ResultSet: setFetchSize(int rows)
48.	ResultSet: updateInt(String columnLabel, int x)
49.	ResultSet: updateRow()
50.	ResultSet: updateDouble(int columnIndex, double x)
51.	ResultSet: updateString(String columnName, String x)
52.	ResultSet: wasNull()

ResultSet: getInt(String columnName) : ResultSet « java.sql « Java by API

Related examples in the same category