Bagi sobat ib yang mencari tugas kuliah, atau baru belajar java bisa pelajari salah satu program sederhana ini,
nih kodingnya.
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package tiketbus;
import java.sql.*;
/**
*
* @author chalk
*/
public class formtiket extends javax.swing.JFrame {
int tvip,texe,hargaa,beli,totall,bayar,kembali;
Connection con;
Statement stat;
ResultSet rs;
String sql;
public formtiket() {
initComponents();
koneksidatabase DB = new koneksidatabase();
DB.koneksi();
con = DB.cn;
stat= DB.st;
vjurusan.addItem("SILAHKAN PILIH");
vjurusan.addItem("LHOKSEUMAWE");
vjurusan.addItem("LANGSA");
vjurusan.addItem("KUALA SIMPANG");
vjurusan.addItem("MEDAN");
}
/**
* 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();
jLabel1 = new javax.swing.JLabel();
jPanel2 = new javax.swing.JPanel();
jPanel3 = new javax.swing.JPanel();
jLabel2 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
vjurusan = new javax.swing.JComboBox();
vharga = new javax.swing.JLabel();
jLabel5 = new javax.swing.JLabel();
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();
no = new javax.swing.JTextField();
nm = new javax.swing.JTextField();
jumlah = new javax.swing.JTextField();
ubayar = new javax.swing.JTextField();
total = new javax.swing.JLabel();
jSeparator1 = new javax.swing.JSeparator();
ukembali = new javax.swing.JLabel();
jPanel4 = new javax.swing.JPanel();
btnsimpan = new javax.swing.JButton();
btnedit = new javax.swing.JButton();
btnhapus = new javax.swing.JButton();
btnlaporan = new javax.swing.JButton();
jPanel5 = new javax.swing.JPanel();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jPanel1.setBackground(new java.awt.Color(255, 255, 255));
jPanel1.setLayout(null);
jLabel1.setFont(new java.awt.Font("The Inbox St", 0, 24)); // NOI18N
jLabel1.setText("PENJUALAN TIKET BUS TELOLET STAR");
jPanel1.add(jLabel1);
jLabel1.setBounds(110, 10, 440, 30);
jPanel2.setBackground(new java.awt.Color(255, 255, 255));
jPanel2.setLayout(null);
jPanel3.setBackground(new java.awt.Color(255, 255, 255));
jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder("DATA BUS"));
jLabel2.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
jLabel2.setText("Jurusan");
jLabel4.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
jLabel4.setText("Harga");
vjurusan.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
vjurusan.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
vjurusanActionPerformed(evt);
}
});
vharga.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
vharga.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
vharga.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
jPanel3.setLayout(jPanel3Layout);
jPanel3Layout.setHorizontalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel2)
.addComponent(jLabel4))
.addGap(30, 30, 30)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(vjurusan, javax.swing.GroupLayout.PREFERRED_SIZE, 179, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(vharga, javax.swing.GroupLayout.PREFERRED_SIZE, 132, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap(18, Short.MAX_VALUE))
);
jPanel3Layout.setVerticalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(vjurusan, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(vharga, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel4))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jPanel2.add(jPanel3);
jPanel3.setBounds(10, 70, 290, 120);
jLabel5.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
jLabel5.setText("Nomor KURSUS");
jPanel2.add(jLabel5);
jLabel5.setBounds(320, 40, 90, 14);
jLabel6.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
jLabel6.setText("Nama Penumpang");
jPanel2.add(jLabel6);
jLabel6.setBounds(320, 80, 110, 15);
jLabel7.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
jLabel7.setText("Jumlah Beli");
jPanel2.add(jLabel7);
jLabel7.setBounds(320, 120, 70, 15);
jLabel8.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
jLabel8.setText("Total Bayar");
jPanel2.add(jLabel8);
jLabel8.setBounds(320, 160, 70, 15);
jLabel9.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
jLabel9.setText("Uang Bayar");
jPanel2.add(jLabel9);
jLabel9.setBounds(320, 230, 70, 15);
jLabel10.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
jLabel10.setText("Uang Kembali");
jPanel2.add(jLabel10);
jLabel10.setBounds(320, 270, 80, 15);
no.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
no.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
no.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyReleased(java.awt.event.KeyEvent evt) {
noKeyReleased(evt);
}
});
jPanel2.add(no);
no.setBounds(440, 30, 60, 30);
nm.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
nm.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
jPanel2.add(nm);
nm.setBounds(440, 70, 170, 30);
jumlah.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
jumlah.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
jumlah.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyReleased(java.awt.event.KeyEvent evt) {
jumlahKeyReleased(evt);
}
});
jPanel2.add(jumlah);
jumlah.setBounds(440, 110, 60, 30);
ubayar.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
ubayar.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
ubayar.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyReleased(java.awt.event.KeyEvent evt) {
ubayarKeyReleased(evt);
}
});
jPanel2.add(ubayar);
ubayar.setBounds(440, 220, 140, 30);
total.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
total.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
total.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
jPanel2.add(total);
total.setBounds(440, 150, 140, 30);
jPanel2.add(jSeparator1);
jSeparator1.setBounds(320, 200, 300, 2);
ukembali.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
ukembali.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
ukembali.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
jPanel2.add(ukembali);
ukembali.setBounds(440, 260, 140, 30);
jPanel4.setBackground(new java.awt.Color(255, 255, 255));
jPanel4.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
btnsimpan.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
btnsimpan.setText("SIMPAN");
btnsimpan.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnsimpanActionPerformed(evt);
}
});
btnedit.setText("EDIT");
btnedit.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btneditActionPerformed(evt);
}
});
btnhapus.setText("HAPUS");
btnhapus.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnhapusActionPerformed(evt);
}
});
btnlaporan.setText("LAPORAN");
btnlaporan.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnlaporanActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
jPanel4.setLayout(jPanel4Layout);
jPanel4Layout.setHorizontalGroup(
jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addContainerGap()
.addComponent(btnsimpan)
.addGap(18, 18, 18)
.addComponent(btnedit, javax.swing.GroupLayout.PREFERRED_SIZE, 69, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(btnhapus, javax.swing.GroupLayout.DEFAULT_SIZE, 88, Short.MAX_VALUE)
.addContainerGap())
.addGroup(jPanel4Layout.createSequentialGroup()
.addGap(82, 82, 82)
.addComponent(btnlaporan, javax.swing.GroupLayout.PREFERRED_SIZE, 107, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jPanel4Layout.setVerticalGroup(
jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addGap(11, 11, 11)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(btnsimpan, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(btnedit, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 32, Short.MAX_VALUE)
.addComponent(btnhapus, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(btnlaporan, javax.swing.GroupLayout.DEFAULT_SIZE, 33, Short.MAX_VALUE)
.addContainerGap())
);
jPanel2.add(jPanel4);
jPanel4.setBounds(10, 220, 290, 100);
jPanel5.setBackground(new java.awt.Color(255, 255, 255));
jPanel5.setBorder(javax.swing.BorderFactory.createTitledBorder("CARI/TAMPIL DATA"));
javax.swing.GroupLayout jPanel5Layout = new javax.swing.GroupLayout(jPanel5);
jPanel5.setLayout(jPanel5Layout);
jPanel5Layout.setHorizontalGroup(
jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGap(0, 268, Short.MAX_VALUE)
);
jPanel5Layout.setVerticalGroup(
jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGap(0, 27, Short.MAX_VALUE)
);
jPanel2.add(jPanel5);
jPanel5.setBounds(20, 10, 280, 50);
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(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, 644, Short.MAX_VALUE)
.addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, 45, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, 350, Short.MAX_VALUE)
.addContainerGap())
);
pack();
setLocationRelativeTo(null);
}// </editor-fold>
private void btnhapusActionPerformed(java.awt.event.ActionEvent evt) {
try{
sql="DELETE FROM tiket WHERE no_kursus = '"+no.getText()+"'";
stat.execute(sql);
Bersihkan_form();
}catch (Exception e) {
}
}
private void vjurusanActionPerformed(java.awt.event.ActionEvent evt) {
if(vjurusan.getSelectedItem().equals("LHOKSEUMAWE")){
vharga.setText("75000");
}
else if(vjurusan.getSelectedItem().equals("LANGSA")){
vharga.setText("130000");
}
else if(vjurusan.getSelectedItem().equals("KUALA SIMPANG")){
vharga.setText("150000");
}
else if(vjurusan.getSelectedItem().equals("MEDAN")){
vharga.setText("190000");
}
}
private void jumlahKeyReleased(java.awt.event.KeyEvent evt) {
hargaa =Integer.parseInt(vharga.getText());
int jumlahh= Integer.parseInt(jumlah.getText());
totall = hargaa * jumlahh;
total.setText(String.valueOf(totall));
}
private void ubayarKeyReleased(java.awt.event.KeyEvent evt) {
bayar = Integer.parseInt(ubayar.getText());
kembali = Integer.parseInt(total.getText());
totall = bayar-kembali;
ukembali.setText(String.valueOf(totall));
}
private void btnsimpanActionPerformed(java.awt.event.ActionEvent evt) {
try{
sql = "INSERT INTO tiket VALUES('"+no.getText()+"','"+nm.getText()+"','"+vjurusan.getSelectedItem()+
"','"+vharga.getText()+"','"+jumlah.getText()+"','"+total.getText()+"','"+ubayar.getText()+"','"+ukembali.getText()+"')";
stat.execute(sql);
Bersihkan_form();
} catch (Exception e) {
}
}
private void btnlaporanActionPerformed(java.awt.event.ActionEvent evt) {
new laporandata().setVisible(true);
}
private void noKeyReleased(java.awt.event.KeyEvent evt) {
try{
sql = "SELECT * FROM tiket where no_kursus = '"+no.getText()+"'";
rs = stat.executeQuery(sql);
while (rs.next())
{
nm.setText(rs.getString("nama_penumpang"));
vjurusan.setSelectedItem(rs.getString("jurusan"));
vharga.setText(rs.getString("harga"));
jumlah.setText(rs.getString("jumlah_beli"));
total.setText(rs.getString("total_harga"));
ubayar.setText(rs.getString("uang_bayar"));
ukembali.setText(rs.getString("uang_kembali"));
}
} catch (Exception e) {
}
jumlahKeyReleased(evt);
}
private void btneditActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void Bersihkan_form() {
no.setText("");
nm.setText("");
vjurusan.setSelectedIndex(0);
vharga.setText("");
jumlah.setText("");
total.setText("");
ubayar.setText("");
ukembali.setText("");
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/* Set the Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
* For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(formtiket.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(formtiket.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(formtiket.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(formtiket.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new formtiket().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton btnedit;
private javax.swing.JButton btnhapus;
private javax.swing.JButton btnlaporan;
private javax.swing.JButton btnsimpan;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel10;
private javax.swing.JLabel jLabel2;
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.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JPanel jPanel3;
private javax.swing.JPanel jPanel4;
private javax.swing.JPanel jPanel5;
private javax.swing.JSeparator jSeparator1;
private javax.swing.JTextField jumlah;
private javax.swing.JTextField nm;
private javax.swing.JTextField no;
private javax.swing.JLabel total;
private javax.swing.JTextField ubayar;
private javax.swing.JLabel ukembali;
private javax.swing.JLabel vharga;
private javax.swing.JComboBox vjurusan;
// End of variables declaration
}
Hhehehe Pusing ya??
Bisa minta paasnya gk? 😁
ReplyDeleteboleh.....
Deletehttp://ibagidong.blogspot.co.id
DeletePasword nya apa yaa ? :(
ReplyDelete