Bahasa Pemrograman 3 20181

Program Penjualan
1. Desain Form
a. Form Cari Barang

b. Form Penjualan

2. Kode program form cari barang

- Import library
import database.Konekdb;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
 Bahasa Pemrograman 3 20181
- Deklarasi variable
public class FormCariBarang extends javax.swing.JFrame {
private Connection conn;
private Statement stt;

- Kode program pada constructor

public FormCariBarang () {
initComponents();
tampildata();
}

- Kode program tampildata

private void tampildata(){
DefaultTableModel tblmodel = new DefaultTableModel();
tblmodel.addColumn("Kode Barang");
tblmodel.addColumn("Nama Barang");
tblmodel.addColumn("Merk");
tblmodel.addColumn("Jenis");
tblmodel.addColumn("Satuan");
tblmodel.addColumn("Harga");
tblmodel.addColumn("Stok");
try{
conn = Konekdb.getKoneksi();
stt = conn.createStatement();
String sql = "SELECT barangid,barangnama,merknama,jenisnama,"
+ "barangsatuan,barangharga,barangstok FROM barang JOIN merk ON
barangmerkid=merkid JOIN jenis ON barangjenisid=jenisid";
ResultSet rs = stt.executeQuery(sql);
while(rs.next())
{
tblmodel.addRow(new Object[]{
rs.getString(1),
rs.getString(2),
rs.getString(3),
rs.getString(4),
rs.getString(5),
rs.getString(6),
rs.getString(7)
});
}
jTable1.setModel(tblmodel);
conn.close();
}catch (SQLException e){
JOptionPane.showMessageDialog(null, "Ada Kesalahan"+e);
}
 Bahasa Pemrograman 3 20181

- Kode program cari data

private void txtcariActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
DefaultTableModel tblmodel = new DefaultTableModel();
tblmodel.addColumn("Kode Barang");
tblmodel.addColumn("Nama Barang");
tblmodel.addColumn("Merk");
tblmodel.addColumn("Jenis");
tblmodel.addColumn("Satuan");
tblmodel.addColumn("Harga");
tblmodel.addColumn("Stok");
try{
conn = Konekdb.getKoneksi();
stt = conn.createStatement();
String sql = "SELECT barangid,barangnama,merknama,jenisnama,"
+ "barangsatuan,barangharga,barangstok FROM barang "
+ "JOIN merk ON barangmerkid=merkid \n" +
"JOIN jenis ON barangjenisid=jenisid"
+ " where barangid ='"+ txtcari.getText() +"'"
+ " or barangnama like '%" + txtcari.getText() + "%'";
ResultSet rs = stt.executeQuery(sql);
while(rs.next())
{
tblmodel.addRow(new Object[]{
rs.getString(1),
rs.getString(2),
rs.getString(3),
rs.getString(4),
rs.getString(5),
rs.getString(6),
rs.getString(7)
});
}
jTable1.setModel(tblmodel);
conn.close();
}catch (SQLException e){
JOptionPane.showMessageDialog(null, "Ada Kesalahan"+e);
}
}

- Kode program pada tombol OK

private void btnOkActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
int row = jTable1.getSelectedRow();
 Bahasa Pemrograman 3 20181
//mengambil data dari table
FormPenjualan.txtKobar.setText(jTable1.getValueAt(row, 0).toString());
FormPenjualan.txtNabar.setText(jTable1.getValueAt(row, 1).toString());
FormPenjualan.txtStok.setText(jTable1.getValueAt(row, 6).toString());
FormPenjualan.txtHarga.setText(jTable1.getValueAt(row, 5).toString());
this.dispose();
}

3. Kode program form Penjualan

- Import library
import database.Konekdb;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;

