untuk source code dan pengembangan aplikasi silahkan agan download di bawah
Berikut ini tampilanya...SELAMAT MENYAKSIKAN
1.MAIN MENU
Source code MAIN MENU
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.tree.DefaultMutableTreeNode;
import steam.*;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
import static steam.Stetment.st;
import static steam.Stetment.rs;
import static steam.Stetment.rs1;
import static steam.Stetment.rs2;
import javax.swing.table.DefaultTableModel;
import java.util.Calendar.*;
public class MAINMENU extends javax.swing.JFrame {
DefaultTableModel tbl= new DefaultTableModel();
/**
* Creates new form MAINMENU
*/
public MAINMENU() throws ClassNotFoundException, SQLException {
initComponents();
setExtendedState(MAXIMIZED_BOTH);
st=ConnectionString.getconnection().createStatement();
}
private void initComponents() {
}
private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {
try {
Transaction tn= new Transaction();
tn.show();
tn.requestFocus();
} catch (ClassNotFoundException ex) {
Logger.getLogger(MAINMENU.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(MAINMENU.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void jMenuItem3ActionPerformed(java.awt.event.ActionEvent evt) {
try {
Report rp=new Report();
rp.show();
} catch (ClassNotFoundException ex) {
Logger.getLogger(MAINMENU.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(MAINMENU.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void jMenuItem2ActionPerformed(java.awt.event.ActionEvent evt) {
try {
InputItem i=new InputItem();
i.show();
} catch (ClassNotFoundException ex) {
Logger.getLogger(MAINMENU.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(MAINMENU.class.getName()).log(Level.SEVERE, null, ex);
}
}
2.FORM TRANSAKSI
package steam;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import steam.*;
import java.util.Date;
import javax.swing.table.DefaultTableModel;
/**
*
* @author PC-IT-3
*/
public class Transaction extends javax.swing.JFrame {
public Transaction() throws ClassNotFoundException, SQLException {
initComponents();
Stetment.st=ConnectionString.getconnection().createStatement();
}
/**
* This method is called from within the constructor to initialize the form.
* WARNING: Do NOT modify this code. The content of this method is always
* regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jScrollPane2 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
jPanel1 = new javax.swing.JPanel();
cmbpilih = new javax.swing.JComboBox();
txtjeniskendaraan = new javax.swing.JTextField();
txttransaksi = new javax.swing.JTextField();
txtharga = new javax.swing.JTextField();
jButton1 = new javax.swing.JButton();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jPanel2 = new javax.swing.JPanel();
jScrollPane1 = 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"
}
));
jScrollPane2.setViewportView(jTable1);
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setTitle("Transaksi");
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowOpened(java.awt.event.WindowEvent evt) {
formWindowOpened(evt);
}
});
jPanel1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 255)));
cmbpilih.addItemListener(new java.awt.event.ItemListener() {
public void itemStateChanged(java.awt.event.ItemEvent evt) {
cmbpilihItemStateChanged(evt);
}
});
txtjeniskendaraan.setEditable(false);
txttransaksi.setEditable(false);
txtharga.setEditable(false);
jButton1.setText("save");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jLabel1.setText("MEREK KENDARAAN");
jLabel2.setText("MEREK KENDARAAN");
jLabel3.setText("TRANSAKSI");
jLabel4.setText("HARGA");
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(cmbpilih, javax.swing.GroupLayout.PREFERRED_SIZE, 192, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel1)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(txtjeniskendaraan, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(txttransaksi, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel3))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(txtharga, javax.swing.GroupLayout.PREFERRED_SIZE, 148, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jButton1))
.addComponent(jLabel4))))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel1)
.addGap(5, 5, 5)
.addComponent(cmbpilih, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(3, 3, 3)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(jLabel3)
.addComponent(jLabel4))
.addGap(1, 1, 1)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txtjeniskendaraan, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(txttransaksi, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(txtharga, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton1))
.addContainerGap(20, Short.MAX_VALUE))
);
jPanel2.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 255)));
tbl.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{},
{},
{},
{}
},
new String [] {
}
));
jScrollPane1.setViewportView(tbl);
javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
jPanel2.setLayout(jPanel2Layout);
jPanel2Layout.setHorizontalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1)
.addContainerGap())
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 58, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(19, Short.MAX_VALUE))
);
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)
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(20, Short.MAX_VALUE))
);
pack();
setLocationRelativeTo(null);
}// </editor-fold>
private void formWindowOpened(java.awt.event.WindowEvent evt) {
cmbpilih.addItem("");
try {
Stetment.rs=Stetment.st.executeQuery("select * from Transaksi");
while(Stetment.rs.next()){
cmbpilih.addItem(Stetment.rs.getString(1));
}
} catch (SQLException ex) {
Logger.getLogger(Transaction.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void reload(){
try {
Stetment.rs=Stetment.st.executeQuery("select * from Transaksi where Kendaraan='"+cmbpilih.getSelectedItem()+"'");
while(Stetment.rs.next()){
txtjeniskendaraan.setText(Stetment.rs.getString(1));
txttransaksi.setText(Stetment.rs.getString(2));
txtharga.setText(Stetment.rs.getString(3));
}
} catch (SQLException ex) {
Logger.getLogger(Transaction.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void cmbpilihItemStateChanged(java.awt.event.ItemEvent evt) {
try {
DefaultTableModel tebel=new DefaultTableModel();
tebel.addColumn("Jenis kendaraan"); tebel.addColumn("Jenis Transaksi"); tebel.addColumn("Harga");
Stetment.rs=Stetment.st.executeQuery("select * from Transaksi where Kendaraan='"+cmbpilih.getSelectedItem()+"'");
while(Stetment.rs.next()){
txtjeniskendaraan.setText(Stetment.rs.getString(1));
txttransaksi.setText(Stetment.rs.getString(2));
txtharga.setText(Stetment.rs.getString(3));
tebel.addRow(new Object[]{Stetment.rs.getString(1),Stetment.rs.getString(2),Stetment.rs.getString(3)});
}tbl.setModel(tebel);
} catch (SQLException ex) {
Logger.getLogger(Transaction.class.getName()).log(Level.SEVERE, null, ex);
}reload();
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
if(txtjeniskendaraan.getText().equals("")|txttransaksi.getText().equals("")){
JOptionPane.showMessageDialog(null,"Data Kosong Silahkan Isi");
txtjeniskendaraan.requestFocus();
return;
}
try {
java.util.Date now = new java.util.Date();
SimpleDateFormat sdf = new SimpleDateFormat( "dd-MM-yyyy" );
String sdate=sdf.format(now).toString();
int i= Stetment.st.executeUpdate("insert into transaksi2(Kendaraan,Jtransaksi,harga,tanggal)values('"
+txtjeniskendaraan.getText()+"','"
+txttransaksi.getText()+"','"
+txtharga.getText()+"','"+sdate+"')");
if(i==0){
JOptionPane.showMessageDialog(null,"Tidak Tersimpan");
}else {
JOptionPane.showMessageDialog(null,"Sukses");
txtjeniskendaraan.setText("");
txttransaksi.setText("");
txtharga.setText("");
}
} catch (SQLException ex) {
Logger.getLogger(Transaction.class.getName()).log(Level.SEVERE, null, ex);
}
}
3.REPORT
package steam;
import steam.*;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.logging.Level;
import java.util.logging.Logger;
import static steam.Stetment.st;
import static steam.Stetment.rs;
import static steam.Stetment.rs1;
import static steam.Stetment.rs2;
import javax.swing.table.DefaultTableModel;
import java.util.Calendar.*;
import java.util.Date;
import javax.swing.JOptionPane;
/**
*
* @author PC-IT-3
*/
public class Report extends javax.swing.JFrame {
DefaultTableModel tbl= new DefaultTableModel();
public Report() throws ClassNotFoundException, SQLException {
initComponents();
st=ConnectionString.getconnection().createStatement();
Date tgl = new Date();
SimpleDateFormat simpdate = new SimpleDateFormat("dd-MM-yyy");
tanggal.setText(simpdate.format(tgl));
}
/**
* This method is called from within the constructor to initialize the form.
* WARNING: Do NOT modify this code. The content of this method is always
* regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jPanel1 = new javax.swing.JPanel();
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
tanggal = new javax.swing.JTextField();
jButton1 = new javax.swing.JButton();
jLabel1 = new javax.swing.JLabel();
cekbok = new javax.swing.JCheckBox();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setAutoRequestFocus(false);
setFocusTraversalPolicyProvider(true);
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowOpened(java.awt.event.WindowEvent evt) {
formWindowOpened(evt);
}
});
jPanel1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 204)));
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);
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 705, Short.MAX_VALUE)
.addContainerGap())
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 322, Short.MAX_VALUE)
.addContainerGap())
);
tanggal.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyReleased(java.awt.event.KeyEvent evt) {
tanggalKeyReleased(evt);
}
});
jButton1.setText("Refresh");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jLabel1.setText("Date");
cekbok.setText("ALL");
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(tanggal, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(cekbok)
.addGap(35, 35, 35)
.addComponent(jButton1)
.addGap(0, 0, Short.MAX_VALUE))
);
layout.setVerticalGroup(
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)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(tanggal, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel1)
.addComponent(cekbok))
.addComponent(jButton1))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
pack();
setLocationRelativeTo(null);
}// </editor-fold>
private void formWindowOpened(java.awt.event.WindowEvent evt) {
try {
tbl.addColumn("Kendaraan");tbl.addColumn("Transaksi");tbl.addColumn("Harga");
tbl.addColumn("Tanggal");
rs=st.executeQuery("select * from Transaksi2 where tanggal='"+tanggal.getText()+"'");
while(rs.next()){
tbl.addRow(new Object[]{rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4)});
}jTable1.setModel(tbl);
} catch (SQLException ex) {
Logger.getLogger(Report.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void refresh(){
try {
rs1=st.executeQuery("select * from Transaksi2");
while(rs1.next()){
tbl.addRow(new Object[]{rs1.getString(1),rs1.getString(2),rs1.getString(3),rs1.getString(4)});
}jTable1.setModel(tbl);
} catch (SQLException ex) {
Logger.getLogger(Report.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void tanggalKeyReleased(java.awt.event.KeyEvent evt) {
try {
rs2=st.executeQuery("select * from Transaksi2 where tanggal='"+tanggal.getText()+"'");
if(rs2.next()){
tbl.addRow(new Object[]{rs2.getString(1),rs2.getString(2),rs2.getString(3),rs2.getString(4)});
}jTable1.setModel(tbl);
} catch (SQLException ex) {
Logger.getLogger(Report.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
if(cekbok.isSelected()){
refresh();
}else{
try {
rs2=st.executeQuery("select * from Transaksi2 where tanggal='"+tanggal.getText()+"'");
if(rs2.next()){
tbl.addRow(new Object[]{rs2.getString(1),rs2.getString(2),rs2.getString(3),rs2.getString(4)});
}jTable1.setModel(tbl);
} catch (SQLException ex) {
Logger.getLogger(Report.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
4.MASTER ITEM
package steam;
import steam.*;
import static steam.Stetment.st;
import static steam.Stetment.rs;
import javax.swing.table.DefaultTableModel;
import java.sql.*;
import static java.time.zone.ZoneRulesProvider.refresh;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
public class InputItem extends javax.swing.JFrame {
DefaultTableModel tbl=new DefaultTableModel();
public InputItem() throws ClassNotFoundException, SQLException {
initComponents();
st=ConnectionString.getconnection().createStatement();
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jPanel1 = new javax.swing.JPanel();
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
jPanel2 = new javax.swing.JPanel();
txtkendaraan = new javax.swing.JTextField();
transaksi = new javax.swing.JTextField();
harga = new javax.swing.JTextField();
jButton1 = new javax.swing.JButton();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
btnedit = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowOpened(java.awt.event.WindowEvent evt) {
formWindowOpened(evt);
}
});
jPanel1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 204)));
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);
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)
.addContainerGap())
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 211, Short.MAX_VALUE)
.addContainerGap())
);
jPanel2.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 204)));
jButton1.setText("Simpan");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jLabel1.setText("jenis Kendaraan");
jLabel2.setText("Jenis Transaksi");
jLabel3.setText("Harga");
btnedit.setText("Edit");
btnedit.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btneditActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
jPanel2.setLayout(jPanel2Layout);
jPanel2Layout.setHorizontalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(txtkendaraan, javax.swing.GroupLayout.PREFERRED_SIZE, 122, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGap(23, 23, 23)
.addComponent(jLabel1)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(transaksi, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
.addComponent(jLabel2)
.addGap(17, 17, 17)))
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addComponent(harga, javax.swing.GroupLayout.PREFERRED_SIZE, 83, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jButton1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(btnedit))
.addGroup(jPanel2Layout.createSequentialGroup()
.addGap(22, 22, 22)
.addComponent(jLabel3)))
.addContainerGap(65, Short.MAX_VALUE))
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
.addContainerGap(21, Short.MAX_VALUE)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1)
.addComponent(jLabel2)
.addComponent(jLabel3))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txtkendaraan, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(transaksi, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(harga, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton1)
.addComponent(btnedit))
.addContainerGap())
);
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)
.addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jPanel1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addContainerGap())
);
layout.setVerticalGroup(
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(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
pack();
setLocationRelativeTo(null);
}// </editor-fold>
private void formWindowOpened(java.awt.event.WindowEvent evt) {
try {
tbl.addColumn("Jenis Kendaraan");tbl.addColumn("Jenis Transaksi");tbl.addColumn("Harga");
rs=st.executeQuery("select * from transaksi");
while(rs.next()){
tbl.addRow(new Object[]{rs.getString(1),rs.getString(2),rs.getString(3)});
}jTable1.setModel(tbl);
} catch (SQLException ex) {
Logger.getLogger(InputItem.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void reload(){
try {
rs=st.executeQuery("select * from transaksi");
while(rs.next()){
tbl.addRow(new Object[]{rs.getString(1),rs.getString(2),rs.getString(3)});
}jTable1.setModel(tbl);
} catch (SQLException ex) {
Logger.getLogger(InputItem.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
if(txtkendaraan.getText().equals("") & transaksi.getText().equals("")& harga.getText().equals("")){
JOptionPane.showMessageDialog(null,"Data Not Found");
txtkendaraan.requestFocus();
return;
}
try {
int x= st.executeUpdate("insert into transaksi(Kendaraan,Jtransaksi,harga)Values('"+txtkendaraan.getText()+"','"+transaksi.getText()+"','"+harga.getText()+"')");
if(x==0){
JOptionPane.showMessageDialog(null,"Tidak tersimpan");
}else {
JOptionPane.showMessageDialog(null,"Tersimpan");
}
} catch (SQLException ex) {
Logger.getLogger(InputItem.class.getName()).log(Level.SEVERE, null, ex);
}reload();
}
private void btneditActionPerformed(java.awt.event.ActionEvent evt) {
if(txtkendaraan.getText().equals("") & transaksi.getText().equals("")& harga.getText().equals("")){
JOptionPane.showMessageDialog(null,"Data Not Found");
txtkendaraan.requestFocus();
return;
}
try {
int i= st.executeUpdate("update transaksi set Jtransaksi='"+transaksi.getText()
+"',harga='"+harga.getText()+"'where kendaraan='"+txtkendaraan.getText()+"'");
if(i==0){
JOptionPane.showMessageDialog(null,"Updated :" +i);
}else{
JOptionPane.showMessageDialog(null,"Updated :" +i);
}
} catch (SQLException ex) {
Logger.getLogger(InputItem.class.getName()).log(Level.SEVERE, null, ex);
}reload();
}
