Advertisement
Guest User

Untitled

a guest
Oct 26th, 2018
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. try{
  2. Class.forName("com.mysql.jdbc.Driver");
  3. Connection c = DriverManager.getConnection(
  4. "jdbc:mysql://localhost/ventas2018","root","");
  5.  
  6. Statement s = c.createStatement();
  7. String sql =
  8. "update producto set nombre='%2', precio='%3' where codigo='%1'";
  9. sql = sql.replace("%1",jTextField1.getText());
  10. sql = sql.replace("%2",jTextField2.getText());
  11. sql = sql.replace("%3",jTextField3.getText());
  12. s.execute(sql);
  13.  
  14. jButton1ActionPerformed(null);
  15.  
  16. javax.swing.JOptionPane.showMessageDialog(null, sql);
  17. } catch(Exception e){
  18. e.printStackTrace();
  19. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement