1.1.
Latar Belakang
Seiring dengan perkembangan teknologi yang
semakin meningkat, banyak orang yang sudah memanfaatkan kecanggihan teknologi
sebagai contoh adalah teknologi komputer yang semakin canggih sehingga
menyebabkan banyak perusahaan yang bersaing dalam menciptakan teknologi
komputer yang baru.Contohnya sorum mobil
milik perseorangan yang masih menggunakan alat manual untuk mengelola
data-datanya. Hal tersebut menyebabkan kesulitan dalam mencatat data. Oleh
karena itu di usulkan program aplikasi yang diharapkan
jika terealisasikan bisa mempermudah segala bentuk transaksi, dan laporan.Selain itu penyusunan laporan ini
adalah untuk memenuhi tugas besar mata kuliah Perancangan Berorientasi Objek. di era globalisasi sekarang ini
sangat penting dalam pengolahan informasi, karena dengan pengolahan informasi
yang berbasis komputer akan mampu menghasilkan informasi yang tepat, akurat,
dan bermanfaat bagi suatu organisasi atau perusahaan.
1.2.
Tujuan
Tujuan Membuat sebuah Aplikasi Sorum Mobil ini yang dapat memudahkan proses penginputan data transaksi dan laporan. Adapun tujuan yang hendak dicapai dalam
pembuatan aplikasi ini :
1.
Diharapkan
dapat mempermudah dalam penyampaian informasi transaksi penjualan dan report data yang berjalan.
2.
Menguji sistem informasi yang diharapkan dapat mempermudah
pegawai dalam mengelola data.
1.3. Ruang Lingkup
Untuk membatasi permasalahan
pada sisfo yang akan dibangun
harus diberikan batasan untuk memperjelas dan mencapai tujuan utama. Batasan
masalah dari sistem yang dibahas adalah sebagai berikut:
1.
Pegawai
melakukan pengelolaan data
transaksi, data pembelian, laporan.
2.
owner
dapat memonitoring aktivitas yang terjadi pada sistem
3. Tidak
membahas tentang pembayaran onlineantar badan sistem pembayaran otomatis.
2.1. Aktor dan Diagram Use Case
package penjualanmobil;
import java.awt.Dimension;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
public class MenuUtama extends javax.swing.JFrame
{
public
MenuUtama() {
initComponents();
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = getSize();
setLocation(
(screenSize.width - frameSize.width) / 2,
(screenSize.height - frameSize.height) / 2);
}
@SuppressWarnings("unchecked")
private
void initComponents() {
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jLabel5 = new javax.swing.JLabel();
usernameTextField = new javax.swing.JTextField();
jLabel2 = new javax.swing.JLabel();
passwordField = new javax.swing.JPasswordField();
jButton1 = new javax.swing.JButton();
jMenuBar1 = new javax.swing.JMenuBar();
jMenu3 = new javax.swing.JMenu();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setTitle("Menu Login Aplikasi Database Penjualan Mobil");
setName("");
jLabel3.setIcon(new javax.swing.ImageIcon(getClass().getResource("/penjualanmobil/Honda-XN-V.jpg")));
jLabel3.setText("jLabel3");
jLabel4.setFont(new java.awt.Font("Times New Roman", 1, 11));
// NOI18N
jLabel4.setText("USER NAME");
jLabel5.setFont(new java.awt.Font("Times New Roman", 1, 11));
// NOI18N
jLabel5.setText("PASSWORD");
usernameTextField.addActionListener(new java.awt.event.ActionListener()
{
public void actionPerformed(java.awt.event.ActionEvent evt) {
usernameTextFieldActionPerformed(evt);
}
});
jLabel2.setFont(new java.awt.Font("Alien Encounters", 1, 24));
// NOI18N
jLabel2.setText("MENU UTAMA");
passwordField.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
passwordFieldActionPerformed(evt);
}
});
passwordField.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
passwordFieldKeyPressed(evt);
}
});
jButton1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/penjualanmobil/login.png")));
// NOI18N
jButton1.setText("LOGIN");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jButton1.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
jButton1KeyPressed(evt);
}
});
jMenu3.setText("Master Data");
jMenuBar1.add(jMenu3);
setJMenuBar(jMenuBar1);
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(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel4, javax.swing.GroupLayout.Alignment.TRAILING,
javax.swing.GroupLayout.PREFERRED_SIZE, 98,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel5, javax.swing.GroupLayout.Alignment.TRAILING,
javax.swing.GroupLayout.PREFERRED_SIZE, 98,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(usernameTextField, javax.swing.GroupLayout.PREFERRED_SIZE,
183, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(passwordField, javax.swing.GroupLayout.PREFERRED_SIZE,
183, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(27, 27, 27)
.addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 92,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(101, 101, 101))
.addGroup(layout.createSequentialGroup()
.addGap(205, 205, 205)
.addComponent(jLabel2)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 733,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(0, 0, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 23,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 269,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(25, 25, 25)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel4,
javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(usernameTextField, 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(jLabel5,
javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(passwordField, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addComponent(jButton1, javax.swing.GroupLayout.Alignment.TRAILING,
javax.swing.GroupLayout.PREFERRED_SIZE, 58,
javax.swing.GroupLayout.PREFERRED_SIZE)))
);
pack();
}
private
void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
String.valueOf(passwordField.getPassword()).equals("admin"))){
new Penjualan().setVisible(true);
dispose();
}else{
JOptionPane.showMessageDialog(
null,
usernameTextField.getText()+
"password anda
salah",
"Pesan kesalahan",
JOptionPane.ERROR_MESSAGE);
usernameTextField.setText("");
passwordField.setText("");
usernameTextField.requestFocus();
}
}
private
void passwordFieldKeyPressed(java.awt.event.KeyEvent evt) {
}
private
void passwordFieldActionPerformed(java.awt.event.ActionEvent evt) {
jButton1.requestFocus();
}
private
void usernameTextFieldActionPerformed(java.awt.event.ActionEvent evt) {
passwordField.requestFocus();
}
private
void jButton1KeyPressed(java.awt.event.KeyEvent evt) {
if(evt.getKeyCode()==evt.VK_ENTER){
jButton1ActionPerformed(new ActionEvent(evt.getSource(),evt.getID(),""));
}
}
public
static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new MenuUtama().setVisible(true);
}
});
}
private
javax.swing.JButton jButton1;
private
javax.swing.JLabel jLabel2;
private
javax.swing.JLabel jLabel3;
private
javax.swing.JLabel jLabel4;
private
javax.swing.JLabel jLabel5;
private
javax.swing.JMenu jMenu3;
private
javax.swing.JMenuBar jMenuBar1;
private
javax.swing.JPasswordField passwordField;
private
javax.swing.JTextField usernameTextField;
}
package penjualanmobil;
import com.mysql.jdbc.Statement;
import java.awt.Dimension;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Locale;
import javax.swing.JOptionPane;
import javax.swing.Timer;
import javax.swing.table.DefaultTableModel;
public class Penjualan extends javax.swing.JFrame
{
java.util.Date tglsekarang = new java.util.Date();
private
SimpleDateFormat smpdtfmt = new SimpleDateFormat("dd/MM/yyyy",
Locale.getDefault());
private
String tanggal = smpdtfmt.format(tglsekarang);
private
Statement stm;
private
com.mysql.jdbc.Connection Con;
public
Penjualan() {
initComponents();
tgl.setText(tanggal);
setJam();
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = getSize();
setLocation(
(screenSize.width - frameSize.width) / 2,
(screenSize.height - frameSize.height) / 2);
}
public final void setJam(){
ActionListener taskPerformer = new
ActionListener() {
@Override
public void actionPerformed(ActionEvent evt) {
String nol_jam = "", nol_menit =
"",nol_detik = "";
java.util.Date dateTime = new java.util.Date();
int nilai_jam = dateTime.getHours();
int nilai_menit = dateTime.getMinutes();
int nilai_detik = dateTime.getSeconds();
if(nilai_jam <= 9) nol_jam= "0";
if(nilai_menit <= 9) nol_menit= "0";
if(nilai_detik <= 9) nol_detik= "0";
String jam = nol_jam +
Integer.toString(nilai_jam);
String menit = nol_menit +
Integer.toString(nilai_menit);
String detik = nol_detik +
Integer.toString(nilai_detik);
lblwktu.setText(jam+":"+menit+":"+detik+"");
}
};
new Timer(1000, taskPerformer).start();
}
@SuppressWarnings("unchecked")
//
<editor-fold defaultstate="collapsed" desc="Generated
Code">
private void initComponents() {
jMenuItem4 = new javax.swing.JMenuItem();
jMenuBar2 = new javax.swing.JMenuBar();
jMenu3 = new javax.swing.JMenu();
jMenu4 = new javax.swing.JMenu();
jMenuItem5 = new javax.swing.JMenuItem();
jMenuItem6 = new javax.swing.JMenuItem();
jMenuItem7 = new javax.swing.JMenuItem();
jPanel1 = new javax.swing.JPanel();
jButton3 = new javax.swing.JButton();
jButton6 = new javax.swing.JButton();
jButton5 = new javax.swing.JButton();
jButton7 = new javax.swing.JButton();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
lblwktu = new javax.swing.JLabel();
tgl
= new javax.swing.JLabel();
jLabel6 = new javax.swing.JLabel();
jMenuBar1 = new javax.swing.JMenuBar();
jMenu1 = new javax.swing.JMenu();
jMenuItem1 = new javax.swing.JMenuItem();
jMenu5 = new javax.swing.JMenu();
jMenuItem8 = new javax.swing.JMenuItem();
jMenuItem9 = new javax.swing.JMenuItem();
jMenuItem10 = new javax.swing.JMenuItem();
jMenuItem11 = new javax.swing.JMenuItem();
jMenuItem4.setText("jMenuItem4");
jMenu3.setText("File");
jMenuBar2.add(jMenu3);
jMenu4.setText("Edit");
jMenuBar2.add(jMenu4);
jMenuItem5.setText("jMenuItem5");
jMenuItem6.setText("jMenuItem6");
jMenuItem7.setText("jMenuItem7");
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setTitle("Menu Utama Aplikasi Database Penjualan Mobil");
setName(""); // NOI18N
jPanel1.setBackground(new java.awt.Color(255, 255, 255));
jPanel1.setBorder(javax.swing.BorderFactory.createMatteBorder(3, 3, 3,
3, new java.awt.Color(0, 0, 0)));
jButton3.setFont(new java.awt.Font("Times New Roman", 1,
12)); jButton3.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/penjualanmobil/customers.png")));
jButton3.setText("PEMBELI");
jButton3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton3ActionPerformed(evt);
}
});
jButton6.setFont(new java.awt.Font("Times New Roman", 1, 12));
jButton6.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/penjualanmobil/Cancel.png")));
jButton6.setText("Tutup Aplikasi");
jButton6.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton6ActionPerformed(evt);
}
});
jButton5.setFont(new java.awt.Font("Times New Roman", 1, 12));
jButton5.setIcon(new javax.swing.ImageIcon(getClass().getResource("/penjualanmobil/gtk-edit.png")));
jButton5.setText("FAKTUR");
jButton5.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton5ActionPerformed(evt);
}
});
jButton7.setFont(new java.awt.Font("Times New Roman", 1,
12)); jButton7.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/penjualanmobil/gtk-edit.png")));
jButton7.setText("TRANSAKSI");
jButton7.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton7ActionPerformed(evt);
}
});
jLabel1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/penjualanmobil/model_1500432792-model-93.png")));
javax.swing.GroupLayout jPanel1Layout = new
javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jButton5,
javax.swing.GroupLayout.PREFERRED_SIZE, 172,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 172,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton7, javax.swing.GroupLayout.PREFERRED_SIZE, 172,
javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(26, 26, 26)
.addComponent(jButton6)))
.addGap(21, 21, 21))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
jPanel1Layout.createSequentialGroup()
.addGap(0, 0, Short.MAX_VALUE)
.addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 35,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(33, 33, 33)
.addComponent(jButton5, javax.swing.GroupLayout.PREFERRED_SIZE, 35,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(33, 33, 33)
.addComponent(jButton7, javax.swing.GroupLayout.PREFERRED_SIZE, 35,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(32, 32, 32)
.addComponent(jButton6)
.addContainerGap())
.addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
);
jLabel2.setFont(new java.awt.Font("Times New Roman", 1, 24));
// NOI18N
jLabel2.setText("FORM PENJUALAN");
jLabel3.setFont(new java.awt.Font("Times New Roman", 3, 14));
// NOI18N
jLabel3.setText("Tanggal =");
jLabel6.setFont(new java.awt.Font("Times New Roman", 3, 14));
// NOI18N
jLabel6.setText("Jam =");
jMenu1.setText("File");
jMenuItem1.setText("Tambah Data Mobil");
jMenuItem1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuItem1ActionPerformed(evt);
}
});
jMenu1.add(jMenuItem1);
jMenuBar1.add(jMenu1);
jMenu5.setText("Lihat");
jMenuItem8.setText("Lihat Mobil");
jMenuItem8.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuItem8ActionPerformed(evt);
}
});
jMenu5.add(jMenuItem8);
jMenuItem9.setText("Lihat Pembeli");
jMenuItem9.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuItem9ActionPerformed(evt);
}
});
jMenu5.add(jMenuItem9);
jMenuItem10.setText("Lihat
Faktur");
jMenuItem10.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuItem10ActionPerformed(evt);
}
});
jMenu5.add(jMenuItem10);
jMenuItem11.setText("Lihat Transaksi");
jMenuItem11.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuItem11ActionPerformed(evt);
}
});
jMenu5.add(jMenuItem11);
jMenuBar1.add(jMenu5);
setJMenuBar(jMenuBar1);
javax.swing.GroupLayout layout = new
javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel2)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel3)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(tgl,
javax.swing.GroupLayout.PREFERRED_SIZE, 84,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jLabel6)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(lblwktu,
javax.swing.GroupLayout.PREFERRED_SIZE, 71,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(lblwktu, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(tgl, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel2)
.addGap(0, 0, Short.MAX_VALUE))
.addComponent(jLabel6, javax.swing.GroupLayout.Alignment.TRAILING,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE)
.addComponent(jLabel3, javax.swing.GroupLayout.Alignment.TRAILING,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE))
.addGap(11, 11, 11)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
pack();
}
private
void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {
new
Transaksi().setVisible(true);
}
private
void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
new
Faktur().setVisible(true);
}
private
void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
System.exit(0);
}
private
void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
new
Pembeli().setVisible(true);
}
private
void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {
new Mobil().setVisible(true);
}
private
void jMenuItem8ActionPerformed(java.awt.event.ActionEvent evt) {
new lihat_mobil().setVisible(true);
}
private void
jMenuItem9ActionPerformed(java.awt.event.ActionEvent evt) {
new
lihat_pembeli().setVisible(true);
}
private
void jMenuItem10ActionPerformed(java.awt.event.ActionEvent evt) {
new
lihat_faktur().setVisible(true);
}
private
void jMenuItem11ActionPerformed(java.awt.event.ActionEvent evt) {
new
lihat_transaksi().setVisible(true);
}
public
static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new Penjualan().setVisible(true);
}
});
}
private
javax.swing.JButton jButton3;
private
javax.swing.JButton jButton5;
private
javax.swing.JButton jButton6;
private
javax.swing.JButton jButton7;
private
javax.swing.JLabel jLabel1;
private
javax.swing.JLabel jLabel2;
private
javax.swing.JLabel jLabel3;
private
javax.swing.JLabel jLabel6;
private
javax.swing.JMenu jMenu1;
private
javax.swing.JMenu jMenu3;
private
javax.swing.JMenu jMenu4;
private
javax.swing.JMenu jMenu5;
private
javax.swing.JMenuBar jMenuBar1;
private
javax.swing.JMenuBar jMenuBar2;
private
javax.swing.JMenuItem jMenuItem1;
private
javax.swing.JMenuItem jMenuItem10;
private
javax.swing.JMenuItem jMenuItem11;
private
javax.swing.JMenuItem jMenuItem4;
private
javax.swing.JMenuItem jMenuItem5;
private
javax.swing.JMenuItem jMenuItem6;
private
javax.swing.JMenuItem jMenuItem7;
private
javax.swing.JMenuItem jMenuItem8;
private
javax.swing.JMenuItem jMenuItem9;
private
javax.swing.JPanel jPanel1;
private
javax.swing.JLabel lblwktu;
private javax.swing.JLabel tgl;
}
2.2.3 Tampilan Faktur
package penjualanmobil;
import java.awt.Dimension;
import java.awt.Toolkit;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
public class lihat_transaksi extends
javax.swing.JFrame {
private Connection con;
private Statement stat;
private ResultSet res;
public
lihat_transaksi() {
initComponents();
setTitle("TRANSAKSI");
koneksi();
tabel();
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = getSize();
setLocation(
(screenSize.width - frameSize.width) / 2,
(screenSize.height - frameSize.height) / 2);
}
private
void koneksi()
{ try
{
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://127.0.0.1/penjualanmobil",
"root", "");
stat=con.createStatement();
} catch (ClassNotFoundException | SQLException e)
{
JOptionPane.showMessageDialog(null, e);
} }
private void tabel(){
DefaultTableModel t= new DefaultTableModel();
t.addColumn("No Transaksi");
t.addColumn("No Faktur");
t.addColumn("Tanggal");
t.addColumn("Jam");
t.addColumn("Kode Pembeli");
t.addColumn("Nama");
t.addColumn("Kode Mobil");
t.addColumn("Nama Mobil");
t.addColumn("Merk");
t.addColumn("Warna");
t.addColumn("Tahun");
t.addColumn("Harga");
tbl.setModel(t);
try{ res=stat.executeQuery("select * from transaksi");
while
(res.next()) {
t.addRow(new Object[]{
res.getString("no_transaksi"),
res.getString("no_faktur"),
res.getString("tgl_fktur"),
res.getString("jam_fktur"),
res.getString("kode_pembeli"),
res.getString("nama"),
res.getString("kode_mobil"),
res.getString("nama_mobil"),
res.getString("merk"),
res.getString("warna"),
res.getString("tahun"),
res.getString("harga")
});
}
}catch
(Exception e) {
JOptionPane.showMessageDialog(rootPane,
e);
}
}
@SuppressWarnings("unchecked")
//
<editor-fold defaultstate="collapsed" desc="Generated
Code">
private void initComponents() {
jLabel1 = new javax.swing.JLabel();
jScrollPane1 = new javax.swing.JScrollPane();
tbl
= new javax.swing.JTable();
jButton1 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setTitle("Lihat");
getContentPane().setLayout(null);
jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 24));
// NOI18N
jLabel1.setText("DAFTAR TRANSAKSI");
getContentPane().add(jLabel1);
jLabel1.setBounds(360, 30, 250, 28);
tbl.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{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(tbl);
getContentPane().add(jScrollPane1);
jScrollPane1.setBounds(10, 81, 1040, 230);
jButton1.setText("Kembali");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
getContentPane().add(jButton1);
jButton1.setBounds(960, 40, 90, 30);
setBounds(0, 0, 1078, 367);
}
private
void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
new Penjualan().setVisible(true);
dispose();
}
public
static void main(String args[]) {
//<editor-fold defaultstate="collapsed" desc=" Look
and feel setting code (optional) ">
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(lihat_transaksi.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(lihat_transaksi.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(lihat_transaksi.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(lihat_transaksi.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new lihat_transaksi().setVisible(true);
}
});
}
private
javax.swing.JButton jButton1;
private
javax.swing.JLabel jLabel1;
private
javax.swing.JScrollPane jScrollPane1;
private
javax.swing.JTable tbl;
}
2.2.4 Tampilan Daftar Mobil
package penjualanmobil;
import java.awt.Dimension;
import java.awt.Toolkit;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
public class lihat_mobil extends javax.swing.JFrame
{
private Connection con;
private Statement stat;
private ResultSet res;
public
lihat_mobil() {
initComponents();
setTitle("Daftar Mobil");
koneksi();
tabel();
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = getSize();
setLocation(
(screenSize.width - frameSize.width) / 2,
(screenSize.height - frameSize.height) / 2);
}
private
void koneksi()
{ try
{
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://127.0.0.1/penjualanmobil",
"root", "");
stat=con.createStatement();
} catch (ClassNotFoundException | SQLException e)
{
JOptionPane.showMessageDialog(null, e);
} }
private void tabel(){
DefaultTableModel t= new DefaultTableModel();
t.addColumn("Kode Mobil");
t.addColumn("Nama Mobil");
t.addColumn("Merk");
t.addColumn("Warna");
t.addColumn("Tahun");
t.addColumn("Harga");
tbl.setModel(t); try{ res=stat.executeQuery("select
* from mobil");
while
(res.next()) {
t.addRow(new Object[]{
res.getString("kode_mobil"),
res.getString("nama_mobil"),
res.getString("merk"),
res.getString("warna"),
res.getString("tahun"),
res.getString("harga")
});
}
}catch
(Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
@SuppressWarnings("unchecked")
//
<editor-fold defaultstate="collapsed" desc="Generated
Code">
private
void initComponents() {
jLabel1 = new javax.swing.JLabel();
jScrollPane1 = new javax.swing.JScrollPane();
tbl
= new javax.swing.JTable();
jButton1 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setTitle("Lihat");
getContentPane().setLayout(null);
jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 24));
// NOI18N
jLabel1.setText("DAFTAR MOBIL");
getContentPane().add(jLabel1);
jLabel1.setBounds(260, 30, 190, 28);
tbl.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{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(tbl);
getContentPane().add(jScrollPane1);
jScrollPane1.setBounds(10, 81, 690, 230);
jButton1.setText("Kembali");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
getContentPane().add(jButton1);
jButton1.setBounds(610, 30, 90, 30);
setBounds(0, 0, 731, 367);
}
private
void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
new
Penjualan().setVisible(true);
dispose();
}
public static void main(String args[]) {
//<editor-fold defaultstate="collapsed" desc=" Look
and feel setting code (optional) ">
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(lihat_mobil.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(lihat_mobil.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(lihat_mobil.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(lihat_mobil.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new lihat_mobil().setVisible(true);
}
});
}
private
javax.swing.JButton jButton1;
private
javax.swing.JLabel jLabel1;
private
javax.swing.JScrollPane jScrollPane1;
private
javax.swing.JTable tbl;
}
2.2.5 Tampilan Daftar Transaksi
package penjualanmobil;
import java.awt.Dimension;
import java.awt.Toolkit;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
public class lihat_transaksi extends
javax.swing.JFrame {
private Connection con;
private Statement stat;
private ResultSet res;
public
lihat_transaksi() {
initComponents();
setTitle("TRANSAKSI");
koneksi();
tabel();
//membuat
layout tampil di tengah pada saat di tampilkan
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = getSize();
setLocation(
(screenSize.width - frameSize.width) / 2,
(screenSize.height - frameSize.height) / 2);
}
private
void koneksi()
{ try
{
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://127.0.0.1/penjualanmobil",
"root", "");
stat=con.createStatement();
} catch (ClassNotFoundException | SQLException e)
{
JOptionPane.showMessageDialog(null, e);
} }
private void tabel(){
DefaultTableModel t= new DefaultTableModel();
t.addColumn("No Transaksi");
t.addColumn("No Faktur");
t.addColumn("Tanggal");
t.addColumn("Jam");
t.addColumn("Kode Pembeli");
t.addColumn("Nama");
t.addColumn("Kode Mobil");
t.addColumn("Nama Mobil");
t.addColumn("Merk");
t.addColumn("Warna");
t.addColumn("Tahun");
t.addColumn("Harga");
tbl.setModel(t); try{ res=stat.executeQuery("select
* from transaksi");
while
(res.next()) {
t.addRow(new Object[]{
res.getString("no_transaksi"),
res.getString("no_faktur"),
res.getString("tgl_fktur"),
res.getString("jam_fktur"),
res.getString("kode_pembeli"),
res.getString("nama"),
res.getString("kode_mobil"),
res.getString("nama_mobil"),
res.getString("merk"),
res.getString("warna"),
res.getString("tahun"),
res.getString("harga")
});
}
}catch
(Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
@SuppressWarnings("unchecked")
//
<editor-fold defaultstate="collapsed" desc="Generated
Code">
private
void initComponents() {
jLabel1 = new javax.swing.JLabel();
jScrollPane1 = new javax.swing.JScrollPane();
tbl
= new javax.swing.JTable();
jButton1 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setTitle("Lihat");
getContentPane().setLayout(null);
jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 24));
// NOI18N
jLabel1.setText("DAFTAR TRANSAKSI");
getContentPane().add(jLabel1);
jLabel1.setBounds(360, 30, 250, 28);
tbl.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{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(tbl);
getContentPane().add(jScrollPane1);
jScrollPane1.setBounds(10, 81, 1040, 230);
jButton1.setText("Kembali");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
getContentPane().add(jButton1);
jButton1.setBounds(960, 40, 90, 30);
setBounds(0, 0, 1078, 367);
}
private
void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
new
Penjualan().setVisible(true);
dispose();
}
public
static void main(String args[]) {
//<editor-fold defaultstate="collapsed" desc=" Look
and feel setting code (optional) ">
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(lihat_transaksi.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(lihat_transaksi.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(lihat_transaksi.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(lihat_transaksi.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new lihat_transaksi().setVisible(true);
}
});
}
private
javax.swing.JButton jButton1;
private
javax.swing.JLabel jLabel1;
private
javax.swing.JScrollPane jScrollPane1;
private
javax.swing.JTable tbl;
}
package penjualanmobil;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import java.awt.Dimension;
import java.awt.HeadlessException;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Locale;
import javax.swing.JOptionPane;
import javax.swing.Timer;
import javax.swing.table.DefaultTableModel;
public class Faktur extends javax.swing.JFrame {
private Connection con;
private Statement stat;
private ResultSet res;
private String t;
private void koneksi(){
try {
Class.forName("com.mysql.jdbc.Driver");
con=(Connection)
DriverManager.getConnection("jdbc:mysql://127.0.0.1/PenjualanMobil",
"root", "");
stat=(Statement) con.createStatement();
} catch (ClassNotFoundException | SQLException e)
{
JOptionPane.showMessageDialog(null, e);
}
}
private void kosongkan()
{
no_faktur.setText("");
kode_pembeli.setText("");
kode_mobil.setText("");
tgl_fktur.setText("");
jam_fktur.setText("");
no_faktur.requestFocus();
}
java.util.Date tglsekarang = new java.util.Date();
private
SimpleDateFormat smpdtfmt = new SimpleDateFormat("dd/MM/yyyy",
Locale.getDefault());
private
String tanggal = smpdtfmt.format(tglsekarang);
private
Statement stm;
private
Connection Con;
public
Faktur() {
initComponents();
tgl.setText(tanggal);
setJam();
koneksi();
kosongkan();
tabel();
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = getSize();
setLocation(
(screenSize.width - frameSize.width) / 2,
(screenSize.height - frameSize.height) / 2);
}
private
void tabel(){
DefaultTableModel t= new DefaultTableModel();
t.addColumn("No Faktur");
t.addColumn("Kode Pembeli");
t.addColumn("Kode
Mobil");
t.addColumn("Tanggal");
t.addColumn("Jam");
tbl.setModel(t); try{
res=stat.executeQuery("select * from faktur");
while
(res.next()) {
t.addRow(new Object[]{
res.getString("no_faktur"),
res.getString("kode_pembeli"),
res.getString("kode_mobil"),
res.getString("tgl_fktur"),
res.getString("jam_fktur"),
});
}
}catch
(Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
public
final void setJam(){
ActionListener taskPerformer = new ActionListener()
{
@Override
public void actionPerformed(ActionEvent evt) {
String nol_jam = "", nol_menit =
"",nol_detik = "";
java.util.Date dateTime = new java.util.Date();
int nilai_jam = dateTime.getHours();
int nilai_menit = dateTime.getMinutes();
int nilai_detik = dateTime.getSeconds();
if(nilai_jam <= 9) nol_jam= "0";
if(nilai_menit <= 9) nol_menit= "0";
if(nilai_detik <= 9) nol_detik= "0";
String jam = nol_jam +
Integer.toString(nilai_jam);
String menit = nol_menit + Integer.toString(nilai_menit);
String detik = nol_detik +
Integer.toString(nilai_detik);
lblwktu.setText(jam+":"+menit+":"+detik+"");
}
};
new Timer(1000, taskPerformer).start();
}
@SuppressWarnings("unchecked")
// <editor-fold
defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
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();
no_faktur = new javax.swing.JTextField();
kode_mobil = new javax.swing.JTextField();
kode_pembeli = new
javax.swing.JTextField();
jButton1 = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
jButton3 = new javax.swing.JButton();
jButton4 = new javax.swing.JButton();
jLabel6 = new javax.swing.JLabel();
jButton5 = new javax.swing.JButton();
tgl
= new javax.swing.JLabel();
lblwktu = new javax.swing.JLabel();
jLabel7 = new javax.swing.JLabel();
jLabel8 = new javax.swing.JLabel();
tgl_fktur = new javax.swing.JTextField();
jam_fktur = new javax.swing.JTextField();
jButton6 = new javax.swing.JButton();
jScrollPane2 = new javax.swing.JScrollPane();
tbl = new javax.swing.JTable();
jTable1.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(jTable1);
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jLabel1.setText("No Faktur");
jLabel2.setText("Kode Mobil");
jLabel3.setText("Kode
Pembeli");
jLabel4.setFont(new java.awt.Font("Times New Roman", 1, 12));
// NOI18N
jLabel4.setText("Jam =");
jLabel5.setFont(new java.awt.Font("Times New Roman", 1, 12));
// NOI18N
jLabel5.setText("Tanggal =");
no_faktur.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
no_fakturActionPerformed(evt);
}
});
kode_mobil.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
kode_mobilActionPerformed(evt);
}
});
kode_pembeli.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
kode_pembeliActionPerformed(evt);
}
});
jButton1.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/penjualanmobil/Zoom.png"))); jButton1.setText("CARI");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jButton2.setIcon(new javax.swing.ImageIcon(getClass().getResource("/penjualanmobil/gtk-edit.png")));
jButton2.setText("EDIT");
jButton2.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jButton2.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
jButton3.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/penjualanmobil/document_delete.png")));
// NOI18N
jButton3.setText("HAPUS");
jButton3.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jButton3.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
jButton3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton3ActionPerformed(evt);
}
});
jButton4.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/penjualanmobil/gtk-save-as.png")));
// NOI18N
jButton4.setText("SIMPAN");
jButton4.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jButton4.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
jButton4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton4ActionPerformed(evt);
}
});
jLabel6.setFont(new java.awt.Font("Times New Roman", 1, 18));
// NOI18N
jLabel6.setText("FORM FAKTUR");
jButton5.setText("Kembali");
jButton5.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton5ActionPerformed(evt);
}
});
tgl.setText("tgl");
lblwktu.setText("lblwktu");
jLabel7.setText("Tanggal");
jLabel8.setText("Jam");
tgl_fktur.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
tgl_fkturActionPerformed(evt);
}
});
jButton6.setText("WAKTU");
jButton6.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton6ActionPerformed(evt);
}
});
tbl.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"
}
));
jScrollPane2.setViewportView(tbl);
javax.swing.GroupLayout layout = new
javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(143, 143, 143)
.addComponent(jLabel6)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 0,
Short.MAX_VALUE)
.addContainerGap())
.addGroup(layout.createSequentialGroup()
.addGap(30, 30, 30)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 88,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 88,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 88,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel5)
.addGap(9, 9, 9))
.addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 88,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 88,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
layout.createSequentialGroup()
.addComponent(no_faktur, javax.swing.GroupLayout.PREFERRED_SIZE, 187,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jButton1)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(layout.createSequentialGroup()
.addComponent(tgl,
javax.swing.GroupLayout.PREFERRED_SIZE, 94,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 45,
Short.MAX_VALUE)
.addComponent(jLabel4,
javax.swing.GroupLayout.PREFERRED_SIZE, 39, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(lblwktu,
javax.swing.GroupLayout.PREFERRED_SIZE, 57, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(62, 62, 62))
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addComponent(kode_mobil,
javax.swing.GroupLayout.DEFAULT_SIZE, 275, Short.MAX_VALUE)
.addComponent(kode_pembeli, javax.swing.GroupLayout.DEFAULT_SIZE, 275,
Short.MAX_VALUE)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING,
false)
.addComponent(jam_fktur, javax.swing.GroupLayout.Alignment.LEADING,
javax.swing.GroupLayout.DEFAULT_SIZE, 93, Short.MAX_VALUE)
.addComponent(tgl_fktur, javax.swing.GroupLayout.Alignment.LEADING))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jButton6)))
.addGap(0, 0,
Short.MAX_VALUE))))
.addGroup(layout.createSequentialGroup()
.addGap(30, 30, 30)
.addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 93,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(54, 54, 54)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addComponent(jButton5, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton3, javax.swing.GroupLayout.DEFAULT_SIZE, 86,
Short.MAX_VALUE))
.addGap(48, 48, 48)
.addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 100,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(0, 0, Short.MAX_VALUE))
);
layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(10, 10, 10)
.addComponent(jLabel6)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(tgl,
javax.swing.GroupLayout.PREFERRED_SIZE, 14,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(lblwktu))
.addGap(22, 22, 22)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 24, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(no_faktur, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton1))
.addGap(28, 28, 28)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(kode_pembeli, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(26, 26, 26)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(kode_mobil, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(28, 28, 28)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 22,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(tgl_fktur, 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(jam_fktur, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 23,
javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(layout.createSequentialGroup()
.addGap(41, 41, 41)
.addComponent(jButton6)))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jButton2)
.addComponent(jButton3)
.addComponent(jButton4))
.addGap(18, 18, 18)
.addComponent(jButton5)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane2,
javax.swing.GroupLayout.PREFERRED_SIZE, 119,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
pack();
}
private
void no_fakturActionPerformed(java.awt.event.ActionEvent evt) {
}
private
void kode_pembeliActionPerformed(java.awt.event.ActionEvent evt) {
}
private
void kode_mobilActionPerformed(java.awt.event.ActionEvent evt) {
}
private
void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
try {
stat.executeUpdate("insert into faktur
values ("
+ "'" +
no_faktur.getText()+"',"
+ "'" +
kode_pembeli.getText()+"',"
+ "'" +
kode_mobil.getText()+"',"
+ "'" +
tgl_fktur.getText()+"',"
+ "'" + jam_fktur.getText()+
"')");
kosongkan();
JOptionPane.showMessageDialog(null, "Berhasil
Menyimpan Data");
} catch (SQLException | HeadlessException e) {
JOptionPane.showMessageDialog(null, "Perintah
Salah : "+e);
} finally{
tabel();
}
}
private
void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
new
Penjualan().setVisible(true);
dispose();
}
private
void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
try
{
res=stat.executeQuery("select * from faktur
where "+ "no_faktur='" +no_faktur.getText()
+"'" ); while (res.next())
{kode_pembeli.setText(res.getString("kode_pembeli"));
kode_mobil.setText(res.getString("kode_mobil"));
jam_fktur.setText(res.getString("jam_fktur"));
tgl_fktur.setText(res.getString("tgl_fktur"));
}
}
catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
private
void tgl_fkturActionPerformed(java.awt.event.ActionEvent evt) {
}
private
void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
tgl_fktur.setText(tgl.getText());
jam_fktur.setText(lblwktu.getText());
}
private
void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
try {
stat.executeUpdate("delete from faktur where
"
+ "no_faktur='"+no_faktur.getText()
+"'" );
kosongkan();
JOptionPane.showMessageDialog(null,
"Berhasil");
} catch
(Exception e) {
JOptionPane.showMessageDialog(null, "pesan
salah : "+e);
} finally{
tabel();
}
}
private
void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
try
{
stat.executeUpdate("update faktur set "
+ "no_faktur='"+no_faktur.getText()+"',"
+ "kode_pembeli='"+kode_pembeli.getText()+"',"
+ "kode_mobil='"+kode_mobil.getText()+"',"
+ "tgl_fktur='"+tgl_fktur.getText()+"',"
+ "jam_fktur='"+jam_fktur.getText()+"'"
+ " where " + "no_faktur='"+no_faktur.getText()+"'"
);
kosongkan();
JOptionPane.showMessageDialog(rootPane, "Data berhasil
Diupdate");
}
catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}finally{
tabel();
}
}
public
static void main(String args[]) {
//<editor-fold defaultstate="collapsed" desc=" Look
and feel setting code (optional) ">
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(Faktur.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(Faktur.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(Faktur.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch
(javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(Faktur.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new Faktur().setVisible(true);
}
});
}
private
javax.swing.JButton jButton1;
private
javax.swing.JButton jButton2;
private
javax.swing.JButton jButton3;
private
javax.swing.JButton jButton4;
private
javax.swing.JButton jButton5;
private
javax.swing.JButton jButton6;
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.JLabel jLabel8;
private
javax.swing.JScrollPane jScrollPane1;
private
javax.swing.JScrollPane jScrollPane2;
private
javax.swing.JTable jTable1;
private
javax.swing.JTextField jam_fktur;
private
javax.swing.JTextField kode_mobil;
private
javax.swing.JTextField kode_pembeli;
private
javax.swing.JLabel lblwktu;
private
javax.swing.JTextField no_faktur;
private
javax.swing.JTable tbl;
private
javax.swing.JLabel tgl;
private
javax.swing.JTextField tgl_fktur;
}
2.2.7 Form Pengelolaan Mobil
package penjualanmobil;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import java.awt.Dimension;
import java.awt.HeadlessException;
import java.awt.Toolkit;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
public class Mobil extends javax.swing.JFrame {
private
Connection con;
private Statement stat;
private ResultSet res;
private String t;
private void koneksi(){
try {
Class.forName("com.mysql.jdbc.Driver");
con=(Connection)
DriverManager.getConnection("jdbc:mysql://127.0.0.1/PenjualanMobil",
"root", "");
stat=(Statement) con.createStatement();
} catch (ClassNotFoundException | SQLException e)
{
JOptionPane.showMessageDialog(null, e);
}
}
private void kosongkan()
{
kode_mobil.setText("");
nama_mobil.setText("");
merk.setText("");
warna.setText("");
tahun.setText("");
harga.setText("");
kode_mobil.requestFocus();
}
public
Mobil() {
initComponents();
setTitle("Entry Data Mobil");
koneksi();
tabel();
kosongkan();
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = getSize();
setLocation(
(screenSize.width - frameSize.width) / 2,
(screenSize.height
- frameSize.height) / 2);
}
always
@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();
kode_mobil = new javax.swing.JTextField();
merk
= new javax.swing.JTextField();
nama_mobil = new javax.swing.JTextField();
tahun = new javax.swing.JTextField();
warna = new javax.swing.JTextField();
jButton1 = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
jButton3 = new javax.swing.JButton();
jButton4 = new javax.swing.JButton();
jLabel7 = new javax.swing.JLabel();
harga = new javax.swing.JTextField();
jButton5 = new javax.swing.JButton();
jScrollPane1 = new javax.swing.JScrollPane();
tbl
= new javax.swing.JTable();
jLabel8 = new javax.swing.JLabel();
jPanel1 = new javax.swing.JPanel();
jLabel6 = new javax.swing.JLabel();
jButton6 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jLabel1.setText("Kode Mobil");
jLabel2.setText("Merk");
jLabel3.setText("Nama Mobil");
jLabel4.setText("Tahun");
jLabel5.setText("Warna");
kode_mobil.addActionListener(new
java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
kode_mobilActionPerformed(evt);
}
});
merk.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
merkActionPerformed(evt);
}
});
nama_mobil.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
nama_mobilActionPerformed(evt);
}
});
tahun.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
tahunActionPerformed(evt);
}
});
jButton1.setText("CARI");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jButton2.setText("EDIT");
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
jButton3.setText("HAPUS");
jButton3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton3ActionPerformed(evt);
}
});
jButton4.setText("TAMBAH");
jButton4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton4ActionPerformed(evt);
}
});
jLabel7.setText("Harga");
harga.addActionListener(new java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
hargaActionPerformed(evt);
}
});
jButton5.setText("Kembali");
jButton5.addActionListener(new java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jButton5ActionPerformed(evt);
}
});
tbl.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(tbl);
jLabel8.setFont(new java.awt.Font("Times New Roman", 1, 12));
// NOI18N
jLabel8.setText("DAFTAR
MOBIL");
jPanel1.setBackground(new java.awt.Color(153, 153, 153));
jLabel6.setFont(new
java.awt.Font("Times New Roman", 1, 18)); // NOI18N
jLabel6.setText("FORM MOBIL");
javax.swing.GroupLayout jPanel1Layout = new
javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
jPanel1Layout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel6)
.addGap(223, 223, 223))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel6)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jButton6.setText("CLEAR");
jButton6.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton6ActionPerformed(evt);
}
});
javax.swing.GroupLayout layout = new
javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1)
.addContainerGap())
.addComponent(jPanel1, javax.swing.GroupLayout.Alignment.TRAILING,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(48, 48,
48)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jLabel2,
javax.swing.GroupLayout.PREFERRED_SIZE, 70,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 70,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 70,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 70,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 70,
javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 70,
javax.swing.GroupLayout.PREFERRED_SIZE)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(kode_mobil, javax.swing.GroupLayout.PREFERRED_SIZE, 197,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18,
18)
.addComponent(jButton1))
.addComponent(warna, javax.swing.GroupLayout.PREFERRED_SIZE, 275,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(tahun, javax.swing.GroupLayout.PREFERRED_SIZE, 275,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(merk,
javax.swing.GroupLayout.PREFERRED_SIZE, 275,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(nama_mobil, javax.swing.GroupLayout.PREFERRED_SIZE, 275,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(harga, javax.swing.GroupLayout.PREFERRED_SIZE, 275,
javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(layout.createSequentialGroup()
.addGap(237, 237, 237)
.addComponent(jLabel8)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 32,
Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING,
false)
.addComponent(jButton3, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton5, javax.swing.GroupLayout.DEFAULT_SIZE, 101,
Short.MAX_VALUE)
.addComponent(jButton4, javax.swing.GroupLayout.DEFAULT_SIZE, 101,
Short.MAX_VALUE)
.addComponent(jButton2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE)
.addComponent(jButton6, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGap(36, 36, 36))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jPanel1, 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(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(kode_mobil, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton1)
.addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 31,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(nama_mobil, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton2))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(merk, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 23,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(11, 11, 11)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(warna, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton6))
.addGap(14, 14, 14)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(tahun, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(11, 11, 11)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(harga, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton5))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 23,
Short.MAX_VALUE)
.addComponent(jLabel8)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 244,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
pack();
}
private
void kode_mobilActionPerformed(java.awt.event.ActionEvent evt) {
}
private
void nama_mobilActionPerformed(java.awt.event.ActionEvent evt) {
}
private
void merkActionPerformed(java.awt.event.ActionEvent evt) {
}
private
void tahunActionPerformed(java.awt.event.ActionEvent evt) {
}
private
void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
try {
stat.executeUpdate("insert into mobil
values ("
+ "'" +
kode_mobil.getText()+"',"
+ "'" +
nama_mobil.getText()+"',"
+ "'" + merk.getText()+"',"
+ "'" + warna.getText()+"',"
+ "'" + tahun.getText()+ "',"
+ "'" + harga.getText()+
"')");
kosongkan();
JOptionPane.showMessageDialog(null, "Berhasil
Menyimpan Data");
} catch (SQLException | HeadlessException e) {
JOptionPane.showMessageDialog(null, "Perintah
Salah : "+e);
}finally{
tabel();
}
}
private void tabel(){
DefaultTableModel t= new DefaultTableModel();
t.addColumn("Kode Mobil");
t.addColumn("Nama Mobil");
t.addColumn("Merk");
t.addColumn("Warna");
t.addColumn("Tahun");
t.addColumn("Harga");
tbl.setModel(t); try{
res=stat.executeQuery("select * from mobil");
while
(res.next()) {
t.addRow(new Object[]{
res.getString("kode_mobil"),
res.getString("nama_mobil"),
res.getString("merk"),
res.getString("warna"),
res.getString("tahun"),
res.getString("harga")
});
}
}catch
(Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
private
void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
try
{
res=stat.executeQuery("select * from mobil
where "+ "kode_mobil='" +kode_mobil.getText()
+"'" );
while (res.next())
{
kode_mobil.setText(res.getString("kode_mobil"));
nama_mobil.setText(res.getString("nama_mobil"));
merk.setText(res.getString("merk"));
warna.setText(res.getString("warna"));
tahun.setText(res.getString("tahun"));
harga.setText(res.getString("harga"));
}
}
catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
private
void hargaActionPerformed(java.awt.event.ActionEvent evt) {
}
private
void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
new
Penjualan().setVisible(true);
dispose();
}
private
void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
try
{
stat.executeUpdate("update mobil set "
+ "kode_mobil='"+kode_mobil.getText()+"',"
+ "nama_mobil='"+nama_mobil.getText()+"',"
+ "merk='"+merk.getText()+"',"
+ "warna='"+warna.getText()+"',"
+ "tahun='"+tahun.getText()+"',"
+ "harga='"+harga.getText()+"'"
+ " where " +
"kode_mobil='"+kode_mobil.getText()+"'" );
kosongkan();
JOptionPane.showMessageDialog(rootPane, "Data berhasil
Diupdate");
}
catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}finally{
tabel();
}
}
private
void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
kosongkan();
}
private
void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
try {
stat.executeUpdate("delete from mobil where
"
+ "kode_mobil='"+kode_mobil.getText()
+"'" );
kosongkan();
JOptionPane.showMessageDialog(null,
"Berhasil");
} catch
(Exception e) {
JOptionPane.showMessageDialog(null, "pesan
salah : "+e);
}finally{
tabel();
}
}
public
static void main(String args[]) {
//<editor-fold defaultstate="collapsed" desc=" Look
and feel setting code (optional) ">
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(Mobil.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(Mobil.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(Mobil.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(Mobil.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new Mobil().setVisible(true);
}
});
}
private
javax.swing.JTextField harga;
private
javax.swing.JButton jButton1;
private
javax.swing.JButton jButton2;
private
javax.swing.JButton jButton3;
private
javax.swing.JButton jButton4;
private
javax.swing.JButton jButton5;
private
javax.swing.JButton jButton6;
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.JLabel jLabel8;
private
javax.swing.JPanel jPanel1;
private
javax.swing.JScrollPane jScrollPane1;
private
javax.swing.JTextField kode_mobil;
private
javax.swing.JTextField merk;
private
javax.swing.JTextField nama_mobil;
private
javax.swing.JTextField tahun;
private
javax.swing.JTable tbl;
private
javax.swing.JTextField warna;
}
2.2.8 Form Pengelolaan Pembeli
package
penjualanmobil;
import
com.mysql.jdbc.Connection;
import
com.mysql.jdbc.Statement;
import
java.awt.Dimension;
import
java.awt.HeadlessException;
import
java.awt.Toolkit;
import
java.sql.DriverManager;
import
java.sql.ResultSet;
import
java.sql.SQLException;
import
javax.swing.JOptionPane;
import
javax.swing.table.DefaultTableModel;
public class
Pembeli extends javax.swing.JFrame {
private Connection con;
private Statement
stat;
private ResultSet
res;
private String t;
private void
koneksi(){
try {
Class.forName("com.mysql.jdbc.Driver");
con=(Connection)
DriverManager.getConnection("jdbc:mysql://127.0.0.1/PenjualanMobil",
"root", "");
stat=(Statement)
con.createStatement();
} catch
(ClassNotFoundException | SQLException e) {
JOptionPane.showMessageDialog(null,
e);
}
}
private void
kosongkan()
{
kode_pembeli.setText("");
nama.setText("");
pekerjaan.setText("");
alamat.setText("");
umur.setText("");
kode_pembeli.requestFocus();
}
public Pembeli() {
initComponents();
koneksi();
kosongkan();
tabel();
Dimension screenSize =
Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = getSize();
setLocation(
(screenSize.width - frameSize.width) /
2,
(screenSize.height - frameSize.height)
/ 2);
}
private void
tabel(){
DefaultTableModel
t= new DefaultTableModel();
t.addColumn("Kode Pembeli");
t.addColumn("Nama");
t.addColumn("Pekerjaan");
t.addColumn("Alamat");
t.addColumn("No Telepon");
tbl.setModel(t); try{
res=stat.executeQuery("select * from pembeli");
while (res.next()) {
t.addRow(new Object[]{
res.getString("kode_pembeli"),
res.getString("nama"),
res.getString("pekerjaan"),
res.getString("alamat"),
res.getString("no_tlp")
});
}
}catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
@SuppressWarnings("unchecked")
// <editor-fold
defaultstate="collapsed" desc="Generated Code">
private void
initComponents() {
jScrollPane1 = new
javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
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();
kode_pembeli = new
javax.swing.JTextField();
pekerjaan = new
javax.swing.JTextField();
nama = new javax.swing.JTextField();
umur = new javax.swing.JTextField();
alamat = new javax.swing.JTextField();
jButton1 = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
jButton3 = new javax.swing.JButton();
jButton4 = new javax.swing.JButton();
jLabel6 = new javax.swing.JLabel();
jButton5 = new javax.swing.JButton();
jScrollPane2 = new
javax.swing.JScrollPane();
tbl = new
javax.swing.JTable();
jTable1.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(jTable1);
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jLabel1.setText("Kode
Pembeli");
jLabel2.setText("Pekerjaan");
jLabel3.setText("Nama");
jLabel4.setText("No Telepon");
jLabel5.setText("Alamat");
kode_pembeli.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
kode_pembeliActionPerformed(evt);
}
});
pekerjaan.addActionListener(new
java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent
evt) {
pekerjaanActionPerformed(evt);
}
});
nama.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
namaActionPerformed(evt);
}
});
umur.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
umurActionPerformed(evt);
}
});
jButton1.setIcon(new
javax.swing.ImageIcon("D:\\foto up\\ikon aplikasi\\Zoom.png"));
jButton1.setText("CARI");
jButton1.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jButton2.setIcon(new
javax.swing.ImageIcon("D:\\foto up\\ikon aplikasi\\gtk-edit.png"));
jButton2.setText("EDIT");
jButton2.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jButton2.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
jButton2.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
jButton3.setIcon(new
javax.swing.ImageIcon("D:\\foto up\\ikon
aplikasi\\document_delete.png"));
jButton3.setText("HAPUS");
jButton3.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jButton3.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
jButton3.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jButton3ActionPerformed(evt);
}
});
jButton4.setIcon(new
javax.swing.ImageIcon("D:\\foto up\\ikon
aplikasi\\gtk-save-as.png"));
jButton4.setText("SIMPAN");
jButton4.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jButton4.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
jButton4.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jButton4ActionPerformed(evt);
}
});
jLabel6.setFont(new
java.awt.Font("Times New Roman", 1, 18)); // NOI18N
jLabel6.setText("FORM
PEMBELI");
jButton5.setText("Kembali");
jButton5.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jButton5ActionPerformed(evt);
}
});
tbl.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"
}
));
jScrollPane2.setViewportView(tbl);
javax.swing.GroupLayout layout = new
javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(30, 30, 30)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 88,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 88,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 88,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 88,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 88,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(umur,
javax.swing.GroupLayout.PREFERRED_SIZE, 275, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(alamat, javax.swing.GroupLayout.PREFERRED_SIZE, 275,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(pekerjaan, javax.swing.GroupLayout.PREFERRED_SIZE, 275,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(nama,
javax.swing.GroupLayout.PREFERRED_SIZE, 275,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createSequentialGroup()
.addComponent(kode_pembeli, javax.swing.GroupLayout.PREFERRED_SIZE, 190,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jButton1)))
.addContainerGap(33,
Short.MAX_VALUE))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
layout.createSequentialGroup()
.addGap(28, 28, 28)
.addComponent(jButton2,
javax.swing.GroupLayout.PREFERRED_SIZE, 80,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(28, 28, 28)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addComponent(jButton5, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton3, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGap(36, 36, 36)
.addComponent(jButton4,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE)
.addContainerGap(69,
Short.MAX_VALUE))))
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(143, 143, 143)
.addComponent(jLabel6))
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 416,
javax.swing.GroupLayout.PREFERRED_SIZE)))
.addContainerGap(15,
Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(10, 10, 10)
.addComponent(jLabel6)
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1,
javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(kode_pembeli,
javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton1))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3,
javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(nama,
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(jLabel2,
javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(pekerjaan,
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,
javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(alamat,
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,
javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(umur,
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.LEADING)
.addComponent(jButton4)
.addComponent(jButton3)
.addComponent(jButton2))
.addGap(18, 18, 18)
.addComponent(jButton5)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane2,
javax.swing.GroupLayout.PREFERRED_SIZE, 156,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(29,
Short.MAX_VALUE))
);
pack();
}
private void
kode_pembeliActionPerformed(java.awt.event.ActionEvent evt) {
}
private void
namaActionPerformed(java.awt.event.ActionEvent evt) {
}
private void
pekerjaanActionPerformed(java.awt.event.ActionEvent evt) {
}
private void
umurActionPerformed(java.awt.event.ActionEvent evt) {
}
private void
jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
try {
stat.executeUpdate("insert into pembeli
values ("
+ "'" +
kode_pembeli.getText()+"',"
+ "'" +
nama.getText()+"',"
+ "'" +
pekerjaan.getText()+"',"
+ "'" +
alamat.getText()+"',"
+ "'" +
umur.getText()+ "')");
kosongkan();
JOptionPane.showMessageDialog(null,
"Berhasil Menyimpan Data");
} catch
(SQLException | HeadlessException e) {
JOptionPane.showMessageDialog(null,
"Perintah Salah : "+e);
}finally{
tabel();
}
}
private void
jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
new Penjualan().setVisible(true);
dispose();
}
private void
jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
try {
res=stat.executeQuery("select
* from pembeli where "+ "kode_pembeli='" +kode_pembeli.getText()
+"'" );
while (res.next())
{
kode_pembeli.setText(res.getString("kode_pembeli"));
nama.setText(res.getString("nama"));
pekerjaan.setText(res.getString("pekerjaan"));
alamat.setText(res.getString("alamat"));
umur.setText(res.getString("no_tlp"));
}
}
catch (Exception
e) {
JOptionPane.showMessageDialog(rootPane,
e);
}
}
private void
jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
try {
stat.executeUpdate("update
pembeli set "
+
"kode_pembeli='"+kode_pembeli.getText()+"',"
+
"nama='"+nama.getText()+"',"
+
"pekerjaan='"+pekerjaan.getText()+"',"
+
"alamat='"+alamat.getText()+"',"
+
"no_tlp='"+umur.getText()+"'"
+ " where " +
"kode_pembeli='"+kode_pembeli.getText()+"'" );
kosongkan();
JOptionPane.showMessageDialog(rootPane, "Data berhasil
Diupdate");
} catch (SQLException |
HeadlessException e) {
JOptionPane.showMessageDialog(rootPane,
e);
}finally{
tabel();
}
}
private void
jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
try {
stat.executeUpdate("delete
from pembeli where "
+
"kode_pembeli='"+kode_pembeli.getText()
+"'" );
kosongkan();
JOptionPane.showMessageDialog(null,
"Berhasil");
} catch (SQLException | HeadlessException e) {
JOptionPane.showMessageDialog(null,
"pesan salah : "+e);
} finally{
tabel();
}
}
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(Pembeli.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(Pembeli.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(Pembeli.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch
(javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(Pembeli.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
java.awt.EventQueue.invokeLater(new
Runnable() {
public void run() {
new Pembeli().setVisible(true);
}
});
}
private javax.swing.JTextField alamat;
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JButton jButton3;
private javax.swing.JButton jButton4;
private javax.swing.JButton jButton5;
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.JScrollPane
jScrollPane1;
private javax.swing.JScrollPane
jScrollPane2;
private javax.swing.JTable jTable1;
private javax.swing.JTextField
kode_pembeli;
private javax.swing.JTextField nama;
private javax.swing.JTextField pekerjaan;
private javax.swing.JTable tbl;
private javax.swing.JTextField umur;
}
2.2.9 Form Pengelolaan Transaksi
package penjualanmobil;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import java.awt.Dimension;
import java.awt.HeadlessException;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Locale;
import javax.swing.JOptionPane;
import javax.swing.Timer;
import javax.swing.table.DefaultTableModel;
public class Transaksi extends javax.swing.JFrame
{
java.util.Date tglsekarang = new java.util.Date();
private
final SimpleDateFormat smpdtfmt = new SimpleDateFormat("dd/MM/yyyy",
Locale.getDefault());
private
final String tanggal = smpdtfmt.format(tglsekarang);
private
Statement stat;
private
Connection Con;
private
Connection con;
private ResultSet res;
private String t;
public
Transaksi() {
initComponents();
tgl.setText(tanggal);
setJam();
koneksi();
tabel();
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = getSize();
setLocation(
(screenSize.width - frameSize.width) / 2,
(screenSize.height - frameSize.height) / 2);
}
public final void setJam(){
ActionListener taskPerformer = (ActionEvent evt)
-> {
String
nol_jam = "", nol_menit = "",nol_detik = "";
java.util.Date dateTime = new java.util.Date();
int
nilai_jam = dateTime.getHours();
int
nilai_menit = dateTime.getMinutes();
int
nilai_detik = dateTime.getSeconds();
if(nilai_jam <= 9) nol_jam= "0";
if(nilai_menit <= 9) nol_menit= "0";
if(nilai_detik <= 9) nol_detik= "0";
String
jam = nol_jam + Integer.toString(nilai_jam);
String
menit = nol_menit + Integer.toString(nilai_menit);
String
detik = nol_detik + Integer.toString(nilai_detik);
lblwktu.setText(jam+":"+menit+":"+detik+"");
};
new Timer(1000, taskPerformer).start();
}
private void koneksi(){
try {
Class.forName("com.mysql.jdbc.Driver");
con = (Connection) DriverManager.getConnection("jdbc:mysql://127.0.0.1/PenjualanMobil",
"root", "");
stat=(Statement) con.createStatement();
} catch (ClassNotFoundException | SQLException e)
{
JOptionPane.showMessageDialog(null, e);
}
}
@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();
no_faktur = new javax.swing.JTextField();
kode_pembeli = new javax.swing.JTextField();
kode_mobil = new javax.swing.JTextField();
nama
= new javax.swing.JTextField();
jButton4 = new javax.swing.JButton();
jLabel6 = new javax.swing.JLabel();
jLabel7 = new javax.swing.JLabel();
jLabel8 = new javax.swing.JLabel();
jLabel9 = new javax.swing.JLabel();
jLabel10 = new javax.swing.JLabel();
jButton5 = new javax.swing.JButton();
jButton6 = new javax.swing.JButton();
jLabel11 = new javax.swing.JLabel();
jLabel12 = new javax.swing.JLabel();
jButton7 = new javax.swing.JButton();
nama_mobil = new javax.swing.JTextField();
merk
= new javax.swing.JTextField();
warna = new javax.swing.JTextField();
harga = new javax.swing.JTextField();
tahun = new javax.swing.JTextField();
jLabel13 = new javax.swing.JLabel();
no_transaksi = new javax.swing.JTextField();
tgl
= new javax.swing.JLabel();
lblwktu = new javax.swing.JLabel();
tgl_fktur = new javax.swing.JTextField();
jam_fktur = new javax.swing.JTextField();
jButton1 = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
jButton3 = new javax.swing.JButton();
jButton8 = new javax.swing.JButton();
jScrollPane1 = new javax.swing.JScrollPane();
tbl
= new javax.swing.JTable();
jButton9 = new javax.swing.JButton();
setDefaultClosOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jLabel1.setText("No
Faktur");
jLabel2.setText("Jam");
jLabel3.setText("Tanggal");
jLabel4.setText("Nama");
jLabel5.setText("Kode
Pembeli");
no_faktur.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
no_fakturActionPerformed(evt);
}
});
kode_pembeli.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
kode_pembeliActionPerformed(evt);
}
});
kode_mobil.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
kode_mobilActionPerformed(evt);
}
});
jButton4.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/penjualanmobil/gtk-save-as.png")));
jButton4.setText("SIMPAN");
jButton4.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jButton4.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
jButton4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton4ActionPerformed(evt);
}
});
jLabel6.setFont(new java.awt.Font("Times New Roman", 1, 18));
// NOI18N
jLabel6.setText("FORM TRANSAKSI");
jLabel7.setText("Kode Mobil");
jLabel8.setText("Nama Mobil");
jLabel9.setText("Merk");
jLabel10.setText("Warna");
jButton5.setText("Cari");
jButton5.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton5ActionPerformed(evt);
}
});
jButton6.setText("Cari");
jButton6.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton6ActionPerformed(evt);
}
});
jLabel11.setText("Tahun");
jLabel12.setText("Harga");
jButton7.setText("Cari");
jButton7.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton7ActionPerformed(evt);
}
});
jLabel13.setText("No
Transaksi");
tgl.setFont(new java.awt.Font("Times New Roman", 1, 14)); //
NOI18N
tgl.setText("jLabel14");
lblwktu.setFont(new java.awt.Font("Times New Roman", 1, 14));
// NOI18N
lblwktu.setText("jLabel15");
jButton1.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/penjualanmobil/Print.png"))); jButton1.setText("CETAK");
jButton1.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jButton1.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jButton2.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/penjualanmobil/gtk-edit.png")));
jButton2.setText("EDIT");
jButton2.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jButton2.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
jButton3.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/penjualanmobil/document_delete.png")));
// NOI18N
jButton3.setText("HAPUS");
jButton3.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jButton3.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
jButton3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton3ActionPerformed(evt);
}
});
jButton8.setIcon(new javax.swing.ImageIcon(getClass().getResource("/penjualanmobil/Zoom.png")));
// NOI18N
jButton8.setText("Cari");
jButton8.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton8ActionPerformed(evt);
}
});
tbl.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(tbl);
jButton9.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/penjualanmobil/application-exit.png")));
// NOI18N
jButton9.setText("KEMBALI");
jButton9.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton9ActionPerformed(evt);
}
});
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(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel6)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(layout.createSequentialGroup()
.addGap(30, 30, 30)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel13,
javax.swing.GroupLayout.PREFERRED_SIZE, 88,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(no_transaksi, javax.swing.GroupLayout.PREFERRED_SIZE, 151,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jButton8,
javax.swing.GroupLayout.PREFERRED_SIZE, 93, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING,
false)
.addGroup(layout.createSequentialGroup()
.addComponent(jButton4)
.addGap(32, 32, 32)
.addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 71,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(28, 28, 28)
.addComponent(jButton3)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton1))
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING,
false)
.addComponent(tgl, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel3, javax.swing.GroupLayout.Alignment.LEADING,
javax.swing.GroupLayout.DEFAULT_SIZE, 88, Short.MAX_VALUE)
.addComponent(jLabel5, javax.swing.GroupLayout.Alignment.LEADING,
javax.swing.GroupLayout.DEFAULT_SIZE, 88, Short.MAX_VALUE)
.addComponent(jLabel1, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE,
88, Short.MAX_VALUE)
.addComponent(jLabel4, javax.swing.GroupLayout.Alignment.LEADING,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addComponent(nama, javax.swing.GroupLayout.PREFERRED_SIZE, 275,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createSequentialGroup()
.addComponent(kode_pembeli, javax.swing.GroupLayout.PREFERRED_SIZE, 207,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton6, javax.swing.GroupLayout.PREFERRED_SIZE, 62,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addComponent(tgl_fktur,
javax.swing.GroupLayout.PREFERRED_SIZE, 110, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 28,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jam_fktur))
.addGroup(layout.createSequentialGroup()
.addComponent(no_faktur, javax.swing.GroupLayout.PREFERRED_SIZE, 207,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jButton5, javax.swing.GroupLayout.PREFERRED_SIZE, 58, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addComponent(lblwktu, javax.swing.GroupLayout.PREFERRED_SIZE, 72,
javax.swing.GroupLayout.PREFERRED_SIZE)))))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 13,
Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addGroup(layout.createSequentialGroup()
.addGap(33, 33, 33)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel12, javax.swing.GroupLayout.PREFERRED_SIZE, 88,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(harga, javax.swing.GroupLayout.PREFERRED_SIZE, 275, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 88,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(kode_mobil, javax.swing.GroupLayout.PREFERRED_SIZE, 203,
javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton7, javax.swing.GroupLayout.PREFERRED_SIZE, 62,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 88,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(nama_mobil, javax.swing.GroupLayout.PREFERRED_SIZE, 274,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel9,
javax.swing.GroupLayout.PREFERRED_SIZE, 88, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(merk, javax.swing.GroupLayout.PREFERRED_SIZE, 274,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel10, javax.swing.GroupLayout.PREFERRED_SIZE, 88, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(warna, javax.swing.GroupLayout.PREFERRED_SIZE, 275,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel11, javax.swing.GroupLayout.PREFERRED_SIZE, 88,
javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(tahun, javax.swing.GroupLayout.PREFERRED_SIZE, 275,
javax.swing.GroupLayout.PREFERRED_SIZE))))
.addComponent(jButton9, javax.swing.GroupLayout.Alignment.TRAILING))
.addContainerGap(46, Short.MAX_VALUE))
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1)
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(10, 10, 10)
.addComponent(jLabel6)
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel13, javax.swing.GroupLayout.PREFERRED_SIZE, 22,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(no_transaksi, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton8)
.addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 22,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(kode_mobil, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton7))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel1,
javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(tgl_fktur, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jam_fktur, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel9, javax.swing.GroupLayout.PREFERRED_SIZE, 22,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(merk,
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, javax.swing.GroupLayout.PREFERRED_SIZE, 24,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(kode_pembeli, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton6)
.addComponent(jLabel10, javax.swing.GroupLayout.PREFERRED_SIZE, 22,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(warna, 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, javax.swing.GroupLayout.PREFERRED_SIZE, 20,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(nama,
javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel11, javax.swing.GroupLayout.PREFERRED_SIZE, 23,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(tahun, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(no_faktur, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton5)
.addComponent(jLabel8,
javax.swing.GroupLayout.PREFERRED_SIZE, 22,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(nama_mobil, 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.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addComponent(jButton2, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton4, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton3, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton1, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGap(18, 18, 18) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(tgl)
.addComponent(lblwktu)))
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel12, javax.swing.GroupLayout.PREFERRED_SIZE, 22,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(harga, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addComponent(jButton9)))
.addGap(10, 10, 10)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 183,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(42, Short.MAX_VALUE))
);
pack();
}
private
void no_fakturActionPerformed(java.awt.event.ActionEvent evt) {
try
{
res=stat.executeQuery("select * from faktur
where "+ "faktur='" +no_faktur.getText()
+"'" ); while (res.next())
{ no_faktur.setText(res.getString("no
faktur"));
tgl_fktur.setText(res.getString("tanggal"));
jam_fktur.setText(res.getString("jam"));
}
}
catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
private
void kode_pembeliActionPerformed(java.awt.event.ActionEvent evt) {
}
private
void kode_mobilActionPerformed(java.awt.event.ActionEvent evt) {
}
private
void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
new
cetak_faktur().setVisible(true);
try
{
stat.executeUpdate("insert into transaksi
values ("
+ "'" +
no_transaksi.getText()+"',"
+ "'" +
no_faktur.getText()+"',"
+ "'" +
tgl_fktur.getText()+"',"
+ "'" + jam_fktur.getText()+
"',"
+ "'" +
kode_pembeli.getText()+"',"
+ "'" + nama.getText()+
"',"
+ "'" + kode_mobil.getText()+
"',"
+ "'" + nama_mobil.getText()+
"',"
+ "'" + merk.getText()+ "',"
+ "'" + warna.getText()+ "',"
+ "'" + tahun.getText()+ "',"
+ "'" + harga.getText()+
"')");
JOptionPane.showMessageDialog(null, "Berhasil
Menyimpan Data");
} catch (SQLException | HeadlessException e) {
JOptionPane.showMessageDialog(null, "Perintah
Salah : "+e);
} finally{
tabel();
}
}
private
void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
try
{
res=stat.executeQuery("select * from faktur
where "+ "no_faktur='" +no_faktur.getText()
+"'" ); while (res.next())
{ no_faktur.setText(res.getString("no_faktur"));
tgl_fktur.setText(res.getString("tgl_fktur"));
jam_fktur.setText(res.getString("jam_fktur"));
kode_pembeli.setText(res.getString("kode_pembeli"));
kode_mobil.setText(res.getString("kode_mobil"));
}
}
catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
private
void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
try
{
res=stat.executeQuery("select * from pembeli
where "+ "kode_pembeli='" +kode_pembeli.getText()
+"'" ); while (res.next())
{
kode_pembeli.setText(res.getString("kode_pembeli"));
nama.setText(res.getString("nama"));
}
}
catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
private
void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {
try
{
res=stat.executeQuery("select * from mobil
where "+ "kode_mobil='" +kode_mobil.getText()
+"'" ); while (res.next())
{
kode_mobil.setText(res.getString("kode_mobil"));
nama_mobil.setText(res.getString("nama_mobil"));
merk.setText(res.getString("merk"));
warna.setText(res.getString("warna"));
tahun.setText(res.getString("tahun"));
harga.setText(res.getString("harga"));
}
}
catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
private
void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
new
cetak_faktur().setVisible(true);
}
private
void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
try
{
stat.executeUpdate("update transaksi set "
+ "no_transaksi='"+no_transaksi.getText()+"',"
+
"no_faktur='"+no_faktur.getText()+"',"
+ "tgl_fktur='"+tgl_fktur.getText()+"',"
+ "jam_fktur='"+jam_fktur.getText()+"',"
+ "kode_pembeli='"+kode_pembeli.getText()+"',"
+ "nama='"+nama.getText()+"',"
+ "kode_mobil='"+kode_mobil.getText()+"',"
+ "nama_mobil='"+nama_mobil.getText()+"',"
+ "merk='"+merk.getText()+"',"
+ "warna='"+warna.getText()+"',"
+ "tahun='"+tahun.getText()+"',"
+
"harga='"+harga.getText()+"'"
+ " where " +
"no_transaksi='"+no_transaksi.getText()+"'" );
JOptionPane.showMessageDialog(rootPane, "Data berhasil
Diupdate");
}
catch (SQLException | HeadlessException e) {
JOptionPane.showMessageDialog(rootPane, e);
}finally{
tabel();
}
}
private
void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO
add your handling code here:
try
{
res=stat.executeQuery("select * from
transaksi where "+ "no_transaksi='" +no_transaksi.getText()
+"'" ); while (res.next())
{
no_transaksi.setText(res.getString("no_transaksi"));
no_faktur.setText(res.getString("no_faktur"));
tgl_fktur.setText(res.getString("tgl_fktur"));
jam_fktur.setText(res.getString("jam_fktur"));
kode_pembeli.setText(res.getString("kode_pembeli"));
nama.setText(res.getString("nama"));
kode_mobil.setText(res.getString("kode_mobil"));
nama_mobil.setText(res.getString("nama_mobil"));
merk.setText(res.getString("merk"));
warna.setText(res.getString("warna"));
tahun.setText(res.getString("tahun"));
harga.setText(res.getString("harga"));
}
}
catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
private
void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
try {
stat.executeUpdate("delete from transaksi
where "
+
"no_transaksi='"+no_transaksi.getText()
+"'" );
JOptionPane.showMessageDialog(null,
"Berhasil");
} catch
(SQLException | HeadlessException e) {
JOptionPane.showMessageDialog(null, "pesan
salah : "+e);
} finally{
tabel();
}
}
private
void jButton9ActionPerformed(java.awt.event.ActionEvent evt) {
new Penjualan().setVisible(true);
dispose();
}
private
void tabel(){
DefaultTableModel t= new DefaultTableModel();
t.addColumn("No Transaksi");
t.addColumn("No Faktur");
t.addColumn("Tanggal");
t.addColumn("Jam");
t.addColumn("Kode Pembeli");
t.addColumn("Nama");
t.addColumn("Kode
Mobil");
t.addColumn("Nama Mobil");
t.addColumn("Merk");
t.addColumn("Warna");
t.addColumn("Tahun");
t.addColumn("Harga");
tbl.setModel(t); try{
res=stat.executeQuery("select * from transaksi");
while
(res.next()) {
t.addRow(new Object[]{
res.getString("no_transaksi"),
res.getString("no_faktur"),
res.getString("tgl_fktur"),
res.getString("jam_fktur"),
res.getString("kode_pembeli"),
res.getString("nama"),
res.getString("kode_mobil"),
res.getString("nama_mobil"),
res.getString("merk"),
res.getString("warna"),
res.getString("tahun"),
res.getString("harga")
});
}
}catch
(Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
//<editor-fold defaultstate="collapsed" desc=" Look
and feel setting code (optional) ">
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(Transaksi.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch
(InstantiationException ex) {
java.util.logging.Logger.getLogger(Transaksi.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(Transaksi.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(Transaksi.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new Transaksi().setVisible(true);
}
});
}
private
javax.swing.JTextField harga;
private
javax.swing.JButton jButton1;
private
javax.swing.JButton jButton2;
private
javax.swing.JButton jButton3;
private
javax.swing.JButton jButton4;
private
javax.swing.JButton jButton5;
private
javax.swing.JButton jButton6;
private
javax.swing.JButton jButton7;
private
javax.swing.JButton jButton8;
private
javax.swing.JButton jButton9;
private
javax.swing.JLabel jLabel1;
private
javax.swing.JLabel jLabel10;
private
javax.swing.JLabel jLabel11;
private
javax.swing.JLabel jLabel12;
private
javax.swing.JLabel jLabel13;
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.JLabel jLabel8;
private
javax.swing.JLabel jLabel9;
private
javax.swing.JScrollPane jScrollPane1;
private
javax.swing.JTextField jam_fktur;
private
javax.swing.JTextField kode_mobil;
private
javax.swing.JTextField kode_pembeli;
private
javax.swing.JLabel lblwktu;
private
javax.swing.JTextField merk;
private
javax.swing.JTextField nama;
private
javax.swing.JTextField nama_mobil;
private
javax.swing.JTextField no_faktur;
private
javax.swing.JTextField no_transaksi;
private
javax.swing.JTextField tahun;
private
javax.swing.JTable tbl;
private
javax.swing.JLabel tgl;
private
javax.swing.JTextField tgl_fktur;
private
javax.swing.JTextField warna;
}
3.1 Kesimpulan
Berdasarkan hasil analisis yang didapat dalam
perancangan dan studi kasus dilapangan serta disesuaikan dengan tujuan awal
dari tugas akhir ini, maka diperoleh kesimpulan sebagai berikut:
1. Aplikasi penjualan mobil menggunakan database untuk menyimpan
data-data sehingga kemungkinan terjadinya redudansi data sangat kecil.
2. Aplikasi penjualan mobil memudahkan pegawai dalam hal menginput data.
3.2 Saran
Dari hasil pemrograman diatas
terdapat beberapa saran bagi pembaca:
1.
Kritik dan saran sangat diperlukan demi
tercapainya sistem yang maksimal.
2.
Disarankan back up data dilakukan secara
berkala.
3.
Sistem ini dapat dikembangkan secara online.
Disusun oleh :
Dindin Jamaludin (A3.1600010)
Fadhlan Hidayatil BM (A3.1600013)
Ridwan
Sukandar (A3.1600031)
Try
Taufik Ginanjar (A3.1600039)
0 Komentar untuk "APLIKASI PENJUALAN MOBIL "
Silakan tinggalkan komentar anda. DILARANG KERAS menyimpan link blog/web pada komentar dengan tujuan backlink, Spam.