Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.27 KB | None | 0 0
  1. private void update(){
  2. connection();
  3. try{
  4. String sqldb =
  5. "update votersInfo set votersName = ? , age = ?,state = ? where votersId =?"
  6. ;
  7. prep = conn.prepareStatement(sqldb);
  8.  
  9. //int intA = Integer.parseInt(jTextField1.getText());
  10. prep.setInt(1, Integer.parseInt(jTextField1.getText()));
  11. prep.setString(2, jTextField2.getText());
  12. prep.setInt(3, Integer.parseInt(jTextField3.getText()));
  13. prep.setString(4, jTextField4.getText());
  14. int a = prep.executeUpdate();
  15. if (a>0){
  16. JOptionPane.showMessageDialog(rootPane, "Sucessful");
  17. }
  18. }
  19. catch(Exception e){
  20. // System.err.println(e.printStackTrace());
  21. e.printStackTrace();
  22. }
  23. }
  24.  
  25. String sqldb =
  26. "update votersInfo set votersName = ? [1], age = ? [2] ,state = ? [3] where votersId =? [4]";
  27.  
  28. prep.setInt(1, Integer.parseInt(jTextField1.getText())); //setting name to an Integer
  29. prep.setString(2, jTextField2.getText()); //setting age to a String
  30. prep.setInt(3, Integer.parseInt(jTextField3.getText())); //setting state to an Integer
  31. prep.setString(4, jTextField4.getText()); //setting votersId to a String
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement