

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;
}
}
Filed under: Visual Class | 43 Comentarios »

Metal Slug – Last Mission
Billiards
Mini Ping Pong































