TUGAS UAS SEMESTER 1
ALGORITMA PEMPROGRAMAN
STMIK ERESHA
Nama : Rayhan Fauzan
NIM : 181021400090
Ruangan : 506
Prodi : Teknik Informatika
Assalammualaikum Wr.Wb. / Salam Sejahtera
Dalam rangka memenuhi Penilaian Untuk UAS dari Dosen saya yaitu Bapak
Dalam rangka memenuhi Penilaian Untuk UAS dari Dosen saya yaitu Bapak
Ir. Agus Suharto, S.kom, M.kom tentang Algoritma dan pemrograman
dimana tugasnya adalah membuat suatu program aplikasi dengan menggunakan aplikasi netbeans.
dimana tugasnya adalah membuat suatu program aplikasi dengan menggunakan aplikasi netbeans.
Deskripsi :
Membuat aplikasi sederhana untuk di bidang cuci steam motor membantu pemilik usaha untuk mempermudah dalam urusan membuat Form Transaksi,Report, dan Master Item.
FLOW CHART
FLOW CHART
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();
}
