Ilham Maulana Yusuf_181011402664_Pertemuan 9
buka xampp dan aktifkan Appache dan MySQL
buka phpmyadmin dan buat database dan tabel
Tugas Pertemuan 9
Buka netbeans new projek dengan nama “IlhamMaulanaYusuf_181011402664_Pertemuan9”
Buat package baru dengan nama “Tugas_Pertemuan9”
Buat Jframe dengan nama “penyimpanan_uang_kas”
buatlah Design seperti dibawah ini
Change semua variable hingga menjadi seperti ini
Edit item combo box Bayar dan Kembalian. klik kanan > properties
Kemudian buka source code. Kemudian masukan source code berikut
public class penyimpanan_uang_kas extends javax.swing.JFrame {
private Connection con_IlhamMaulanaYusuf;
private Statement stat_IlhamMaulanaYusuf;
private ResultSet res_IlhamMaulanaYusuf;
private String t;
private DefaultTableModel dtm;
private float Kembalian=0;
/**
* Creates new form penyimpanan_uang_kas
*/
public penyimpanan_uang_kas() {
initComponents();
koneksi();
kosongkan();
table();
Bayar();
Kembalian();
Uangkas_IlhamMaulanaYusuff.setText("2000");
//Rata
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = getSize();
setLocation(
(screenSize.width - frameSize.width)/3,
(screenSize.height - frameSize.height)/4);
}
isi method koneksi(), kosongkan(), bayar(),kembalian(),table( )dengan kode dia bawah ini:
private void koneksi() {
try {
Class.forName("com.mysql.jdbc.Driver");
con_IlhamMaulanaYusuf =DriverManager.getConnection("jdbc:mysql://127.0.0.1/penyimpanan_uang_kas","root", "");
stat_IlhamMaulanaYusuf = con_IlhamMaulanaYusuf.createStatement();
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}
}
private void kosongkan() {
NIM_IlhamMaulanaYusuff.setText("");
Nama_IlhamMaulanaYusuff.setText("");
Uangkas_IlhamMaulanaYusuff.setText("");
}
private void Bayar() {
Bayar_IlhamMaulanaYusuff.addItem("1000");
Bayar_IlhamMaulanaYusuff.addItem("2000");
Bayar_IlhamMaulanaYusuff.addItem("3000");
Bayar_IlhamMaulanaYusuff.addItem("4000");
Bayar_IlhamMaulanaYusuff.addItem("5000");
Bayar_IlhamMaulanaYusuff.addItem("6000");
Bayar_IlhamMaulanaYusuff.addItem("7000");
Bayar_IlhamMaulanaYusuff.addItem("8000");
Bayar_IlhamMaulanaYusuff.addItem("90000");
Bayar_IlhamMaulanaYusuff.addItem("1000");
Bayar_IlhamMaulanaYusuff.setSelectedIndex(-1);
}
private void Kembalian() {
Kembalian_IlhamMaulanaYusuff.addItem("1000");
Kembalian_IlhamMaulanaYusuff.addItem("2000");
Kembalian_IlhamMaulanaYusuff.addItem("3000");
Kembalian_IlhamMaulanaYusuff.addItem("4000");
Kembalian_IlhamMaulanaYusuff.addItem("5000");
Kembalian_IlhamMaulanaYusuff.addItem("6000");
Kembalian_IlhamMaulanaYusuff.addItem("7000");
Kembalian_IlhamMaulanaYusuff.addItem("8000");
Kembalian_IlhamMaulanaYusuff.addItem("90000");
Kembalian_IlhamMaulanaYusuff.addItem("1000");
Kembalian_IlhamMaulanaYusuff.setSelectedIndex(-1);
}
private void table() {
DefaultTableModel t= new DefaultTableModel ();
t.addColumn("NIM");
t.addColumn("Nama");
t.addColumn("Uang_Kas");
t.addColumn("Bayar");
t.addColumn("Kembalian");
Tabel_IlhamMaulanaYusuf.setModel (t); try { res_IlhamMaulanaYusuf= stat_IlhamMaulanaYusuf.executeQuery("select * from tabel_kas");
while (res_IlhamMaulanaYusuf.next()) {
t.addRow(new Object []{ res_IlhamMaulanaYusuf.getString("NIM"),
res_IlhamMaulanaYusuf.getString("Nama"),
res_IlhamMaulanaYusuf.getString("Uang_kas"),
res_IlhamMaulanaYusuf.getString("Bayar"),
res_IlhamMaulanaYusuf.getString("Kembalian"),
});
}
} catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
Kemudian kembali ke desain lagi lalu berikan event action pada tombol simpan, kemudian berikan code berikut.
private void Simpan_IlhamMaulanaYusufActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try {
stat_IlhamMaulanaYusuf.executeUpdate("insert into tabel_kas values ("
+"'"+ NIM_IlhamMaulanaYusuff.getText()+"',"
+"'"+ Nama_IlhamMaulanaYusuff.getText()+"',"
+"'"+ Uangkas_IlhamMaulanaYusuff.getText()+"',"
+"'"+ Bayar_IlhamMaulanaYusuff.getSelectedItem()+"',"
+"'"+ Kembalian_IlhamMaulanaYusuff.getSelectedItem()+"')");
kosongkan();
JOptionPane.showMessageDialog(null, "Berhasil Menyimpan Data");
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "Perintah Salah");
}
Kemudian kembali ke desain lagi lalu berikan event action pada tombol Refresh, kemudian berikan code berikut.
private void Refresh_IlhamMaulanaYusufActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
DefaultTableModel t= new DefaultTableModel();
t.addColumn("NIM");
t.addColumn("Nama");
t.addColumn("Uang_Kas");
t.addColumn("Bayar");
t.addColumn("Kembalian");
Tabel_IlhamMaulanaYusuf.setModel(t);
try {
res_IlhamMaulanaYusuf= stat_IlhamMaulanaYusuf.executeQuery("select * from tabel_kas");
while (res_IlhamMaulanaYusuf.next()) {
t.addRow(new Object [] { res_IlhamMaulanaYusuf.getString("NIM"),
res_IlhamMaulanaYusuf.getString("Nama"),
res_IlhamMaulanaYusuf.getString("Uang_Kas"),
res_IlhamMaulanaYusuf.getString("Bayar"),
res_IlhamMaulanaYusuf.getString("Kembalian")
});
}
} catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
Kemudian kembali ke desain lagi lalu berikan event action pada tombol Hapus, kemudian berikan code berikut
private void Hapus_IlhamMaulanaYusufActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
int ok=JOptionPane.showConfirmDialog(null,"Apakah Yakin mendelete record ini ??",
"Confirmation",JOptionPane.YES_NO_CANCEL_OPTION);
if (ok==0)
{
try
{
String sql="delete from tabel_kas where NIM='"+NIM_IlhamMaulanaYusuff.getText()+"'";
PreparedStatement st=con_IlhamMaulanaYusuf.prepareStatement(sql);
st.executeUpdate();
JOptionPane.showMessageDialog(null,"Delete Data Sukses");
}
catch (Exception e)
{
JOptionPane.showMessageDialog(null,"Delete Data Gagal");
}
}
Kemudian kembali ke desain lagi lalu berikan event action pada textfield NIM, kemudian berikan code berikut
try {
res_IlhamMaulanaYusuf= stat_IlhamMaulanaYusuf.executeQuery("select *from tabel_kas where"+"NIM='"+
NIM_IlhamMaulanaYusuff.getText()
+""); while (res_IlhamMaulanaYusuf.next())
{ Nama_IlhamMaulanaYusuff.setText(res_IlhamMaulanaYusuf.getString("Nama"));
Uangkas_IlhamMaulanaYusuff.setText(res_IlhamMaulanaYusuf.getString("Uang_Kas"));
Bayar_IlhamMaulanaYusuff.setSelectedItem(res_IlhamMaulanaYusuf.getString("Bayar"));
Kembalian_IlhamMaulanaYusuff.setSelectedItem(res_IlhamMaulanaYusuf.getString("Kembalian"));
}
} catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
Klik kanan pada Table, pilih Events, Mouse, mouseClicked, isi perintah seperti dibawah ini
int i= Tabel_IlhamMaulanaYusuf.getSelectedRow();
if(i==-1){
return;
}
String code= (String)Tabel_IlhamMaulanaYusuf.getValueAt(i,0);
String code1= (String)Tabel_IlhamMaulanaYusuf.getValueAt(i,1);
String code2= (String)Tabel_IlhamMaulanaYusuf.getValueAt(i,2);
String code3= (String)Tabel_IlhamMaulanaYusuf.getValueAt(i,3);
String code4= (String)Tabel_IlhamMaulanaYusuf.getValueAt(i,4);
NIM_IlhamMaulanaYusuff.setText(code);
Nama_IlhamMaulanaYusuff.setText(code1);
Uangkas_IlhamMaulanaYusuff.setText(code2);
Bayar_IlhamMaulanaYusuff.setSelectedItem(code3);
Kembalian_IlhamMaulanaYusuff.setSelectedItem(code4);
kembali ke design dan import mysql connector pada libraries. klik kanan pada libraries, pilih add jar/folder
membuat action Lihat
Masukan source pada button “Lihat”
try {
Object[]rows={"Id","Nama","No Kontak","Status"};
dtm = new DefaultTableModel(null,rows);
Tabel_IlhamMaulanaYusuf.setModel(dtm);
Tabel_IlhamMaulanaYusuf.setBorder(null);
Tabel_IlhamMaulanaYusuf.setVisible(true);
Tabel_IlhamMaulanaYusuf.setViewportView(Tabel_IlhamMaulanaYusuf);
int no =1;
String NIM="",Nama="",Uang_Kas="",Bayar="",Kembalian="";
try {
String sql ="select * from tabel_kas";
Statement st=con_IlhamMaulanaYusuf.createStatement ();
ResultSet rs=st.executeQuery(sql);
while (rs.next()){
NIM=rs.getString("NIM");
Nama=rs.getString("Nama");
Uang_Kas=rs.getString("Uang_Kas");
Bayar=rs.getString("Bayar");
Kembalian=rs.getString("Kembalian");
String [] tampil={""+NIM,Nama,Uang_Kas,Bayar,Kembalian};
dtm.addRow(tampil);
}
run program...
Masukan 1 Button,selanjutnya edit menjadi “Search”
sourcenya
try {
res_IlhamMaulanaYusuf=stat_IlhamMaulanaYusuf.executeQuery("select *from tabel_kas where "+"NIM='"+
NIM_IlhamMaulanaYusuff.getText()
+"'"); while (res_IlhamMaulanaYusuf.next())
{ Nama_IlhamMaulanaYusuff.setText(res_IlhamMaulanaYusuf.getString("Nama"));
Uangkas_IlhamMaulanaYusuff.setText(res_IlhamMaulanaYusuf.getString("Uang_Kas"));
Bayar_IlhamMaulanaYusuff.setSelectedItem(res_IlhamMaulanaYusuf.getString("Bayar"));
Kembalian_IlhamMaulanaYusuff.setSelectedItem(res_IlhamMaulanaYusuf.getString("Bayar"));
}
}
catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
Membuat perintah edit data,clear dan exit
Masukan 3 button,selanjutnya edit text sebagai berikut
Masukan source pada Button Edit,Clear dan Exit
private void Edit_IlhamMaulanaYusufActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
int ok=JOptionPane.showConfirmDialog(null,"Apakah Yakin Untuk Update Record???","Confirmation",
JOptionPane.YES_NO_OPTION);
try {
String sql="update tabel_kas set "
+ "NIM=?,Nama=?,Uang_Kas=?," + "Bayar=?,Kembalian=? where "+"NIM='"
+NIM_IlhamMaulanaYusuff.getText()+"'";
PreparedStatement st=con_IlhamMaulanaYusuf.prepareStatement(sql);
if (ok==0)
{
try
{
st.setString(1,NIM_IlhamMaulanaYusuff.getText());
st.setString(2,Nama_IlhamMaulanaYusuff.getText());
st.setString(3,Uangkas_IlhamMaulanaYusuff.getText());
st.setString(4,(String)Bayar_IlhamMaulanaYusuff.getSelectedItem());
st.setString(5,(String)Kembalian_IlhamMaulanaYusuff.getSelectedItem());
st.executeUpdate();
JOptionPane.showMessageDialog(null,"Update Data Sukses");
}catch (Exception e)
{
JOptionPane.showMessageDialog(null,"Update Data Gagal");
}
}
}catch (Exception e){
}
private void Exit_IlhamMaulanaYusufActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
JOptionPane.showMessageDialog(null,"Anda Exit");
System.exit(0);
private void Clear_IlhamMaulanaYusufActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
NIM_IlhamMaulanaYusuff.setText("");
Nama_IlhamMaulanaYusuff.setText("");
Uangkas_IlhamMaulanaYusuff.setText("");
Bayar_IlhamMaulanaYusuff.requestFocus();
Kembalian_IlhamMaulanaYusuff.requestFocus();
Bayar_IlhamMaulanaYusuff.setSelectedIndex(-1);
Kembalian_IlhamMaulanaYusuff.setSelectedIndex(-1);
}
HASILNYA..
Tidak ada komentar:
Posting Komentar