datos.java

ejemplo de java para conexion a base de datos

/*
 * datos_persona.java
 *
 * Created on 12 de junio de 2004, 12:01 AM
 */

/**
 *
 * @author  GBS
 */

import javax.swing.table .*;
import java.sql.*;
public class datos extends javax.swing.JDialog {  
public Connection pcon;    /** Creates new form datos_persona */
    public datos(java.awt.Frame parent, boolean modal,Connection ppconn)throws Exception  {
        super(parent,modal);
        initComponents();
        setSize(500, 400);
        pcon=ppconn;
        inicializar();
        llenatabla();
        
       
    }
    
    /** 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
        jScrollPane1 = new javax.swing.JScrollPane();
        tabla = new javax.swing.JTable();
        agregar = new javax.swing.JButton();
        modificar = new javax.swing.JButton();
        eliminar = new javax.swing.JButton();
        salir = new javax.swing.JButton();
        jButton1 = new javax.swing.JButton();

        getContentPane().setLayout(null);

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

        tabla.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(tabla);

        getContentPane().add(jScrollPane1);
        jScrollPane1.setBounds(0, 20, 400, 80);

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

        getContentPane().add(agregar);
        agregar.setBounds(30, 150, 90, 26);

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

        getContentPane().add(modificar);
        modificar.setBounds(140, 150, 100, 26);

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

        getContentPane().add(eliminar);
        eliminar.setBounds(270, 150, 80, 26);

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

        getContentPane().add(salir);
        salir.setBounds(20, 260, 59, 26);

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

        getContentPane().add(jButton1);
        jButton1.setBounds(100, 260, 100, 26);

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

    private void eliminarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_eliminarActionPerformed
     eliminar eli;
     eli=new eliminar(new javax.swing.JFrame(),true,pcon);
     eli.show();
    }//GEN-LAST:event_eliminarActionPerformed

    private void modificarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_modificarActionPerformed
   modificar modi;
try{
    modi=new modificar(new javax.swing.JFrame(),true,pcon);
    modi.show();
}
catch(Exception ex)
{}     // Add your handling code here:
    }//GEN-LAST:event_modificarActionPerformed

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

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

    private void agregarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_agregarActionPerformed
agregardato agre;
try{
    agre=new agregardato(new javax.swing.JFrame(),true,pcon);
    agre.show();
}
catch(Exception ex)
{}
    }//GEN-LAST:event_agregarActionPerformed
    
    /** Closes the dialog */
    private void closeDialog(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_closeDialog
        setVisible(false);
        dispose();
    }//GEN-LAST:event_closeDialog
    
    /**
     * @param args the command line arguments
     */
    /*public static void main(String args[]) throws Exception {
        new datos(new javax.swing.JFrame(), true).show();
    }*/
     public void inicializar(){
        String titulos[]=new String[]{"rut","ap paterno","ap materno","p nombre","s nombre"};
        DefaultTableModel dtm=new DefaultTableModel(null,titulos);
        tabla.setModel(dtm);
    }  
     public void llenatabla()throws Exception {
        Statement stmt;
        ResultSet rs;
       
        try
        {
            stmt=pcon.createStatement();
            rs=stmt.executeQuery("Select * from persona");
            DefaultTableModel dtm;
            dtm = (DefaultTableModel)tabla.getModel();
            
            for (int i=tabla.getRowCount()-1;i>=0;i--)
        { 
            dtm.removeRow(i);
        } 
            
            
            
            
            
            while (rs.next())
            {
                String data[] = new String[] {rs.getString("rut"),rs.getString("ap_paterno"),rs.getString("ap_materno"),rs.getString("p_nombre"),rs.getString("s_nombre")};
                dtm.addRow(data); 
                dtm.fireTableDataChanged();
            }
        }
        catch (SQLException ex)
        {
            System.out.println("SQLException: " + ex.getMessage()); 
            System.out.println("SQLState: " + ex.getSQLState()); 
            System.out.println("VendorError: " + ex.getErrorCode()); 
        }
}   
    
    
    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JButton agregar;
    private javax.swing.JButton eliminar;
    private javax.swing.JButton jButton1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JButton modificar;
    private javax.swing.JButton salir;
    private javax.swing.JTable tabla;
    // End of variables declaration//GEN-END:variables

}