ejemplo de Grabar, Modificar y Eliminar con Base de Datos

package javasql;

import java.sql.*;
import java.awt.BorderLayout;
import javax.swing.JPanel;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.JComboBox;
import javax.swing.JTextArea;
import javax.swing.JButton;
import java.awt.Rectangle;
import java.awt.Dimension;

public class MantProductos extends JFrame {

private JPanel jContentPane = null;

private JLabel jLabel = null;

private JLabel jLabel1 = null;

private JLabel jLabel2 = null;

private JLabel jLabel3 = null;

private JLabel jLabel4 = null;

private JLabel jLabel5 = null;

private JTextField jTextField = null;

private JComboBox jComboBox = null;

private JTextField jTextField1 = null;

private JTextField jTextField2 = null;

private JTextField jTextField3 = null;

private JButton jButton = null;

private JButton jButton1 = null;

private JButton jButton2 = null;

private JButton jButton3 = null;

private JButton jButton4 = null;

private JTextArea jTextArea = null;

private JLabel jLabel6 = null;

private JLabel jLabel7 = null;

private JLabel jLabel8 = null;

private JLabel jLabel9 = null;

private JLabel jLabel10 = null;

private JButton jButton5 = null;

public MantProductos() {
  super();
  initialize();
 }

private void initialize() {
  this.setSize(476, 420);
  this.setContentPane(getJContentPane());
  this.setTitle(”Mantenimiento de Productos”);
  // CArgando el jcombobox
  String driver = “sun.jdbc.odbc.JdbcOdbcDriver”;
  String dsn = “jdbc:odbc:DSNJava”;
  String sql = “select Nombre from marcas order by 1 asc”;
  try {
  // cargo el driver
  Class.forName(driver);
  // creo objeto conexion
  Connection con = DriverManager.getConnection(dsn, ” “, ” “);
  // creo objeto sentencia
  Statement stm = con.createStatement();
  ResultSet rs = stm.executeQuery(sql);
  jComboBox.addItem(”Escoja”);
  while (rs.next() == true)
  jComboBox.addItem(rs.getString(1));

// cierren objetos
  stm.close();
  con.close();
  } catch (Exception e) {
  jTextArea.setText(e.getMessage());
  }
 }

private JPanel getJContentPane() {
  if (jContentPane == null) {
  jLabel10 = new JLabel();
  jLabel10.setBounds(new Rectangle(360, 206, 54, 16));
  jLabel10.setText(”STOCK”);
  jLabel9 = new JLabel();
  jLabel9.setBounds(new Rectangle(277, 208, 62, 14));
  jLabel9.setText(”PRECIO”);
  jLabel8 = new JLabel();
  jLabel8.setBounds(new Rectangle(186, 208, 67, 13));
  jLabel8.setText(”NOMBRE”);
  jLabel7 = new JLabel();
  jLabel7.setBounds(new Rectangle(91, 205, 53, 16));
  jLabel7.setText(”MARCA”);
  jLabel6 = new JLabel();
  jLabel6.setBounds(new Rectangle(17, 204, 63, 17));
  jLabel6.setText(”CODIGO”);
  jLabel5 = new JLabel();
  jLabel5.setBounds(new java.awt.Rectangle(15, 164, 49, 18));
  jLabel5.setText(”STOCK”);
  jLabel4 = new JLabel();
  jLabel4.setBounds(new java.awt.Rectangle(15, 137, 48, 14));
  jLabel4.setText(”PRECIO”);
  jLabel3 = new JLabel();
  jLabel3.setBounds(new java.awt.Rectangle(15, 105, 61, 15));
  jLabel3.setText(”NOMBRE”);
  jLabel2 = new JLabel();
  jLabel2.setBounds(new java.awt.Rectangle(15, 75, 50, 13));
  jLabel2.setText(”MARCA”);
  jLabel1 = new JLabel();
  jLabel1.setBounds(new java.awt.Rectangle(12, 47, 47, 14));
  jLabel1.setText(”CODIGO”);
  jLabel = new JLabel();
  jLabel.setBounds(new java.awt.Rectangle(91, 8, 191, 20));
  jLabel.setText(”MANTENIMIENTO DE PRODUCTOS”);
  jContentPane = new JPanel();
  jContentPane.setLayout(null);
  jContentPane.add(jLabel, null);
  jContentPane.add(jLabel1, null);
  jContentPane.add(jLabel2, null);
  jContentPane.add(jLabel3, null);
  jContentPane.add(jLabel4, null);
  jContentPane.add(jLabel5, null);
  jContentPane.add(getJTextField(), null);
  jContentPane.add(getJComboBox(), null);
  jContentPane.add(getJTextField1(), null);
  jContentPane.add(getJTextField2(), null);
  jContentPane.add(getJTextField3(), null);
  jContentPane.add(getJButton(), null);
  jContentPane.add(getJButton1(), null);
  jContentPane.add(getJButton2(), null);
  jContentPane.add(getJButton3(), null);
  jContentPane.add(getJButton4(), null);
  jContentPane.add(getJTextArea(), null);
  jContentPane.add(jLabel6, null);
  jContentPane.add(jLabel7, null);
  jContentPane.add(jLabel8, null);
  jContentPane.add(jLabel9, null);
  jContentPane.add(jLabel10, null);
  jContentPane.add(getJButton5(), null);
  }
  return jContentPane;
 }

private JTextField getJTextField() {
  if (jTextField == null) {
  jTextField = new JTextField();
  jTextField.setBounds(new java.awt.Rectangle(78, 46, 98, 17));
  }
  return jTextField;
 }

private JComboBox getJComboBox() {
  if (jComboBox == null) {
  jComboBox = new JComboBox();
  jComboBox.setBounds(new java.awt.Rectangle(77, 77, 103, 17));
  }
  return jComboBox;
 }

private JTextField getJTextField1() {
  if (jTextField1 == null) {
  jTextField1 = new JTextField();
  jTextField1.setBounds(new java.awt.Rectangle(81, 103, 100, 19));
  }
  return jTextField1;
 }

private JTextField getJTextField2() {
  if (jTextField2 == null) {
  jTextField2 = new JTextField();
  jTextField2.setBounds(new java.awt.Rectangle(81, 135, 98, 17));
  }
  return jTextField2;
 }

private JTextField getJTextField3() {
  if (jTextField3 == null) {
  jTextField3 = new JTextField();
  jTextField3.setBounds(new java.awt.Rectangle(79, 166, 100, 17));
  }
  return jTextField3;
 }

private JTextArea getJTextArea() {
  if (jTextArea == null) {
  jTextArea = new JTextArea();
  jTextArea.setBounds(new Rectangle(15, 225, 412, 156));
  }
  return jTextArea;
 }

private JButton getJButton() {
  if (jButton == null) {
  jButton = new JButton();
  jButton.setBounds(new java.awt.Rectangle(201, 45, 101, 18));
  jButton.setText(”NUEVO”);
  jButton.addActionListener(new java.awt.event.ActionListener() {
  public void actionPerformed(java.awt.event.ActionEvent e) {
  // System.out.println(”actionPerformed()”); // TODO
  // Auto-generated Event stub actionPerformed()
  jComboBox.setSelectedIndex(0);
  jTextField1.setText(”");
  jTextField2.setText(”");
  jTextField3.setText(”");
  jTextArea.setText(”");
  String driver = “sun.jdbc.odbc.JdbcOdbcDriver”;
  String dsn = “jdbc:odbc:DSNJava”;
  String sql = “SELECT count(IDProd)+1 FROM productos”;
  try {
  // cargo el driver
  Class.forName(driver);
  // creo objeto conexion
  Connection con = DriverManager.getConnection(dsn, ” “,
  ” “);
  // creo objeto sentencia
  Statement stm = con.createStatement();
  ResultSet rs = stm.executeQuery(sql);
  while (rs.next() == true)
  jTextField.setText(rs.getString(1));

// cierren objetos
  stm.close();
  con.close();
  } catch (Exception e5) {
  jTextArea.setText(e5.getMessage());
  }
  }
  });
  }
  return jButton;
 }

private JButton getJButton1() {
  if (jButton1 == null) {
  jButton1 = new JButton();
  jButton1.setBounds(new java.awt.Rectangle(200, 68, 103, 16));
  jButton1.setText(”ELIMINAR”);
  jButton1.addActionListener(new java.awt.event.ActionListener() {
  public void actionPerformed(java.awt.event.ActionEvent e) {
  // System.out.println(”actionPerformed()”); // TODO
  // Auto-generated Event stub actionPerformed()
  String cod = jTextField.getText();
  String driver = “sun.jdbc.odbc.JdbcOdbcDriver”;
  String dsn = “jdbc:odbc:DSNJava”;
  String sql = “delete from productos where IDProd =’” + cod
  + “‘”;
  try { // cargo el driver
  Class.forName(driver);
  // creo objeto conexion
  Connection con = DriverManager.getConnection(dsn, ” “,
  ” “);
  // creo objeto sentencia
  Statement stm = con.createStatement();
  int nfilas = stm.executeUpdate(sql);
  if (nfilas > 0)
  jTextArea.setText(”Se elimino Producto”);
  else
  jTextArea.setText(”No se elimino Producto”);
  // cierro objetos
  stm.close();
  con.close();
  } catch (Exception e2) {
  jTextArea.setText(e2.getMessage());
  }

}
  });
  }
  return jButton1;
 }

private JButton getJButton2() {
  if (jButton2 == null) {
  jButton2 = new JButton();
  jButton2.setBounds(new java.awt.Rectangle(200, 88, 103, 16));
  jButton2.setText(”VER TODOS”);
  jButton2.addActionListener(new java.awt.event.ActionListener() {
  public void actionPerformed(java.awt.event.ActionEvent e) {
  // System.out.println(”actionPerformed()”); // TODO
  // Auto-generated Event stub actionPerformed()
  String driver = “sun.jdbc.odbc.JdbcOdbcDriver”;
  String dsn = “jdbc:odbc:DSNJava”;
  String sql = “select * from productos order by 1 asc”;
  jTextArea.setText(”");
  try { // cargo el driver
  Class.forName(driver);
  // creo objeto conexion
  Connection con = DriverManager.getConnection(dsn, ” “,
  ” “);
  // creo objeto sentencia
  Statement stm = con.createStatement();
  // creo objeto ResultSet para almacenar resultado de
  // consulta
  ResultSet rs = stm.executeQuery(sql);
  while (rs.next() == true)
  jTextArea.append(rs.getString(1) + “\t”
  + rs.getString(2) + “\t” + rs.getString(3)
  + “\t” + rs.getString(4) + “\t”
  + rs.getString(5) + “\n”);
  // cierro objetos
  stm.close();
  con.close();
  } catch (Exception e4) {
  jTextArea.setText(e4.getMessage());
  }

}
  });
  }
  return jButton2;
 }

private JButton getJButton3() {
  if (jButton3 == null) {
  jButton3 = new JButton();
  jButton3.setBounds(new Rectangle(200, 107, 103, 18));
  jButton3.setText(”GRABAR”);
  jButton3.addActionListener(new java.awt.event.ActionListener() {
  public void actionPerformed(java.awt.event.ActionEvent e) {
  // System.out.println(”actionPerformed()”); // TODO
  // Auto-generated Event stub actionPerformed()
  int cod = Integer.parseInt(jTextField.getText());
  // String mar = String.valueOf(jComboBox.getSelectedItem());
  int mar = jComboBox.getSelectedIndex();
  // String idmar = “select IDMarca from marcas where nombre
  // =’”+mar+”‘”;
  String nom = jTextField1.getText();
  double pre = Double.parseDouble(jTextField2.getText());
  int sto = Integer.parseInt(jTextField3.getText());
  String driver = “sun.jdbc.odbc.JdbcOdbcDriver”;
  String dsn = “jdbc:odbc:DSNJava”;
  // String idmar = “select IDMarca from marcas where nombre
  // =’”+mar+”‘”;
  // int idm=Integer.parseInt(idmar);
  String sql = “insert into productos values(’” + cod + “‘,’”
  + mar + “‘,’” + nom + “‘,’” + pre + “‘,’” + sto
  + “‘)”;

try { // cargo el driver
  Class.forName(driver);
  // creo objeto conexion
  Connection con = DriverManager.getConnection(dsn, ” “,
  ” “);
  // creo objeto sentencia
  Statement stm = con.createStatement();
  int nfilas = stm.executeUpdate(sql);
  if (nfilas > 0)
  jTextArea.setText(”Se grabo Producto”);
  else
  jTextArea.setText(”No se grabo Producto”);
  // cierro objetos
  stm.close();
  con.close();
  } catch (Exception e1) {
  jTextArea.setText(e1.getMessage());
  }
  }
  });
  }
  return jButton3;
 }

private JButton getJButton4() {
  if (jButton4 == null) {
  jButton4 = new JButton();
  jButton4.setBounds(new java.awt.Rectangle(200, 129, 103, 17));
  jButton4.setText(”MODIFICAR”);
  jButton4.addActionListener(new java.awt.event.ActionListener() {
  public void actionPerformed(java.awt.event.ActionEvent e) {
  // System.out.println(”actionPerformed()”); // TODO
  // Auto-generated Event stub actionPerformed()

int cod = Integer.parseInt(jTextField.getText());
  int mar = jComboBox.getSelectedIndex();
  String nom = jTextField1.getText();
  double pre = Double.parseDouble(jTextField2.getText());
  int sto = Integer.parseInt(jTextField3.getText());
  String driver = “sun.jdbc.odbc.JdbcOdbcDriver”;
  String dsn = “jdbc:odbc:DSNJava”;
  String sql = “update productos set IDMarca=’” + mar
  + “‘,NomProd=’” + nom + “‘,Precio=’” + pre
  + “‘,Stock=’” + sto + “‘ where IDProd=’” + cod
  + “‘”;

try { // cargo el driver
  Class.forName(driver);
  // creo objeto conexion
  Connection con = DriverManager.getConnection(dsn, ” “,
  ” “);
  // creo objeto sentencia
  Statement stm = con.createStatement();
  int nfilas = stm.executeUpdate(sql);
  if (nfilas > 0)
  jTextArea.setText(”Se modifico Producto”);
  else
  jTextArea.setText(”No se modifico Producto”);
  // cierro objetos
  stm.close();
  con.close();
  } catch (Exception e3) {
  jTextArea.setText(e3.getMessage());
  }

}
  });
  }
  return jButton4;
 }

private JButton getJButton5() {
  if (jButton5 == null) {
  jButton5 = new JButton();
  jButton5.setBounds(new Rectangle(201, 150, 102, 15));
  jButton5.setText(”SALIR”);
  jButton5.addActionListener(new java.awt.event.ActionListener() {
  public void actionPerformed(java.awt.event.ActionEvent e) {
  //System.out.println(”actionPerformed()”); // TODO Auto-generated Event stub actionPerformed()
  System.exit(0);
  }
  });
  }
  return jButton5;
 }
}