• Author / Uploaded
• Jeiimy Angel

Citation preview

package Formulario; import claseConectar.conectar; import java.sql.*; import java.util.logging.*; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; /** * * @author Juancruz */ public class IngresoProductos extends javax.swing.JInternalFrame { DefaultTableModel model; /** Creates new form IngresoProductos */ public IngresoProductos() { initComponents(); this.setLocation(150,15 ); bloquear(); cargar(""); } void bloquear(){ txtcod.setEnabled(false); txtdes.setEnabled(false); txtpre.setEnabled(false); txtstock.setEnabled(false); btnguardar.setEnabled(false); btnnuevo.setEnabled(true); btncancelar.setEnabled(false); btnactualizar.setEnabled(false); } void limpiar(){ txtcod.setText(""); txtdes.setText(""); txtpre.setText(""); txtstock.setText(""); } void desbloquear(){ txtcod.setEnabled(true); txtdes.setEnabled(true); txtpre.setEnabled(true); txtstock.setEnabled(true); btnguardar.setEnabled(true); btnnuevo.setEnabled(false); btncancelar.setEnabled(true);

} void cargar(String valor) { try{ String [] titulos={"Codigo","Descripcion","Precio","Stock"}; String [] registros= new String[4]; model=new DefaultTableModel(null,titulos); String cons="select * from producto WHERE CONCAT (descripcion,'',precio) LIKE '%"+valor+"%'"; Statement st= cn.createStatement(); ResultSet rs = st.executeQuery(cons); while(rs.next()){ registros[0]=rs.getString(1); registros[1]=rs.getString(2); registros[2]=rs.getString(3); registros[3]=rs.getString(4); model.addRow(registros); } tbproductos.setModel(model); tbproductos.getColumnModel().getColumn(0).setPreferredWidth(150); tbproductos.getColumnModel().getColumn(1).setPreferredWidth(300); tbproductos.getColumnModel().getColumn(2).setPreferredWidth(100); }catch(Exception e){ System.out.println(e.getMessage()); } } void BuscarProductoEditar(String cod) { try{ String codi="",desc="",prec="",stock=""; String cons="select * from producto WHERE cod_pro='"+cod+"'"; Statement st = cn.createStatement(); ResultSet rs = st.executeQuery(cons); while(rs.next()) { codi=rs.getString(1); desc=rs.getString(2); prec=rs.getString(3); stock=rs.getString(4); } txtcod.setText(codi); txtdes.setText(desc); txtpre.setText(prec); txtstock.setText(stock);

}catch(Exception e) { System.out.println(e.getMessage()); } } void codigos(){ int j; int cont=1; String num=""; String c=""; String SQL="select max(cod_pro) from producto"; // String SQL="select count(*) from factura"; //String SQL="SELECT MAX(cod_emp) AS cod_emp FROM empleado"; //String SQL="SELECT @@identity AS ID"; try { Statement st = cn.createStatement(); ResultSet rs=st.executeQuery(SQL); if(rs.next()) { c=rs.getString(1); }

if(c==null){ txtcod.setText("CP0001"); } else{ char r1=c.charAt(2); char r2=c.charAt(3); char r3=c.charAt(4); char r4=c.charAt(5); String r=""; r=""+r1+r2+r3+r4; j=Integer.parseInt(r); GenerarCodigos gen= new GenerarCodigos(); gen.generar(j); txtcod.setText("CP"+gen.serie());

}

} catch (SQLException ex) { Logger.getLogger(Factura.class.getName()).log(Level.SEVERE, null, ex); }

}

