Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2019
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. String ssn;
  2. String stmt1 = "select Ssn from EMPLOYEE";
  3. PreparedStatement p = conn.prepareStatement(stmt1);
  4.  
  5. p.clearParameters();
  6. ResultSet r = p.executeQuery();
  7.  
  8. while (r.next()) {
  9. ssn = r.getString(1);
  10. String stmt2 = "UPDATE EMPLOYEE SET salary = salary + 100 WHERE Ssn = " + ssn;
  11. PreparedStatement s = conn.prepareStatement(stmt2);
  12. s.executeUpdate();
  13. }
  14. r.close();
  15.  
  16. v8a.printTable(conn);
  17.  
  18. conn.close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement