Advertisement
Guest User

Untitled

a guest
Mar 18th, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. String val = txt_val.getText();
  2. String col = txt_col.getText();
  3. Connection conn = null;
  4. PreparedStatement pstmt = null;
  5. ResultSet rs = null;
  6. try{
  7. Class.forName("com.mysql.jdbc.Driver");
  8. conn = DriverManager.getConnection("jdbc:mysql://localhost/net","root","");
  9.  
  10. pstmt.setString(1,val);
  11. pstmt.setString(2,val);
  12.  
  13. pstmt.setString(3,col);
  14. pstmt.setString(4,col);
  15.  
  16.  
  17. int i = pstmt.executeUpdate();
  18. if(i>0)
  19. {
  20. JOptionPane.showMessageDialog(null,"done");
  21. }
  22. else
  23. {
  24. JOptionPane.showMessageDialog(null,"query failed");
  25. }
  26.  
  27.  
  28. }
  29.  
  30. catch(Exception e){
  31. JOptionPane.showMessageDialog(null,e);
  32. }
  33.  
  34.  
  35. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement