Advertisement
Guest User

Untitled

a guest
Dec 10th, 2016
160
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.44 KB | None | 0 0
  1. private void btnModificarActionPerformed(java.awt.event.ActionEvent evt) {
  2.  
  3.  
  4. if(datosValidos()){
  5. try {
  6. //Registrar driver
  7. Class.forName("oracle.jdbc.OracleDriver");
  8. //Solicitar conexión
  9. String baseDatos = "jdbc:oracle:thin:@192.168.202.2:1521:orcl";
  10. Connection conex = DriverManager.getConnection(baseDatos, "user", "pass");
  11.  
  12.  
  13. String nuevaMarca = JOptionPane.showInputDialog("Ingresa el nuevo nombre de la Marca");
  14.  
  15. int codigo = Integer.parseInt(txtCodigo.getText());
  16.  
  17. String query = "update Marca " + "set marca='" + nuevaMarca + "'"+ " where codigo=" + codigo + ";";
  18. PreparedStatement ps = conex.prepareStatement(query);
  19. ps.setInt(1,codigo);
  20. ps.setString(2, txtMarca.getText());
  21. ResultSet rs = ps.executeQuery();
  22.  
  23. if(rs != null){
  24. JOptionPane.showMessageDialog(null, "Marca actualizada exitosamente");
  25. btnLimpiar.setEnabled(true);
  26. }
  27.  
  28.  
  29.  
  30. } catch (Exception ex) {
  31. JOptionPane.showMessageDialog(null, ex.toString());
  32. }
  33. txtCodigo.requestFocus();
  34. }else
  35. lblEstado.setText("Tiene errores de validación");
  36.  
  37. }
  38.  
  39. "update Marca " + "set marca='" + nuevaMarca + "'"+ " where codigo=" + codigo <sup>1</sup>
  40.  
  41. "update Marca set marca=? where codigo= ?"<sup>2</sup>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement