agregardato.java

ejemplo de java para conexion a base de datos

/*
 * agregardato.java
 *
 * Created on 23 de junio de 2004, 11:45 AM
 */

/**
 *
 * @author  Alumno_Ing
 */
import javax.swing.table .*;
import java.sql.*;
public class agregardato extends javax.swing.JDialog {
    Connection aconn;
    /** Creates new form agregardato */
    public agregardato(java.awt.Frame parent, boolean modal,Connection acon) throws Exception {
        super(parent, modal);
        initComponents();
        setSize(500, 400);
        aconn=acon;
         carga();
    }
    
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    private void initComponents() {//GEN-BEGIN:initComponents
        todo = new javax.swing.ButtonGroup();
        p_nombre = new javax.swing.JTextField();
        aceptar = new javax.swing.JButton();
        jButton1 = new javax.swing.JButton();
        rut = new javax.swing.JTextField();
        ap_paterno = new javax.swing.JTextField();
        s_nombre = new javax.swing.JTextField();
        ap_materno = new javax.swing.JTextField();
        label1 = new java.awt.Label();
        label2 = new java.awt.Label();
        label3 = new java.awt.Label();
        label4 = new java.awt.Label();
        label5 = new java.awt.Label();
        label6 = new java.awt.Label();
        label7 = new java.awt.Label();
        label8 = new java.awt.Label();
        ciudad = new javax.swing.JComboBox();
        uno = new javax.swing.JRadioButton();
        dos = new javax.swing.JRadioButton();
        caja = new javax.swing.JCheckBox();

        getContentPane().setLayout(null);

        addWindowListener(new java.awt.event.WindowAdapter() {
            public void windowClosing(java.awt.event.WindowEvent evt) {
                closeDialog(evt);
            }
        });

        getContentPane().add(p_nombre);
        p_nombre.setBounds(130, 100, 110, 30);

        aceptar.setText("aceptar");
        aceptar.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                aceptarActionPerformed(evt);
            }
        });

        getContentPane().add(aceptar);
        aceptar.setBounds(50, 300, 78, 26);

        jButton1.setText("salir");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });

        getContentPane().add(jButton1);
        jButton1.setBounds(170, 300, 59, 26);

        getContentPane().add(rut);
        rut.setBounds(130, 60, 110, 30);

        getContentPane().add(ap_paterno);
        ap_paterno.setBounds(130, 180, 110, 30);

        getContentPane().add(s_nombre);
        s_nombre.setBounds(130, 140, 110, 30);

        getContentPane().add(ap_materno);
        ap_materno.setBounds(130, 220, 110, 30);

        label1.setText("Rut");
        getContentPane().add(label1);
        label1.setBounds(20, 60, 60, 30);

        label2.setText("Ap Paterno");
        getContentPane().add(label2);
        label2.setBounds(18, 190, 90, 20);

        label3.setText("Nombre");
        getContentPane().add(label3);
        label3.setBounds(20, 100, 60, 20);

        label4.setText("Seg. Nombre");
        getContentPane().add(label4);
        label4.setBounds(20, 140, 110, 30);

        label5.setText("Ap Materno");
        getContentPane().add(label5);
        label5.setBounds(20, 220, 90, 30);

        label6.setText("ciudad");
        getContentPane().add(label6);
        label6.setBounds(280, 70, 41, 20);

        label7.setText("estado civil");
        getContentPane().add(label7);
        label7.setBounds(280, 150, 60, 20);

        label8.setText("sexo");
        getContentPane().add(label8);
        label8.setBounds(280, 110, 30, 20);

        ciudad.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                ciudadActionPerformed(evt);
            }
        });

        getContentPane().add(ciudad);
        ciudad.setBounds(350, 70, 50, 25);

        uno.setText("mas.");
        todo.add(uno);
        getContentPane().add(uno);
        uno.setBounds(320, 110, 60, 24);

        dos.setText("fem.");
        todo.add(dos);
        getContentPane().add(dos);
        dos.setBounds(380, 110, 70, 24);

        caja.setText("soltero");
        caja.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cajaActionPerformed(evt);
            }
        });

        getContentPane().add(caja);
        caja.setBounds(360, 150, 93, 24);

        pack();
    }//GEN-END:initComponents

    private void cajaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cajaActionPerformed
        // Add your handling code here:
    }//GEN-LAST:event_cajaActionPerformed

    private void ciudadActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ciudadActionPerformed
        
    }//GEN-LAST:event_ciudadActionPerformed

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
dispose();        // Add your handling code here:
    }//GEN-LAST:event_jButton1ActionPerformed

    private void aceptarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_aceptarActionPerformed
 Statement stmt;
  String a=rut.getText();
  String b=p_nombre.getText();
  String c=s_nombre.getText();
  String d=ap_paterno.getText();
  String e=ap_materno.getText();
  int aux=0;
  int aux1;
  String combo;
  
        try
       { 

          if(caja.isSelected()==true)
                aux=1;   
          if(uno.isSelected()==true)
                aux1=1;
          else
              aux1=0;
              
         String consulta;
         combo=(String)ciudad.getSelectedItem(); 
         stmt = aconn.createStatement();  
        
         consulta="insert into persona values('"+ a+"','"+ b+"','"+ c+"','"+ d+"','"+ e+"','"+ b+"','"+ aux1+"','"+ aux+"') ";
         stmt.executeUpdate(consulta);
         carga();
         stmt.close();
         dispose();
        }
        catch (SQLException ex)
        {
            System.out.println("Hubo un error en la consulta ... :"+ex);
        } 
 
    
    }//GEN-LAST:event_aceptarActionPerformed
    
    /** Closes the dialog */
    private void closeDialog(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_closeDialog
        setVisible(false);
        dispose();
    }//GEN-LAST:event_closeDialog
    public void carga(){
     try
        {
        Statement stmt;
        ResultSet rs;
    
        stmt=aconn.createStatement();
        rs=stmt.executeQuery("Select * from ciudad");
        ciudad.removeAllItems();
           while(rs.next())
           {
             ciudad.addItem(rs.getString("nombre"));
           }   
        }
        catch(Exception e) 
        {
            System.out.println("error:+ e");
        }
    }
   
    
    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JButton aceptar;
    private javax.swing.JTextField ap_materno;
    private javax.swing.JTextField ap_paterno;
    private javax.swing.JCheckBox caja;
    private javax.swing.JComboBox ciudad;
    private javax.swing.JRadioButton dos;
    private javax.swing.JButton jButton1;
    private java.awt.Label label1;
    private java.awt.Label label2;
    private java.awt.Label label3;
    private java.awt.Label label4;
    private java.awt.Label label5;
    private java.awt.Label label6;
    private java.awt.Label label7;
    private java.awt.Label label8;
    private javax.swing.JTextField p_nombre;
    private javax.swing.JTextField rut;
    private javax.swing.JTextField s_nombre;
    private javax.swing.ButtonGroup todo;
    private javax.swing.JRadioButton uno;
    // End of variables declaration//GEN-END:variables
    
}