Rabu, 07 Maret 2012

Program Menampilkan Isi Database Ke Tabel Java Netbeans (Koneksi Database)




Kali ini saya membuat program tampilkan isi database ke java, database disini saya gunakan Xammp contoh kasus seperti dibawah ini. Program dibawah ini adalah program koneksi.java kita beri nama, untuk lebih jelas perhatikan coding dibawah ini.
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
    package teskoneksidatabse2;

    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    import javax.swing.JOptionPane;

   
    public class koneksi {
    public Connection koneksidatabase;

    public Connection getkoneksi()
        {
            if (koneksidatabase == null)
            {
                try {
                    Class.forName("com.mysql.jdbc.Driver");
                    JOptionPane.showMessageDialog(null,"Driver DITEMUKAN");
                }catch(ClassNotFoundException ex) { 
                JOptionPane.showMessageDialog(null,"Driver ERROR, Keterangan : " +ex.toString());
                }


                try {
                    koneksidatabase = DriverManager.getConnection("jdbc:mysql://localhost:3306/db_buku","root","");
                    JOptionPane.showMessageDialog(null,"Driver Manager DITEMUKAN");  
                }catch (SQLException ex) {
                JOptionPane.showMessageDialog(null,"Driver ERROR, Keterangan : " +ex.toString());
                }
                
                
        }
        
                    return koneksidatabase;
        }
    }

Dan program kedua kita membuat objek di class baru. main.java kita beri nama coding ini seperti tampilan dibawah ini ketik atau copy.
  
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
package teskoneksidatabse2;

/**
 *
 * @author JAYA HARRYSINAGA
 */
public class main {
    public static void main(String[] args) {
        
        koneksi Koneksi = new koneksi ();
        Koneksi.getkoneksi();
      
    }
}

Dan sesudah membuat program diatas selesai kita membuat form tampil database pada tabel, dan disini kita harus membuat Jframeform baru.dan desain lah sesuai koding dibawah ini lalu masukkan codingya. 

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
package teskoneksidatabse2;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.table.DefaultTableModel;

/**
 *
 * @author JAYA HARRYSINAGA
 */
public class FormBuku extends javax.swing.JFrame {
DefaultTableModel modeltabelbuku = new DefaultTableModel();
koneksi koneksi = new koneksi();

    /** Creates new form FormBuku */
    public FormBuku() {
        initComponents();
        modeltabelbuku.addColumn("ID Buku");
        modeltabelbuku.addColumn("Judu Buku");
        modeltabelbuku.addColumn("Penerbit");
        modeltabelbuku.addColumn("Harga");
        modeltabelbuku.addColumn("Stok");
        TabelBuku.setModel(modeltabelbuku);
    }
    
    /** 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.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

        jPanel1 = new javax.swing.JPanel();
        jScrollPane1 = new javax.swing.JScrollPane();
        TabelBuku = new javax.swing.JTable();
        Button_Tampil = new javax.swing.JButton();
        jLabel1 = new javax.swing.JLabel();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        setTitle("Tampil Konfigurasi DataBase");

        jPanel1.setBackground(new java.awt.Color(0, 153, 204));

        TabelBuku.setBackground(new java.awt.Color(153, 153, 153));
        TabelBuku.setFont(new java.awt.Font("Tahoma", 1, 11));
        TabelBuku.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(TabelBuku);

        Button_Tampil.setFont(new java.awt.Font("Tahoma", 1, 12));
        Button_Tampil.setText("Tampil");
        Button_Tampil.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                Button_TampilActionPerformed(evt);
            }
        });

        jLabel1.setFont(new java.awt.Font("Tahoma", 1, 18));
        jLabel1.setForeground(new java.awt.Color(204, 204, 255));
        jLabel1.setText("KONFIGURASI TAMPIL DATA DARI DATABASE");

        javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addContainerGap()
                        .addComponent(Button_Tampil, javax.swing.GroupLayout.PREFERRED_SIZE, 127, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addContainerGap()
                        .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 561, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(79, 79, 79)
                        .addComponent(jLabel1)))
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jLabel1)
                .addGap(18, 18, 18)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 133, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(Button_Tampil)
                .addContainerGap(20, Short.MAX_VALUE))
        );

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                .addContainerGap(16, Short.MAX_VALUE)
                .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(20, 20, 20))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(13, Short.MAX_VALUE))
        );

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

    private void Button_TampilActionPerformed(java.awt.event.ActionEvent evt) {                                              
       tampilBuku();
    }
        
       public void tampilBuku() {
           Connection koneksitabelbuku = koneksi.getkoneksi();
           try{
               Statement statementTampil = koneksitabelbuku.createStatement();
               
               String Sql ="SELECT * From tabel_buku";
               ResultSet resultSet = statementTampil.executeQuery(Sql);
               while (resultSet.next()){
                  ArrayList<Object> objectsBuku = new ArrayList<Object>();
                  objectsBuku.add(resultSet.getInt("id_buku"));
                  objectsBuku.add(resultSet.getString("judul_buku"));
                  objectsBuku.add(resultSet.getString("penerbit"));
                  objectsBuku.add(resultSet.getString("harga"));
                  objectsBuku.add(resultSet.getString("stok"));
                  
                  modeltabelbuku.addRow(objectsBuku.toArray());
                 
               }
               
    }catch (SQLException ex) {
        Logger.getLogger(FormBuku.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 FormBuku().setVisible(true);
            }
        });
    }
    // Variables declaration - do not modify                     
    private javax.swing.JButton Button_Tampil;
    private javax.swing.JTable TabelBuku;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JScrollPane jScrollPane1;
    // End of variables declaration                   
}
Dibuat oleh Jaya Harry Sinaga

Tidak ada komentar:

Posting Komentar

Tolong Beri Komentar Anda Tentang Web Site Saya.

Langganan: Posting Komentar (Atom)