- Deklarasi variable
public class FormPenjualan extends javax.swing.JFrame {
private Connection conn;
private Statement stt;

- Kode program pada constructor

public FormCariBarang () {
initComponents();
tabel.setModel(tblmodel);
}
- Method totalharga dan tabel model
private void totalharga()
{
double tothrg = 0;
int jumrec = tabel.getRowCount();
for (int i=0;i<jumrec;i++)
{
tothrg = tothrg + Double.parseDouble(tblmodel.getValueAt(i,5).toString());
}
txtTotalHarga.setText(String.valueOf(tothrg));
}

String data[] = new String[7];

private javax.swing.table.DefaultTableModel tblmodel=getDefaultTableModel();
int row =0;
private javax.swing.table.DefaultTableModel getDefaultTableModel(){
return new javax.swing.table.DefaultTableModel
 Bahasa Pemrograman 3 20181
( new Object[][]{},
new String[]{"Kode","Nama Barang" ,"Harga","Qty","Diskon","Jumlah
harga"}
);
}

- Method caribarang
private void caribarang(){
try{

conn= Konekdb.getKoneksi();
stt = conn.createStatement();
String sql = "Select * from barang where kobar='"+txtKobar.getText()+"'";
ResultSet rs = stt.executeQuery(sql);
if (rs.next())
{
txtNabar.setText(rs.getString(2));
txtStok.setText(rs.getString(3));
}
else{
JOptionPane.showMessageDialog(null, "Data Barang Tidak Ada");
}
} catch (Exception e){}
}

- Kode program pada txtkobar

private void txtKobarActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
caribarang();
}

private void txtKobarKeyPressed(java.awt.event.KeyEvent evt) {

// TODO add your handling code here:
if (evt.getKeyCode()==10){
caribarang();
}
}

- Kode program pada tombol simpan

private void btnSimpanActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try {
conn= Konekdb.getKoneksi();
stt = conn.createStatement();
//simpan ke tabel jual
 Bahasa Pemrograman 3 20181
String nofak = txtNofak.getText();
String napel = txtNapel.getText();
String total = txtTotalHarga.getText();
String sql = "insert into jual values('"+ nofak +"', "
+ " curdate(),'"+ napel +"','"+ total +"')";
stt.executeUpdate(sql);

//simpan ke tabel detailjual

int t = tabel.getRowCount();
for (int i=0;i < t ;i++){
String kobar = tabel.getValueAt(i, 0).toString();
double hrgjual = Double.parseDouble(tabel.getValueAt(i, 2).toString());
double qty = Double.parseDouble(tabel.getValueAt(i, 3).toString());

//double jmlhrg = Double.parseDouble(tabel.getValueAt(i, 5).toString());

String sql1 ="insert into detailjual"

+ "(detailjualjualid,detailjualbarangid,detailjualqty,detailjualharga)"
+ " values('"+ nofak +"','"+ kobar +"','"+ qty +"','"+ hrgjual +"')";
stt.executeUpdate(sql1);

//udpate stok barang

String sql2 = "update barang set barangstok=barangstok - '"+ qty +"'" +
" where barangid='" + kobar + "'";
stt.executeUpdate(sql2);

}
conn.close();

JOptionPane.showMessageDialog(null,"Data berhasil di simpan");

}catch ( SQLException e){

JOptionPane.showMessageDialog(null,"Proses penyimpanan gagal..");
System.out.println(e.getMessage());
}
}

- Kode program pada tombol tambah

private void btnTambahActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
data[0]= txtKobar.getText();
data[1]= txtNabar.getText();
data[2]= txtStok.getText();
data[3]= txtHarga.getText();
data[4]= txtQty.getText();
 Bahasa Pemrograman 3 20181
data[5]= txtDisc.getText();
data[6]= txtJumlahHarga.getText();
tblmodel.insertRow(row, data);
totalharga();
txtKobar.setText("");
txtNabar.setText("");
txtStok.setText("");
txtHarga.setText("");
txtQty.setText("");
txtDisc.setText("");
txtJumlahHarga.setText("");
}

- Kode program pada tombol hapus

private void btnHapusActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
tblmodel.removeRow(row);
totalharga();
}