Membuat aplikasi Database sederhana menggunakan Java GUI dan MySQL

Pembuatan Database Di phpMyadmin

1. Buka XAMPP kemudian Klik Start Apache Dan My Sql.
2. Buka Browser dalam keadaan internet Off, lalu masukkan alamat localhost/phpmyadmin.
3. Buat Database baru beserta tabelnya.

Saya mengatur jumlah Kolom 4

Buka Netbeans

Pembuatan Database Telepon GUI

Langkah Pembuatan :

Siapkan

1. 6 Jlabel
2. 2 Jbutton
3. 1 Combo box
4. 1jtabel
5. 4 Text Field

Berikut Tata letaknya

Ubah Menjadi

• Klik Kanan JTextField id kontak -> ChangeVariableName (id_kontakTextField)
• Klik Kanan JTextField nama kontak -> ChangeVariableName (nama_kontakTextField)
• Klik Kanan JTextField no kontak -> ChangeVariableName (no_kontakTextField)
• Klik Kanan JTextField alamat -> ChangeVariableName (alamat_kontakTextField)
• Klik Kanan Combo Box Status -> ChangeVariableName (statusComboBox)
• Klik Kanan JButton Simpan -> ChangeVariableName (btnsimpan)
• Klik Kanan JButton Keluar -> ChangeVariableName (btnkeluar)

Masukan Source Code

package aplikasi_buku_telepon;

import java.awt.Dimension;
import java.awt.Toolkit;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.table.DefaultTableModel;
/**
 *
 * @author Luthtiansyah5
 */
public class input_data_kontak extends javax.swing.JFrame {
private Connection con;
private Statement stat;
private ResultSet res;
private String t;
   
    public input_data_kontak() throws SQLException {
        initComponents();
        koneksi ();
        kosongkan ();
        status ();
        table ();
     
        //rata kiri rata kanan
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize = getSize();
        setLocation (
                (screenSize.width - frameSize.width) / 3,
                (screenSize.height - frameSize.height) / 4);
        
    }

#Beri Source Code Pada Method Koneksi (); 

 private void koneksi() {

    try {
        Class.forName("com.mysql.jdbc.Driver");
        con=DriverManager.getConnection("jdbc:mysql://127.0.0.1/database_kontak","root","");
        stat=con.createStatement ();
    } catch (Exception e){
        JOptionPane.showMessageDialog(null,e);
    }
    }

#Beri Source Code Pada Method    Kosongkan ();

private void kosongkan() {
    id_kontakTextField.setText("");
    nama_kontakTextField.setText("");
    no_kontakTextField.setText("");
    alamat_kontakTextField.setText("");
    id_kontakTextField.setText("");
    statusComboBox.setSelectedIndex(-1);
    }

#Beri Source Code Pada Method Status(); 

private void status() {

    statusComboBox.addItem("Keluarga");
    statusComboBox.addItem("Teman");
    statusComboBox.addItem("Kenalan");
    statusComboBox.addItem("Rekan Kerja");
    }

#Beri Source Code Pada Method table();
private void table() {
        DefaultTableModel t= new DefaultTableModel();
        t.addColumn("id");
        t.addColumn("Nama");
        t.addColumn("No Kontak");
        t.addColumn("Alamat");
        t.addColumn("Status");
        Table.setModel(t); try{ res=stat.executeQuery("select * from data_kontak");
        while (res.next()){
            t.addRow(new Object[]{ res.getString("id_kontak"),
            res.getString("nama_kontak"),
            res.getString("no_kontak"),
            res.getString("alamat"),
            res.getString("status")
        });
        }
        }catch (Exception e){
    JOptionPane.showMessageDialog(rootPane, e);
}
    }
}

# Klik Kanan Button Simpan -> Events -> action -> Action Performed

Masukkan Source Code :

private void btnsimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnsimpanActionPerformed
   try{
       stat.executeUpdate("insert into data_kontak values("
+ "'" +id_kontakTextField.getText()+"',"
+ "'" +nama_kontakTextField.getText()+"',"
+ "'" +no_kontakTextField.getText()+"',"
+ "'" +alamat_kontakTextField.getText()+"',"
+ "'" +statusComboBox.getSelectedItem()+ "')");
kosongkan();
               JOptionPane.showMessageDialog(null, "Berhasil Menyimpan Data");
       }catch (Exception e){
       JOptionPane.showMessageDialog(null, "Perintah Salah :"+e);
   }
    }

# Klik Kanan Button Keluar -> Events -> action -> Action Performed

Masukkan Source Code :

private void btnkeluarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnkeluarActionPerformed
    System.exit(0);
    }

Hasil Output Netbeans

Hasil Tersimpan Dalam Database yang dibuat