1. Deskripsi
Pengembangan project kasir minimarket dengan menggunakan JDBC.
Pengembangan menggunakan JDBC ini supaya data penjualan bisa tersimpan datanya.
Screenshoot Design kasir
Screenshoot Program di run
2. Source Code
private void CNBItemStateChanged(java.awt.event.ItemEvent evt) {
// TODO add your handling code here:
int Option = CNB.getSelectedIndex();
switch (Option) {
case 0:
break;
case 1:
TxtHB.setText(""+7500);
break;
case 2:
TxtHB.setText(""+12000);
break;
case 3:
TxtHB.setText(""+24000);
break;
case 4:
TxtHB.setText(""+15000);
break;
default:
TxtHB.setText(""+28000);
}
try{
String host = "jdbc://localhost:3306/irsan",
user ="root",
pass ="";
Connection con = (Connection) DriverManager.getConnection(host, user, pass);
String Nama=CNB.getText();
int Harga=Integer.parseInt(TxtHB.getText());
int Jumlah=Integer.parseInt(TxtJB.getText());
int Total=Integer.parseInt(TxtTotal.getText());
int Dibayar=Integer.parseInt(TxtUD.getText());
int kembali=Integer.parseInt(TxtUK.getText());
Statement st=con.createStatement();
st.executeUpdate("INSERT INTO kasir ( Nama_Barang, Harga_Barang, Jumlah_Barang, Total, Uang_Dibayar, Uang_Kembali) VALUES ( '"+nama+"','"+Harga+"','"+Jumlah+"','"+Total+"','"+Dibayar+"','"+Kembali+"')");
st.close();
JOptionPane.showMessageDialog(null,"Berhasil");
} catch (SQLException err) {
JOptionPane.showMessageDialog(null,err.getMessage());
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
int c = Integer.parseInt(TxtHB.getText());
int d = Integer.parseInt(TxtJB.getText());
int hasilnya = c*d;
TxtTotal.setText(""+hasilnya);
3. Flowchart
Sekian Terimakasih :)