Pembuatan Program Aplikasi Sewa Lapangan Futsal Java GUI sederhana dengan MySQL

 Pembuatan Program GUI Sewa Lapangan Futsal 

  1. Buat Database Di phpMyadmin
  2. Buka xampp Klik Start Apache Dan My Sql
  3. Buka Browser , lalu masukkan alamat localhost/phpmyadmin.
  4. Buat Database baru.








Struktur Database Yang dibuat







Pembuatan Program GUI Netbeans
Siapkan :
6 JLabel
3 JTextField
5 Jbutton
2 Combo Box
1 JTable

Desain 









  • Change Variable Name JTextField No.Booking Ubah Menjadi (no_pelangganTextField)
  • Change Variable Name JTextField Nama Team Ubah Menjadi (nama_TextField)
  • Change Variable Name JTextField Harga Ubah Menjadi (harga_TextField)
  • Change Variable Name Combo Box Jenis Lapangan Ubah Menjadi (jenis_ComboBox)
  • Change Variable Name Combo Box Lama Main Ubah Menjadi (lama_ComboBox)
  • Change Variable Name JTable Ubah Menjadi (Table)
  • Change Variable Name Button SIMPAN Jenis Lapangan Ubah Menjadi (btnsimpan)
  • Change Variable Name Button EDIT Jenis Lapangan Ubah Menjadi (btnedit)
  • Change Variable Name Button LIHAT Jenis Lapangan Ubah Menjadi (btnlihat)
  • Change Variable Name Button CARI Jenis Lapangan Ubah Menjadi (btncari)
  • Change Variable Name Button KELUAR Jenis Lapangan Ubah Menjadi (btnkeluar)
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");
    koneksi ();
        kosongkan ();
        table ();
        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("");
    }
    
# 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");
    }

# Beri Source Code Button SIMPAN
try{
       stat.executeUpdate("insert into data_lapangan_futsal values("
               + "'" +no_pelangganTextField.getText()+"',"
               + "'" +nama_TextField.getText()+"',"
               + "'" +jenis_ComboBox.getSelectedItem()+ "',"
               + "'" +lama_ComboBox.getSelectedItem()+ "',"
               + "'" +harga_TextField.getText()+"')");
                kosongkan();
               JOptionPane.showMessageDialog(null, "Berhasil Menyimpan Data");
       }catch (Exception e){
       JOptionPane.showMessageDialog(null, "Perintah Salah :"+e);
   }                                
    }      

# Beri Source Code Button EDIT

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){}
                                        
    }               

# Beri Source Code Button LIHAT        

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

# Beri Source Code Button CARI

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"));
        }
    }
catch (Exception e){
JOptionPane.showMessageDialog(rootPane,e);
}
    }        

# Beri Source Code Button KELUAR

System.exit (0);

# KLIK KANAN Table - 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);
    }                

Komentar

Posting Komentar