datosciudad.java

ejemplo de java para conexion a base de datos

/*
 * datosciudad.java
 *
 * Created on 25 de junio de 2004, 12:21 AM
 */

/**
 *
 * @author  GeBuSe
 */
import javax.swing.table .*;
import java.sql.*;
public class datosciudad extends javax.swing.JDialog {
private Connection pcon; 
    /** Creates new form datosciudad */
    public datosciudad(java.awt.Frame parent, boolean modal,Connection ppcon) throws Exception {
        super(parent, modal);
        initComponents();
        setSize(500, 400);
        pcon=ppcon;
        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();
        ciudad = new javax.swing.JTable();
        agregar = new javax.swing.JButton();
        jButton2 = 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);
            }
        });

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

        getContentPane().add(jScrollPane1);
        jScrollPane1.setBounds(0, 0, 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(60, 200, 79, 26);

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

        getContentPane().add(jButton2);
        jButton2.setBounds(160, 200, 81, 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(270, 200, 110, 26);

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

    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 jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
dispose();        // Add your handling code here:
    }//GEN-LAST:event_jButton2ActionPerformed

    private void agregarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_agregarActionPerformed
agreciudad agre;
try{
    agre=new agreciudad(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[]) {
        new datosciudad(new javax.swing.JFrame(), true).show();
    }*/
    public void inicializar(){
        String titulos[]=new String[]{"Id","Nombre"};
        DefaultTableModel dtm=new DefaultTableModel(null,titulos);
        ciudad.setModel(dtm);
    }  
     public void llenatabla()throws Exception {
        Statement stmt;
        ResultSet rs;
        try
        {
            stmt=pcon.createStatement();
            rs=stmt.executeQuery("Select * from ciudad");
            DefaultTableModel dtm;
            dtm = (DefaultTableModel)ciudad.getModel();
                 for (int i=ciudad.getRowCount()-1;i>=0;i--)
        { 
            dtm.removeRow(i);
        } 
            while (rs.next())
            {
                String data[] = new String[] {rs.getString("id"),rs.getString("nombre")};
                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 agregar;
    private javax.swing.JTable ciudad;
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JScrollPane jScrollPane1;
    // End of variables declaration//GEN-END:variables
    
}