Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void btnModificarActionPerformed(java.awt.event.ActionEvent evt) {
- if(datosValidos()){
- try {
- //Registrar driver
- Class.forName("oracle.jdbc.OracleDriver");
- //Solicitar conexión
- String baseDatos = "jdbc:oracle:thin:@192.168.202.2:1521:orcl";
- Connection conex = DriverManager.getConnection(baseDatos, "user", "pass");
- String nuevaMarca = JOptionPane.showInputDialog("Ingresa el nuevo nombre de la Marca");
- int codigo = Integer.parseInt(txtCodigo.getText());
- String query = "update Marca " + "set marca='" + nuevaMarca + "'"+ " where codigo=" + codigo + ";";
- PreparedStatement ps = conex.prepareStatement(query);
- ps.setInt(1,codigo);
- ps.setString(2, txtMarca.getText());
- ResultSet rs = ps.executeQuery();
- if(rs != null){
- JOptionPane.showMessageDialog(null, "Marca actualizada exitosamente");
- btnLimpiar.setEnabled(true);
- }
- } catch (Exception ex) {
- JOptionPane.showMessageDialog(null, ex.toString());
- }
- txtCodigo.requestFocus();
- }else
- lblEstado.setText("Tiene errores de validación");
- }
- "update Marca " + "set marca='" + nuevaMarca + "'"+ " where codigo=" + codigo <sup>1</sup>
- "update Marca set marca=? where codigo= ?"<sup>2</sup>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement