Javada Veritabanındaki Verileri Tabloya Yazdırmak

Veritabanındaki kayıtları bu sefer de tabloda gösterelim dedik. Tablo kullanımı daha farklı ve komplike olduğu için kodlarımız da bu doğrultuda değişti. İşte gerekli kodlar ve tablo kullanımı...

import java.sql.*;

import java.util.logging.Level;

import java.util.logging.Logger;

public class VeriTabani3 extends javax.swing.JFrame {

    /** Creates new form VeriTabani3 */

    public VeriTabani3() {

        initComponents();

    }

    @SuppressWarnings("unchecked")

    // <editor-fold defaultstate="collapsed" desc="Generated Code">

    private void initComponents() {

        jButton1 = new javax.swing.JButton();

        jLabel1 = new javax.swing.JLabel();

        jScrollPane1 = new javax.swing.JScrollPane();

        jTable1 = new javax.swing.JTable();

        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);

            }

        });

        jLabel1.setText("başlık");

        jTable1.setModel(new javax.swing.table.DefaultTableModel(

            new Object [][] {

                {null, null, null, null, null},

                {null, null, null, null, null},

                {null, null, null, null, null},

                {null, null, null, null, null}

            },

            new String [] {

                "SİCİL NO", "ADI", "SOYADI", "GÖREVİ", "DEPARTMANI"

            }

        ));

        jScrollPane1.setViewportView(jTable1);

        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()

                        .addGap(85, 85, 85)

                        .addComponent(jLabel1))

                    .addGroup(layout.createSequentialGroup()

                        .addGap(205, 205, 205)

                        .addComponent(jButton1))

                    .addGroup(layout.createSequentialGroup()

                        .addGap(55, 55, 55)

                        .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 428, javax.swing.GroupLayout.PREFERRED_SIZE)))

                .addContainerGap(103, Short.MAX_VALUE))

        );

        layout.setVerticalGroup(

            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

            .addGroup(layout.createSequentialGroup()

                .addGap(20, 20, 20)

                .addComponent(jLabel1)

                .addGap(44, 44, 44)

                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 147, javax.swing.GroupLayout.PREFERRED_SIZE)

                .addGap(32, 32, 32)

                .addComponent(jButton1)

                .addContainerGap(46, Short.MAX_VALUE))

        );

        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");

            int sütun=0,satir=0;

            while (SonucVeriler.next()) {

                jTable1.setValueAt(SonucVeriler.getString("Sicil"), satir, sütun++);

                jTable1.setValueAt(SonucVeriler.getString("Adi"), satir, sütun++);

                jTable1.setValueAt(SonucVeriler.getString("Soyadi"), satir, sütun++);

                jTable1.setValueAt(SonucVeriler.getString("Gorevi"), satir, sütun++);

                jTable1.setValueAt(SonucVeriler.getString("Departmani"), satir, sütun);

                sütun=0;

                satir++;

            }

        } catch (SQLException ex) {

            Logger.getLogger(VeriTabani2.class.getName()).log(Level.SEVERE, null, ex);

        }

    }

    public static void main(String args[]) {

        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {

                new VeriTabani3().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.JTable jTable1;

    // End of variables declaration

}