Skip to content
This repository has been archived by the owner on Jun 4, 2019. It is now read-only.

Is it possible to support also updating a resultset? #13

Open
dportabella opened this issue Jan 10, 2013 · 0 comments
Open

Is it possible to support also updating a resultset? #13

dportabella opened this issue Jan 10, 2013 · 0 comments

Comments

@dportabella
Copy link

Is it possible to support also updating a resultset?

simular to this jdbc example from: http://www.tutorialspoint.com/jdbc/updating-result-sets.htm
+++++++++++++++++++++++++
Statement stmt = conn.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sql = "SELECT id, first, last, age FROM Employees";
ResultSet rs = stmt.executeQuery(sql);

  while(rs.next()){
     int newAge = rs.getInt("age") + 5;
     rs.updateDouble( "age", newAge );
     rs.updateRow();
  }

+++++++++++++++++++++++++

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant