Lanjutan Program Sewa Lapangan Futsal Java GUI dengan MySQL

Siapkan :
1.) XAMPP Control Panel
2.) Netbeans IDE 8.0.2 
3.) Web Browser 

BERIKUT LANGKAH-LANGKAHNYA :
1.) Buka XAMPP > Klik Start Pada Apache Dan MySql











2.) Buka Web Browser Masukkan alamat localhost/phpmyadmin

3.) Buat 3 Database Baru pada phpMyAdmin










4.) Struktur data_lapangan_futsal









5.) Struktur data_lapangan_futsal_2









6.) Struktur data_lapangan_futsal_3










LANJUT NETBEANS

BERIKUT DESAIN






Siapkan :
11 JLabel
7 JButton
2 Panel
3 JTable
2 ComboBox

#Change Variable Name
 
 
 
 
 
 
  • Klik Kanan JTextField No.Booking > ChangeVariableName Menjadi no_pelangganTextField
  • Klik Kanan JTextField Nama Team > ChangeVariableName Menjadi nama_TextField
  • Klik Kanan ComboBox lama main > ChangeVariableName Menjadi lama_ComboBox
  • Klik Kanan JTextField Harga > ChangeVariableName Menjadi harga_TextField
  • Klik Kanan JTextField Nama Team > ChangeVariableName Menjadi nama_TextField
  • Klik Kanan ComboBox Jenis Lapangan > ChangeVariableName Menjadi jenis_ComboBox
  • Klik Kanan JTextField Alamat > ChangeVariableName Menjadi alamatTextField
  • Klik Kanan JTextField No.Telepon > ChangeVariableName Menjadi telponTextField
  • Klik Kanan Tabel 1 > ChangeVariableName Menjadi Table
  • Klik Kanan Tabel 2 > ChangeVariableName Menjadi Tabel2
  • Klik Kanan Tabel 3 > ChangeVariableName Menjadi Tabel3
  • Klik Kanan JButton Simpan > ChangeVariableName Menjadi btnsimpan
  • Klik Kanan JButton Edit > ChangeVariableName Menjadi btnedit
  • Klik Kanan JButton Lihat > ChangeVariableName Menjadi btnlihat
  • Klik Kanan JButton Cari > ChangeVariableName Menjadi btncari
  • Klik Kanan JButton Keluar > ChangeVariableName Menjadi btnkeluar
  • Klik Kanan JButton Ganti Alamat > ChangeVariableName Menjadi btngantialamat
  • Klik Kanan JButton Ganti Nomor > ChangeVariableName Menjadi btngantinomor
# Masukkan Source Code
package aplikasi_sewa_lapangan_futsal;
import java.awt.Dimension;
import java.awt.Toolkit;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
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;

public class data_lapangan_futsal extends javax.swing.JFrame {
private Connection con;
private Statement stat;
private ResultSet res;
private DefaultTableModel dtm;
 
    public data_lapangan_futsal()throws SQLException {
        initComponents();
        setTitle("Luthtiansyah 181011400736 UAS");
    koneksi ();
        kosongkan ();
        table ();
        table2 ();
        table3 ();
        jenis ();
        lama ();
    }

# Source Code Method Koneksi

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

# Source Code Method Kosongkan
    private void kosongkan() {
    no_pelangganTextField.setText("");
    nama_TextField.setText("");
    jenis_ComboBox.setSelectedIndex(-1);
    lama_ComboBox.setSelectedIndex(-1);
    harga_TextField.setText("");
    alamatTextField.setText("");
    telponTextField.setText("");
    }
# Source Code Method table

    private void table() {
       DefaultTableModel t= new DefaultTableModel();
        t.addColumn("no_booking");
        t.addColumn("nama_team");
        t.addColumn("jenis_lapangan");
        t.addColumn("lama_main");
        t.addColumn("harga_lapangan");
        Table.setModel(t); try{ res=stat.executeQuery("select * from data_lapangan_futsal");
        while (res.next()){
            t.addRow(new Object[]{ res.getString("no_booking"),
            res.getString("nama_team"),
            res.getString("jenis_lapangan"),
            res.getString("lama_main"),
            res.getString("harga_lapangan"),
        });
        }
        }catch (Exception e){
    JOptionPane.showMessageDialog(rootPane, e);
}
    }

# Source Code Method jenis
    private void jenis() {
    jenis_ComboBox.addItem("PLESTER");
    jenis_ComboBox.addItem("RUMPUT");
    }

# Source Code Method lama
    private void lama() {
    lama_ComboBox.addItem("1 JAM");
    lama_ComboBox.addItem("2 JAM");
    lama_ComboBox.addItem("3 JAM");
    lama_ComboBox.addItem("4 JAM");
    lama_ComboBox.addItem("5 JAM");
    lama_ComboBox.addItem("6 JAM");
    }

# Source Code Method table2
    private void table2() {
    DefaultTableModel t= new DefaultTableModel();
        t.addColumn("no_booking");
        t.addColumn("nama_team");
        t.addColumn("alamat");
        Tabel2.setModel(t); try{ res=stat.executeQuery("select * from data_lapangan_futsal_2");
        while (res.next()){
            t.addRow(new Object[]{ res.getString("no_booking"),
            res.getString("nama_team"),    
            res.getString("alamat"),
        });
        }
        }catch (Exception e){
    JOptionPane.showMessageDialog(rootPane, e);
}
    }

# Source Code Method table3
    private void table3() {
    DefaultTableModel t= new DefaultTableModel();
        t.addColumn("no_booking");
        t.addColumn("nama_team");
        t.addColumn("no_telepon");
        Tabel3.setModel(t); try{ res=stat.executeQuery("select * from data_lapangan_futsal_3");
        while (res.next()){
            t.addRow(new Object[]{ res.getString("no_booking"),
            res.getString("nama_team"),    
            res.getString("no_telepon"),
        });
        }
        }catch (Exception e){
    JOptionPane.showMessageDialog(rootPane, e);
}
    }
    }
# Klik Kanan JTextField No.Booking > Events > Action > actionperformed

 
 
 
 
 
 
Masukkan Source Code :
try{
 res=stat.executeQuery("Select * from data_lapangan_futsal where " +"no_pelanggan='"+no_pelangganTextField.getText()+"'"); 
        res=stat.executeQuery("Select * from data_lapangan_futsal_2 where "+ "alamat='"+alamatTextField.getText()+"'");
        res=stat.executeQuery("Select * from data_lapangan_futsal_3 where "+ "no_telepon='"+telponTextField.getText()+"'");
while (res.next())
    {nama_TextField.setText(res.getString("nama"));
    jenis_ComboBox.setSelectedItem(res.getString("jenis"));
    lama_ComboBox.setSelectedItem(res.getString("lama"));
    harga_TextField.setText(res.getString("harga"));
    }
    }catch (Exception e){
        JOptionPane.showMessageDialog(rootPane,e);      
    }
    }//GEN-LAST:event_no_pelangganTextFieldActionPerformed
 
# Klik kanan JButton Simpan > Events > action > actionPerformed
Masukkan Source Code :
try{
       stat.executeUpdate("insert into data_lapangan_futsal values("
 + "'" +no_pelangganTextField.getText()+"',"
 + "'" +nama_TextField.getText()+"',"
 + "'" +jenis_ComboBox.getSelectedItem()+ "',"
 +"'"+lama_ComboBox.getSelectedItem()+ "',"
 +"'"+harga_TextField.getText()+"')");
stat.executeUpdate("insert into data_lapangan_futsal_2 values("
 + "'" +no_pelangganTextField.getText()+"',"
 + "'" +nama_TextField.getText()+"',"
 + "'" +alamatTextField.getText()+"')");
       stat.executeUpdate("insert into data_lapangan_futsal_3 values("
 + "'" +no_pelangganTextField.getText()+"',"
 + "'" +nama_TextField.getText()+"',"
 + "'" +telponTextField.getText()+"')");
       kosongkan();
       JOptionPane.showMessageDialog(null, "Berhasil Menyimpan Data");
       }catch (Exception e){
       JOptionPane.showMessageDialog(null, "Perintah Salah :"+e);
   }     
 
