muestra_todo.java

ejemplo de java para conexion a base de datos

/*
 * muetra_todo.java
 *
 * Created on 26 de junio de 2004, 02:07 AM
 */

/**
 *
 * @author  GeBuSe
 */
import javax.swing.table .*;
import java.sql.*;
public class muestra_todo extends javax.swing.JDialog {
private Connection acon;    
    /** Creates new form muetra_todo */
    public muestra_todo(java.awt.Frame parent, boolean modal,Connection pcon)throws Exception {
        super(parent, modal);
       initComponents();
        setSize(650, 400);
        acon=pcon;
        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();
        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, 0, 550, 160);

        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(50, 260, 59, 26);

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

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
dispose();        // Add your handling code here:
    }//GEN-LAST:event_jButton1ActionPerformed
    
    /** 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[]) {
        new muestra_todo(new javax.swing.JFrame(), true).show();
    }*/
   public void inicializar(){
        String titulos[]=new String[]{"rut","ap paterno","ap materno","p nombre","s nombre","id_ciudad","sexo","soltero"};
        DefaultTableModel dtm=new DefaultTableModel(null,titulos);
        tabla.setModel(dtm);
    }  
     public void llenatabla()throws Exception {
        Statement stmt;
        ResultSet rs;
        try
        {
            stmt=acon.createStatement();
            rs=stmt.executeQuery("Select * from persona");
            DefaultTableModel dtm;
            dtm = (DefaultTableModel)tabla.getModel();
            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"),rs.getString("id_ciudad"),rs.getString("sexo"),rs.getString("soltero")};
                dtm.addRow(data);                
            }
        }
        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 jButton1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTable tabla;
    // End of variables declaration//GEN-END:variables
    
}