NAMA : GIGIH MAULIA PUTRA
KELAS :02 TPLP 001
NIM :161011400137
Assalamualaikum Wr.Wb
Kali ini saya akan membuat program sederhana PARKIR yang di
buat menggunakan aplikasi java NETBEANS IDE 8,2 dan saya menghubungkan ke MQSL
1. Buka MSQL, lalu masuk ke datababases
2.
Lalu masuk ke java netbeans dan mulai
mengkoneksikan ke mqsl
3. Lalu RUN PROJECT maka akan muncul seperti ini
1. 4.
Setelah itu isi kolom no kendaraan pilih jenis
lama parkir dan klik proses hasil udah tertera, jika ingin keluar klik exit
Di bawah ini adalah contoh scrip yang saya gunakan buat coding program parkir :
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package aplikasi.parkir.sederhana;
import com.mysql.jdbc.Statement;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import koneksi.conek;
import javax.swing.table.DefaultTableModel;
/**
*
* @author Gigih Maulia Putra
*/
public class PARKIR extends javax.swing.JFrame {
String nm_kendaraan="";
int harga;
int bayar;
int lama;
/**
* Creates new form PARKIR
*/
public PARKIR() {
initComponents();
}
/**
* 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() {
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jLabel5 = new javax.swing.JLabel();
jLabel6 = new javax.swing.JLabel();
txt1 = new javax.swing.JTextField();
txt2 = new javax.swing.JTextField();
txt3 = new javax.swing.JTextField();
txt4 = new javax.swing.JTextField();
jButton1 = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
jScrollPane1 = new javax.swing.JScrollPane();
table = new javax.swing.JTable();
jLabel7 = new javax.swing.JLabel();
txt5 = new javax.swing.JTextField();
CB1 = new javax.swing.JComboBox<>();
jButton3 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
jLabel1.setText("PROGRAM PARKIR");
jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
jLabel2.setText("No Kendaraan");
jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
jLabel3.setText("Jenis Kendaraan");
jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
jLabel4.setText("Harga Parkir");
jLabel5.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
jLabel5.setText("Jam Masuk");
jLabel6.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
jLabel6.setText("Lama Parkir");
txt2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
txt2ActionPerformed(evt);
}
});
txt4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
txt4ActionPerformed(evt);
}
});
jButton1.setText("Proses");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jButton2.setText("Exit");
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
table.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{"1234", "12.00", "1 jam", "2000"},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null}
},
new String [] {
"NO KENDARAAN", "JAM MASUK", "LAMA PARKIR", "HARGA"
}
));
jScrollPane1.setViewportView(table);
jLabel7.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
jLabel7.setText("Total Bayar");
CB1.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "=====", "Motor", "Mobil" }));
CB1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
CB1ActionPerformed(evt);
}
});
jButton3.setText("Chek");
jButton3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton3ActionPerformed(evt);
}
});
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)
.addGroup(layout.createSequentialGroup()
.addGap(142, 142, 142)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(txt5, javax.swing.GroupLayout.PREFERRED_SIZE, 120, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createSequentialGroup()
.addComponent(jButton1)
.addGap(18, 18, 18)
.addComponent(jButton2))
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(txt3, javax.swing.GroupLayout.PREFERRED_SIZE, 64, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(txt4)
.addComponent(txt2)
.addComponent(txt1)
.addComponent(CB1, 0, 120, Short.MAX_VALUE)))
.addGap(18, 18, 18)
.addComponent(jButton3)
.addGap(0, 0, Short.MAX_VALUE))
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(144, 144, 144)
.addComponent(jLabel1))
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel4)
.addComponent(jLabel5)))
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel2)
.addComponent(jLabel3)
.addComponent(jLabel6)))
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 81, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addContainerGap(104, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel1)
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel2)
.addComponent(txt1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(CB1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel4)
.addComponent(txt2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel5)
.addComponent(txt3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel6)
.addComponent(txt4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel7)
.addComponent(txt5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton1)
.addComponent(jButton2)
.addComponent(jButton3))
.addGap(18, 18, 18)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 91, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(22, Short.MAX_VALUE))
);
pack();
}// </editor-fold>
private void txt2ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void txt4ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
dispose();
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
harga = Integer.parseInt(txt2.getText());
lama = Integer.parseInt(txt4.getText());
bayar = harga * lama;
txt5.setText(""+bayar);
String nokendaraan=txt1.getText();
String hargaparkir=txt2.getText();
String jeniskendaraan=(String)CB1.getSelectedItem();
String jammasuk=txt3.getText();
String lamaparkir=txt4.getText();
String totalharga=txt5.getText();
try{
Statement sta =(Statement) conek.GetConnection().createStatement();
sta.executeUpdate("INSERT INTO parkir VALUES('"+nokendaraan+"','"+hargaparkir+"','"+jeniskendaraan+"','"+jammasuk+"','"+lamaparkir+"','"+totalharga+"')");
JOptionPane.showMessageDialog(null,"Data tersimpan");
}catch(Exception e){
JOptionPane.showMessageDialog(null,"Terjadi kesalahan");
}
}
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
DefaultTableModel tbl = new DefaultTableModel();
tbl.addColumn("NO Kendaraan");
tbl.addColumn("Jenis Kendaraan");
tbl.addColumn("Harga Parkir");
tbl.addColumn("Jam Masuk");
tbl.addColumn("Lama Pakir");
tbl.addColumn("Total harga");
table.setModel(tbl);
try{
Statement sta=(Statement) conek.GetConnection().createStatement();
ResultSet res=sta.executeQuery("SELECT * FROM parkir");
while(res.next())
{
tbl.addRow(new Object[]{
res.getString("nokendaraan"),
res.getString("jeniskendaraan"),
res.getString("hargaparkir"),
res.getString("jammasuk"),
res.getString("lamaparkir"),
res.getString("totalharga")
});
table.setModel(tbl);
}
}catch(Exception e){
JOptionPane.showMessageDialog(null,"Terjadi Kesalahan saat menampilkan data");
}
}
private void CB1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
nm_kendaraan=(String)CB1.getSelectedItem();
if(nm_kendaraan=="Motor")
{
harga=2000;
}else if(nm_kendaraan=="Mobil")
{ harga=4000;
}
txt2.setText(""+harga);
}
public void datatable(){
DefaultTableModel tbl = new DefaultTableModel();
tbl.addColumn("NO Kendaraan");
tbl.addColumn("Jenis Kendaraan");
tbl.addColumn("Harga Parkir");
tbl.addColumn("Jam Masuk");
tbl.addColumn("Lama Pakir");
tbl.addColumn("Total harga");
table.setModel(tbl);
try{
Statement sta=(Statement) conek.GetConnection().createStatement();
ResultSet res=sta.executeQuery("SELECT * FROM parkir");
while(res.next())
{
tbl.addRow(new Object[]{
res.getString("nokendaraan"),
res.getString("jeniskendaraan"),
res.getString("hargaparkir"),
res.getString("jammasuk"),
res.getString("lamaparkir"),
res.getString("totalharga")
});
table.setModel(tbl);
}
}catch(Exception e){
JOptionPane.showMessageDialog(null,"Terjadi Kesalahan saat menampilkan data");
}
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/* Set the Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
* For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(PARKIR.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(PARKIR.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(PARKIR.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(PARKIR.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new PARKIR().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JComboBox<String> CB1;
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JButton jButton3;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel7;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable table;
private javax.swing.JTextField txt1;
private javax.swing.JTextField txt2;
private javax.swing.JTextField txt3;
private javax.swing.JTextField txt4;
private javax.swing.JTextField txt5;
// End of variables declaration
}
GOOD LUCK :) :)
Tidak ada komentar:
Posting Komentar