@SuppressWarnings("unchecked") // private void initComponents() { jScrollPane1 = new javax.swing.JScrollPane(); jTable1 = new javax.swing.JTable(); jPopupMenu1 = new javax.swing.JPopupMenu(); mnactualizar = new javax.swing.JMenuItem(); mneliminar = new javax.swing.JMenuItem(); jPanel1 = new javax.swing.JPanel(); jLabel1 = new javax.swing.JLabel(); txtcod = new javax.swing.JTextField(); jLabel2 = new javax.swing.JLabel(); txtdes = new javax.swing.JTextField(); jLabel3 = new javax.swing.JLabel(); txtpre = new javax.swing.JTextField(); jLabel5 = new javax.swing.JLabel(); txtstock = new javax.swing.JTextField(); jPanel2 = new javax.swing.JPanel(); btnnuevo = new javax.swing.JButton(); btnguardar = new javax.swing.JButton(); btnactualizar = new javax.swing.JButton(); btncancelar = new javax.swing.JButton(); btnsalir = new javax.swing.JButton(); jScrollPane2 = new javax.swing.JScrollPane(); tbproductos = new javax.swing.JTable(); jLabel4 = new javax.swing.JLabel(); txtbuscar = new javax.swing.JTextField(); jButton1 = new javax.swing.JButton(); jTable1.setModel(new javax.swing.table.DefaultTableModel( new Object [][] { {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null} }, new String [] { "Title 1", "Title 2", "Title 3", "Title 4"

} )); jScrollPane1.setViewportView(jTable1); mnactualizar.setText("Modificar"); mnactualizar.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { mnactualizarActionPerformed(evt); } }); jPopupMenu1.add(mnactualizar); mneliminar.setText("Eliminar"); mneliminar.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { mneliminarActionPerformed(evt); } }); jPopupMenu1.add(mneliminar); setClosable(true); setIconifiable(true); setMaximizable(true); setResizable(true); setTitle("REGISTRO DE PRODUCTOS"); jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("Detalle de Producto")); jLabel1.setText("Codigo:"); txtcod.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { txtcodActionPerformed(evt); } }); jLabel2.setText("Descripcion:"); txtdes.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { txtdesActionPerformed(evt); } }); jLabel3.setText("Precio:"); txtpre.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) {

txtpreActionPerformed(evt); } }); jLabel5.setText("Stock:"); txtstock.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { txtstockActionPerformed(evt); } }); javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1); jPanel1.setLayout(jPanel1Layout); jPanel1Layout.setHorizontalGroup( jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup() .addContainerGap() .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel2) .addComponent(jLabel1) .addComponent(jLabel3) .addComponent(jLabel5)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(txtstock, javax.swing.GroupLayout.PREFERRED_SIZE, 68, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(txtcod, javax.swing.GroupLayout.PREFERRED_SIZE, 68, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(txtpre, javax.swing.GroupLayout.PREFERRED_SIZE, 68, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(txtdes, javax.swing.GroupLayout.PREFERRED_SIZE, 97, javax.swing.GroupLayout.PREFERRED_SIZE)) .addContainerGap(22, Short.MAX_VALUE)) ); jPanel1Layout.setVerticalGroup( jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup() .addContainerGap() .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel1) .addComponent(txtcod, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(17, 17, 17)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel2) .addComponent(txtdes, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel3) .addComponent(txtpre, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel5) .addComponent(txtstock, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addContainerGap(25, Short.MAX_VALUE)) ); jPanel2.setBorder(javax.swing.BorderFactory.createEtchedBorder()); btnnuevo.setText("Nuevo"); btnnuevo.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnnuevoActionPerformed(evt); } }); btnguardar.setText("Grabar"); btnguardar.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnguardarActionPerformed(evt); } }); btnactualizar.setText("Actualizar"); btnactualizar.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnactualizarActionPerformed(evt); } }); btncancelar.setText("Cancelar"); btncancelar.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btncancelarActionPerformed(evt); }

}); btnsalir.setText("Salir"); btnsalir.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnsalirActionPerformed(evt); } }); javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2); jPanel2.setLayout(jPanel2Layout); jPanel2Layout.setHorizontalGroup( jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel2Layout.createSequentialGroup() .addContainerGap() .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(btnactualizar, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(btnnuevo, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(btnguardar, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(btncancelar, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(btnsalir, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) ); jPanel2Layout.setVerticalGroup( jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel2Layout.createSequentialGroup() .addContainerGap() .addComponent(btnnuevo) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(btnguardar) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(btnactualizar) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(btncancelar) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(btnsalir) .addContainerGap(27, Short.MAX_VALUE)) ); tbproductos.setModel(new javax.swing.table.DefaultTableModel( new Object [][] {

{}, {}, {}, {} }, new String [] { } )); tbproductos.setComponentPopupMenu(jPopupMenu1); jScrollPane2.setViewportView(tbproductos); jLabel4.setText("Buscar:"); txtbuscar.addKeyListener(new java.awt.event.KeyAdapter() { public void keyReleased(java.awt.event.KeyEvent evt) { txtbuscarKeyReleased(evt); } }); jButton1.setText("Mostrar Todo"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addContainerGap() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createSequentialGroup() .addGap(14, 14, 14) .addComponent(jLabel4) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(txtbuscar, javax.swing.GroupLayout.PREFERRED_SIZE, 92, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jButton1))

.addComponent(jScrollPane2, javax.swing.GroupLayout.Alignment.TRAILING, 0, 0, Short.MAX_VALUE)) .addContainerGap()) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addContainerGap() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(txtbuscar, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel4) .addComponent(jButton1)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 129, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap()) ); pack(); }// private void txtcodActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: txtcod.transferFocus(); } private void btnsalirActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: this.dispose(); } private void btnnuevoActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: desbloquear(); limpiar(); txtcod.requestFocus(); codigos(); } private void btncancelarActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here:

