Tuesday, 12 February 2019
Aplikasi Project ATM Untuk Koperasi Simpan Pinjam
Ok Kita Kembali Lagi Di Pembahasan Dan Pembuatan Aplikasai
Assalamu'alaikum,
Hari ini saya akan Posting Project ATM Untuk Koperasi Simpan Pinjam.
Jadi program ini akan membantu Koperasi untuk bisa Menjalankan program ATM pada perkampungan ataupun Organisasi Kecil - Menengah :)
1. Login Form
Source Code:
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
this.dispose();
}
private void jToggleButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
if (vusername.getText().equals("admin")) {
if (vpassword.getText().equals("admin")) {
// Bila Login Sukses Maka Masuk Menu Utama
new utama().show();
this.dispose(); }
else {
// Bila Login Gagal Maka Ulangi Login
JOptionPane.showMessageDialog(rootPane, "<error> Password Salah, Silahkan Coba Lagi");
vpassword.setText("");
vpassword.requestFocus(); }}
else {
JOptionPane.showMessageDialog(rootPane, "<error> Username, Silahkan Coba Lagi");
vusername.setText("");
vpassword.setText("");
vusername.requestFocus();
}
}
2. Menu Utama
Source Code:
private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
new rekening_nasabah().setVisible(true);
dispose();
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
new anggota().setVisible(true);
dispose();
}
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
new jenis_pinjaman().setVisible(true);
dispose();
}
private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
new trans_pinjaman().setVisible(true);
dispose();
}
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
new jenis_simpanan().setVisible(true);
dispose();
}
private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
new login_koperasi().setVisible(true);
dispose();
}
private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {
new trans_simpanan().setVisible(true);
dispose();
// TODO add your handling code here:
}
3. Formulir Anggota
Source Code:
package Aplikasi;
import java.awt.event.KeyEvent;
import java.text.SimpleDateFormat;
import java.util.Date;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
public class anggota extends javax.swing.JFrame {
koneksi con=new koneksi();
Date tgl=new Date();
SimpleDateFormat noformat=new SimpleDateFormat("yyMM");
/* Membuat form Anggota */
public anggota() {
initComponents();
}
private void aktif()
{
tnama.setEnabled(true);
talamat.setEnabled(true);
tkota.setEnabled(true);
ttelp.setEnabled(true);
tpekerjaan.setEnabled(true);
}
private void bersih()
{
tno.setText("");
tnama.setText("");
talamat.setText("");
tkota.setText("");
ttelp.setText("");
tpekerjaan.setText("");
}
public DefaultTableModel gettabel()
{
String[]judul={"No.Anggota","Nama","Alamat","Kota","No.Telpon","Pekerjaan"};
DefaultTableModel kolom=new DefaultTableModel(null,judul);
try
{
con.setkoneksi();
con.rs=con.st.executeQuery("select * from anggota");
String data[]=new String[6];
while(con.rs.next())
{
data[0]=con.rs.getString(1);
data[1]=con.rs.getString(2);
data[2]=con.rs.getString(3);
data[3]=con.rs.getString(4);
data[4]=con.rs.getString(5);
data[5]=con.rs.getString(6);
kolom.addRow(data);
}
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null,"<Error> Koneksikan Xampp Terlebih Dahulu : "+e,"Koneksi Gagal",JOptionPane.WARNING_MESSAGE);
}
return kolom;
}
private void awal()
{
Table1.setModel(gettabel());
bersih();
aktif();
no();
tno.setEnabled(false);
tnama.requestFocus();
bkeluar.setEnabled(true);
bupdate.setVisible(false);
bedit.setEnabled(false);
bhapus.setEnabled(false);
bsimpan.setVisible(true);
}
private void pasif()
{
tno.setEnabled(false);
tnama.setEnabled(false);
talamat.setEnabled(false);
tkota.setEnabled(false);
ttelp.setEnabled(false);
tpekerjaan.setEnabled(false);
}
private void no()
{
try
{
con.setkoneksi();
String nomor=null;
con.rs=con.st.executeQuery("Select right(no_ang,3)+1 as no from anggota order by no_ang desc");
if(con.rs.next())
{
nomor=con.rs.getString("no");
while(nomor.length()<2)
nomor="0"+nomor;
nomor=noformat.format(tgl)+nomor;
}
else
nomor=noformat.format(tgl)+"0";
tno.setText(nomor);
}
catch(Exception e){JOptionPane.showMessageDialog(rootPane, e);
}
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jLabel1 = new javax.swing.JLabel();
jPanel2 = new javax.swing.JPanel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jLabel5 = new javax.swing.JLabel();
jLabel6 = new javax.swing.JLabel();
jLabel7 = new javax.swing.JLabel();
tnama = new javax.swing.JTextField();
talamat = new javax.swing.JTextField();
ttelp = new javax.swing.JTextField();
tpekerjaan = new javax.swing.JTextField();
tkota = new javax.swing.JTextField();
tno = new javax.swing.JTextField();
jPanel4 = new javax.swing.JPanel();
bsimpan = new javax.swing.JButton();
bhapus = new javax.swing.JButton();
bedit = new javax.swing.JButton();
bkeluar = new javax.swing.JButton();
bupdate = new javax.swing.JButton();
jScrollPane1 = new javax.swing.JScrollPane();
Table1 = new javax.swing.JTable();
jPanel1 = new javax.swing.JPanel();
jLabel8 = new javax.swing.JLabel();
jLabel9 = new javax.swing.JLabel();
tcarikode = new javax.swing.JTextField();
tcarinama = new javax.swing.JTextField();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowOpened(java.awt.event.WindowEvent evt) {
formWindowOpened(evt);
}
});
jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 18)); // NOI18N
jLabel1.setText("Formulir Anggota Koperasi");
jPanel2.setBorder(javax.swing.BorderFactory.createEtchedBorder(javax.swing.border.EtchedBorder.RAISED, new java.awt.Color(204, 204, 204), new java.awt.Color(204, 204, 204)));
jLabel2.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
jLabel2.setText("No. Anggota :");
jLabel3.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
jLabel3.setText("Nama :");
jLabel4.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
jLabel4.setText("Alamat :");
jLabel5.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
jLabel5.setText("Kota :");
jLabel6.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
jLabel6.setText("No. Telp :");
jLabel7.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
jLabel7.setText("Pekerjaan :");
ttelp.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ttelpActionPerformed(evt);
}
});
tno.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
tnoActionPerformed(evt);
}
});
tno.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
tnoKeyPressed(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.TRAILING)
.addComponent(jLabel2, javax.swing.GroupLayout.Alignment.LEADING, 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, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel5, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel6, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel7, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(tnama, javax.swing.GroupLayout.PREFERRED_SIZE, 211, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(talamat, javax.swing.GroupLayout.PREFERRED_SIZE, 301, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(ttelp, javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(tpekerjaan, javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(tkota, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 160, Short.MAX_VALUE))
.addComponent(tno, javax.swing.GroupLayout.PREFERRED_SIZE, 86, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(32, 32, 32))
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(tno, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(tnama, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel3))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(talamat, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel4))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(tkota, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel5))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(ttelp, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel6))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(tpekerjaan, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel7))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jPanel4.setBorder(javax.swing.BorderFactory.createEtchedBorder(javax.swing.border.EtchedBorder.RAISED, new java.awt.Color(204, 204, 204), new java.awt.Color(204, 204, 204)));
bsimpan.setText("Simpan");
bsimpan.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
bsimpanActionPerformed(evt);
}
});
bhapus.setText("Hapus");
bhapus.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
bhapusActionPerformed(evt);
}
});
bedit.setText("Edit");
bedit.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
beditActionPerformed(evt);
}
});
bkeluar.setText("Kembali");
bkeluar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
bkeluarActionPerformed(evt);
}
});
bupdate.setText("Update");
bupdate.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
bupdateActionPerformed(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()
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(bkeluar, javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(bhapus, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(bedit, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(bupdate, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(bsimpan, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addContainerGap())
);
jPanel4Layout.setVerticalGroup(
jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel4Layout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(bupdate)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(bsimpan)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(bedit)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(bhapus)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(bkeluar)
.addGap(23, 23, 23))
);
Table1.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(Table1);
jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("Cari Berdasarkan"));
jLabel8.setText("Kode Anggota :");
jLabel9.setText("Nama Anggota :");
tcarikode.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
tcarikodeActionPerformed(evt);
}
});
tcarikode.addPropertyChangeListener(new java.beans.PropertyChangeListener() {
public void propertyChange(java.beans.PropertyChangeEvent evt) {
tcarikodePropertyChange(evt);
}
});
tcarikode.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
tcarikodeKeyPressed(evt);
}
});
tcarinama.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
tcarinamaActionPerformed(evt);
}
});
tcarinama.addPropertyChangeListener(new java.beans.PropertyChangeListener() {
public void propertyChange(java.beans.PropertyChangeEvent evt) {
tcarinamaPropertyChange(evt);
}
});
tcarinama.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
tcarinamaKeyPressed(evt);
}
});
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(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 90, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(tcarikode, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jLabel9, javax.swing.GroupLayout.PREFERRED_SIZE, 90, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(tcarinama, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel8)
.addComponent(jLabel9))
.addComponent(tcarikode, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(tcarinama, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, 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)
.addComponent(jScrollPane1)
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jPanel4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 228, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(0, 0, Short.MAX_VALUE)))
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel1)
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(jPanel4, 0, 0, Short.MAX_VALUE)
.addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 167, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
pack();
}// </editor-fold>
private void bkeluarActionPerformed(java.awt.event.ActionEvent evt) {
new utama().setVisible(true);
dispose();
}
private void formWindowOpened(java.awt.event.WindowEvent evt) {
// TODO add your handling code here:
awal();
}
private void tnoActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void tnoKeyPressed(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
}
private void bsimpanActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try
{
con.setkoneksi();
String sql="insert into anggota values('"+tno.getText()+"','"+tnama.getText()+"','"+talamat.getText()+"','"+tkota.getText()+"','"+ttelp.getText()+"','"+tpekerjaan.getText()+"')";
con.st.executeUpdate(sql);
con.rs.close();
JOptionPane.showMessageDialog(null,"Database Berhasil Tersimpan","Koneksi Sukses",JOptionPane.INFORMATION_MESSAGE);
con.conn.close();
awal();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null,"<Error> Koneksikan Xampp Terlebih Dahulu : "+e,"Koneksi Gagal",JOptionPane.WARNING_MESSAGE);
}
}
private void tcarikodeActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void tcarikodePropertyChange(java.beans.PropertyChangeEvent evt) {
// TODO add your handling code here:
}
private void tcarikodeKeyPressed(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
if(evt.getKeyCode()==KeyEvent.VK_ENTER)
{
try
{
con.setkoneksi();
con.rs=con.st.executeQuery("select * from anggota where no_ang like '"+tcarikode.getText()+"'");
if(con.rs.next())
{
tno.setText(con.rs.getString(1));
tnama.setText(con.rs.getString(2));
talamat.setText(con.rs.getString(3));
tkota.setText(con.rs.getString(4));
ttelp.setText(con.rs.getString(5));
tpekerjaan.setText(con.rs.getString(6));
pasif();
bedit.setEnabled(true);
bhapus.setEnabled(true);
bsimpan.setVisible(false);
bupdate.setVisible(true);
bupdate.setEnabled(false);
}
else
{
JOptionPane.showMessageDialog(null,"Kode Tidak Tersedia");
tcarikode.setText("");
}
con.rs.close();
con.conn.close();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null,"<Error> Koneksikan Xampp Terlebih Dahulu : "+e,"Koneksi Gagal",JOptionPane.WARNING_MESSAGE);
}
}
}
private void tcarinamaKeyPressed(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
if(evt.getKeyCode()==KeyEvent.VK_ENTER)
{
try
{
con.setkoneksi();
con.rs=con.st.executeQuery("select * from anggota where nama_ang like '"+tcarinama.getText()+"'");
if(con.rs.next())
{
tno.setText(con.rs.getString(1));
tnama.setText(con.rs.getString(2));
talamat.setText(con.rs.getString(3));
tkota.setText(con.rs.getString(4));
ttelp.setText(con.rs.getString(5));
tpekerjaan.setText(con.rs.getString(6));
pasif();
bedit.setEnabled(true);
bhapus.setEnabled(true);
bsimpan.setVisible(false);
bupdate.setVisible(true);
bupdate.setEnabled(false);
//Table1.setModel(gettabel());
}
else
{
JOptionPane.showMessageDialog(null,"Nama Tidak Tersedia");
tcarinama.setText("");
}
con.rs.close();
con.conn.close();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null,"<Error> Koneksikan Xampp Terlebih Dahulu : "+e,"Koneksi Gagal",JOptionPane.WARNING_MESSAGE);
}
}
}
private void beditActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
aktif();
bupdate.setEnabled(true);
bedit.setEnabled(false);
bhapus.setEnabled(false);
}
private void bupdateActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try
{
con.setkoneksi();String sql="update anggota set nama_ang='"+tnama.getText()+"',alamat='"+talamat.getText()+"',kota='"+tkota.getText()+"',no_telp='"+ttelp.getText()+"',pekerjaan='"+tpekerjaan.getText()+"' where no_ang='"+tno.getText()+"'";
con.st.executeUpdate(sql);
con.rs.close();
JOptionPane.showMessageDialog(null,"Database Berhasil Terupdate","Koneksi Sukses",JOptionPane.INFORMATION_MESSAGE);
con.conn.close();
awal();
tcarikode.setText("");
tcarinama.setText("");
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null,"<Error> Koneksikan Xampp Terlebih Dahulu : "+e,"Koneksi Gagal",JOptionPane.WARNING_MESSAGE);
}
}
private void bhapusActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try
{
con.setkoneksi();
String sql="delete from anggota where no_ang='"+tcarikode.getText()+"' or nama_ang='"+tcarinama.getText()+"'";
con.st.executeUpdate(sql);
con.rs.close();
JOptionPane.showMessageDialog(null,"Database Berhasil Terhapus","Koneksi Sukses",JOptionPane.INFORMATION_MESSAGE);
con.conn.close();
awal();
tcarikode.setText("");
tcarinama.setText("");
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null,"<Error> Koneksikan Xampp Terlebih : "+e,"Koneksi Gagal",JOptionPane.WARNING_MESSAGE);
}
}
private void tcarinamaActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void tcarinamaPropertyChange(java.beans.PropertyChangeEvent evt) {
// TODO add your handling code here:
}
private void ttelpActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new anggota().setVisible(true);
}
});
}
Sekian Terimakasih :)
Selamat mencoba Kembali