ini dia projectQ,, tp msh sderhana bgt... nmany jg msh belajar dan codingnya jg blm terOOP tp lumayan lah.....
langsung aja ya....
jangn lupa buat databasenya terlebih dahulu ya....... cukup pake 1 table aja dan kode brng sbgai PrimaryKey...
lngsung bka neatBeans, java applications, klik kanan pilih JFrameform...... trus buat interface pake palete yg d drag and drop spt d bwh ini...
pada button2nya sama JTablenya d kasih action ya,,,,
buttonya actionlistener, tablenya mouse klik.... oh iya sm textfieldnya actionnya mousepressed... cra ksih actionya uda tau kan.... klik kanan pada komponen, trus pilih event,,, nah tinggal pilih actionya apayang mau di gunakan......
OKe langsung Coding lengkapnya aja ya d sourcenya:
method mainya:
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package aplikasitransaksi;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.UIManager;
import javax.swing.UnsupportedLookAndFeelException;
/**
*
* @author tiwi
*/
public class Main {
/**
* @param args the command line arguments
*/
public static void main(String[] args) {
try {
UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
// TODO code application logic here
new Transaksi().setVisible(true);
} catch (ClassNotFoundException ex) {
Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
} catch (UnsupportedLookAndFeelException ex) {
Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
Class transaksinya:
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
/*
* Transaksi.java
*
* Created on Jan 19, 2011, 5:22:06 PM
*/
package aplikasitransaksi;
import java.awt.event.KeyEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
/**
*
* @author tiwi
*/
public class Transaksi extends javax.swing.JFrame {
Connection connection;
Statement statement;
DefaultTableModel dtm;
ResultSet resultSet;
/** Creates new form Transaksi */
public Transaksi() {
initComponents();
initTable();
tampilkode();
}
/** 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();
jScrollPane3 = new javax.swing.JScrollPane();
jTable2 = new javax.swing.JTable();
jLabel1 = new javax.swing.JLabel();
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();
tfkode = new javax.swing.JTextField();
tfNama = new javax.swing.JTextField();
tfjumlh = new javax.swing.JTextField();
tfharga = new javax.swing.JTextField();
tftglklr = new javax.swing.JTextField();
tftglmsk = new javax.swing.JTextField();
jLabel8 = new javax.swing.JLabel();
btampil = new javax.swing.JButton();
bsimpan = new javax.swing.JButton();
bubah = new javax.swing.JButton();
bcari = new javax.swing.JButton();
jScrollPane1 = new javax.swing.JScrollPane();
jScrollPane4 = new javax.swing.JScrollPane();
jTable3 = new javax.swing.JTable();
jComboBox1 = new javax.swing.JComboBox();
tfcari = new javax.swing.JTextField();
bhapus = new javax.swing.JButton();
btutup = new javax.swing.JButton();
bhitung = new javax.swing.JButton();
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);
jTable2.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"
}
));
jScrollPane3.setViewportView(jTable2);
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 36));
jLabel1.setText("::DATA TRANSAKSI::");
jLabel2.setFont(new java.awt.Font("Times New Roman", 1, 14));
jLabel2.setText("Kode Barang");
jLabel3.setFont(new java.awt.Font("Times New Roman", 1, 14));
jLabel3.setText("Jumlah Barang");
jLabel4.setFont(new java.awt.Font("Times New Roman", 1, 14));
jLabel4.setText("Nama Barang");
jLabel5.setFont(new java.awt.Font("Times New Roman", 1, 14));
jLabel5.setText("Harga Barang");
jLabel6.setFont(new java.awt.Font("Times New Roman", 1, 14));
jLabel6.setText("Tanggal Masuk");
jLabel7.setFont(new java.awt.Font("Times New Roman", 1, 14));
jLabel7.setText("Tanggal Keluar");
tfkode.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
tfkodeKeyPressed(evt);
}
});
tfNama.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
tfNamaKeyPressed(evt);
}
});
tfjumlh.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
tfjumlhActionPerformed(evt);
}
});
tfjumlh.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
tfjumlhKeyPressed(evt);
}
});
tfharga.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
tfhargaKeyPressed(evt);
}
});
tftglklr.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
tftglklrKeyPressed(evt);
}
});
tftglmsk.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
tftglmskKeyPressed(evt);
}
});
jLabel8.setFont(new java.awt.Font("Times New Roman", 1, 14));
jLabel8.setText("::Tabel Transaksi::");
btampil.setFont(new java.awt.Font("Times New Roman", 1, 14));
btampil.setText("Tampil");
btampil.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btampilActionPerformed(evt);
}
});
bsimpan.setFont(new java.awt.Font("Times New Roman", 1, 14));
bsimpan.setText("Simpan");
bsimpan.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
bsimpanActionPerformed(evt);
}
});
bubah.setFont(new java.awt.Font("Times New Roman", 1, 14));
bubah.setText("Ubah");
bubah.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
bubahActionPerformed(evt);
}
});
bcari.setFont(new java.awt.Font("Times New Roman", 1, 14));
bcari.setText("Cari");
bcari.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
bcariActionPerformed(evt);
}
});
jTable3.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null, null, null},
{null, null, null, null, null, null},
{null, null, null, null, null, null},
{null, null, null, null, null, null}
},
new String [] {
"Kode ", "Nama ", "Jumlah ", "Harga", "Tgl Masuk", "Tgl Keluar"
}
));
jTable3.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
jTable3MouseClicked(evt);
}
});
jScrollPane4.setViewportView(jTable3);
jScrollPane1.setViewportView(jScrollPane4);
jComboBox1.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N
jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "-Kode-" }));
jComboBox1.addItemListener(new java.awt.event.ItemListener() {
public void itemStateChanged(java.awt.event.ItemEvent evt) {
jComboBox1ItemStateChanged(evt);
}
});
bhapus.setFont(new java.awt.Font("Times New Roman", 1, 14));
bhapus.setText("Hapus");
bhapus.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
bhapusActionPerformed(evt);
}
});
btutup.setFont(new java.awt.Font("Times New Roman", 1, 14));
btutup.setText("Tutup");
btutup.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btutupActionPerformed(evt);
}
});
bhitung.setFont(new java.awt.Font("Times New Roman", 1, 14));
bhitung.setText("Hitung");
bhitung.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
bhitungActionPerformed(evt);
}
});
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel2)
.addComponent(jLabel3)
.addComponent(jLabel6)
.addComponent(jLabel7)
.addComponent(jLabel5)
.addComponent(jLabel4))
.addGap(79, 79, 79)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(tfNama, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 176, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(tfharga, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 176, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(tfkode, javax.swing.GroupLayout.PREFERRED_SIZE, 176, javax.swing.GroupLayout.PREFERRED_SIZE))
.addComponent(tftglmsk, javax.swing.GroupLayout.PREFERRED_SIZE, 176, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(tfjumlh, javax.swing.GroupLayout.PREFERRED_SIZE, 176, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(tftglklr, javax.swing.GroupLayout.PREFERRED_SIZE, 176, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
.addGap(109, 109, 109)
.addComponent(jLabel1)))
.addGroup(layout.createSequentialGroup()
.addGap(56, 56, 56)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jLabel8)
.addComponent(btampil))
.addGap(31, 31, 31)
.addComponent(bsimpan)
.addGap(35, 35, 35)
.addComponent(bubah, javax.swing.GroupLayout.PREFERRED_SIZE, 80, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(36, 36, 36)
.addComponent(bhapus, javax.swing.GroupLayout.PREFERRED_SIZE, 81, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addGap(64, 64, 64)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 482, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createSequentialGroup()
.addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 69, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(tfcari, javax.swing.GroupLayout.PREFERRED_SIZE, 110, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(bcari, javax.swing.GroupLayout.PREFERRED_SIZE, 81, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(57, 57, 57)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(btutup, javax.swing.GroupLayout.PREFERRED_SIZE, 81, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(bhitung, javax.swing.GroupLayout.PREFERRED_SIZE, 81, javax.swing.GroupLayout.PREFERRED_SIZE))))))
.addContainerGap(56, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel1)
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(tfkode, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(tfNama, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(8, 8, 8)
.addComponent(tfjumlh, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(tfharga, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(tftglmsk, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(tftglklr, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel2)
.addGap(16, 16, 16)
.addComponent(jLabel4)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jLabel3)
.addGap(13, 13, 13)
.addComponent(jLabel5)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jLabel6)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jLabel7)))
.addGap(32, 32, 32)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(btampil)
.addComponent(bsimpan)
.addComponent(bubah)
.addComponent(bhapus, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(39, 39, 39)
.addComponent(jLabel8)
.addGap(18, 18, 18)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 100, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(26, 26, 26)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(tfcari, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(bcari, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(bhitung, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 41, Short.MAX_VALUE)
.addComponent(btutup, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(38, 38, 38))
);
pack();
}// </editor-fold>
private void tfjumlhActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void tfkodeKeyPressed(java.awt.event.KeyEvent evt) {
if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
if (tfkode.getText().equals("") == false) {
tfNama.requestFocus();
}
}
// TODO add your handling code here:
}
private void tfNamaKeyPressed(java.awt.event.KeyEvent evt) {
if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
if (tfNama.getText().equals("") == false) {
tfjumlh.requestFocus();
}
}
// TODO add your handling code here:
}
private void tfjumlhKeyPressed(java.awt.event.KeyEvent evt) {
if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
if (tfjumlh.getText().equals("") == false) {
tfharga.requestFocus();
}
}
// TODO add your handling code here:
}
private void tfhargaKeyPressed(java.awt.event.KeyEvent evt) {
if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
if (tfharga.getText().equals("") == false) {
tftglmsk.requestFocus();
}
}
// TODO add your handling code here:
}
private void tftglmskKeyPressed(java.awt.event.KeyEvent evt) {
if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
if (tftglmsk.getText().equals("") == false) {
tftglklr.requestFocus();
}
}
// TODO add your handling code here:
}
private void tftglklrKeyPressed(java.awt.event.KeyEvent evt) {
if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
if (tftglklr.getText().equals("") == false) {
bsimpan.requestFocus();
}
}
// TODO add your handling code here:
}
private void bsimpanActionPerformed(java.awt.event.ActionEvent evt) {
simpanData();
String[] data = {tfkode.getText(), tfNama.getText(), tfjumlh.getText(), tfharga.getText(), tftglmsk.getText(), tftglklr.getText()};
dtm.addRow(data);
kosong();
// TODO add your handling code here:
}
private void btampilActionPerformed(java.awt.event.ActionEvent evt) {
tampildata();
// TODO add your handling code here:
}
private void bhapusActionPerformed(java.awt.event.ActionEvent evt) {
hapusData();
dtm.removeRow(jTable3.getSelectedRow());
// TODO add your handling code here:
}
private void bubahActionPerformed(java.awt.event.ActionEvent evt) {
ubahData();
// TODO add your handling code here:
}
private void jTable3MouseClicked(java.awt.event.MouseEvent evt) {
jTable3.getValueAt(jTable3.getSelectedRow(), 1);
ambilData();
// TODO add your handling code here:
}
private void btutupActionPerformed(java.awt.event.ActionEvent evt) {
System.exit(0);
// TODO add your handling code here:
}
private void bcariActionPerformed(java.awt.event.ActionEvent evt) {
cariData();
// TODO add your handling code here:
}
private void jComboBox1ItemStateChanged(java.awt.event.ItemEvent evt) {
cariNama();
// TODO add your handling code here:
}
private void bhitungActionPerformed(java.awt.event.ActionEvent evt) {
Hitung h = new Hitung();
h.setVisible(true);
dispose();
// TODO add your handling code here:
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new Transaksi().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton bcari;
private javax.swing.JButton bhapus;
private javax.swing.JButton bhitung;
private javax.swing.JButton bsimpan;
private javax.swing.JButton btampil;
private javax.swing.JButton btutup;
private javax.swing.JButton bubah;
private javax.swing.JComboBox jComboBox1;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
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.JScrollPane jScrollPane1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JScrollPane jScrollPane3;
private javax.swing.JScrollPane jScrollPane4;
private javax.swing.JTable jTable1;
private javax.swing.JTable jTable2;
private javax.swing.JTable jTable3;
private javax.swing.JTextField tfNama;
private javax.swing.JTextField tfcari;
private javax.swing.JTextField tfharga;
private javax.swing.JTextField tfjumlh;
private javax.swing.JTextField tfkode;
private javax.swing.JTextField tftglklr;
private javax.swing.JTextField tftglmsk;
// End of variables declaration
public void koneksi() {
try {
Class.forName("org.gjt.mm.mysql.Driver");
connection = DriverManager.getConnection("jdbc:mysql://localhost/datatransaksi", "root", null);
statement = connection.createStatement();
} catch (Exception ex) {
ex.printStackTrace();
}
}
public void closeKoneksi() {
try {
connection.close();
statement.close();
resultSet.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
public void kosong() {
tfNama.setText("");
tfcari.setText("");
tfharga.setText("");
tfjumlh.setText("");
tfkode.setText("");
tftglklr.setText("");
tftglmsk.setText("");
jComboBox1.setSelectedIndex(0);
}
private void simpanData() {
try {
koneksi();
String sql = "insert into transaksi values('" + tfkode.getText() + "','" + tfNama.getText() + "','" + tfjumlh.getText() + "','" + tfharga.getText() + "','"
+ tftglmsk.getText() + "','" + tftglklr.getText() + "')";
statement.executeUpdate(sql);
JOptionPane.showMessageDialog(null, "Data berhasil disimpan", "Information", JOptionPane.INFORMATION_MESSAGE);
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "Data Gagal disimpan", "Information", JOptionPane.ERROR_MESSAGE);
ex.printStackTrace();
}
closeKoneksi();
}
private void initTable() {
String kolom[] = {"Kode", "Nama", "Jumlah", "Harga", "TglMasuk", "TglKeluar"};
dtm = new DefaultTableModel(kolom, 0);
jTable3.setModel(dtm);
jScrollPane1.setViewportView(jTable3);
}
private void ubahData() {
try {
koneksi();
String sql = "update transaksi set nama='" + tfNama.getText() + "',jumlah ='" + tfjumlh.getText() + "',harga ='" + tfharga.getText() + "',tglmasuk ='" + tftglmsk.getText()
+ "',tglkeluar ='" + tftglklr.getText() + "'where kode = '" + tfkode.getText() + "'";
statement.executeUpdate(sql);
JOptionPane.showMessageDialog(null, "Data Berhasil Diubah", "Information", JOptionPane.INFORMATION_MESSAGE);
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "Data Gagal Diubah", "Information", JOptionPane.ERROR_MESSAGE);
ex.printStackTrace();
}
closeKoneksi();
kosong();
}
private void ambilData() {
String kode = (String) jTable3.getValueAt(jTable3.getSelectedRow(), 0);
String nama = (String) jTable3.getValueAt(jTable3.getSelectedRow(), 1);
String jml = (String) jTable3.getValueAt(jTable3.getSelectedRow(), 2);
String hrg = (String) jTable3.getValueAt(jTable3.getSelectedRow(), 3);
String tglms = (String) jTable3.getValueAt(jTable3.getSelectedRow(), 4);
String tglkl = (String) jTable3.getValueAt(jTable3.getSelectedRow(), 5);
tfkode.setText(kode);
tfNama.setText(nama);
tfjumlh.setText(jml);
tfharga.setText(hrg);
tftglmsk.setText(tglms);
tftglklr.setText(tglkl);
}
private void hapusData() {
try {
koneksi();
String sql = "delete from transaksi where kode ='" + tfkode.getText() + "'";
statement.executeUpdate(sql);
JOptionPane.showMessageDialog(null, "Data Berhasil diHapus", "Information", JOptionPane.INFORMATION_MESSAGE);
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "Data Gagal Dihapus", "Information", JOptionPane.ERROR_MESSAGE);
ex.printStackTrace();
}
closeKoneksi();
kosong();
}
private void cariData() {
String data[][] = new String[1][6];
try {
koneksi();
String sql = "select * from transaksi where nama='" + tfcari.getText() + "'";
resultSet = statement.executeQuery(sql);
int n = 0;
while (resultSet.next()) {
data[n][0] = resultSet.getString(1);
data[n][1] = resultSet.getString(2);
data[n][2] = resultSet.getString(3);
data[n][3] = resultSet.getString(4);
data[n][4] = resultSet.getString(5);
data[n][5] = resultSet.getString(6);
n++;
}
String kolom[] = {"Kode", "Nama", "Jumlah", "Harga", "TglMasuk", "TglKeluar"};
dtm = new DefaultTableModel(data, kolom);
jTable3.setModel(dtm);
jScrollPane1.setViewportView(jTable3);
JOptionPane.showMessageDialog(null, "Data Berhasil Ditemukan", "Information", JOptionPane.INFORMATION_MESSAGE);
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "Data Tidak ditemukan", "Information", JOptionPane.ERROR_MESSAGE);
ex.printStackTrace();
}
kosong();
}
private void cariNama() {
try {
koneksi();
String sql = "select nama from transaksi where kode ='" + jComboBox1.getSelectedItem() + "'";
resultSet = statement.executeQuery(sql);
if (resultSet.next()) {
tfcari.setText(resultSet.getString(1));
} else {
}
closeKoneksi();
} catch (Exception ex) {
ex.printStackTrace();
}
}
private void tampilkode() {
String sql = "select kode from transaksi";
try {
koneksi();
resultSet = statement.executeQuery(sql);
int b = 0;
while (resultSet.next()) {
jComboBox1.addItem(resultSet.getString(1));
b++;
}
} catch (Exception ex) {
ex.printStackTrace();
}
closeKoneksi();
}
public void tampildata() {
String[][] data = new String[6][6];
try {
koneksi();
String sql = "select * from transaksi";
resultSet = statement.executeQuery(sql);
int n = 0;
while (resultSet.next()) {
data[n][0] = resultSet.getString(1);
data[n][1] = resultSet.getString(2);
data[n][2] = resultSet.getString(3);
data[n][3] = resultSet.getString(4);
data[n][4] = resultSet.getString(5);
data[n][5] = resultSet.getString(6);
n++;
}
String kolom[] = {"Kode", "Nama", "Jumlah", "Harga", "TglMasuk", "TglKeluar"};
dtm = new DefaultTableModel(data, kolom);
jTable3.setModel(dtm);
jScrollPane1.setViewportView(jTable3);
} catch (Exception ex) {
ex.printStackTrace();
}
closeKoneksi();
}
}
klo di run maka tampilanny sbb:
lalu datanya nambah ke table deh:
oh iya dlm project ini saya pke campuran abstrack table model sm default table model,,,,,,,
kemudian klik pd tabelny untuk melakukan edit, jelasny sprti gmbr d bwh ini:
klik button ubah muncul pesan sbb:
lalu klik button tampil untuk melihat perubahanya:
hbs itu klik pd slh satu row table.... trus klik hapus....
keluar pesan lagi:
nah hbs itu searchingnya pilih kode yng ada pd combobox, kemudian d klik nah nama barngya akan muncul di textfielny trus klik button cari,,, sperti gmbr berikut...
untuk button Hitung isinya form perhitungan atau semacam kalkulator:
Codinya sbb:
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
/*
* Hitung.java
*
* Created on Jan 23, 2011, 5:05:38 PM
*/
package aplikasitransaksi;
import java.awt.event.KeyEvent;
/**
*
* @author tiwi
*/
public class Hitung extends javax.swing.JFrame {
/** Creates new form Hitung */
public Hitung() {
initComponents();
}
/** 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() {
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
tf1 = new javax.swing.JTextField();
tf2 = new javax.swing.JTextField();
btambah = new javax.swing.JButton();
bkurang = new javax.swing.JButton();
bkali = new javax.swing.JButton();
bbagi = new javax.swing.JButton();
jLabel4 = new javax.swing.JLabel();
tftotal = new javax.swing.JTextField();
bhasil1 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 36)); // NOI18N
jLabel1.setText("::PerHiTungan::");
jLabel2.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N
jLabel2.setText("Harga Barang 1");
jLabel3.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N
jLabel3.setText("Harga Barang 2");
tf1.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
tf1KeyPressed(evt);
}
});
tf2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
tf2ActionPerformed(evt);
}
});
tf2.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
tf2KeyPressed(evt);
}
});
btambah.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N
btambah.setText("+");
btambah.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btambahActionPerformed(evt);
}
});
bkurang.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N
bkurang.setText("-");
bkurang.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
bkurangActionPerformed(evt);
}
});
bkali.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N
bkali.setText("x");
bkali.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
bkaliActionPerformed(evt);
}
});
bbagi.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N
bbagi.setText("/");
bbagi.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
bbagiActionPerformed(evt);
}
});
jLabel4.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N
jLabel4.setText("Total");
tftotal.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
tftotalActionPerformed(evt);
}
});
bhasil1.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N
bhasil1.setText("<< Back");
bhasil1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
bhasil1ActionPerformed(evt);
}
});
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(174, 174, 174)
.addComponent(jLabel1))
.addGroup(layout.createSequentialGroup()
.addGap(137, 137, 137)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jLabel3)
.addComponent(jLabel2))
.addGap(126, 126, 126)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(tf2, javax.swing.GroupLayout.PREFERRED_SIZE, 127, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(tf1, javax.swing.GroupLayout.PREFERRED_SIZE, 127, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(layout.createSequentialGroup()
.addGap(291, 291, 291)
.addComponent(jLabel4)
.addGap(38, 38, 38)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(bhasil1)
.addComponent(tftotal, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 126, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(layout.createSequentialGroup()
.addGap(192, 192, 192)
.addComponent(btambah)
.addGap(18, 18, 18)
.addComponent(bkurang)
.addGap(18, 18, 18)
.addComponent(bkali)
.addGap(18, 18, 18)
.addComponent(bbagi)))
.addContainerGap(142, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(20, 20, 20)
.addComponent(jLabel1)
.addGap(48, 48, 48)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel2)
.addGap(26, 26, 26)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(tf2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addComponent(tf1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(43, 43, 43)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(btambah)
.addComponent(bkurang)
.addComponent(bkali)
.addComponent(bbagi))
.addGap(41, 41, 41)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(tftotal, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel4))
.addGap(50, 50, 50)
.addComponent(bhasil1)
.addContainerGap(47, Short.MAX_VALUE))
);
pack();
}// </editor-fold>
private void tftotalActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void btambahActionPerformed(java.awt.event.ActionEvent evt) {
int a = Integer.parseInt(tf1.getText());
int b = Integer.parseInt(tf2.getText());
int c;
String e;
c = a + b;
e = String.valueOf(c);
tftotal.setText(e);
// TODO add your handling code here:
}
private void bkurangActionPerformed(java.awt.event.ActionEvent evt) {
int a = Integer.parseInt(tf1.getText());
int b = Integer.parseInt(tf2.getText());
int c;
String e;
c = a - b;
e = String.valueOf(c);
tftotal.setText(e);
// TODO add your handling code here:
}
private void bkaliActionPerformed(java.awt.event.ActionEvent evt) {
int a = Integer.parseInt(tf1.getText());
int b = Integer.parseInt(tf2.getText());
int c;
String e;
c = a * b;
e = String.valueOf(c);
tftotal.setText(e);
// TODO add your handling code here:
}
private void bbagiActionPerformed(java.awt.event.ActionEvent evt) {
int a = Integer.parseInt(tf1.getText());
int b = Integer.parseInt(tf2.getText());
int c;
String e;
c = a / b;
e = String.valueOf(c);
tftotal.setText(e);
// TODO add your handling code here:
}
private void bhasil1ActionPerformed(java.awt.event.ActionEvent evt) {
Transaksi t = new Transaksi();
t.setVisible(true);
dispose(); // TODO add your handling code here:
}
private void tf1KeyPressed(java.awt.event.KeyEvent evt) {
if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
if (tf1.getText().equals("") == false) {
tf2.requestFocus();
}
}
// TODO add your handling code here:
}
private void tf2ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void tf2KeyPressed(java.awt.event.KeyEvent evt) {
if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
if (tf2.getText().equals("") == false) {
btambah.requestFocus();
}
}
// TODO add your handling code here:
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new Hitung().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton bbagi;
private javax.swing.JButton bhasil1;
private javax.swing.JButton bkali;
private javax.swing.JButton bkurang;
private javax.swing.JButton btambah;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JTextField tf1;
private javax.swing.JTextField tf2;
private javax.swing.JTextField tftotal;
// End of variables declaration
}
okelah,,, jadi dalam apikasi ini buat 2 form... jngn lupa runingnya dari method mainya ya.......
sekian terimakasih........
ditugnggu kritik dan sarannya ya......
bagus ....
BalasHapusdapat dicoba :D
hahaha .. marai ngiler :p