Guest User

Untitled

a guest
Sep 25th, 2018
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.31 KB | None | 0 0
  1. try {
  2.  
  3. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sistemarfid?useUnicode=yes&characterEncoding=UTF-8&useSSL=false&useTimezone=true&serverTimezone=UTC", "root", "12345");
  4.  
  5. String sql = "update produto set descricao=?, cod_barras=?, local_armazem=?, nome_forn=?, cod_fornecedor where cod_produto=?";
  6.  
  7. PreparedStatement stmtedit = con.prepareStatement(sql);
  8.  
  9.  
  10. stmtedit.setString(1, descricao_produto.getText());
  11. stmtedit.setString(2, codigo_barras.getText());
  12. stmtedit.setString(3, local_armazenagem.getText());
  13. stmtedit.setString(4, fornecedor.getText());
  14. stmtedit.setString(5, codigo_fornecedor.getText());
  15. stmtedit.setString(6, codigo_produto.getText());
  16.  
  17.  
  18. stmtedit.executeUpdate(sql);
  19. //stmtedit.executeUpdate();
  20. //stmtedit.execute();
  21.  
  22. stmtedit.close();
  23. con.close();
  24.  
  25. JOptionPane.showMessageDialog(jButton1, this, "Produto alterado!", getDefaultCloseOperation());
  26.  
  27. }catch (SQLException e){
  28.  
  29. System.out.println (e);
  30. //e.printStackTrace();
  31.  
  32.  
  33. }
  34.  
  35. catch (Exception e) {System.out.println (e);}
Add Comment
Please, Sign In to add comment