# Klik Kanan JButton Cari > Events > action > actionPerformed
Masukkan Souce Code :   
try{
        res=stat.executeQuery("select * from data_lapangan_futsal where "+"no_booking='"+no_pelangganTextField.getText()+"'");
        while(res.next())
        {nama_TextField.setText(res.getString("nama_team"));
        jenis_ComboBox.setSelectedItem(res.getString("jenis_lapangan"));
        lama_ComboBox.setSelectedItem(res.getString("lama_main"));
        harga_TextField.setText(res.getString("harga_lapangan"));
        res=stat.executeQuery("select * from data_lapangan_futsal_2 where "+"no_booking='"+no_pelangganTextField.getText()+"'");
        while(res.next())
        {
           alamatTextField.setText(res.getString("alamat")); 
           res=stat.executeQuery("select * from data_lapangan_futsal_3 where "+"no_booking='"+no_pelangganTextField.getText()+"'");
        while(res.next())
        {
          telponTextField.setText(res.getString("no_telepon"));   
        }
        }
        }
    }
catch (Exception e){
JOptionPane.showMessageDialog(rootPane,e);
}

    }
 
# Klik Kanan JButton edit > Events > action > actionPerformed
Masukkan Souce Code :       
int ok=JOptionPane.showConfirmDialog(null,"Luthtiansyah Apakah Kamu Yakin Ingin Update Record Ini ??","Confirmation",JOptionPane.YES_NO_CANCEL_OPTION);
    try 
    {
        String sql="update data_lapangan_futsal set no_booking=?,nama_team=?,jenis_lapangan=?,lama_main=?,harga_lapangan=? where no_booking='"+no_pelangganTextField.getText()+"'";   
        PreparedStatement st=con.prepareStatement(sql);
        if(ok==0)
        {
            try
            {
                st.setString(1,no_pelangganTextField.getText());
                st.setString(2,nama_TextField.getText());
                st.setString(3,(String)jenis_ComboBox.getSelectedItem());
                st.setString(4,(String)lama_ComboBox.getSelectedItem());
                st.setString(5,harga_TextField.getText());
                st.executeUpdate();
                
                JOptionPane.showMessageDialog(null,"Data Sukses Di Update");
            }catch (Exception e)
            {
                JOptionPane.showMessageDialog(null,"Data Gagal Di Update");
            }
        }
        }catch (Exception e){}
                                        
    }
 
#Klik Kanan JButton keluar > Events > action > actionPerformed
Masukkan Souce Code :
System.exit (0);
    }
 
# Klik Kanan JButton lihat> Events > action > actionPerformed
Masukkan Souce Code :
try{
        Object [] rows={"No_Booking","Nama_Team","Jenis_Lapangan","Lama_Main","Harga_Lapangan"};
     dtm=new DefaultTableModel(null,rows);   
    Table.setModel(dtm);
    Table.setBorder(null);
    jScrollPane1.setVisible(true);
    jScrollPane1.setViewportView(Table);
    int no=1;
    String No_Booking="",Nama_Team="",Jenis_Lapangan="",Lama_Main="",Harga_Lapangan="";
    try{
        String sql="select * from data_lapangan_futsal";
        Statement stat=con.createStatement();
        ResultSet rs=stat.executeQuery(sql);
        while (rs.next()){
            No_Booking=rs.getString("No_Booking");
            Nama_Team=rs.getString("Nama_Team");
            Jenis_Lapangan=rs.getString("Jenis_Lapangan");
            Lama_Main=rs.getString("Lama_Main");
            Harga_Lapangan=rs.getString("Harga_Lapangan");
            
            String [] tampil={""+No_Booking,Nama_Team,Jenis_Lapangan,Lama_Main,Harga_Lapangan};
            dtm.addRow(tampil);
        }
    }catch (SQLException e){
                e.printStackTrace();
                JOptionPane.showMessageDialog(null,"Query Salah"+e);
                }
    }catch (Exception e){
        e.printStackTrace();
    }
    }
 
