26 Nisan 2013 Cuma

Javada Veritabanındaki Verileri jTextArea'ya Yazdırmak

Veri tabanından verileri çağıran ve jtextareaya yazan programın kodları aşağıdadır. Daha önceden Access veritabanımızda oluşturduğumuz kayıtları gerekli kodlar yardımıyla tabloya çağırıyoruz.
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
public class VeriTabani2 extends javax.swing.JFrame {


    public VeriTabani2() {
        initComponents();
    }

    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">
    private void initComponents() {

        jButton1 = new javax.swing.JButton();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTextArea1 = new javax.swing.JTextArea();
        jLabel1 = new javax.swing.JLabel();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

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

        jTextArea1.setColumns(20);
        jTextArea1.setRows(5);
        jScrollPane1.setViewportView(jTextArea1);

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addContainerGap()
                        .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 364, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(layout.createSequentialGroup()
                        .addGap(40, 40, 40)
                        .addComponent(jLabel1))
                    .addGroup(layout.createSequentialGroup()
                        .addGap(104, 104, 104)
                        .addComponent(jButton1)))
                .addContainerGap(26, Short.MAX_VALUE))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGap(44, 44, 44)
                .addComponent(jLabel1)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 133, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 40, Short.MAX_VALUE)
                .addComponent(jButton1)
                .addGap(54, 54, 54))
        );

        jScrollPane1.getAccessibleContext().setAccessibleParent(jTextArea1);

        pack();
    }// </editor-fold>

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
        try {
            try {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            } catch (ClassNotFoundException ex) {
                Logger.getLogger(VeriTabani2.class.getName()).log(Level.SEVERE, null, ex);
            }
            java.sql.Connection baglanti = null;
            try {
                baglanti = java.sql.DriverManager.getConnection("jdbc:odbc:Personel", "", "");
            } catch (SQLException ex) {
                Logger.getLogger(VeriTabani2.class.getName()).log(Level.SEVERE, null, ex);
            }
            java.sql.Statement sorgulama = null;
            try {
                sorgulama = baglanti.createStatement();
            } catch (SQLException ex) {
                Logger.getLogger(VeriTabani2.class.getName()).log(Level.SEVERE, null, ex);
            }
            java.sql.ResultSet SonucVeriler = sorgulama.executeQuery("SELECT * FROM Elemanlar");
            jLabel1.setText("Personel Veri Tabanı Elemanlar Listesi");
          
            while (SonucVeriler.next()) {
            
                jTextArea1.append(SonucVeriler.getString("Sicil")+"\t");
             
                jTextArea1.append(SonucVeriler.getString("Adi")+"\t");
              
                 jTextArea1.append(SonucVeriler.getString("Soyadi")+"\t");
               
                 jTextArea1.append(SonucVeriler.getString("Gorevi")+"\t");
              
                jTextArea1.append(SonucVeriler.getString("Departmani")+"\n");
               
               
            }
        } catch (SQLException ex) {
            Logger.getLogger(VeriTabani2.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new VeriTabani2().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify
    private javax.swing.JButton jButton1;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTextArea jTextArea1;
    // End of variables declaration

}

Hiç yorum yok:

Yorum Gönder