bloquear(); } private void txtdesActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: txtdes.transferFocus(); } private void txtpreActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: txtpre.transferFocus(); } private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: cargar(""); } private void txtbuscarKeyReleased(java.awt.event.KeyEvent evt) { // TODO add your handling code here: cargar(txtbuscar.getText()); } private void mneliminarActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: int filasel= tbproductos.getSelectedRow(); try { if(filasel==-1) { JOptionPane.showMessageDialog(null, "Seleccione algun dato"); } else { String cod=(String)tbproductos.getValueAt(filasel, 0); String eliminarSQL="DELETE FROM producto WHERE cod_pro = '"+cod+"'"; try { PreparedStatement pst = cn.prepareStatement(eliminarSQL); pst.executeUpdate(); JOptionPane.showMessageDialog(null, "Borrado"); cargar(""); } catch (Exception e) { JOptionPane.showMessageDialog(null, e); } } } catch (Exception e) {

} } private void btnguardarActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: String cod,des,pre,stock; String sql=""; cod=txtcod.getText(); des=txtdes.getText(); pre=txtpre.getText(); stock=txtstock.getText(); sql="INSERT INTO producto (cod_pro,descripcion,precio,Stock) VALUES (?,?,?,?)"; try { PreparedStatement pst = cn.prepareStatement(sql); pst.setString(1, cod); pst.setString(2, des); pst.setString(3, pre); pst.setString(4, stock); int n=pst.executeUpdate(); if(n>0){ JOptionPane.showMessageDialog(null, "Registro Guardado con Exito"); bloquear(); } cargar(""); } catch (SQLException ex) { Logger.getLogger(IngresoProductos.class.getName()).log(Level.SEVERE, null, ex); } } private void mnactualizarActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: try { int filaMod=tbproductos.getSelectedRow(); if(filaMod==-1) { JOptionPane.showMessageDialog(null, "Seleccione alguna fila"); } else { btnactualizar.setEnabled(true); String cod=(String)tbproductos.getValueAt(filaMod, 0); desbloquear(); BuscarProductoEditar(cod); } } catch (Exception e) { }

} private void btnactualizarActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: String sql="UPDATE producto SET precio = '"+txtpre.getText()+"',descripcion ='"+txtdes.getText()+"',Stock = '"+txtstock.getText()+"' WHERE cod_pro = '"+txtcod.getText()+"'"; try { PreparedStatement pst = cn.prepareStatement(sql); pst.executeUpdate(); JOptionPane.showMessageDialog(null, "Actualizado"); cargar(""); bloquear(); limpiar(); } catch (Exception e) { JOptionPane.showMessageDialog(null, e); } } private void txtstockActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: }

// Variables declaration - do not modify private javax.swing.JButton btnactualizar; private javax.swing.JButton btncancelar; private javax.swing.JButton btnguardar; private javax.swing.JButton btnnuevo; private javax.swing.JButton btnsalir; private javax.swing.JButton jButton1; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel4; private javax.swing.JLabel jLabel5; private javax.swing.JPanel jPanel1; private javax.swing.JPanel jPanel2; private javax.swing.JPopupMenu jPopupMenu1; private javax.swing.JScrollPane jScrollPane1; private javax.swing.JScrollPane jScrollPane2; private javax.swing.JTable jTable1; private javax.swing.JMenuItem mnactualizar; private javax.swing.JMenuItem mneliminar; private javax.swing.JTable tbproductos; private javax.swing.JTextField txtbuscar; private javax.swing.JTextField txtcod; private javax.swing.JTextField txtdes; private javax.swing.JTextField txtpre;

private javax.swing.JTextField txtstock; // End of variables declaration conectar cc= new conectar(); Connection cn=cc.conexion(); }