# Klik Kanan JButton Ganti alamat > Events > action > actionPerformed
Masukkan Source Code :
int ok=JOptionPane.showConfirmDialog(null,"Luthtiansyah Apakah Kamu Yakin Ingin Update ALAMAT Ini ??","Confirmation",JOptionPane.YES_NO_CANCEL_OPTION);
    try 
    {
        String sql="update data_lapangan_futsal_2 set no_booking=?,nama_team=?,alamat=? where no_booking='"+no_pelangganTextField.getText()+"'";   
        PreparedStatement st=con.prepareStatement(sql);
        if(ok==0)
        {
            try
            {
                st.setString(1,no_pelangganTextField.getText());
                st.setString(2,nama_TextField.getText());
                st.setString(3,alamatTextField.getText());
                st.executeUpdate();
                
                JOptionPane.showMessageDialog(null,"Luthtiansyah, ALAMAT Telah Sukses Di Update");
            }catch (Exception e)
            {
                JOptionPane.showMessageDialog(null,"Luthtiansyah, ALAMAT Gagal Di Update");
            }
        }
        }catch (Exception e){}
    }
 
# Klik Kanan JButton Ganti Nomor > Events > action > actionPerformed
Masukkan Source Code :
int ok=JOptionPane.showConfirmDialog(null,"Luthtiansyah Apakah Kamu Yakin Ingin Update NO TELEPON Ini ??","Confirmation",JOptionPane.YES_NO_CANCEL_OPTION);
    try 
    {
        String sql="update data_lapangan_futsal_3 set no_booking=?,nama_team=?,no_telepon=? where no_booking='"+no_pelangganTextField.getText()+"'";   
        PreparedStatement st=con.prepareStatement(sql);
        if(ok==0)
        {
            try
            {
                st.setString(1,no_pelangganTextField.getText());
                st.setString(2,nama_TextField.getText());
                st.setString(3,telponTextField.getText());
                st.executeUpdate();
                
                JOptionPane.showMessageDialog(null,"Luthtiansyah, NOMOR TELEPON Telah Sukses Di Update :)");
            }catch (Exception e)
            {
                JOptionPane.showMessageDialog(null,"Luthtiansyah, NOMOR TELEPON Gagal Di Update :(");
            }
        }
        }catch (Exception e){}
    }
 
# Klik kanan JTable 1 > Events > Mouse > MouseClicked 









Masukkan Source Code:
int i = Table.getSelectedRow();
    if(i==-1){
    return;
    }
String code = (String)Table.getValueAt(i,0);
String code1 = (String)Table.getValueAt(i,1);
String code2 = (String)Table.getValueAt(i,2);
String code3 = (String)Table.getValueAt(i,3);
String code4 = (String)Table.getValueAt(i,4);
no_pelangganTextField.setText(code);
nama_TextField.setText(code1);
jenis_ComboBox.setSelectedItem(code2);
lama_ComboBox.setSelectedItem(code3);
harga_TextField.setText(code4);
    }
 
# Klik kanan JTable 2 > Events > Mouse > MouseClicked 
Masukkan Source Code:
int i = Tabel2.getSelectedRow();
    if(i==-1){
    return;
    }
String code = (String)Tabel2.getValueAt(i,0);
String code1 = (String)Tabel2.getValueAt(i,1);
String code2 = (String)Tabel2.getValueAt(i,2);
no_pelangganTextField.setText(code);
nama_TextField.setText(code1);
alamatTextField.setText(code2);                            
    }
 
# Klik kanan JTable 3 > Events > Mouse > MouseClicked 
Masukkan Source Code:
    int i = Tabel3.getSelectedRow();
    if(i==-1){
    return;
    }
String code = (String)Tabel3.getValueAt(i,0);
String code1 = (String)Tabel3.getValueAt(i,1);
String code2 = (String)Tabel3.getValueAt(i,2);
no_pelangganTextField.setText(code);
nama_TextField.setText(code1);
telponTextField.setText(code2);   
    }
Hasil Output Dan Yang Tersimpan pada database


   














HASIL BUTTON CARI





Hasil Penambahan Button Ganti Alamat Dan Ganti Nomor Telepon





Penggantian Alamat Dan Nomor Telepon
Data Telah Berubah

Jadi Data Dengan Nama Team Elang yang semula pada data awal beralamat di BOGOR Sukses Diubah Menjadi PAMULANG.

Komentar

Posting Komentar