LISTINGPROGRAM

Listing Koneksi
packagekoneksi;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLExc
eption;public class koneksi {private Connection koneksi;public Connection connect(){try
{Class.forName("com.mysql.jdbc.Driver");System.out.println("BerhasilKoneksi");}catch(ClassNo
tFoundExceptionex){System.out.println("GagalKoneksi"+ex);}Stringurl="jdbc:mysql://
localhost:3306/
aplikasi_persediaan_barang";try{koneks=DriverManager.getConnection(url,"root","");System.out.
println("BerhasilKoneksi Database");} catch (SQLException ex){System.out.println("Gagal
KoneksiDatabase"+ex);}returnkoneksi;}}

Listing Login
package tampilan;import java.awt.event.ActionEvent;import java.awt.event.KeyEvent;import
java.sql.Connection;importjava.sql.ResultSet;importjavax.swing.JFrame;importjavax.swing.JOptio
nPane;import koneksi.koneksi;public class login extends javax.swing.JFrame {private Connection
conn = new koneksi().connect();public login() {initComponents();} // <editor-fold
defaultstate="collapsed" desc="Generated Code"> private void initComponents() {jPanel1 = new
javax.swing.JPanel();iconuser=newjavax.swing.JLabel();jLabel1=newjavax.swing.JLabel();txtUse
rname=newjavax.swing.JTextField();jLabel2=newjavax.swing.JLabel();btnLogin=newjavax.swing
.JButton();btnCancel=newjavax.swing.JButton();txtPassword=newjavax.swing.JPasswordField();j
Label3=newjavax.swing.JLabel();setDefaultCloseOperation(javax.swing.WindowConstants.EXIT
_ON_CLOSE);setTitle("Login");jPanel1.setBackground(newjava.awt.Color(153,153,153));jPanel
1.setCursor(newjava.awt.Cursor(java.awt.Cursor.HAND_CURSOR));jPanel1.setPreferredSize(ne
w java.awt.Dimension(500, 300));iconuser.setBackground(new java.awt.Color(255, 255,
255));iconuser.setIcon(newjavax.swing.ImageIcon(getClass().getResource("/gambar/
gambargembok.png.png"))); // NOI18NjLabel1.setFont(new java.awt.Font("Tahoma", 1, 16)); //
NOI18N
jLabel1.setForeground(newjava.awt.Color(255,255,255));jLabel1.setText("Username");txtUserna
me.setFont(newjava.awt.Font("Tahoma",0,16));//
NOI18NtxtUsername.addKeyListener(newjava.awt.event.KeyAdapter()
{publicvoidkeyPressed(java.awt.event.KeyEventevt)
{txtUsernameKeyPressed(evt);}});jLabel2.setFont(newjava.awt.Font("Tahoma",1,16));//
NOI18NjLabel2.setForeground(newjava.awt.Color(255,255,255));jLabel2.setText("Password");bt
nLogin.setFont(newjava.awt.Font("Tahoma",1,14));NOI18NbtnLogin.setText("Login");btnLogin.
setBorder;btnLogin.addActionListener(newjava.awt.event.ActionListener()
{publicvoidactionPerformed(java.awt.event.ActionEventevt)btnLoginActionPerformed(evt);}btnC
ancel.setFont(newjava.awt.Font("Tahoma", 1, 14)); //
NOI18NbtnCancel.setText("Cancel");btnCancel.addActionListener(newjava.awt.event.ActionList
ener(){publicvoidactionPerformed(java.awt.event.ActionEventevt)
{btnCancelActionPerformed(evt);});txtPassword.setFont(new.awt.Font("Tahoma",0,16));//
NOI18NtxtPassword.addKeyListener(newjava.awt.event.KeyAdapter()publicvoidkeyPressed(java.
awt.event.KeyEventevt)
{txtPasswordKeyPressed(evt);}});jLabel3.setFont(newjava.awt.Font("Times New Roman", 1,
18)); //
NOI18NjLabel3.setForeground(newjava.awt.Color(255,255,255));jLabel3.setText("SELAMATD
ATANGDIRVRSTOREKOMPUTER");javax.swing.GroupLayout jPanel1Layout = new
javax.swing.GroupLayout(jPanel1);jPanel1.setLayout(jPanel1Layout);jPanel1Layout.setHorizonta
lGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).add
PreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED,66,Short.MAX_VALU
E).addComponent(iconuser,javax.swing.GroupLayout.PREFERRED_SIZE,87,javax.swing.Group
Layout.PREFERRED_SIZE).addGap(39,39,39))).addGroup(jPanel1Layout.createParallelGroup(ja
vax.swing.GroupLayout.Alignment.BASELINE)addComponent(btnLogin,javax.swing.GroupLay
out.PREFERRED_SIZE,40,javax.swing.GroupLayout.PREFERRED_SIZE).addComponent(btnC
ancel,javax.swing.GroupLayout.PREFERRED_SIZE,40,javax.swing.GroupLayout.PREFERRED
_SIZE)).addContainerGap(32,Short.MAX_VALUE))javax.swing.GroupLayoutlayout=newjavax.s
wing.GroupLayout(getContentPane());getContentPane().setLayout(layout);layout.setHorizontalGr
oup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addComponent(
jPanel1,javax.swing.GroupLayout.PREFERRED_SIZE,494,javax.swing.GroupLayout.PREFERR
ED_SIZE)layout.setVerticalGroup(layout.createParallelGrop(javax.swing.GroupLayout.Alignmen
t.LEADING).addComponent(jPanel1,javax.swing.GroupLayout.PREFERRED_SIZE,364,javax.s
wing.GroupLayout.PREFERRED_SIZE)pack();setLocationRelativeTo;privatevoidtxtPasswordyPr
essed(java.awt.event.KeyEventevt){ if(evt.getKeyCode()==KeyEvent.VK_ENTER)
{btnLoginActionPerformed(newActionEvent(evt.getKeyCode(),evt.getID(),"KeyPressLogin"));}p
rivatevoidbtnCancelActionPerformed(java.awt.event.ActionEvent evt) dispose();}private void
btnLoginActionPerformed(java.awt.event.ActionEvent evt) { try {java.sql.Statement stat =
conn.createStatement();ResultSet result=stat.executeQuery ("select * from tb_user where "+
"username='" +txtUsername.getText()+"'");if (result.next()) {if
(txtPassword.getText().equals(result.getString("password"))){menu_utama mn = new
menu_utama();mn.setExtendedState(JFrame.MAXIMIZED_BOTH);mn.setVisible(true);this.dispo
se();else{JOptionPane.showMessageDialog(rootPane,"PasswordSalah");txtPassword.setText("");t
xtUsername.requestFocus();}} else {JOptionPane.showMessageDialog(rootPane, "User Tidak
Ditemukan");txtUsername.setText("");txtPassword.setText("");txtUsername.requestFocus();}}
catch(Exceptione){JOptionPane.showMessageDialog(rootPane,"Gagal");}}
privatevoidtxtUsernameKeyPressed(java.awt.event.KeyEventevt){ if(evt.getKeyCode()==
KeyEvent.VK_ENTER){txtPassword.requestFocus();}public static void main(String args[]) {/*
Set the Nimbus look and feel *///<editor-fold defaultstate="collapsed" desc=" Look and feel
setting code (optional) ">/* If Nimbus (introduced in Java SE 6) is not
available,staywiththedefaultlookandfeel.Fordetailsseehttp://download.oracle.com/javase/tutorial/
uiswing/lookandfeel/plaf.html try {for (javax.swing.UIManager.LookAndFeelInfo info :
javax.swing.UIManager.getInstalledLookAndFeels())if("Nimbus".equals(info.getName()))
{javax.swing.UIManager.setLookAndFeel(info.getClassName());break;}} catch
(ClassNotFoundException ex)
{java.util.logging.Logger.getLogger(login.class.getName()).log(java.util.logging.Level.SEVERE,e
x);}catch(InstantiationExceptionex)
{java.util.logging.Logger.getLogger(login.class.getName()).log(java.util.logging.Level.SEVERE,e
x);}catch(IllegalAccessExceptionex)
{java.util.logging.Logger.getLogger(login.class.getName()).log(java.util.logging.Level.SEVERE,
ex);}catch(javax.swing.UnsupportedLookAndFeelExceptionex)
{java.util.logging.Logger.getLogger(login.class.getName()).log(java.util.logging.Level.SEVERE,
ex);}//</editor-fold>//</editor-fold>/*Createanddisplaytheform
*/java.awt.EventQueue.invokeLater(newRunnable(){publicvoidrun()
{newlogin().setVisible(true);}});}// Variables declaration - do not modif private
javax.swing.JButton btnCancel;private
javax.swing.JButtonbtnLogin;privatejavax.swing.JLabeliconuser;privatejavax.swing.JLabeljLabel
1;privatejavax.swing.JLabeljLabel2;private javax.swing.JLabel jLabel3;private javax.swing.JPanel
jPanel1;privatejavax.swing.JPasswordFieldtxtPassword;privatejavax.swing.JTextFieldtxtUsernam
e;// End of variables declaration }
Data Barang
packagetampilan;importcom.sun.glass.events.KeyEvent;import java.awt.event.ActionEvent;import
java.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQ
LException;importjava.text.ParseException;importjava.text.SimpleDateFormat;importjava.util.Dat
e;importjava.util.logging.Level;importjava.util.logging.Logger;importjavax.swing.JOptionPane;im
portjavax.swing.table.DefaultTableModel;importjavax.swing.table.TableColumn;importkoneksi.k
oneksi;public class data_barang extends javax.swing.JInternalFrame {public final Connection
conn = new koneksi().connect();private DefaultTableModel tabmode;private DefaultTableModel
tabmode2;privateDefaultTableModeltabmode3;privatevoidaktif()
{txtKodeBarang.setEnabled(true);txtNamaBarang.setEnabled(true);txtSupplier.setEnabled(true);tx
tHargaJual.setEnabled(true);txtHargaBeli.setEnabled(true);txtJumlah.setEnabled(true);}protectedv
oidkosong()
{txtKodeBarang.setText;txtNamaBarang.setText;txtSupplier.setText;txtHargaJual.setText;txtHarg
aBeli.setText;txtJumlah.setText;}public void noTable() {int Baris = tabmode.getRowCount();for
(int a = 0; a < Baris; a++) {String nomor = String.valueOf(a + 1);tabmode.setValueAt(nomor +
".", a, 0);}}public void noTable2() {int Baris = tabmode2.getRowCount();for (int a = 0; a < Baris;
a++) {String nomor = String.valueOf(a + 1);tabmode2.setValueAt(nomor + ".", a, 0);}public void
lebarKolom({TableColumn
column;tabelBarang.setAutoResizeMode(javax.swing.JTable.AUTO_RESIZE_ALL_COLUMNS)
;column = tabelBarang.getColumnModel().getColumn(0);column.setPreferredWidth(40);column =
tabelBarang.getColumnModel().getColumn(1);column.setPreferredWidth(100);column =
tabelBarang.getColumnModel().getColumn(2);column.setPreferredWidth(150);column =
tabelBarang.getColumnModel().getColumn(3);column.setPreferredWidth(120);column =
tabelBarang.getColumnModel().getColumn(4);column.setPreferredWidth(130);column =
tabelBarang.getColumnModel().getColumn(5);column.setPreferredWidth(50);column =
tabelBarang.getColumnModel().getColumn(6);column.setPreferredWidth(150);}public void
dataTable() {Object[] Baris = {"No", "Kode Barang", "Nama Barang", "Harga Beli", "Harga Jual",
"Qty","KodeSupplier"};tabmode=newDefaultTableModel(Baris);tabelBarang.setModel(tabmode);
String sql = "select * from tb_barang order by kode_barang asc";try {java.sql.Statement stat =
conn.createStatement();ResultSet hasil = stat.executeQuery(sql);while (hasil.next()) {String
kode_barang=.getString("kode_barang");Stringnama_barang=
hasil.getString("nama_barang");String harga_beli = hasil.getString("harga_beli");String harga_jual
= hasil.getString("harga_jual");String jumlah_barang = hasil.getString("jumlah_barang");String
supplier = hasil.getString("supplier");String[] data = {"", kode_barang, nama_barang, harga_beli,
harga_jual,jumlah_barang,supplier};tabmode.addRow(data);noTable();lebarKolom();}try
{java.sql.Statement stat = conn.createStatement();ResultSet hasil = stat.executeQuery(sql);while
(hasil.next()) {String kode_barang = hasil.getString("kode_barang");String nama_barang =
hasil.getString("nama_barang");String harga_beli = hasil.getString("harga_beli");String harga_jual
= hasil.getString("harga_jual");String jumlah_barang = hasil.getString("jumlah_barang");String
supplier = hasil.getString("supplier");String[] data = {"", kode_barang, nama_barang, harga_beli,
harga_jual, jumlah_barang, supplier};tabmode.addRow(data);noTable();}public void dataTable2()
{Object[] Baris = {"No", "Kode Supplier", "Nama Supplier"};tabmode2 = new
DefaultTableModel(Baris);tabelSupplier.setModel(tabmode2);String sql = "select * from
tb_supplierorderbykode_supplierasc";try{java.sql.Statementstat=
conn.createStatement();ResultSet hasil=stat.executeQuery(sql);while(hasil.next())
{Stringkode_supplier=hasil.getString("kode_supplier");String nama_supplier =
hasil.getString("nama_supplier");String[] data = {"", kode_supplier,
nama_supplier};tabmode2.addRow(data);noTable2();lebarKolom2();}public void dataTable3()
{Object[] Baris = {"No", "Kode Supplier", "Nama Supplier"};tabmode3 = new
DefaultTableModel(Baris);tabelSupplierUbah.setModel(tabmode3);String sql = "select * from
tb_supplierorderbykode_supplierasc";try{java.sql.Statementstat =
conn.createStatement();ResultSethasil=stat.executeQuery(sql);while(hasil.next())
{Stringkode_supplier=hasil.getString("kode_supplier");Stringnama_supplier=hasil.getString("nam
a_supplier");String[] data = {"", kode_supplier,
nama_supplier};tabmode3.addRow(data);noTable3();}public void lebarKolom3()
{TableColumncolumn3;tabelSupplierUbah.setAutoResizeMode(javax.swing.JTable.AUTO_RESI
ZE_OFF);column3tabelSupplierUbah.getColumnModel().getColumn(0);column3.setPreferredWid
th(40);column3tabelSupplierUbah.getColumnModel().getColumn(1);column3.setPreferredWidth(
150);column3tabelSupplierUbah.getColumnModel().getColumn(2);column3.setPreferredWidth(20
0);}public void pencarian3(String sql) {Object[] Baris = {"No", "Kode Supplier",
"NamaSupplier"};tabmode3=newDefaultTableModel(Baris);tabelSupplierUbah.setModel(tabmod
e3);int brs = tabelSupplierUbah.getRowCount();for (int i = 0; 1 < brs; i++)
{tabmode3.removeRow(1);}publicdata_barang()
{initComponents();lebarKolom();lebarKolom2();lebarKolom3();dataTable();dataTable2();dataTab
le3();aktif();},new String [] {"Title 1", "Title 2",
"Title3"}));tabelSupplier.setRowHeight(20);tabelSupplier.addMouseListener(newjava.awt.event.
MouseAdapter(){publicvoidmouseClicked(java.awt.event.MouseEventevt)
{tabelSupplierMouseClicked(evt);}});jScrollPane4.setViewportView(tabelSupplier);javax.swing.
GroupLayout
jPanel6Layout=newjavax.swing.GroupLayout(jPanel6);jPanel6.setLayout(jPanel6Layout);jPanel6
Layout.setHorizontalGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignm
ent.LEADING).addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
jPanel6Layout.createSequentialGroup().addContainerGap(javax.swing.GroupLayout.DEFAULT_
SIZE,Short.MAX_VALUE).addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLay
out.Alignment.TRAILING).addComponent(jScrollPane4,javax.swing.GroupLayout.PREFERRED
_SIZE,402,javax.swing.GroupLayout.PREFERRED_SIZE).addGroup(jPanel6Layout.createSeque
ntialGroup().addComponent(jLabel15,javax.swing.GroupLayout.PREFERRED_SIZE120,
javax.swing.GroupLayout.PREFERRED_SIZE).addPreferredGap(javax.swing.LayoutStyle.Comp
onentPlacement.RELATED).addComponent(txtCariSupplier,javax.swing.GroupLayout.PREFERR
ED_SIZE,264,javax.swing.GroupLayout.PREFERRED_SIZE))).addGap(84,84,84)));listUbahSup
plier.setTitle("ListDataPemasok");listUbahSupplier.setMinimumSize(newjava.awt.Dimension(450
,460));listUbahSupplier.setModalityType(java.awt.Dialog.ModalityType.DOCUMENT_MODAL)
;listUbahSupplier.setResizable(false);listUbahSupplier.setSize(newjava.awt.Dimension(450,460));
jPanel7.setBackground(newjava.awt.Color(204,255,255));jPanel7.setBorder(javax.swing.BorderF
actory.createEtchedBorder());jPanel7.setMaximumSize(newjava.awt.Dimension(500,300));jPanel
7.setMinimumSize(newjava.awt.Dimension(500,300));jLabel16.setFont(newjava.awt.Font("Taho
ma", 0, 14)); // NOI18NjLabel16.setText("Cari Supplier");txtCariSupplierUbah.setFont(new
java.awt.Font("Tahoma", 0, 14)); // NOI18NtxtCariSupplierUbah.addKeyListener(new
java.awt.event.KeyAdapter(){publicvoidkeyTyped(java.awt.event.KeyEventevt)
{txtCariSupplierUbahKeyTyped(evt);}});tabelSupplierUbah.setFont(new
java.awt.Font("Tahoma", 0, 12)); // NOI18NtabelSupplierUbah.setModel(new
javax.swing.table.DefaultTableModel(new Object [][] { } } } } },new String [] {"Title 1", "Title
2", "Title
3"}));jPanel7Layout.setVerticalGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLay
out.Alignment.LEADING).addGroup(jPanel7Layout.createSequentialGroup().addContainerGap().
addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE).
addComponent(jLabel16,javax.swing.GroupLayout.PREFERRED_SIZE,30,javax.swing.GroupLa
yout.PREFERRED_SIZE).addComponent(txtCariSupplierUbah,javax.swing.GroupLayout.PREFE
RRED_SIZE,30,javax.swing.GroupLayout.PREFERRED_SIZE)).addPreferredGap(javax.swing.L
ayoutStyle.ComponentPlacement.RELATED).addComponent(jScrollPane5,javax.swing.GroupLa
yout.DEFAULT_SIZE,375,Short.MAX_VALUE).addContainerGap()));listUbahSupplierLayout.s
etVerticalGroup(listUbahSupplierLayout.createParallelGroup(javax.swing.GroupLayout.Alignme
nt.LEADING).addGroup(listUbahSupplierLayout.createSequentialGroup().addContainerGap().ad
dComponent(jPanel7,javax.swing.GroupLayout.DEFAULT_SIZE,javax.swing.GroupLayout.DEF
AULT_SIZE,Short.MAX_VALUE).addContainerGap()));setClosable(true);setMaximizable(true);
setResizable(true);jPanel1.setBackground(newjava.awt.Color(255,255,255));jPanel3.setBackgroun
d(newjava.awt.Color(153,153,153));jPanel3.setBorder(javax.swing.BorderFactory.createTitledBor
der("DataBarang",javax.swing.border.TitledBorder.CENTER,javax.swing.border.TitledBorder.TO
P, new java.awt.Font("Tahoma", 0, 14), new java.awt.Color(51, 51, 255))); //
NOI18NjPanel3.setCursor(newjava.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));jLabel3.s
etFont(newjava.awt.Font("Tahoma",0,14));//
NOI18NjLabel3.setText("KodeBarang");txtKodeBarang.setFont(new java.awt.Font("Tahoma", 0,
14)); // NOI18NtxtKodeBarang.addKeyListener(new java.awt.event.KeyAdapter() {public void
keyPressed(java.awt.event.KeyEvent evt)
{txtKodeBarangKeyPressed(evt);}});tabelBarang.setRowHeight(30);tabelBarang.addMouseListen
er(new java.awt.event.MouseAdapter() {public void mouseClicked(java.awt.event.MouseEvent
evt) {tabelBarangMouseClicked(evt);}});jLabel6.setFont(new java.awt.Font("Tahoma", 0, 14)); //
NOI18NjLabel6.setText("Pencarian");btnRefreshBarang.setBackground(new java.awt.Color(204,
255,255));btnRefreshBarang.setForeground(newjava.awt.Color(204,255,255));btnRefreshBarang.s
etIcon(newjavax.swing.ImageIcon(getClass().getResource("/gambar/icons8_refresh_16px.png")));
//NOI18NbtnRefreshBarang.setCursor(newjava.awt.Cursor(java.awt.Cursor.HAND_CURSOR));b
tnRefreshBarang.addActionListener(newjava.awt.event.ActionListener(){publicvoid
actionPerformed(java.awt.event.ActionEvent evt) {btnRefreshBarangActionPerformed(evt);}});
privatevoidbtnTambahActionPerformed(java.awt.event.ActionEventevt)
{ (txtKodeBarang.getText().equals("")) {JOptionPane.showMessageDialog("Kode Barang tidak
bolehkosong");}elseif(txtNamaBarang.getText().equals(""))
{JOptionPane.showMessageDialog("Nama Barang tidak boleh kosong");} else if
(txtHargaBeli.getText().equals("")) {JOptionPane.showMessageDialog("Harga Beli tidak boleh
kosong");} else if (txtHargaJual.getText().equals("")) {JOptionPane.showMessageDialog("Harga
Jual tidak boleh kosong");} else if (txtJumlah.getText().equals(""))
{JOptionPane.showMessageDialog("Jumlah tidak boleh kosong atau diisi 0");} else if
(txtSupplier.getText().equals("")) {JOptionPane.showMessageDialog("Supplier tidak boleh
kosong");} else {String sql = "insert into
tb_barangvalues(?,?,?,?,?,?)";try{PreparedStatementstat=conn.prepareStatement(sql);stat.setString
(1,txtKodeBarang.getText());stat.setString(2,txtNamaBarang.getText());stat.setString(3,txtHargaB
eli.getText());stat.setString(4,txtHargaJual.getText());stat.setString(5,txtJumlah.getText());stat.setS
tring(6,txtSupplier.getText());stat.executeUpdate();JOptionPane.showMessageDialog("DataBerhas
ilDisimpan");kosong();dataTable();lebarKolom();txtKodeBarang.requestFocus();}catch(SQLExce
ptione)
{JOptionPane.showMessageDialog("DataGagalDisimpan"+e);privatevoidbtnBersihActionPerform
ed(java.awt.event.ActionEventevt)
{kosong();}privatevoidbtnHapusActionPerformed(java.awt.event.ActionEvent evt) { int ok =
JOptionPane.showConfirmDialog(" Apakah Anda Yakin Ingin "+ "Menghapus Data",
"Konfirmasi Dialog", JOptionPane.YES_NO_OPTION);if (ok == 0) {String sql = "delete from
tb_barang where kode_barang='" + txtKodeBarang.getText() + "'";try
{PreparedStatementstat=conn.prepareStatement(sql);stat.executeUpdate();JOptionPane.showMess
ageDialog("DataBerhasilDihapus");kosong();dataTable();lebarKolom();txtKodeBarang.requestFoc
us();}catch \(SQLException e) {JOptionPane.showMessageDialog("Data Gagal Dihapus" + e);}}}
privatevoidbtnSimpanUbahActionPerformed(java.awt.event.ActionEventevt){ String sql =
"update
tb_barangsetkode_barang=?,nama_barang=?,harga_beli=?,harga_jual=?,jumlah_barang=?,supplier
=? where kode_barang='" + txtKodeBarangUbah.getText() + "'";try {PreparedStatement stat =
conn.prepareStatement(sql);stat.setString(1,txtKodeBarangUbah.getText());stat.setString(2,
txtNamaBarangUbah.getText());stat.setString(3,txtHargaBeliUbah.getText());stat.setString(4,
txtHargaJualUbah.getText());stat.setString(5,txtJumlahUbah.getText());stat.setString(6,
txtSupplierUbah.getText());stat.executeUpdate();JOptionPane.showMessageDialog("Date Berhasil
Diubah");//Stringrefresh="select*fromtb_barang";kosong();dataTable();lebarKolom();txtKodeBara
ng.requestFocus();ubahBarang.dispose();}catch(SQLExceptione)
{JOptionPane.showMessageDialog("DataGagalDiubah"+e);}}privatevoidbtnCancelUbahActionPe
rformed(java.awt.event.ActionEventevt){ubahBarang.setVisible(false);}privatevoid
btnUbahActionPerformed(java.awt.event.ActionEventevt)
{ ubahBarang.setLocationRelativeTo(this);txtKodeBarangUbah.setEditable(false);txtNamaBarang
Ubah.requestFocus();ubahBarang.setVisible(true);}privatevoid
btnCariActionPerformed(java.awt.event.ActionEvent evt) { String sqlPencarian = "select * from
tb_barang where nama_barang like '%" + txtCari.getText() + "%' or "+ "nama_barang like '%" +
txtCari.getText() + "%' or "+ "harga_jual like '%" + txtCari.getText() + "%' or "+ "supplier like
'%" + txtCari.getText() + "%'";pencarian(sqlPencarian);lebarKolom();} private void
tabelBarangMouseClicked(java.awt.event.MouseEvent evt) { int bar =
tabelBarang.getSelectedRow();String a = tabmode.getValueAt(bar, 0).toString();String b =
tabmode.getValueAt(bar, 1).toString();String c = tabmode.getValueAt(bar, 2).toString();String d =
tabmode.getValueAt(bar, 3).toString();String e = tabmode.getValueAt(bar, 4).toString();String f =
tabmode.getValueAt(bar,5).toString();Stringg=tabmode.getValueAt(bar,
6).toString();txtKodeBarang.setText(b);txtKodeBarangUbah.setText(b);txtNamaBarang.setText(c)
;txtNamaBarangUbah.setText(c);txtHargaBeli.setText(d);txtHargaBeliUbah.setText(d);txtHargaJu
al.setText(e);txtHargaJualUbah.setText(e);txtJumlah.setText(f);txtJumlahUbah.setText(f);txtSuppl
ier.setText(g);txtSupplierUbah.setText(g);}privatevoid
txtCariActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code
here:} // Variables declaration - do not modify private javax.swing.JButton btnBersih;private
javax.swing.JButtonbtnCancel;privatejavax.swing.JButtonbtnCancelUbah;private
javax.swing.JButtonbtnCari;privatejavax.swing.JButtonbtnCariSupplier;private
javax.swing.JButtonbtnCariSupplierUbah;privatejavax.swing.JButtonbtnHapus;private
javax.swing.JButtonbtnRefreshBarang;privatejavax.swing.JButtonbtnSimpanUbah;private
javax.swing.JButton btnTambah;private javax.swing.JButton btnUbah;private javax.swing.JLabel
jLabel1;private javax.swing.JLabel jLabel10;private javax.swing.JLabel jLabel12;private
javax.swing.JLabel jLabel14;private javax.swing.JLabel jLabel15;private javax.swing.JLabel
jLabel16;private javax.swing.JLabel jLabel17;private javax.swing.JLabel jLabel18;private
javax.swing.JLabel jLabel2;private javax.swing.JLabel jLabel20;private javax.swing.JLabel
jLabel21;private javax.swing.JLabel jLabel3;private javax.swing.JLabel jLabel4;private
javax.swing.JLabel jLabel5;private javax.swing.JLabel jLabel6;private javax.swing.JLabel
jLabel8;private javax.swing.JLabel jLabel9;private javax.swing.JPanel jPanel1;private
javax.swing.JPanel jPanel3;private javax.swing.JPanel jPanel4;private javax.swing.JPanel
jPanel5;privatejavax.swing.JPaneljPanel6;privatejavax.swing.JPaneljPanel7;private
javax.swing.JScrollPanejScrollPane2;privatejavax.swing.JScrollPanejScrollPane4;private
javax.swing.JScrollPanejScrollPane5;privatejavax.swing.JDialoglistSupplier;private
javax.swing.JDialoglistUbahSupplier;privatejavax.swing.JTabletabelBarang;private
javax.swing.JTabletabelSupplier;privatejavax.swing.JTabletabelSupplierUbah;private
javax.swing.JTextFieldtxtCari;privatejavax.swing.JTextFieldtxtCariSupplier;private
javax.swing.JTextFieldtxtCariSupplierUbah;privatejavax.swing.JTextFieldtxtHargaBeli;private
javax.swing.JTextFieldtxtHargaBeliUbah;privatejavax.swing.JTextFieldtxtHargaJual;private
javax.swing.JTextFieldtxtHargaJualUbah;privatejavax.swing.JTextFieldtxtJumlah;private
javax.swing.JTextFieldtxtJumlahUbah;privatejavax.swing.JTextFieldtxtKodeBarang;private
javax.swing.JTextFieldtxtKodeBarangUbah;privatejavax.swing.JTextField
txtNamaBarang;privatejavax.swing.JTextFieldtxtNamaBarangUbah;private
javax.swing.JTextFieldtxtSupplier;privatejavax.swing.JTextFieldtxtSupplierUbah;private
javax.swing.JDialog ubahBarang;// End of variables declaration }

Data Customer
package tampilan;import com.sun.glass.events.KeyEvent;import java.sql.Connection;import
java.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;import
java.text.ParseException;importjava.text.SimpleDateFormat;importjava.util.Date;import
java.util.logging.Level;import java.util.logging.Logger;import javax.swing.JOptionPane;import
javax.swing.table.DefaultTableModel;importjavax.swing.table.TableColumn;import
koneksi.koneksi;public class data_customer extends javax.swing.JInternalFrame { public final
Connection conn = new koneksi().connect(); private DefaultTableModel tabmode; private void
aktif(){txtKodeCustomer.setEnabled(true);txtNamaCustomer.setEnabled(true);
txtNoTelepon.setEnabled(true);txtEmailCustomer.setEnabled(true);
txtAlamatCustomer.setEnabled(true); }public void noTable() { int Baris =
tabmode.getRowCount(); for (int a = 0; a < Baris; a++) { String nomor = String.valueOf(a + 1);
tabmode.setValueAt(nomor + ".", a, 0); } } public void lebarKolom() { TableColumn column;
tabelCustomer.setAutoResizeMode(javax.swing.JTable.AUTO_RESIZE_ALL_COLUMNS);
column = tabelCustomer.getColumnModel().getColumn(0); column.setPreferredWidth(40);
column = tabelCustomer.getColumnModel().getColumn(1); column.setPreferredWidth(120);
column = tabelCustomer.getColumnModel().getColumn(2); column.setPreferredWidth(150);
column = tabelCustomer.getColumnModel().getColumn(3); column.setPreferredWidth(100);
column = tabelCustomer.getColumnModel().getColumn(4); column.setPreferredWidth(150);
column = tabelCustomer.getColumnModel().getColumn(5); column.setPreferredWidth(200); }
public void dataTable() { Object[] Baris = {"No", "Kode Customer", "Nama Customer", "No
Telepon","Email","Alamat"};tabmode=newDefaultTableModel(Baris);
tabelCustomer.setModel(tabmode); String sql = "select * from tb_customer order by
kode_customer asc";try { java.sql.Statement stat = conn.createStatement(); ResultSet hasil =
stat.executeQuery(sql); while(hasil.next())
{Stringkode_customer=hasil.getString("kode_customer");String nama_customer =
hasil.getString("nama_customer"); String no_telepon = hasil.getString("no_telepon"); String
email_customer = hasil.getString("email_customer"); String alamat_customer =
hasil.getString("alamat_customer"); String[] data = {"", kode_customer, nama_customer,
no_telepon, email_customer, alamat_customer}; tabmode.addRow(data); noTable();
lebarKolom(); } } catch (Exception e) { } } public void pencarian(String sql) { Object[] Baris =
{"No", "Kode Customer", "Nama Customer", "No Telepon", "Email", "Alamat"}; tabmode = new
DefaultTableModel(Baris);tabelCustomer.setModel(tabmode);intbrs=tabelCustomer.getRowCount
(); for (int i = 0; 1 < brs; i++) { tabmode.removeRow(1); } try { java.sql.Statement stat =
conn.createStatement(); ResultSet hasil = stat.executeQuery(sql); while (hasil.next()) { String
kode_customer=hasil.getString("kode_customer");Stringnama_customer=hasil.getString("nama_c
ustomer"); String no_telepon = hasil.getString("no_telepon"); String email_customer =
hasil.getString("email_customer"); String alamat_customer = hasil.getString("alamat_customer");
String[] data = {"", kode_customer, nama_customer, no_telepon, email_customer,
alamat_customer}; tabmode.addRow(data); noTable(); } } catch (Exception e) { } } public
data_customer() { initComponents(); lebarKolom(); dataTable(); aktif(); } /** * 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() { ubahCustomer = new javax.swing.JDialog(); jPanel5 =
new javax.swing.JPanel(); jLabel8 = new javax.swing.JLabel(); txtNamaCustomerUbah = new
javax.swing.JTextField(); jLabel9 = new javax.swing.JLabel(); txtNoTeleponUbah = new
javax.swing.JTextField(); jLabel10 = new javax.swing.JLabel(); jScrollPane3 = new
javax.swing.JScrollPane(); txtAlamatCustomerUbah = new javax.swing.JTextArea();
btnSimpanUbah = new javax.swing.JButton(); btnCancelUbah = new javax.swing.JButton();
jLabel11 = new javax.swing.JLabel(); jLabel13 = new javax.swing.JLabel();
txtEmailCustomerUbah = new javax.swing.JTextField(); txtKodeCustomerUbah = new
javax.swing.JTextField(); jPanel1 = new javax.swing.JPanel(); jPanel3 = new
javax.swing.JPanel(); jLabel3 = new javax.swing.JLabel(); txtNamaCustomer = new
javax.swing.JTextField(); jLabel4 = new javax.swing.JLabel(); txtNoTelepon = new
javax.swing.JTextField(); jLabel5 = new javax.swing.JLabel(); btnTambah = new
javax.swing.JButton(); btnUbah = new javax.swing.JButton(); btnHapus = new
javax.swing.JButton(); btnBersih = new javax.swing.JButton(); btnCancel = new
javax.swing.JButton(); jLabel7 = new javax.swing.JLabel(); jLabel12 = new javax.swing.JLabel();
txtEmailCustomer = new javax.swing.JTextField(); txtKodeCustomer = new
javax.swing.JTextField(); jScrollPane4 = new javax.swing.JScrollPane(); txtAlamatCustomer =
new javax.swing.JTextArea(); jPanel4 = new javax.swing.JPanel(); txtCari = new
javax.swing.JTextField(); jScrollPane2 = new javax.swing.JScrollPane(); tabelCustomer = new
javax.swing.JTable(); btnCari = new javax.swing.JButton(); jLabel6 = new javax.swing.JLabel();
jLabel1 = new javax.swing.JLabel(); ubahCustomer.setTitle("Ubah Data Customer");
ubahCustomer.setMinimumSize(new
java.awt.Dimension(450,450));ubahCustomer.setModalityType(java.awt.Dialog.ModalityType.D
OCUMENT_MODAL);ubahCustomer.setResizable(false);ubahCustomer.setSize(new
java.awt.Dimension(450,450));jPanel5.setBackground(newjava.awt.Color(255,255,255));jPanel5.s
etBorder(javax.swing.BorderFactory.createTitledBorder("UbahDataCustomer",javax.swing.border
.TitledBorder.LEFT,javax.swing.border.TitledBorder.TOP,new java.awt.Font("Tahoma", 0, 14),
newjava.awt.Color(255,0,0)));//NOI18NjPanel5.setMaximumSize(newjava.awt.Dimension(500,30
0));jPanel5.setMinimumSize(new java.awt.Dimension(500, 300)); jLabel8.setFont(new
java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel8.setText("Nama Customer");
txtNamaCustomerUbah.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
txtNamaCustomerUbah.addKeyListener(new java.awt.event.KeyAdapter() { public void
keyPressed(java.awt.event.KeyEvent evt) { txtNamaCustomerUbahKeyPressed(evt); } });
jLabel9.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel9.setText("No Telepon");
txtNoTeleponUbah.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
txtNoTeleponUbah.addKeyListener(new java.awt.event.KeyAdapter() { public void
keyPressed(java.awt.event.KeyEvent evt) { txtNoTeleponUbahKeyPressed(evt); } });
jLabel10.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel10.setText("Alamat
Customer"); txtAlamatCustomerUbah.setColumns(20); txtAlamatCustomerUbah.setFont(new
java.awt.Font("Tahoma", 0, 14)); // NOI18N txtAlamatCustomerUbah.setRows(5);
jScrollPane3.setViewportView(txtAlamatCustomerUbah);btnSimpanUbah.setFont(newjava.awt.F
ont("Tahoma",0,12));//
NOI18NbtnSimpanUbah.setIcon(newjavax.swing.ImageIcon(getClass().getResource("/gambar/
icons8_edit_16px.png")));//
NOI18NbtnSimpanUbah.setText("Simpan");btnSimpanUbah.setCursor(newjava.awt.Cursor(java.a
wt.Cursor.HAND_CURSOR));btnSimpanUbah.setMargin(newjava.awt.Insets(0,0,0,0));btnSimpan
Ubah.addActionListener(newjava.awt.event.ActionListener()
{publicvoidactionPerformed(java.awt.event.ActionEventevt)
{btnSimpanUbahActionPerformed(evt); } }); btnCancelUbah.setFont(new
java.awt.Font("Tahoma", 0, 12)); // NOI18N
btnCancelUbah.setIcon(newjavax.swing.ImageIcon(getClass().getResource("/gambar/
icons8_delete_sign_16px.png"))); //
NOI18NbtnCancelUbah.setText("Cancel");btnCancelUbah.setCursor(new
java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));btnCancelUbah.setMargin(new
java.awt.Insets(0, 0, 0, 0)); btnCancelUbah.addActionListener(new
java.awt.event.ActionListener() {publicvoidactionPerformed(java.awt.event.ActionEventevt)
{btnCancelUbahActionPerformed(evt); } }); jLabel11.setFont(new java.awt.Font("Tahoma", 0,
14)); // NOI18N jLabel11.setText("Kode
Customer");jLabel13.setFont(newjava.awt.Font("Tahoma",0,14));//NOI18NjLabel13.setText("Em
ailCustomer");txtEmailCustomerUbah.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
txtEmailCustomerUbah.addKeyListener(new java.awt.event.KeyAdapter() { public void
keyPressed(java.awt.event.KeyEvent evt) { txtEmailCustomerUbahKeyPressed(evt); } });
txtKodeCustomerUbah.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
txtKodeCustomerUbah.addKeyListener(new java.awt.event.KeyAdapter() { public void
keyPressed(java.awt.event.KeyEvent evt) { txtKodeCustomerUbahKeyPressed(evt); } });
setClosable(true); setMaximizable(true); setResizable(true); jPanel1.setBackground(new
java.awt.Color(255, 255, 255)); jPanel3.setBackground(new java.awt.Color(153, 153, 153));
jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder("DataCustomer",javax.swing.bo
rder.TitledBorder.CENTER,javax.swing.border.TitledBorder.TOP,new java.awt.Font("Tahoma",
0, 14), new java.awt.Color(51, 51, 255))); // NOI18N jLabel3.setFont(new
java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel3.setText("Nama Customer");
txtNamaCustomer.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
txtNamaCustomer.addKeyListener(new java.awt.event.KeyAdapter() { public void
keyPressed(java.awt.event.KeyEvent evt) { txtNamaCustomerKeyPressed(evt); } });
jLabel5.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel5.setText("Alamat");
btnTambah.setBackground(new java.awt.Color(0, 51, 255)); btnTambah.setFont(new
java.awt.Font("Tahoma", 0, 12)); // NOI18N btnTambah.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/gambar/icons8_plus_math_16px.png"))); //
NOI18NbtnTambah.setText("Tambah");btnTambah.setCursor(newjava.awt.Cursor(java.awt.Curso
r.HAND_CURSOR));btnTambah.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT
); btnTambah.setMargin(new java.awt.Insets(0, 0, 0, 0)); btnTambah.setMaximumSize(new
java.awt.Dimension(100, 40)); btnTambah.setMinimumSize(new java.awt.Dimension(100, 40));
btnTambah.addActionListener(new java.awt.event.ActionListener() { public void
actionPerformed(java.awt.event.ActionEvent evt) { btnTambahActionPerformed(evt); } });
btnHapus.setBackground(newjava.awt.Color(0,51,255));btnHapus.setFont(newjava.awt.Font("Tah
oma",0,12));//NOI18NbtnHapus.setIcon(newjavax.swing.ImageIcon(getClass().getResource("/
gambar/icons8_delete_2_16px.png")));//
NOI18NbtnHapus.setText("Hapus");btnHapus.setCursor(newjava.awt.Cursor(java.awt.Cursor.HA
ND_CURSOR));btnHapus.setMargin(new java.awt.Insets(0, 0, 0, 0));
btnHapus.addActionListener(new java.awt.event.ActionListener() { public void
actionPerformed(java.awt.event.ActionEvent evt) { btnHapusActionPerformed(evt); } });
btnBersih.setBackground(newjava.awt.Color(0,51,255))btnBersih.setFont(newjava.awt.Font("Tah
oma",0,12));//NOI18NbtnBersih.setIcon(newjavax.swing.ImageIcon(getClass().getResource("/
gambar/icons8_erase_16px.png")));//
NOI18NbtnBersih.setText("Bersih");btnBersih.setCursor(newjava.awt.Cursor(java.awt.Cursor.HA
ND_CURSOR)); btnBersih.setMargin(new java.awt.Insets(0, 0, 0, 0));
btnBersih.addActionListener(new java.awt.event.ActionListener() { public void
actionPerformed(java.awt.event.ActionEvent evt) { btnBersihActionPerformed(evt); } });
btnCancel.setBackground(new java.awt.Color(0, 51, 255)); btnCancel.setFont(new
java.awt.Font("Tahoma",0,12));//NOI18NbtnCancel.setIcon(newjavax.swing.ImageIcon(getClass(
).getResource("/gambar/icons8_delete_sign_16px.png")));//
NOI18NbtnCancel.setText("Cancel");btnCancel.setCursor(newjava.awt.Cursor(java.awt.Cursor.H
AND_CURSOR));btnCancel.setMargin(newjava.awt.Insets(0,0,0,0));btnCancel.addActionListene
r(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent
evt) { btnCancelActionPerformed(evt); } }); jLabel7.setFont(new java.awt.Font("Tahoma", 0,
14)); // NOI18N jLabel7.setText("Kode
Customer");jLabel12.setFont(newjava.awt.Font("Tahoma",0,14));//NOI18NjLabel12.setText("Em
ail");txtEmailCustomer.setFont(newjava.awt.Font("Tahoma", 0, 14)); // NOI18N
txtEmailCustomer.addKeyListener(newjava.awt.event.KeyAdapter()
{publicvoidkeyPressed(java.awt.event.KeyEventevt){txtEmailCustomerKeyPressed(evt);}});
txtKodeCustomer.setFont(newjava.awt.Font("Tahoma",0,14));//NOI18NtxtKodeCustomer.addKey
Listener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt)
{ txtKodeCustomerKeyPressed(evt); } }); jPanel4.setBackground(new java.awt.Color(255, 255,
255)); jPanel4.setBorder(javax.swing.BorderFactory.createTitledBorder("Tabel Data Customer",
javax.swing.border.TitledBorder.CENTER,javax.swing.border.TitledBorder.TOP,new
java.awt.Font("Tahoma", 0, 14), new java.awt.Color(0, 0, 255))); //
NOI18NtxtCari.setBackground(new java.awt.Color(204, 204, 204)); txtCari.setFont(new
java.awt.Font("Tahoma", 0, 14)); // NOI18N txtCari.addKeyListener(new
java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt)
{ txtCariKeyTyped(evt); } }); tabelCustomer.setFont(new java.awt.Font("Tahoma", 0, 12)); //
NOI18N tabelCustomer.setModel(new javax.swing.table.DefaultTableModel( new Object [][]
{ } } } } } } } } } } }, new String [] { "Title 1", "Title 2", "Title 3", "Title 4", "Title 5", "Title
6" } ));
tabelCustomer.setRowHeight(30);tabelCustomer.addMouseListener(newjava.awt.event.MouseAd
apter(){publicvoidmouseClicked(java.awt.event.MouseEventevt)
{tabelCustomerMouseClicked(evt); } }); jScrollPane2.setViewportView(tabelCustomer);
btnCari.setBackground(new
java.awt.Color(204,255,255));btnCari.setIcon(newjavax.swing.ImageIcon(getClass().getResource(
"/gambar/icons8_Search_30px.png")));//
NOI18NbtnCari.setCursor(newjava.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
btnCari.addActionListener(new java.awt.event.ActionListener() { public void
actionPerformed(java.awt.event.ActionEvent evt) { btnCariActionPerformed(evt); } }); private
void txtNoTeleponKeyPressed(java.awt.event.KeyEvent evt) { if (evt.getKeyCode() ==
KeyEvent.VK_ENTER)
{txtEmailCustomer.requestFocus();}}privatevoidbtnTambahActionPerformed(java.awt.event.Acti
onEventevt){if(txtKodeCustomer.getText().equals(""))
{JOptionPane.showMessageDialog("KodeCustomertidakbolehkosong");}elseif(txtNamaCustomer.
getText().equals("")) { JOptionPane.showMessageDialog("Nama Customer tidak boleh
kosong"); } else if (txtNoTelepon.getText().equals("")) { JOptionPane.showMessageDialog("No
Telepon tidak boleh kosong"); } else { String sql = "insert into tb_customer values (?,?,?,?,?)"; try
{ PreparedStatement stat = conn.prepareStatement(sql); stat.setString(1,
txtKodeCustomer.getText()); stat.setString(2,
txtNamaCustomer.getText());stat.setString(3,txtNoTelepon.getText());stat.setString(4,
txtEmailCustomer.getText());stat.setString(5, txtAlamatCustomer.getText()); stat.executeUpdate();
JOptionPane.showMessageDialog("Data Berhasil Disimpan"); // String refresh = "select * from
tb_customer"; kosong(); dataTable(); lebarKolom(); txtNamaCustomer.requestFocus(); } catch
(SQLException e) { JOptionPane.showMessageDialog(Data Gagal Disimpan" + e); } } } private
void btnBersihActionPerformed(java.awt.event.ActionEvent evt) { kosong(); } private void
btnHapusActionPerformed(java.awt.event.ActionEvent evt) { int ok =
JOptionPane.showConfirmDialog(" Apakah Anda Yakin Ingin " + "Menghapus Data",
"Konfirmasi Dialog", JOptionPane.YES_NO_OPTION); if (ok == 0) { String sql = "delete from
tb_customer where kode_customer='" + txtKodeCustomer.getText() + "'"; try { PreparedStatement
stat = conn.prepareStatement(sql); stat.executeUpdate(); JOptionPane.showMessageDialog("Data
Berhasil Dihapus"); kosong(); dataTable(); lebarKolom(); txtKodeCustomer.requestFocus(); }
catch (SQLException e) { JOptionPane.showMessageDialog("Data Gagal Dihapus" + e); } } }
private void btnSimpanUbahActionPerformed(java.awt.event.ActionEvent evt) { String sql =
"update
tb_customersetkode_customer=?,nama_customer=?,no_telepon=?,email_customer=?,alamat_custo
mer=? where kode_customer='" + txtKodeCustomer.getText() + "'"; try { PreparedStatement stat =
conn.prepareStatement(sql); stat.setString(1, txtKodeCustomerUbah.getText()); stat.setString(2,
txtNamaCustomerUbah.getText()); stat.setString(3, txtNoTeleponUbah.getText());
stat.setString(4, txtEmailCustomerUbah.getText()); stat.setString(5,
txtAlamatCustomerUbah.getText()); stat.executeUpdate();
JOptionPane.showMessageDialog("Data Berhasil Diubah"); // String refresh = "select * from
tb_customer"; kosong(); dataTable(); lebarKolom(); txtKodeCustomer.requestFocus();
ubahCustomer.dispose(); } catch (SQLException e) { JOptionPane.showMessageDialog("Data
Gagal Diubah" + e); } } private void
btnCancelUbahActionPerformed(java.awt.event.ActionEventevt)ubahCustomer.setVisible(false);}
privatevoidbtnUbahActionPerformed(java.awt.event.ActionEventevt)
{ubahCustomer.setLocationRelativeTo(this);txtKodeCustomerUbah.setEditable(false);ubahCusto
mer.setVisible(true);} private void txtCariKeyTyped(java.awt.event.KeyEvent evt) { String
sqlPencarian = "select * from tb_customer where kode_customer like '%" + txtCari.getText() +
"%' or " + "nama_customer like '%" + txtCari.getText() + "%' or " + "no_telepon like '%" +
txtCari.getText() + "%'";
pencarian(sqlPencarian);lebarKolom();}privatevoidbtnCariActionPerformed(java.awt.event.Actio
nEvent evt) { String sqlPencarian = "select * from tb_customer where kode_customer like '%" +
txtCari.getText() + "%' or " + "nama_customer like '%" + txtCari.getText() + "%' or " +
"no_telepon like '%" + txtCari.getText() + "%'"; pencarian(sqlPencarian); lebarKolom(); } private
void tabelCustomerMouseClicked(java.awt.event.MouseEvent evt) { int bar =
tabelCustomer.getSelectedRow(); String a = tabmode.getValueAt(bar, 0).toString(); String b =
tabmode.getValueAt(bar, 1).toString(); String c = tabmode.getValueAt(bar, 2).toString(); String d
= tabmode.getValueAt(bar, 3).toString(); String e = tabmode.getValueAt(bar, 4).toString(); String
f
=tabmode.getValueAt(bar,5).toString();txtKodeCustomer.setText(b);txtKodeCustomerUbah.setTe
xt(b);txtNamaCustomer.setText(c); txtNamaCustomerUbah.setText(c); txtNoTelepon.setText(d);
txtNoTeleponUbah.setText(d); txtEmailCustomer.setText(e); txtEmailCustomerUbah.setText(e);
txtAlamatCustomer.setText(f);txtAlamatCustomerUbah.setText(f);}privatevoidbtnCancelActionP
erformed(java.awt.event.ActionEventevt)
{dispose();}privatevoidtxtEmailCustomerKeyPressed(java.awt.event.KeyEventevt)
{if(evt.getKeyCode()==KeyEvent.VK_ENTER)
{txtAlamatCustomer.requestFocus();}}privatevoid
txtEmailCustomerUbahKeyPressed(java.awt.event.KeyEvent evt) { if (evt.getKeyCode() ==
KeyEvent.VK_ENTER) { txtAlamatCustomerUbah.requestFocus(); } } private void
txtKodeCustomerKeyPressed(java.awt.event.KeyEvent evt) { if (evt.getKeyCode() ==
KeyEvent.VK_ENTER)
{txtNamaCustomer.requestFocus();}}privatevoidtxtKodeCustomerUbahKeyPressed(java.awt.even
t.KeyEvent evt) { if (evt.getKeyCode() == KeyEvent.VK_ENTER)
{ txtNamaCustomerUbah.requestFocus(); } } // Variables declaration - do not modify private
javax.swing.JButton btnBersih; private javax.swing.JButton btnCancel; private
javax.swing.JButton btnCancelUbah; private javax.swing.JButton btnCari; private
javax.swing.JButton btnHapus; private javax.swing.JButton btnSimpanUbah; private
javax.swing.JButton btnTambah; private javax.swing.JButton btnUbah; private javax.swing.JLabel
jLabel1; private javax.swing.JLabel jLabel10; private javax.swing.JLabel jLabel11; private
javax.swing.JLabel jLabel12; private javax.swing.JLabel jLabel13; 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.JLabel jLabel9; private javax.swing.JPanel jPanel1; private
javax.swing.JPanel jPanel3; private javax.swing.JPanel jPanel4; private javax.swing.JPanel
jPanel5; private javax.swing.JScrollPane jScrollPane2; private javax.swing.JScrollPane
jScrollPane3; private javax.swing.JScrollPane jScrollPane4; private javax.swing.JTable
tabelCustomer; private javax.swing.JTextArea txtAlamatCustomer; private javax.swing.JTextArea
txtAlamatCustomerUbah; private javax.swing.JTextField txtCari; private javax.swing.JTextField
txtEmailCustomer; private javax.swing.JTextField txtEmailCustomerUbah; private
javax.swing.JTextField txtKodeCustomer; private javax.swing.JTextField txtKodeCustomerUbah;
private javax.swing.JTextField txtNamaCustomer; private javax.swing.JTextField
txtNamaCustomerUbah; private javax.swing.JTextField txtNoTelepon; private
javax.swing.JTextField txtNoTeleponUbah; private javax.swing.JDialog ubahCustomer; // End of
variables declaration }

Data Suplier
packagetampilan;importcom.sun.glass.events.KeyEvent;importjava.sql.Connection;importjava.sql.
PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.text.ParseE
xception;importjava.text.SimpleDateFormat;importjava.util.Date;importjava.util.logging.Level;im
portjava.util.logging.Logger;importjavax.swing.JOptionPane;importjavax.swing.table.DefaultTabl
eModel;import javax.swing.table.TableColumn;import koneksi.koneksi;public class data_supplier
extends javax.swing.JInternalFrame { public final Connection conn = new koneksi().connect();
private DefaultTableModel tabmode; private void aktif() { txtKodeSupplier.setEnabled(true);
txtNamaSupplier.setEnabled(true);txtNoTelepon.setEnabled(true);txtEmailSupplier.setEnabled(tru
e); txtAlamatSupplier.setEnabled(true); } protected void kosong() { txtKodeSupplier.setText;
txtNamaSupplier.setText;txtNoTelepon.setText;txtEmailSupplier.setText;txtAlamatSupplier.setTe
xt; } public void noTable() { int Baris = tabmode.getRowCount(); for (int a = 0; a < Baris; a++)
{ String nomor = String.valueOf(a + 1); tabmode.setValueAt(nomor + ".", a, 0); } } public void
lebarKolom()
{TableColumncolumn;tabelSupplier.setAutoResizeMode(javax.swing.JTable.AUTO_RESIZE_A
LL_COLUMNS); column = tabelSupplier.getColumnModel().getColumn(0);
column.setPreferredWidth(40); column = tabelSupplier.getColumnModel().getColumn(1);
column.setPreferredWidth(120); column = tabelSupplier.getColumnModel().getColumn(2);
column.setPreferredWidth(150); column = tabelSupplier.getColumnModel().getColumn(3);
column.setPreferredWidth(100); column = tabelSupplier.getColumnModel().getColumn(4);
column.setPreferredWidth(150); column = tabelSupplier.getColumnModel().getColumn(5);
column.setPreferredWidth(200); } public void dataTable() { Object[] Baris = {"No", "Kode
Supplier", "Nama Supplier", "No Telepon", "Email", "Alamat"}; tabmode = new
DefaultTableModel(Baris); tabelSupplier.setModel(tabmode); String sql = "select * from
tb_supplier order by kode_supplier asc"; try { java.sql.Statement stat = conn.createStatement();
ResultSet hasil = stat.executeQuery(sql); while (hasil.next()) { String kode_supplier =
hasil.getString("kode_supplier"); String nama_supplier = hasil.getString("nama_supplier"); String
no_telepon=hasil.getString("no_telepon");Stringemail_supplier=
hasil.getString("email_supplier"); String alamat_supplier = hasil.getString("alamat_supplier");
String[] data = {"", kode_supplier, nama_supplier, no_telepon, email_supplier, alamat_supplier};
tabmode.addRow(data); noTable(); lebarKolom(); } } catch (Exception e) { } } public void
pencarian(String sql) { Object[] Baris = {"No", "Kode Supplier", "Nama Supplier", "No Telepon",
"Email", "Alamat"}; tabmode = new
DefaultTableModel(Baris);tabelSupplier.setModel(tabmode);intbrs=tabelSupplier.getRowCount();
for (int i = 0; 1 < brs; i++) { tabmode.removeRow(1); } try { java.sql.Statement stat =
conn.createStatement(); ResultSet hasil = stat.executeQuery(sql); while (hasil.next()) { String
kode_supplier = hasil.getString("kode_supplier"); String nama_supplier =
hasil.getString("nama_supplier"); String no_telepon = hasil.getString("no_telepon"); String
email_supplier = hasil.getString("email_supplier"); String alamat_supplier =
hasil.getString("alamat_supplier"); String[] data = {"", kode_supplier, nama_supplier, no_telepon,
email_supplier, alamat_supplier}; tabmode.addRow(data); noTable(); } } catch (Exception e) { } }
public data_supplier() { initComponents(); lebarKolom(); dataTable(); aktif(); } /** * 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() { ubahSupplier = new javax.swing.JDialog(); jPanel5 =
new javax.swing.JPanel(); jLabel8 = new javax.swing.JLabel(); txtNamaSupplierUbah = new
javax.swing.JTextField(); jLabel9 = new javax.swing.JLabel(); txtNoTeleponUbah = new
javax.swing.JTextField(); jLabel10 = new javax.swing.JLabel(); jScrollPane3 = new
javax.swing.JScrollPane(); txtAlamatSupplierUbah = new javax.swing.JTextArea();
btnSimpanUbah = new javax.swing.JButton(); btnCancelUbah = new javax.swing.JButton();
jLabel11 = new javax.swing.JLabel(); jLabel13 = new javax.swing.JLabel();
txtEmailSupplierUbah = new javax.swing.JTextField(); txtKodeSupplierUbah = new
javax.swing.JTextField(); jPanel1 = new javax.swing.JPanel(); jPanel3 = new
javax.swing.JPanel(); jLabel3 = new javax.swing.JLabel(); txtNamaSupplier = new
javax.swing.JTextField(); jLabel4 = new javax.swing.JLabel(); txtNoTelepon = new
javax.swing.JTextField(); jLabel5 = new javax.swing.JLabel(); btnTambah = new
javax.swing.JButton(); btnUbah = new javax.swing.JButton(); btnHapus = new
javax.swing.JButton(); btnBersih = new javax.swing.JButton(); btnCancel = new
javax.swing.JButton(); jLabel7 = new javax.swing.JLabel(); jLabel12 = new javax.swing.JLabel();
txtEmailSupplier = new javax.swing.JTextField(); txtKodeSupplier = new
javax.swing.JTextField(); jScrollPane4 = new javax.swing.JScrollPane(); txtAlamatSupplier =
new javax.swing.JTextArea(); jPanel4 = new javax.swing.JPanel(); txtCari = new
javax.swing.JTextField(); jScrollPane2 = new javax.swing.JScrollPane(); tabelSupplier = new
javax.swing.JTable(); btnCari = new javax.swing.JButton(); jLabel6 = new javax.swing.JLabel();
jLabel1 = new javax.swing.JLabel();
ubahSupplier.setTitle("UbahDataSupplier");ubahSupplier.setMinimumSize(newjava.awt.Dimensi
on(450, 450)); }); jLabel9.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
jLabel9.setText("No Telepon"); txtNoTeleponUbah.setFont(new java.awt.Font("Tahoma", 0, 14));
// NOI18N txtNoTeleponUbah.addKeyListener(new java.awt.event.KeyAdapter() { public void
keyPressed(java.awt.event.KeyEvent evt) { txtNoTeleponUbahKeyPressed(evt); } });
jLabel10.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel10.setText("Alamat");
txtAlamatSupplierUbah.setColumns(20);txtAlamatSupplierUbah.setFont(newjava.awt.Font("Taho
ma",0,14));//
NOI18NtxtAlamatSupplierUbah.setRows(5);jScrollPane3.setViewportView(txtAlamatSupplierUb
ah);btnSimpanUbah.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
btnSimpanUbah.setIcon(newjavax.swing.ImageIcon(getClass().getResource("/gambar/
icons8_edit_16px.png"))); // NOI18N btnSimpanUbah.setText("Simpan");
btnSimpanUbah.setMargin(new java.awt.Insets(0,0, 0, 0));
btnSimpanUbah.addActionListener(new java.awt.event.ActionListener() { public void
actionPerformed(java.awt.event.ActionEvent evt) { jLabel11.setFont(new
java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel11.setText("Kode Supplier");
jLabel13.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel13.setText("Email");
txtEmailSupplierUbah.setFont(newjava.awt.Font("Tahoma",0,14));//NOI18NtxtEmailSupplierUba
h.addKeyListener(newjava.awt.event.KeyAdapter()
{publicvoidkeyPressed(java.awt.event.KeyEvent evt)
{ txtEmailSupplierUbahKeyPressed(evt); } }); txtKodeSupplierUbah.setFont(new
java.awt.Font("Tahoma", 0, 14)); // NOI18N txtKodeSupplierUbah.addKeyListener(new
java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt)
{ txtKodeSupplierUbahKeyPressed(evt);}});ubahSupplierLayout.setVerticalGroup(ubahSupplierL
ayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(ubahSuppl
ierLayout.createSequentialGroup().addContainerGap().addComponent(jPanel5,javax.swing.Group
Layout.DEFAULT_SIZE,javax.swing.GroupLayout.DEFAULT_SIZE,Short.MAX_VALUE) .add
ContainerGap()))setClosable(true);setMaximizable(true);setResizable(true);jPanel1.setBackground
(new java.awt.Color(255, 255, 255)); jPanel3.setBackground(new
java.awt.Color(153,153,153));jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder("
DataSupplier", javax.swing.border.TitledBorder.CENTER,javax.swing.border.TitledBorder.TOP,
new java.awt.Font("Tahoma", 0, 14), new java.awt.Color(51, 51, 255))); // NOI18N
jLabel3.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel3.setText("Nama
Supplier"); txtNamaSupplier.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
txtNamaSupplier.addKeyListener(new java.awt.event.KeyAdapter() { public void
keyPressed(java.awt.event.KeyEvent evt) { txtNamaSupplierKeyPressed(evt); } });
jLabel4.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N btnTambah.setText("Tambah");
btnTambah.setCursor(newjava.awt.Cursor(java.awt.Cursor.HAND_CURSOR));btnTambah.setHo
rizontalTextPosition(javax.swing.SwingConstants.RIGHT);btnTambah.setMargin(newjava.awt.Ins
ets(0, 0, 0, 0)); btnTambah.setMaximumSize(new java.awt.Dimension(100, 40));
btnTambah.setMinimumSize(newjava.awt.Dimension(100,40));btnTambah.addActionListener(ne
w java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt)
{ btnTambahActionPerformed(evt); } }); btnUbah.setBackground(new java.awt.Color(0, 0, 255));
btnUbah.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N btnUbah.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/gambar/icons8_edit_16px.png"))); // NOI18N
btnUbah.setText("Ubah");btnUbah.setCursor(newjava.awt.Cursor(java.awt.Cursor.HAND_CURS
OR)); btnUbah.setMargin(new java.awt.Insets(0, 0, 0, 0)); btnUbah.addActionListener(new
java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt)
{ btnUbahActionPerformed(evt); } }); btnHapus.setBackground(new java.awt.Color(0, 0, 255));
btnHapus.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N btnHapus.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/gambar/icons8_delete_2_16px.png"))); //
NOI18NbtnHapus.setText("Hapus");btnHapus.setCursor(newjava.awt.Cursor(java.awt.Cursor.HA
ND_CURSOR));btnHapus.setMargin(newjava.awt.Insets(0,0,0,0));btnHapus.addActionListener(n
ew java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent
evt) { btnHapusActionPerformed(evt); } }); btnBersih.setBackground(new java.awt.Color(0, 0,
255));
btnBersih.setFont(newjava.awt.Font("Tahoma",0,12));//NOI18N});btnCancel.setBackground(newj
ava.awt.Color(0, 0, 255)); btnCancel.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
btnCancel.setIcon(newjavax.swing.ImageIcon(getClass().getResource("/gambar/
icons8_delete_sign_16px.png"))); // NOI18N btnCancel.setText("Cancel");
btnCancel.setCursor(new java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
btnCancel.setMargin(new java.awt.Insets(0, 0, 0, 0)); btnCancel.addActionListener(new
java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt)
{ btnCancelActionPerformed(evt); } }); jLabel7.setFont(new java.awt.Font("Tahoma", 0, 14)); //
NOI18N jLabel7.setText("Kode Supplier"); jLabel12.setFont(new java.awt.Font("Tahoma", 0,
14)); // NOI18N jLabel12.setText("Email"); txtEmailSupplier.setFont(new
java.awt.Font("Tahoma", 0, 14)); // NOI18N txtEmailSupplier.addKeyListener(new
java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt)
{ txtEmailSupplierKeyPressed(evt); } }); tabelSupplier.setFont(newjava.awt.Font("Tahoma", 0,
12)); // NOI18N tabelSupplier.setModel(new javax.swing.table.DefaultTableModel( new String []
{ "Title 1", "Title 2", "Title 3", "Title 4", "Title 5", "Title 6" } ));
jScrollPane2.setViewportView(tabelSupplier); btnCari.setBackground(new
java.awt.Color(204,255,255));btnCari.setIcon(newjavax.swing.ImageIcon(getClass().getResource(
"/gambar/icons8_Search_30px.png")));//
NOI18NbtnCari.setCursor(newjava.awt.Cursor(java.awt.Cursor.HAND_CURSOR));btnCari.addA
ctionListener(new java.awt.event.ActionListener() { jLabel6.setFont(new
java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel6.setText("Pencarian");
javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
jPanel4.setLayout(jPanel4Layout);addGroup(jPanel4Layout.createParallelGroup(javax.swing.Gro
upLayout.Alignment.LEADING).addComponent(jScrollPane2,javax.swing.GroupLayout.DEFAU
LT_SIZE,513,Short.MAX_VALUE).addGroup(jPanel4Layout.createSequentialGroup().addGap(0
,0,Short.MAX_VALUE).addComponent(jLabel6, javax.swing.GroupLayout.PREFERRED_SIZE,
68,javax.swing.GroupLayout.PREFERRED_SIZE).addPreferredGap(javax.swing.LayoutStyle.Co
mponentPlacement.RELATED).addComponent(txtCari,javax.swing.GroupLayout.PREFERRED_
SIZE,187,javax.swing.GroupLayout.PREFERRED_SIZE).addGap(0,0,0) .addComponent(btnCari,
javax.swing.GroupLayout.PREFERRED_SIZE,35,javax.swing.GroupLayout.PREFERRED_SIZE
))).addContainerGap())layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADIN
G).addComponent(jPanel1,javax.swing.GroupLayout.DEFAULT_SIZE,javax.swing.GroupLayout
.DEFAULT_SIZE,Short.MAX_VALUE));privatevoidtxtNoTeleponKeyPressed(java.awt.event.Ke
yEvent evt) { if (evt.getKeyCode() == KeyEvent.VK_ENTER) { txtEmailSupplier.requestFocus();
} } private void btnTambahActionPerformed(java.awt.event.ActionEvent evt) { if
(txtKodeSupplier.getText().equals("")) { JOptionPane.showMessageDialog("Kode Supplier tidak
bolehkosong");}elsif(txtNamaSupplier.getText().equals(""))
{ JOptionPane.showMessageDialog("Nama Supplier tidak boleh kosong"); } else if
(txtNoTelepon.getText().equals("")) { JOptionPane.showMessageDialog("No Telepon tidak boleh
kosong"); } else { String sql = "insert into tb_supplier values (?,?,?,?,?)"; try { PreparedStatement
stat = conn.prepareStatement(sql); stat.setString(1, txtKodeSupplier.getText()); stat.setString(2,
txtNamaSupplier.getText()); stat.setString(3, txtNoTelepon.getText()); stat.setString(4,
txtEmailSupplier.getText()); stat.setString(5, txtAlamatSupplier.getText()); stat.executeUpdate();
JOptionPane.showMessageDialog("DataBerhasiDisimpan");privatevoidbtnBersihActionPerformed
(java.awt.event.ActionEventevt)
{kosong();privatvoidtxtNamaSupplierUbahKeyPressed(java.awt.event.KeyEvent evt) { if
(evt.getKeyCode() == KeyEvent.VK_ENTER) { txtNoTeleponUbah.requestFocus(); } } private
void btnSimpanUbahActionPerformed(java.awt.event.ActionEvent evt) { String sql = "update
tb_supplier set
kode_supplier=?,nama_supplier=?,no_telepon=?,email_supplier=?,alamat_supplier=? where
kode_supplier='" + txtKodeSupplier.getText() + "'"; try { PreparedStatement stat =
conn.prepareStatement(sql); stat.setString(1, txtKodeSupplierUbah.getText()); stat.setString(2,
txtNamaSupplierUbah.getText()); stat.setString(3, txtNoTeleponUbah.getText()); stat.setString(4,
txtEmailSupplierUbah.getText()); stat.setString(5, txtAlamatSupplierUbah.getText());
stat.executeUpdate(); JOptionPane.showMessageDialog("Data Berhasil Diubah"); // String refresh
= "select * from tb_supplier"; kosong(); dataTable(); lebarKolom();
txtKodeSupplier.requestFocus(); ubahSupplier.dispose(); } catch (SQLException e)
{ JOptionPane.showMessageDialog("Data Gagal Diubah" + e); } } private void
txtCariKeyTyped(java.awt.event.KeyEvent evt) { String sqlPencarian = "select * from tb_supplier
where kode_supplier like '%" + txtCari.getText() + "%' or " + "nama_supplier like '%" +
txtCari.getText() + "%' or " + "no_telepon like '%" + txtCari.getText() + "%'";
pencarian(sqlPencarian); lebarKolom(); } private void
tabelSupplierMouseClicked(java.awt.event.MouseEvent evt) { int bar =
tabelSupplier.getSelectedRow(); String a = tabmode.getValueAt(bar, 0).toString(); String b =
tabmode.getValueAt(bar, 1).toString(); String c = tabmode.getValueAt(bar, 2).toString(); String d
= tabmode.getValueAt(bar, 3).toString(); String e = tabmode.getValueAt(bar, 4).toString(); String
f = tabmode.getValueAt(bar, 5).toString(); txtKodeSupplier.setText(b);
txtKodeSupplierUbah.setText(b); txtNamaSupplier.setText(c); txtNamaSupplierUbah.setText(c);
txtNoTelepon.setText(d); txtNoTeleponUbah.setText(d); txtEmailSupplier.setText(e);
txtEmailSupplierUbah.setText(e); txtAlamatSupplier.setText(f);
txtAlamatSupplierUbah.setText(f); } // Variables declaration - do not modify private
javax.swing.JButton btnBersih; private javax.swing.JButton btnCancel; private
javax.swing.JButton btnCancelUbah; private javax.swing.JButton btnCari; private
javax.swing.JButton btnHapus; private javax.swing.JButton btnSimpanUbah; private
javax.swing.JButton btnTambah; private javax.swing.JButton btnUbah; private javax.swing.JLabel
jLabel1; private javax.swing.JLabel jLabel10; private javax.swing.JLabel jLabel11; private
javax.swing.JLabel jLabel12; private javax.swing.JLabel jLabel13; 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.JLabel jLabel9; private javax.swing.JPanel jPanel1; private
javax.swing.JPanel jPanel3; private javax.swing.JPanel jPanel4; private javax.swing.JPanel
jPanel5; private javax.swing.JScrollPane jScrollPane2; private javax.swing.JScrollPane
jScrollPane3; private javax.swing.JScrollPane jScrollPane4; private javax.swing.JTable
tabelSupplier; private javax.swing.JTextArea txtAlamatSupplier; private javax.swing.JTextArea
txtAlamatSupplierUbah; private javax.swing.JTextField txtCari; private javax.swing.JTextField
txtEmailSupplier; private javax.swing.JTextField txtEmailSupplierUbah; private
javax.swing.JTextField txtKodeSupplier; private javax.swing.JTextField txtKodeSupplierUbah;
private javax.swing.JTextField txtNamaSupplier; private javax.swing.JTextField
txtNamaSupplierUbah; private javax.swing.JTextField txtNoTelepon; private
javax.swing.JTextField txtNoTeleponUbah; private javax.swing.JDialog ubahSupplier; // End of
variables declaration }

Data User
package tampilan;import com.sun.glass.events.KeyEvent;import java.sql.Connection;import
java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import
java.text.ParseException;import java.text.SimpleDateFormat;import java.util.Date;import
java.util.logging.Level;import java.util.logging.Logger;import javax.swing.JOptionPane;import
javax.swing.table.DefaultTableModel;import javax.swing.table.TableColumn;import
koneksi.koneksi;public class data_user extends javax.swing.JInternalFrame { public final
Connection conn = new koneksi().connect() private DefaultTableModel tabmode; private void
aktif() { txtUsername.setEnabled(true); txtPassword.setEnabled(true); txtLevel.setEnabled(true); }
protected void kosong() { txtUsername.setText; txtPassword.setText; txtLevel.setText; } public
void noTable() { int Baris = tabmode.getRowCount(); for (int a = 0; a < Baris; a++) { String
nomor = String.valueOf(a + 1); tabmode.setValueAt(nomor + ".", a, 0); } } public void
lebarKolom() { TableColumn column;
tabelUser.setAutoResizeMode(javax.swing.JTable.AUTO_RESIZE_ALL_COLUMNS); column =
tabelUser.getColumnModel().getColumn(0); column.setPreferredWidth(20); column =
tabelUser.getColumnModel().getColumn(1); column.setPreferredWidth(150); column =
tabelUser.getColumnModel().getColumn(2); column.setPreferredWidth(150); column =
tabelUser.getColumnModel().getColumn(3); column.setPreferredWidth(150); } public void
dataTable() { Object[] Baris = {"No", "Username", "Password", "Level"}; tabmode = new
DefaultTableModel(Baris); tabelUser.setModel(tabmode); String sql = "select * from tb_user
order by username asc"; try { java.sql.Statement stat = conn.createStatement(); ResultSet hasil =
stat.executeQuery(sql); while (hasil.next()) { String username = hasil.getString("username");
String password = hasil.getString("password"); String level = hasil.getString("level"); String[] data
= {"", username, password, level}; tabmode.addRow(data); noTable(); lebarKolom(); } } catch
(Exception e) { } } public void pencarian(String sql) { Object[] Baris = {"No", "Username",
"Password", "Level"}; tabmode = new DefaultTableModel (Baris); tabelUser.setModel(tabmode);
int brs = tabelUser.getRowCount(); for (int i = 0; 1 < brs; i++) { tabmode.removeRow(1); } try
{ java.sql.Statement stat = conn.createStatement(); ResultSet hasil = stat.executeQuery(sql); while
(hasil.next()) { String username = hasil.getString("username"); String password =
hasil.getString("password"); String level = hasil.getString("level"); String[] data = {"", username,
password, level}; tabmode.addRow(data); noTable(); jLabel9.setFont(new
java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel9.setText("Level"); txtLevelUbah.setFont(new
java.awt.Font("Tahoma", 0, 14)); // NOI18N txtLevelUbah.addKeyListener(new
java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt)
{ txtLevelUbahKeyPressed(evt); javax.swing.GroupLayout ubahUserLayout = new
javax.swing.GroupLayout(ubahUser.getContentPane());
ubahUser.getContentPane().setLayout(ubahUserLayout);
ubahUserLayout.setHorizontalGroup( ubahUserLayout.createParallelGroup(javax.swing.GroupLa
yout.Alignment.LEADING) .addGroup(ubahUserLayout.createSequentialGroup() .addContainerG
ap() .addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, 430,
Short.MAX_VALUE) .addContainerGap()) );
ubahUserLayout.setVerticalGroup( txtPassword.addKeyListener(new
java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt)
{ txtPasswordKeyPressed(evt); } }); jLabel4.setFont(new java.awt.Font("Tahoma", 0, 14)); //
NOI18N jLabel4.setText("Level"); txtLevel.setFont(new java.awt.Font("Tahoma", 0, 14)); //
NOI18N txtLevel.addKeyListener(new java.awt.event.KeyAdapter() { public void
keyPressed(java.awt.event.KeyEvent evt) { txtLevelKeyPressed(evt); } });
btnTambah.setBackground(new java.awt.Color(0, 0, 255)); btnTambah.setFont(new
java.awt.Font("Tahoma", 0, 12)); // NOI18N btnTambah.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/gambar/icons8_plus_math_16px.png"))); //
NOI18N btnTambah.setText("Tambah"); btnTambah.setCursor(new
java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
btnTambah.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);
btnHapus.setCursor(new java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
btnHapus.setMargin(new java.awt.Insets(0, 0, 0, 0)); btnHapus.addActionListener(new
java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt)
{ btnHapusActionPerformed(evt); } }); btnBersih.setBackground(new java.awt.Color(0, 0, 255));
btnBersih.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N btnBersih.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/gambar/icons8_erase_16px.png"))); // NOI18N
btnBersih.setText("Bersih");btnBersih.setCursor(new
java.awt.Cursor(java.awt.Cursor.HAND_CURSOR)); btnBersih.setMargin(new java.awt.Insets(0,
0, 0, 0)); btnBersih.addActionListener(new java.awt.event.ActionListener() { public void
actionPerformed(java.awt.event.ActionEvent evt) { btnBersihActionPerformed(evt); } });
btnCancel.setBackground(new java.awt.Color(0, 0, 255)); btnCancel.setFont(new
java.awt.Font("Tahoma",0,12));//NOI18NbtnCancel.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/gambar/icons8_delete_sign_16px.png"))); //
NOI18NbtnCancel.setText("Cancel");btnCancel.setCursor(new
java.awt.Cursor(java.awt.Cursor.HAND_CURSOR)); btnCancel.setMargin(new java.awt.Insets(0,
0, 0, 0)); btnCancel.addActionListener(new java.awt.event.ActionListener() { public void
actionPerformed(java.awt.event.ActionEvent evt) { jScrollPane2.setViewportView(tabelUser);
btnCari.setBackground(newjava.awt.Color(204,255,255));btnCari.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/gambar/icons8_Search_30px.png"))); // NOI18N
btnCari.setCursor(newjava.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
btnCari.addActionListener(newjava.awt.event.ActionListener(){publicvoid
actionPerformed(java.awt.event.ActionEvent evt) { btnCariActionPerformed(evt); } });
jPanel4Layout.setVerticalGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Al
ignment.LEADING).addGroup(jPanel4Layout.createSequentialGroup()
jLabel1.setBackground(new java.awt.Color(153, 153, 153)); jLabel1.setFont(new
java.awt.Font("Tahoma", 0, 18)); // NOI18N jLabel1.setForeground(new java.awt.Color(255, 255,
255));jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel1.setText("Pengolahan Data User"); jLabel1.setOpaque(true); 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() .a
ddComponent(jPanel3javax.swing.GroupLayout.PREFERRED_SIZE,javax.swing.GroupLayout.D
EFAULT_SIZE,javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.L
ayoutStyle.ComponentPlacement.RELATED) .addComponent(jPanel4,javax.swing.GroupLayout.
DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE,Short.MAX_VALUE).addContainerGap()) .addCom
ponent(jLabel1,javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) ); setBounds(100, 0, 1000,
600); }// </editor-fold> private void txtPasswordKeyPressed(java.awt.event.KeyEvent evt) { if
(evt.getKeyCode() == KeyEvent.VK_ENTER) { txtLevel.requestFocus(); } } private void
txtLevelKeyPressed(java.awt.event.KeyEventevt){}privatevoid
btnTambahActionPerformed(java.awt.event.ActionEventevt){if
(txtUsername.getText().equals("")) { JOptionPane.showMessageDialog("Username tidak boleh
kosong");}elseif (txtPassword.getText().equals(""))
{ JOptionPane.showMessageDialog("Password
tidakbolehkosong");}elseif(txtLevel.getText().equals("")
{JOptionPane.showMessageDialog("Level tidak boleh kosong"); } else { String sql = "insert into
tb_user (username,password,level) values (?,?,?)"; try { PreparedStatement stat =
conn.prepareStatement(sql); stat.setString(1,
txtUsername.getText());stat.setString(2,txtPassword.getText());stat.setString(3,
txtLevel.getText()); stat.executeUpdate(); JOptionPane.showMessageDialog("Data Berhasil
Disimpan"); kosong(); dataTable(); lebarKolom(); txtPassword.requestFocus(); } catch
(SQLException e) { JOptionPane.showMessageDialog("Data Gagal Disimpan" + e); } } } private
void btnHapusActionPerformed(java.awt.event.ActionEvent evt) { int ok =
JOptionPane.showConfirmDialog(" Apakah Anda Yakin Ingin " + "Menghapus Data",
"Konfirmasi Dialog", JOptionPane.YES_NO_OPTION); if (ok == 0) { String sql = "delete from
tb_user where username='" + txtUsername.getText() + "'"; try { PreparedStatement stat =
conn.prepareStatement(sql); stat.executeUpdate(); JOptionPane.showMessageDialog("Data
Berhasil Dihapus"); kosong(); dataTable(); lebarKolom(); txtUsername.requestFocus(); } catch
(SQLException e) { JOptionPane.showMessageDialog("Data Gagal Dihapus" + e); } } } private
void txtPasswordUbahKeyPressed(java.awt.event.KeyEvent evt) { if (evt.getKeyCode() ==
KeyEvent.VK_ENTER)
{txtLevelUbah.requestFocus();}}privatevoidtxtLevelUbahKeyPressed(java.awt.event.KeyEventev
t){}privatevoidbtnSimpanUbahActionPerformed(java.awt.event.ActionEvent evt) { String sql =
"update tb_user set username=?,password=?,level=? where username='" + txtUsername.getText()
+ "'"; try { PreparedStatement stat=conn.prepareStatement(sql); stat.setString(1,
txtUsernameUbah.getText()); stat.setString(2,txtPasswordUbah.getText());
stat.setString(3,txtLevelUbah.getText());stat.executeUpdate();
JOptionPane.showMessageDialog("DataBerhasilDiubah");privatvoid
btnCariActionPerformed(java.awt.event.ActionEvent evt) { String sqlPencarian = "select * from
tb_user where username like '%" + txtCari.getText() + "%' or " + "password like '%" +
txtCari.getText() + "%' or " + "level like '%" + txtCari.getText() + "%'"; pencarian(sqlPencarian);
lebarKolom(); } private void tabelUserMouseClicked(java.awt.event.MouseEvent evt) { int bar =
tabelUser.getSelectedRow(); String a = tabmode.getValueAt(bar, 0).toString(); String b =
tabmode.getValueAt(bar, 1).toString(); String c = tabmode.getValueAt(bar, 2).toString(); String d
= tabmode.getValueAt(bar, 3).toString(); txtUsername.setText(b); txtUsernameUbah.setText(b);
txtPassword.setText(c);txtPasswordUbah.setText(c); txtLevel.setText(d);
txtLevelUbah.setText(d); } private void btnCancelActionPerformed(java.awt.event.ActionEvent
evt) { dispose(); } private
voidtxtUsernameKeyPressed(java.awt.event.KeyEventevt)if(evt.getKeyCode()==
KeyEvent.VK_ENTER){txtPassword.requestFocus();}}privatevoid
txtUsernameUbahKeyPressed(java.awt.event.KeyEvent evt) { if (evt.getKeyCode() ==
KeyEvent.VK_ENTER) { txtPasswordUbah.requestFocus(); } } // Variables declaration - do not
modify private javax.swing.JButton btnBersih; private javax.swing.JButton btnCancel; private
javax.swing.JButtonbtnCancelUbah;privatejavax.swing.JButtonbtnCari;privatejavax.swing.JButto
nbtnHapus;privatejavax.swing.JButtobtnSimpanUbah;private javax.swing.JButton btnTambah;
private javax.swing.JButton btnUbah; private javax.swing.JLabel jLabel1; private
javax.swing.JLabel jLabel11; private javax.swing.JLabel jLabel3; private javax.swing.JLabel
jLabel4; private javax.swing.JLabel jLabel6; private javax.swing.JLabel jLabel7; private
javax.swing.JLabel jLabel8; private javax.swing.JLabel jLabel9; private javax.swing.JPanel
jPanel1; private javax.swing.JPanel jPanel3; private javax.swing.JPanel jPanel4; private
javax.swing.JPaneljPanel5;privatejavax.swing.JScrollPanejScrollPane2;privatejavax.swing.JTablet
abelUser;privatjavax.swing.JTextFieldtxtCari;privatejavax.swing.JTextFieldtxtLevel;privatejavax.
swing.JTextFieldtxtLevelUbahprivatejavax.swing.JTextFieldtxtPassword;privatejavax.swing.JTex
tFieldtxtPasswordUbahprivate javax.swing.JTextFieldtxtUsername; private
javax.swing.JTextField txtUsernameUbah; private javax.swing.JDialog ubahUser; // End of
variables declaration }

Laporan Data Customer

package tampilan;import java.io.File;import java.sql.Connection;import java.sql.ResultSet;import
java.text.SimpleDateFormat;importjava.util.Date;importjava.util.HashMap;import
java.util.Map;importjavax.swing.JOptionPane;import
javax.swing.table.DefaultTableModel;import
koneksi.koneksi;importnet.sf.jasperreports.engine.JasperCompileManager;import
net.sf.jasperreports.engine.JasperFillManager;import net.sf.jasperreports.engine.JasperPrint;import
net.sf.jasperreports.engine.JasperReport;import
net.sf.jasperreports.engine.design.JasperDesign;import
net.sf.jasperreports.engine.xml.JRXmlLoader;import net.sf.jasperreports.view.JasperViewer;/** *
* @author SUSENO-PC */public class laporan_data_customer extends
javax.swing.JInternalFrame { public final Connection conn = new koneksi().connect(); private
DefaultTableModel tabmode; JasperReport JasRep; JasperPrint JasPri; Map param = new
HashMap(2); JasperDesign JasDes; public void tampil_combo1(){ try { Connection con = new
koneksi().connect(); java.sql.Statement stat = con.createStatement(); String sql = "select
kode_customer from tb_customer order by kode_customer asc"; ResultSet res =
stat.executeQuery(sql); cbCustomer1.addItem(" -- Pilih Dari Customer --"); while(res.next())
{ cbCustomer1.addItem(res.getString("kode_customer")); } } catch (Exception e)
{ System.out.println(e.getMessage()); } } public void tampil_combo2(){ try { Connection con =
new koneksi().connect(); java.sql.Statement stat = con.createStatement(); String sql = "select
kode_customer from tb_customer order by kode_customer asc"; ResultSet res =
stat.executeQuery(sql); cbCustomer2.addItem(" -- Sampai Customer --"); while(res.next())
{ cbCustomer2.addItem(res.getString("kode_customer")); } } catch (Exception e)
{ System.out.println(e.getMessage()); } } public laporan_data_customer() { initComponents();
tampil_combo1(); tampil_combo2(); } /** * 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();
cetak = new javax.swing.JButton(); cbCustomer1 = new javax.swing.JComboBox<>();
cbCustomer2 = new javax.swing.JComboBox<>(); setClosable(true); setTitle("Laporan Data
Customer"); setToolTipText(""); jLabel1.setFont(new java.awt.Font("Tahoma", 3, 14)); //
NOI18N jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
jLabel1.setText("Customer"); jLabel2.setFont(new java.awt.Font("Tahoma", 3, 14)); // NOI18N
jLabel2.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
jLabel2.setText("Customer"); jLabel3.setBackground(new java.awt.Color(153, 153, 153));
jLabel3.setFont(new java.awt.Font("Tahoma", 3, 18)); // NOI18N
jLabel3.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel3.setText("Laporan Data Customer"); cetak.setFont(new java.awt.Font("Tahoma", 0, 14)); //
NOI18Ncetak.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/gambar/icons8_print_16px_1.png"))); //
NOI18N cetak.setText("Cetak"); cetak.addActionListener(new java.awt.event.ActionListener()
{ public void actionPerformed(java.awt.event.ActionEvent evt) { cetakActionPerformed(evt); } });
// Variables declaration - do not modify private javax.swing.JComboBox<String> cbCustomer1;
private javax.swing.JComboBox<String> cbCustomer2; private javax.swing.JButton cetak; private
javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel
jLabel3; // End of variables declaration }

Laporan Data Suplier

package tampilan;import java.io.File;import java.sql.Connection;import java.sql.ResultSet;import
java.text.SimpleDateFormat;importjava.util.Date;importjava.util.HashMap;import
java.util.Map;importjavax.swing.JOptionPane;import
javax.swing.table.DefaultTableModel;import
koneksi.koneksi;importnet.sf.jasperreports.engine.JasperCompileManager;import
net.sf.jasperreports.engine.JasperFillManager;import net.sf.jasperreports.engine.JasperPrint;import
net.sf.jasperreports.engine.JasperReport;import
net.sf.jasperreports.engine.design.JasperDesign;import
net.sf.jasperreports.engine.xml.JRXmlLoader;import net.sf.jasperreports.view.JasperViewer;/** *
* @author SUSENO-PC */public class laporan_data_supplier extends javax.swing.JInternalFrame
{ public final Connection conn = new koneksi().connect(); private DefaultTableModel tabmode;
JasperReport JasRep; JasperPrint JasPri; Map param = new HashMap(2); JasperDesign JasDes;
public void tampil_combo1(){ try { Connection con = new koneksi().connect(); java.sql.Statement
stat = con.createStatement(); String sql = "select kode_supplier from tb_supplier"; ResultSet res =
stat.executeQuery(sql); cbSupplier1.addItem(" -- Pilih Dari Supplier --"); while(res.next())
{ cbSupplier1.addItem(res.getString("kode_supplier")); } } catch (Exception e)
{ System.out.println(e.getMessage()); } } public void tampil_combo2(){ try { Connection con =
new koneksi().connect(); java.sql.Statement stat = con.createStatement(); String sql = "select
kode_supplier from tb_supplier"; ResultSet res = stat.executeQuery(sql); cbSupplier2.addItem(" --
Sampai Supplier --"); while(res.next()){ cbSupplier2.addItem(res.getString("kode_supplier")); } }
catch (Exception e) { System.out.println(e.getMessage()); } } public laporan_data_supplier()
{ initComponents(); tampil_combo1(); tampil_combo2(); } /** * 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(); cetak = new javax.swing.JButton();
cbSupplier1 = new javax.swing.JComboBox<>(); cbSupplier2 = new
javax.swing.JComboBox<>(); setClosable(true);
setTitle("LaporanDataSupplier");setToolTipText("");privatevoidcetakActionPerformed(java.awt.e
vent.ActionEvent evt) { try { Connection konn = new koneksi().connect(); File file = new
File("src/laporan/laporanDataSupplier.jrxml");Stringstatus1=
(String)cbSupplier1.getSelectedItem(); String status2 = (String)cbSupplier2.getSelectedItem();
JasDes = JRXmlLoader.load(file); param.put("supplier1",status1); param.put("supplier2",status2);
param.put("realPath","src/gambar"); JasRep = JasperCompileManager.compileReport(JasDes);
JasPri = JasperFillManager.fillReport(JasRep, param, konn); //JasperViewer.viewReport(JasPri,
false);JasperViewerjasperViewer=newJasperViewer(JasPri,false);
jasperViewer.setExtendedState(jasperViewer.getExtendedState()|
javax.swing.JFrame.MAXIMIZED_BOTH);jasperViewer.setVisible(true);}catch(Exceptione)
{ JOptionPane.showMessageDialog("GagalmembukaLaporan","Cetaklaporan",
JOptionPane.ERROR_MESSAGE);}}privatevoidcbSupplier1ActionPerformed(java.awt.event.Act
ionEvent evt) { // TODO add your handling code here: } // Variables declaration - do not modify
private javax.swing.JComboBox<String> cbSupplier1; private javax.swing.JComboBox<String>
cbSupplier2; private javax.swing.JButton cetak; private javax.swing.JLabel jLabel1; private
javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; // End of variables declaration }

Laporan Pembelian
package tampilan;import java.io.File;import java.sql.Connection;import java.sql.ResultSet;import
java.text.SimpleDateFormat;importjava.util.Date;importjava.util.HashMap;importjava.util.Map;im
portjavax.swing.JOptionPane;importjavax.swing.table.DefaultTableModel;importkoneksi.koneksi;
importnet.sf.jasperreports.engine.JasperCompileManager;importnet.sf.jasperreports.engine.Jasper
FillManager;importnet.sf.jasperreports.engine.JasperPrint;importnet.sf.jasperreports.engine.Jasper
Report;importnet.sf.jasperreports.engine.design.JasperDesign;importnet.sf.jasperreports.engine.xm
l.JRXmlLoader;import net.sf.jasperreports.view.JasperViewer;/*/public class laporan_pembelian
extends javax.swing.JInternalFrame { public final Connection conn = new koneksi().connect();
private DefaultTableModel tabmode; JasperReport JasRep; JasperPrint JasPri; Map param = new
HashMap(2); JasperDesign JasDes; public void tampil_combo1(){ try { Connection con = new
koneksi().connect(); java.sql.Statement stat = con.createStatement(); String sql = "select * from
tb_barang order by kode_barang asc"; ResultSet res = stat.executeQuery(sql);
cbBarang1.addItem(" -- Pilih Dari Barang --"); while(res.next())
{ cbBarang1.addItem(res.getString("kode_barang")); } } catch (Exception e)
{ System.out.println(e.getMessage()); } } public void tampil_combo2(){ try { Connection con =
new koneksi().connect(); java.sql.Statement stat = con.createStatement(); String sql = "select *
from tb_barang order by kode_barang asc"; ResultSet res = stat.executeQuery(sql);
cbBarang2.addItem(" -- Sampai Barang --");
while(res.next()){cbBarang2.addItem(res.getString("kode_barang")); } } catch (Exception e)
{ System.out.println(e.getMessage()); } } public void tanggal(){ Date tgl = new Date();
tglAwal.setDate(tgl); tglAkhir.setDate(tgl); } public laporan_pembelian() { initComponents();
tanggal(); tampil_combo1(); tampil_combo2(); } /** * 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()
{ laporan_data_supplier1 = new tampilan.laporan_data_supplier(); jLabel1 = new
javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel();
tglAwal = new com.toedter.calendar.JDateChooser(); tglAkhir = new
com.toedter.calendar.JDateChooser(); cetak = new javax.swing.JButton(); cbBarang1 = new
javax.swing.JComboBox<>(); cbBarang2 = new javax.swing.JComboBox<>();
laporan_data_supplier1.setVisible(true); setBackground(new java.awt.Color(153, 153, 153));
setClosable(true); setTitle("Laporan Pembelian"); jLabel1.setFont(new java.awt.Font("Tahoma",
3, 14)); // NOI18N jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
jLabel1.setText("Tanggal Awal"); jLabel2.setFont(new java.awt.Font("Tahoma", 3, 14)); //
NOI18N jLabel2.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
jLabel2.setText("Tanggal Akhir"); jLabel3.setFont(new java.awt.Font("Tahoma", 3, 18)); //
NOI18N jLabel3.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel3.setText("Cetak Laporan Pembelian"); tglAwal.setDateFormatString("dd-MM-yyyy");
tglAwal.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
tglAkhir.setDateFormatString("dd-MM-yyyy"); tglAkhir.setFont(new java.awt.Font("Tahoma", 0,
14)); // NOI18N cetak.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N cetak.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/gambar/icons8_print_16px_1.png"))); //
NOI18N cetak.setText("Cetak"); cetak.addActionListener(new java.awt.event.ActionListener()
{ public void actionPerformed(java.awt.event.ActionEvent evt) { cetakActionPerformed(evt); } });
cbBarang1.addActionListener(new java.awt.event.ActionListener() { public void
actionPerformed(java.awt.event.ActionEvent evt) { cbBarang1ActionPerformed(evt); } });
setBounds(200, 30, 500, 216); }// </editor-fold> JasDes = JRXmlLoader.load(file);
param.put("tglAwal",tanggalAwal); param.put("tglAkhir",tanggalAkhir);
param.put("tglAwalIndo", tanggalAwalIIndo); param.put("tglAkhirIndo", tanggalAkhirIndo);
param.put("barang1", cb1); param.put("barang2", cb2); param.put("realPath","src/gambar");
JasRep = JasperCompileManager.compileReport(JasDes); JasPri =
JasperFillManager.fillReport(JasRep, param, konn); JasperViewer jasperViewer = new
JasperViewer(JasPri, false);
jasperViewer.setExtendedState(jasperViewer.getExtendedState()|
javax.swing.JFrame.MAXIMIZED_BOTH); jasperViewer.setVisible(true); } catch (Exception e)
{
JOptionPane.showMessageDialog("Gagal membuka Laporan", "Cetak laporan",
JOptionPane.ERROR_MESSAGE); } } private void
cbBarang1ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code
here: } // Variables declaration - do not modify private javax.swing.JComboBox<String>
cbBarang1; private javax.swing.JComboBox<String> cbBarang2; private javax.swing.JButton
cetak; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private
javax.swing.JLabel jLabel3; private tampilan.laporan_data_supplier laporan_data_supplier1;
private com.toedter.calendar.JDateChooser tglAkhir; private com.toedter.calendar.JDateChooser
tglAwal; // End of variables declaration }

Laporan Penjualan
package tampilan;import java.io.File;import java.sql.Connection;import java.sql.ResultSet;import
java.text.SimpleDateFormat;import java.util.Date;import java.util.HashMap;import
java.util.Map;import javax.swing.JOptionPane;import
javax.swing.table.DefaultTableModel;import koneksi.koneksi;import
net.sf.jasperreports.engine.JasperCompileManager;import
net.sf.jasperreports.engine.JasperFillManager;import net.sf.jasperreports.engine.JasperPrint;import
net.sf.jasperreports.engine.JasperReport;import
net.sf.jasperreports.engine.design.JasperDesign;import
net.sf.jasperreports.engine.xml.JRXmlLoader;import net.sf.jasperreports.view.JasperViewer;/** *
* @author */public class laporan_penjualan extends javax.swing.JInternalFrame { public final
Connection conn = new koneksi().connect(); private DefaultTableModel tabmode; JasperReport
JasRep; JasperPrint JasPri; Map param = new HashMap(2); JasperDesign JasDes; public void
tampil_combo1(){ try { Connection con = new koneksi().connect(); java.sql.Statement stat =
con.createStatement(); String sql = "select * from tb_barang order by kode_barang asc"; ResultSet
res = stat.executeQuery(sql); cbBarang1.addItem(" -- Pilih Dari Barang --"); while(res.next())
{ cbBarang1.addItem(res.getString("kode_barang")); } } catch (Exception e)
{ System.out.println(e.getMessage()); } } public void tampil_combo2(){ try { Connection con =
new koneksi().connect(); java.sql.Statement stat = con.createStatement(); String sql = "select *
from tb_barang order by kode_barang asc"; ResultSet res = stat.executeQuery(sql);
cbBarang2.addItem(" -- Sampai Barang --"); while(res.next())
{ cbBarang2.addItem(res.getString("kode_barang")); } } catch (Exception e)
{ System.out.println(e.getMessage()); } } public void tanggal(){ Date tgl = new Date();
tglAwal.setDate(tgl); tglAkhir.setDate(tgl); } public laporan_penjualan() { initComponents();
tanggal(); tampil_combo1(); tampil_combo2(); } /** * 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=newjavax.swing.JLabel(); tglAwal = new
com.toedter.calendar.JDateChooser(); tglAkhir = new com.toedter.calendar.JDateChooser(); cetak
= new javax.swing.JButton(); cbBarang1 = new javax.swing.JComboBox<>(); cbBarang2 = new
javax.swing.JComboBox<>(); setClosable(true); setTitle("Laporan Penjualan");
jLabel1.setFont(new java.awt.Font("Tahoma", 3, 14)); // NOI18N
jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); jLabel1.setText("Tanggal
Awal");jLabel2.setFont(newjava.awt.Font("Tahoma",3,14));//NOI18N
jLabel2.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); jLabel2.setText("Tanggal
Akhir");jLabel3.setFont(newjava.awt.Font("Tahoma",3,18));//NOI18N
jLabel3.setHorizontalAlignment(javax.swing.SwingConstants.CENTER); jLabel3.setText("Cetak
Laporan Penjualan"); tglAwal.setDateFormatString("dd-MM-yyyy"); tglAwal.setFont(new
java.awt.Font("Tahoma", 0, 14)); // NOI18N tglAkhir.setDateFormatString("dd-MM-yyyy");
tglAkhir.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N cetak.setFont(new
java.awt.Font("Tahoma",0,14));//NOI18Ncetak.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/gambar/icons8_print_16px_1.png"))); //
NOI18N cetak.setText("Cetak"); cetak.addActionListener(new java.awt.event.ActionListener()
{ public void actionPerformed(java.awt.event.ActionEvent evt) { cetakActionPerformed(evt); } });
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout); layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.cr
eateSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignmen
t.LEADING) .addGroup(layout.createSequentialGroup() .addGap(105, 105,
105) .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 272,
javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createSequentialGroup()
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE,Short.MAX_VALUE).addComponent(jLabel2,
javax.swing.GroupLayout.PREFERRED_SIZE,100,javax.swing.GroupLayout.PREFERRED_SIZ
E)).addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(l
ayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(tglA
wal, javax.swing.GroupLayout.PREFERRED_SIZE, 150,
javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(tglAkhir,
javax.swing.GroupLayout.PREFERRED_SIZE, 150,
javax.swing.GroupLayout.PREFERRED_SIZE)) layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.c
reateSequentialGroup()addContainerGap().addComponent(jLabel3,
javax.swing.GroupLayout.PREFERRED_SIZE,35javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,false) .ad
dGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.Group
Layout.Alignment.LEADING,false) .addComponent(tglAwal,
javax.swing.GroupLayout.DEFAULT_SIZE, 32,
Short.MAX_VALUE) .addComponent(jLabel1,javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE,Short.MAX_VALUE)) .addPreferredGap(javax.swin
g.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(layout.createParallelGroup(javax.
swing.GroupLayout.Alignment.TRAILING).addComponent(jLabel2,javax.swing.GroupLayout.P
REFERRED_SIZE,32,javax.swing.GroupLayout.PREFERRED_SIZE).addComponent(tglAkhir,
javax.swing.GroupLayout.PREFERRED_SIZE, 32,
javax.swing.GroupLayout.PREFERRED_SIZE))).addComponent(cetak,
javax.swing.GroupLayout.DEFAULT_SIZE,javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE)).addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELAT
ED).addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .add
Component(cbBarang1,javax.swing.GroupLayout.PREFERRED_SIZE,javax.swing.GroupLayout.
DEFAULT_SIZE,javax.swing.GroupLayout.PREFERRED_SIZE)addComponent(cbBarang2,java
x.swing.GroupLayout.PREFERRED_SIZE,javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE)) .addContainerGap(javax.swing.GroupLayout.DE
FAULT_SIZE, Short.MAX_VALUE)) ); setBounds(200, 30, 500, 200); }// </editor-fold> private
void cetakActionPerformed(java.awt.event.ActionEvent evt) { try { Connection konn = new
koneksi().connect(); File file = new File("src/laporan/laporanPenjualan.jrxml"); String cb1 =
(String)cbBarang1.getSelectedItem(); String cb2 = (String)cbBarang2.getSelectedItem(); String
tampilan = "yyyy-MM-dd"; String tampilan_indo = "dd-MM-yyyy"; SimpleDateFormat fm = new
SimpleDateFormat(tampilan)SimpleDateFormatfm_indo=newSimpleDateFormat(tampilan_indo);
JasDes=JRXmlLoader.load(file);param.put("tglAwal",tanggalAwal);param.put("tglAkhir",tanggal
Akhir);param.put("tglAwalIndo",tanggalAwalIIndo);param.put("tglAkhirIndo",tanggalAkhirIndo);
param.put("barang1",cb1);param.put("barang2",cb2);param.put("realPath","src/gambar");
JasRep=JasperCompileManager.compileReport(JasDes);JasPri=JasperFillManager.fillReport(JasR
ep,param,konn);//
JasperViewer.viewReport(JasPri,false);JasperViewerjasperViewer=newJasperViewer(JasPrifalse);
jasperViewer.setExtendedState(jasperViewer.getExtendedState()|
javax.swing.JFrame.MAXIMIZED_BOTH);jasperViewer.setVisible(true);}catch(Exceptione)
{JOptionPane.showMessageDialog("GagalmembukaLaporan","Cetaklaporan",
JOptionPane.ERROR_MESSAGE); } } //Variablesdeclaration-donotmodifyprivate
javax.swing.JComboBox<String>cbBarang1;private javax.swing.JComboBox<String>
cbBarang2; private javax.swing.JButton cetak; private javax.swing.JLabel jLabel1; private
javax.swing.JLabel jLabel2; private javax.swing.JLabel
jLabel3;privatecom.toedter.calendar.JDateChoosertglAkhir;privatecom.toedter.calendar.JDateCho
oser tglAwal; // End of variables declaration }

Laporan Stok barang

package tampilan;import java.io.File;import java.sql.Connection;import java.sql.ResultSet;import
java.text.SimpleDateFormat;importjava.util.Date;imporjava.util.HashMap;import
java.util.Map;importjavax.swing.JOptionPane;import
javax.swing.table.DefaultTableModel;import
koneksi.koneksi;importnet.sf.jasperreports.engine.JasperCompileManager;import
net.sf.jasperreports.engine.JasperFillManager;import net.sf.jasperreports.engine.JasperPrint;import
net.sf.jasperreports.engine.JasperReport;importnet.sf.jasperreports.engine.design.JasperDesign;im
portnet.sf.jasperreports.engine.xml.JRXmlLoader;importnet.sf.jasperreports.view.JasperViewepub
lic class laporan_stok_barang extends javax.swing.JInternalFrame { public final Connection conn
= new koneksi().connect(); private DefaultTableModel tabmode; JasperReport JasRep; JasperPrint
JasPri; Map param = new HashMap(2); JasperDesign JasDes; public void tampil_combo1(){ try
{ Connection con = new koneksi().connect(); java.sql.Statement stat = con.createStatement();
String sql = "select kode_barang from tb_barang order by kode_barang asc"; ResultSet res =
stat.executeQuery(sql); cbBarang1.addItem(" -- Pilih Dari Barang --"); while(res.next())
{ cbBarang1.addItem(res.getString("kode_barang")); } } catch (Exception e)
{ System.out.println(e.getMessage()); } } public void tampil_combo2(){ try { Connection con =
new koneksi().connect(); java.sql.Statement stat = con.createStatement(); String sql = "select
kode_barang from tb_barang order by kode_barang asc"; ResultSet res = stat.executeQuery(sql);
cbBarang2.addItem(SampaiBarang");while(res.next())
{cbBarang2.addItem(res.getString("kode_barang")); } } catch (Exception e)
{ System.out.println(e.getMessage()); } } public laporan_stok_barang() { initComponents();
tampil_combo1(); tampil_combo2(); } /** * 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();
cetak = new javax.swing.JButton(); cbBarang1 = new javax.swing.JComboBox<>(); cbBarang2 =
new javax.swing.JComboBox<>(); setBackground(new java.awt.Color(204, 204, 204));
setClosable(true); setTitle("Laporan Stok Barang"); jLabel1.setFont(new java.awt.Font("Tahoma",
3, 14)); // NOI18N jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
jLabel1.setText("Kode Barang"); jLabel2.setFont(new java.awt.Font("Tahoma", 3, 14)); //
NOI18N jLabel2.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
jLabel2.setText("Kode Barang"); jLabel3.setFont(new java.awt.Font("Tahoma", 3, 18)); //
NOI18N
jLabel3.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);jLabel3.setText("Lapora
n Stok Barang"); cetak.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18Ncetak.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/gambar/icons8_print_16px_1.png"))); //
NOI18N cetak.setText("Cetak"); cetak.addActionListener(new java.awt.event.ActionListener()
{ public void actionPerformed(java.awt.event.ActionEvent evt) { cetakActionPerformed(evt); } });
.addContainerGap(29, Short.MAX_VALUE)) ); setBounds(200, 30, 500, 200); }// </editor-fold>
private void cetakActionPerformed(java.awt.event.ActionEvent evt) { try { Connection konn =
new koneksi().connect(); File file = new File("src/laporan/laporanStokBarang.jrxml"); String
status1 = (String)cbBarang1.getSelectedItem(); String status2 =
(String)cbBarang2.getSelectedItem(); JasDes
=JRXmlLoader.load(file);param.put("part1",status1);param.put("part2",status2)param.put("realPat
h","src/gambar"); jasperViewer.setVisible(true); } catch (Exception e)
{ JOptionPane.showMessageDialog("Gagal membuka Laporan", "Cetak laporan",
JOptionPane.ERROR_MESSAGE); } } // Variables declaration - do not modify private
javax.swing.JComboBox<String> cbBarang1;privatejavax.swing.JComboBox<String>
cbBarang2; private javax.swing.JButton cetak; private javax.swing.JLabel jLabel1; private
javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; // End of variables declaration }

Login
package tampilan;import java.awt.event.ActionEvent;import java.awt.event.KeyEvent;import
java.sql.Connection;importjava.sql.ResultSet;importjavax.swing.JFrame;importjavax.swing.JOptio
nPane;import koneksi.koneksi;/** * * @author */public class login extends javax.swing.JFrame
{ private Connection conn = new koneksi().connect(); /** * Creates new form menuUtama */
public login() { 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() { jPanel1 = new
javax.swing.JPanel(); iconuser = new javax.swing.JLabel(); jLabel1 = new javax.swing.JLabel();
txtUsername = new javax.swing.JTextField(); jLabel2 = new javax.swing.JLabel(); btnLogin =
new javax.swing.JButton(); btnCancel = new javax.swing.JButton(); txtPassword = new
javax.swing.JPasswordField();jLabel3=newjavax.swing.JLabel();setDefaultCloseOperation(javax.
swing.WindowConstants.EXIT_ON_CLOSE);setTitle("Login");jPanel1.setBackground(new
java.awt.Color(153,153,153));jPanel1.setCursor(newjava.awt.Cursor(java.awt.Cursor.HAND_CU
RSOR));jPanel1.setPreferredSize(newjava.awt.Dimension(500,300));iconuser.setBackground(new
java.awt.Color(255,255,255));iconuser.setIcon(newjavax.swing.ImageIcon(getClass().getResource
("/gambar/gambar gembok.png.png"))); // NOI18N jLabel1.setFont(new java.awt.Font("Tahoma",
1, 16)); // NOI18N jLabel1.setForeground(new java.awt.Color(255, 255, 255));
jLabel1.setText("Username"); txtUsername.setFont(new java.awt.Font("Tahoma", 0, 16)); //
NOI18N txtUsername.addKeyListener(new java.awt.event.KeyAdapter() { public void
keyPressed(java.awt.event.KeyEvent evt) { txtUsernameKeyPressed(evt); } });
jLabel2.setFont(new java.awt.Font("Tahoma", 1, 16)); // NOI18N jLabel2.setForeground(new
java.awt.Color(255, 255, 255)); jLabel2.setText("Password"); btnLogin.setFont(new
java.awt.Font("Tahoma", 1, 14)); // NOI18N btnLogin.setText("Login"); btnLogin.setBorder;
btnLogin.addActionListener(new java.awt.event.ActionListener() { public void
actionPerformed(java.awt.event.ActionEvent evt) { btnLoginActionPerformed(evt); } });
txtPassword.setFont(newjava.awt.Font("Tahoma",0,16));//NOI18NtxtPassword.addKeyListener(n
ewjava.awt.event.KeyAdapter(){publicvoid keyPressed(java.awt.event.KeyEvent evt)
{ txtPasswordKeyPressed(evt);}});jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelG
roup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(jPanel1Layout.createSequential
Group().addGap(44,44,44).addComponent(jLabel3,javax.swing.GroupLayout.PREFERRED_SIZ
E,56,javax.swing.GroupLayout.PREFERRED_SIZE).addGroup(jPanel1Layout.createParallelGrou
p(javax.swing.GroupLayout.Alignment.LEADING).addGroup(jPanel1Layout.createSequentialGro
up().addGap(72,72,72).addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.A
lignment.LEADING).addComponent(txtUsername,
javax.swing.GroupLayout.PREFERRED_SIZE30,javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel1,javax.swing.GroupLay
out.PREFERRED_SIZE,30,javax.swing.GroupLayout.PREFERRED_SIZE).addPreferredGap(jav
ax.swing.LayoutStyle.ComponentPlacement.RELATED).addGroup(jPanel1Layout.createParallel
Group(javax.swing.GroupLayout.Alignment.BASELINE).addComponent(jLabel2,javax.swing.Gr
oupLayout.PREFERRED_SIZE,30,javax.swing.GroupLayout.PREFERRED_SIZE).addCompone
nt(txtPassword,javax.swing.GroupLayout.PREFERRED_SIZE,30,javax.swing.GroupLayout.PRE
FERRED_SIZE)))).addGap(51,51,51)).addComponent(btnLogin,javax.swing.GroupLayout.PREF
ERRED_SIZE,40,javax.swing.GroupLayout.PREFERRED_SIZE).addComponent(btnCancel,java
x.swing.GroupLayout.PREFERRED_SIZE,40,javax.swing.GroupLayout.PREFERRED_SIZE))pri
vatevoidtxtPasswordKeyPressed(java.awt.event.KeyEventevt)
{if(evt.getKeyCode()==KeyEvent.VK_ENTER)
{btnLoginActionPerformed(newActionEvent(evt.getKeyCode(),evt.getID(),"KeyPressLogin"));}}
privatevoid btnCancelActionPerformed(java.awt.event.ActionEvent evt) { dispose(); } private
void btnLoginActionPerformed(java.awt.event.ActionEvent evt) { try { java.sql.Statement stat =
conn.createStatement(); JOptionPane.showMessageDialog(rootPane,"Password Salah");
txtPassword.setText("");txtUsername.requestFocus();}}else{JOptionPane.showMessageDialog(ro
otPane, "User Tidak Ditemukan"); txtUsername.setText(""); txtPassword.setText("");
txtUsername.requestFocus(); } } catch (Exception e){ JOptionPane.showMessageDialog(rootPane,
"Gagal"); } } private void txtUsernameKeyPressed(java.awt.event.KeyEvent evt)
{ if(evt.getKeyCode()== KeyEvent.VK_ENTER){ txtPassword.requestFocus(); } } /** * @param
args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus
look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code
(optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and
feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */
try { for
(javax.swing.UIManager.LookAndFeelInfoinf:javax.swing.UIManager.getInstalledLookAndFeels
()){if("Nimbus".equals(info.getName()))
{javax.swing.UIManager.setLookAndFeel(info.getClassName());break;}}}catch(ClassNotFoundE
xceptionex)
{java.util.logging.Logger.getLogger(login.class.getName()).log(java.util.logging.Level.SEVERE,
ex); } catch (InstantiationException ex)
{ java.util.logging.Logger.getLogger(login.class.getName()).log(java.util.logging.Level.SEVERE,
ex);}catch(IllegalAccessExceptionex)
{java.util.logging.Logger.getLogger(login.class.getName()).log(java.util.logging.Level.SEVERE,e
x);}catch(javax.swing.UnsupportedLookAndFeelExceptionex)
{java.util.logging.Logger.getLogger(login.class.getName()).log(java.util.logging.Level.SEVERE,
ex); } //</editor-fold> //</editor-fold> /* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new
login().setVisible(true); } }); } // Variables declaration - do not modify private
javax.swing.JButton btnCancel; private javax.swing.JButton btnLogin; private javax.swing.JLabel
iconuser; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private
javax.swing.JLabel jLabel3; private javax.swing.JPanel jPanel1; private
javax.swing.JPasswordField txtPassword; private javax.swing.JTextField txtUsername; // End of
variables declaration }

Menu Utama
packagetampilan;importjava.sql.Connection;importjavax.swing.ImageIcon;importjavax.swing.JOp
tionPane;importkoneksi.koneksi;publicclassmenu_utamaextends javax.swing.JFrame { private
final Connection conn = new koneksi().connect(); private data_customer data_customer; private
data_barang data_barang; private data_supplier data_supplier; private data_user data_user; private
transaksi_pembelian transaksi_pembelian; private transaksi_penjualan transaksi_penjualan; private
laporan_pembelian laporan_pembelian; private laporan_penjualan laporan_penjualan; private
laporan_stok_barang laporan_stok_barang; private laporan_data_supplier laporan_data_supplier;
private laporan_data_customer laporan_data_customer; private void initForm() { data_customer =
new data_customer(); data_barang = new data_barang(); data_supplier = new data_supplier();
data_user = new data_user(); transaksi_pembelian = new transaksi_pembelian();
transaksi_penjualan = new transaksi_penjualan(); laporan_pembelian = new laporan_pembelian();
laporan_penjualan = new laporan_penjualan(); laporan_stok_barang = new laporan_stok_barang();
laporan_data_supplier = new laporan_data_supplier(); laporan_data_customer = new
laporan_data_customer(); } public menu_utama() { initComponents(); initForm(); }
@SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated
Code"> private void initComponents() content = new javax.swing.JDesktopPane(); background =
new background(); menuNavbar = new javax.swing.JMenuBar(); menuFile = new
javax.swing.JMenu(); btnExit = new javax.swing.JMenuItem(); menuMaster = new
javax.swing.JMenu(); menuBarang = new javax.swing.JMenuItem(); menuCustomer = new
javax.swing.JMenuItem(); menuSupplier = new javax.swing.JMenuItem(); menuUser = new
javax.swing.JMenuItem(); menuTransaksi = new javax.swing.JMenu(); transaksiPembelian = new
javax.swing.JMenuItem(); transaksiPenjualan = new javax.swing.JMenuItem(); menuLaporan =
new javax.swing.JMenu(); laporanPembelian = new javax.swing.JMenuItem(); laporanPenjualan =
new javax.swing.JMenuItem(); laporanStokBarang = new javax.swing.JMenuItem();
laporanDataSupplier = new javax.swing.JMenuItem(); laporanDataCustomer = new
javax.swing.JMenuItem();setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_C
LOSE);setTitle("RVRSTOREKOMPUTER");addWindowListener(new
java.awt.event.WindowAdapter() { public void windowActivated(java.awt.event.WindowEvent
evt) { formWindowOpened(evt); } }); javax.swing.GroupLayout backgroundLayout = new
javax.swing.GroupLayout(background);background.setLayout(backgroundLayout);backgroundLa
yout.setHorizontalGroup(backgroundLayout.createParallelGroup(javax.swing.GroupLayout.Align
ment.LEADING) .addGap(0, 1298, Short.MAX_VALUE) ); backgroundLayout.setVerticalGroup(
backgroundLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGa
p(0,660,Short.MAX_VALUE));content.setLayer(background,
javax.swing.JLayeredPane.DEFAULT_LAYER); javax.swing.GroupLayout contentLayout = new
javax.swing.GroupLayout(content);content.setLayout(contentLayout);
contentLayout.setHorizontalGroup(contentLayout.createParallelGroup(javax.swing.GroupLayout.
Alignment.LEADING) .addComponent(background,javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE,Short.MAX_VALUE));contentLayout.setVerticalGro
up(contentLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addCom
ponent(background,javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE,Short.MAX_VALUE));
menuNavbar.setBackground(new java.awt.Color(204, 204, 255)); menuNavbar.setCursor(new
java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
menuNavbar.setDebugGraphicsOptions(javax.swing.DebugGraphics.NONE_OPTION);
menuNavbar.setOpaque(false);menuNavbar.setPreferredSize(newjava.awt.Dimension(210,
40));menuFile.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
menuFile.setMargin(new java.awt.Insets(0, 10, 0, 10)); btnExit.setFont(new java.awt.Font("Segoe
UI",0,14));//NOI18NbtnExit.setText("Logout");btnExit.setCursor(new
java.awt.Cursor(java.awt.Cursor.HAND_CURSOR)); btnExit.setMargin(new java.awt.Insets(5, 0,
5,0));btnExit.addActionListener(newjava.awt.event.ActionListener(){publicvoid
actionPerformed(java.awt.event.ActionEventevt){btnExitActionPerformed(evt);}});
menuMaster.add(menuBarang); menuCustomer.setFont(new java.awt.Font("Segoe UI", 0, 14)); //
NOI18NmenuCustomer.setText("DataCustomer");menuCustomer.setCursor(new
java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));menuCustomer.setMargin(new
java.awt.Insets(5, 0, 5, 0)); menuCustomer.addActionListener(new
java.awt.event.ActionListener() {publicvoidactionPerformed(java.awt.event.ActionEventevt)
{ menuCustomerActionPerformed(evt);}});menuMaster.add(menuCustomer);
menuSupplier.setFont(newjava.awt.Font("SegoeUI",0,14));//NOI18N menuSupplier.setText("Data
Supplier"); menuSupplier.setCursor(new java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
menuSupplier.setMargin(new java.awt.Insets(5, 0, 5, 0)); menuSupplier.addActionListener(new
java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt)
{ menuSupplierActionPerformed(evt);}});menuMaster.add(menuSupplier);
menuTransaksi.setText("Transaksi"); menuTransaksi.setFont(new java.awt.Font("Segoe UI", 0,
14));//NOI18NmenuTransaksi.setMargin(newjava.awt.Insets(0,10,0,10));
transaksiPembelian.setFont(newjava.awt.Font("SegoeUI",0,14));//NOI18N
transaksiPembelian.setText("TransaksiPembelian");transaksiPembelian.setCursor(new
java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));transaksiPembelian.setMargin(new
java.awt.Insets(5, 0, 5, 0)); transaksiPembelian.addActionListener(new
java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt)
{ transaksiPembelianActionPerformed(evt); } }); menuTransaksi.add(transaksiPembelian);
transaksiPenjualan.setFont(new java.awt.Font("Segoe UI", 0, 14)); // NOI18N
transaksiPenjualan.setText("TransaksiPenjualan");transaksiPenjualan.setCursor(new
java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));transaksiPenjualan.setMargin(new
java.awt.Insets(50,5,0));menuTransaksi.add(transaksiPenjualan);
menuNavbar.add(menuTransaksi); menuLaporan.setText("Laporan"); menuLaporan.setFont(new
java.awt.Font("Segoe UI", 0, 14)); // NOI18N menuLaporan.setMargin(new java.awt.Insets(0, 10,
0,10))menuLaporan.setPreferredSize(newjava.awt.Dimension(8020));
menuLaporan.add(laporanPembelian); laporanPenjualan.setFont(new java.awt.Font("Segoe UI", 0,
14)); // NOI18N laporanPenjualan.setText("Laporan Penjualan"); laporanPenjualan.setCursor(new
java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));laporanPenjualan.setMargin(newjava.awt.Ins
ets(5,0,5,0));laporanPenjualan.addActionListener(newjava.awt.event.ActionListener()
{publicvoidactionPerformed(java.awt.event.ActionEventevt)laporanPenjualanActionPerformed(ev
t); }});menuLaporan.add(laporanPenjualan);laporanStokBarang.setFont(new java.awt.Font("Segoe
UI", 0, 14)); // NOI18N laporanStokBarang.setText("Laporan Stok Barang");
laporanStokBarang.setCursor(newjava.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
laporanStokBarang.setMargin(newjava.awt.Insets(5,0,5,0));laporanStokBarang.addActionListener
(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent
evt) { laporanStokBarangActionPerformed(evt); } }); menuLaporan.add(laporanStokBarang);
laporanDataSupplier.setFont(newjava.awt.Font("Segoe UI", 0, 14)); // NOI18N
laporanDataSupplier.setText("LaporanDataSupplier");laporanDataSupplier.setCursor(new
java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));laporanDataSupplier.setMargin(new
java.awt.Insets(5, 0, 5, 0)); laporanDataCustomer.setFont(new java.awt.Font("Segoe UI", 0,
14)); // NOI18NlaporanDataCustomer.setText("LaporanDataCustomer");
laporanDataCustomer.setCursor(newjava.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
laporanDataCustomer.setMargin(newjava.awt.Insets(50,5,0));laporanDataCustomer.addActionList
ener(newjava.awt.event.ActionListener(){public void
actionPerformed(java.awt.event.ActionEvent evt) { laporanDataCustomerActionPerformed(evt); }
}); menuLaporan.add(laporanDataCustomer);
menuNavbar.add(menuLaporan);setJMenuBar(menuNavbar);privatevoid
menuBarangActionPerformed(java.awt.event.ActionEvent evt) { if (!data_barang.isVisible())
{ content.add(data_barang);data_barang.show();}}privatevoid
menuSupplierActionPerformed(java.awt.event.ActionEvent evt) { if (!data_supplier.isVisible())
{ content.add(data_supplier);data_supplier.show();}}privatevoid
transaksiPembelianActionPerformed(java.awt.event.ActionEvent evt) { ImageIcon img = new
ImageIcon("src/gambar/logo.png"); setIconImage(img.getImage()); } /** * @param args the
command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and
feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If
Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details
see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ } catch
(ClassNotFoundExceptionex)java.util.logging.Logger.getLogger(menu_utama.class.getName()).lo
g(java.util.logging.Level.SEVERE,ex);}catch(InstantiationExceptionex)
{ java.util.logging.Logger.getLogger(menu_utama.class.getName()).log(java.util.logging.Level.S
EVERE,ex);}catch(IllegalAccessExceptionex)
{java.util.logging.Logger.getLogger(menu_utama.class.getName()).log(java.util.logging.Level.SE
VERE,ex);}catch(javax.swing.UnsupportedLookAndFeelExceptionex)
{java.util.logging.Logger.getLogger(menu_utama.class.getName()).log(java.util.logging.Level.SE
VERE, ex); } //</editor-fold> /* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new
menu_utama().setVisible(true); } }); } // Variables declaration - do not modify private
javax.swing.JPanelbackground;privatejavax.swing.JMenuItembtnExit;privatejavax.swing.JDeskto
pPanecontent;privatejavax.swing.JMenuItemlaporanDataCustomer;private
javax.swing.JMenuItem
laporanDataSupplier;privatejavax.swing.JMenuItemlaporanPembelian;privatejavax.swing.JMenuIt
emlaporanPenjualan;privatejavax.swing.JMenuItemlaporanStokBarang;private
javax.swing.JMenuItem menuBarang; private javax.swing.JMenuItem menuCustomer; private
javax.swing.JMenumenuFile;private javax.swing.JMenu menuLaporan; private
javax.swing.JMenu
menuMaster;privatejavax.swing.JMenuBarmenuNavbar;privatejavax.swing.JMenuItemmenuSuppl
ier;privatejavax.swing.JMenumenuTransaksi;privatejavax.swing.JMenuItem menuUser; private
javax.swing.JMenuItem transaksiPembelian; private javax.swing.JMenuItem transaksiPenjualan; //
End of variables declaration }

Transaksi Pembelian
packagetampilan;importcom.sun.glass.events.KeyEvent;import java.awt.event.ActionEvent;import
java.io.File;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;
importjava.sql.SQLException;importjava.text.ParseException;importjava.text.SimpleDateFormat;i
mportjava.util.Date;importjava.util.HashMap;importjava.util.Locale;importjava.util.Map;import
java.util.logging.Level;import java.util.logging.Logger;import javax.swing.JOptionPane;import
javax.swing.table.DefaultTableModel;importjavax.swing.table.TableColumn;importkoneksi.konek
si;importnet.sf.jasperreports.engine.JasperCompileManager;importnet.sf.jasperreports.engine.Jasp
erFillManager;importnet.sf.jasperreports.engine.JasperPrint;importnet.sf.jasperreports.engine.Jasp
erReport;impornet.sf.jasperreports.engine.design.JasperDesign;importnet.sf.jasperreports.engine.x
ml.JRXmlLoader;importnet.sf.jasperreports.view.JasperViewer;import
tampilan.data_barang;public class transaksi_pembelian extends javax.swing.JInternalFrame
{ public final Connection conn = new koneksi().connect(); private DefaultTableModel tabmode;
private DefaultTableModel tabmode2; private DefaultTableModel tabmode3; JasperReport
JasRep; JasperPrint JasPri; Map param = new HashMap(); JasperDesign JasDes; protected void
kosong() { tgl_pembelian(); txtIdPembelian.setText; txtIdDetailPembelian.setTex;
txtKodeBarang.setText; txtNamaBarang.setText; txtJumlahBarang.setText;
txtKodeSupplier.setText; txtNoBukti.setText; } private void autoIdPB() { try { Connection con =
new koneksi().connect(); java.sql.Statement stat = con.createStatement(); Date tanggal_update =
new Date(); String tampilan = "MMyy"; SimpleDateFormat fm = new
SimpleDateFormat(tampilan); String tanggal = String.valueOf(fm.format(btnTanggal.getDate()));
String sql = "select max(right (id_pembelian,4)) as no from tb_pembelian where id_pembelian like
'%" + "PB" + tanggal.toString() + "%'"; ResultSet res = stat.executeQuery(sql); while (res.next()) {
if (res.first() == false) { txtIdPembelian.setText("PB" + tanggal.toString() + "0001"); } else
{ res.last(); int aut_id = res.getInt(1) + 1; String no = String.valueOf(aut_id); int no_jual =
no.length(); // mengatur jumlah_barang 0 for (int j = 0; j < 4 - no_jual; j++) { no = "0" + no; }
txtIdPembelian.setText("PB" + tanggal.toString() + no); } } res.close(); stat.close(); } catch
(Exception e) { JOptionPane.showMessageDialog("Terjadi Kesalahan di auto_id_bm"); } }
private void autoIdPB_DT() { try { Connection con = new koneksi().connect(); java.sql.Statement
stat = con.createStatement(); String sql_dt = "select max(right (id_dt_pembelian,2)) as no from
tb_pembelian where id_dt_pembelian like '%" + txtIdPembelian.getText() + "%'"; ResultSet res_dt
= stat.executeQuery(sql_dt); while (res_dt.next()) { if (res_dt.first() == false)
{ txtIdDetailPembelian.setText(txtIdPembelian.getText()+ "01"); } else { public void
lebarKolom2() { public void lebarKolom5() { TableColumn column3; column3 =
tabelBarangUbah.getColumnModel().getColumn(0); column3.setPreferredWidth(40); column3 =
tabelBarangUbah.getColumnModel().getColumn(1); column3.setPreferredWidth(150); column3 =
tabelBarangUbah.getColumnModel().getColumn(2); column3.setPreferredWidth(200); column3 =
tabelBarangUbah.getColumnModel().getColumn(3); column3.setPreferredWidth(100); } public
void dataTable() { Object[] Baris = {"No", "Tanggal", "ID Detail Pembelian", "ID Pembelian",
"Kode Supplier", "Kode Barang", "Nama Barang", "Qty", "No Bukti"}; tabmode = new
DefaultTableModel(Baris); tabelPembelian.setModel(tabmode); String sql = "select * from
tb_pembelian order by tgl_pembelian desc"; try { java.sql.Statement stat = conn.createStatement();
ResultSet hasil = stat.executeQuery(sql); while (hasil.next()) { String tgl_pembelian =
hasil.getString("tgl_pembelian"); String id_dt_pembelian = hasil.getString("id_dt_pembelian");
String id_pembelian = hasil.getString("id_pembelian"); String kode_supplier =
hasil.getString("kode_supplier"); String kode_barang = hasil.getString("kode_barang"); String
nama_barang=hasil.getString("nama_barang");Stringjumlah_barang=
hasil.getString("jumlah_barang"); String no_bukti = hasil.getString("no_bukti"); String[] data =
{"", tgl_pembelian, id_dt_pembelian, id_pembelian, kode_supplier, kode_barang, nama_barang,
jumlah_barang, no_bukti}; tabmode.addRow(data); lebarKolom(); noTable(); } } catch (Exception
e) { } } public void dataTable2() { Object[] Baris = {"No", "Kode Supplier", "Nama Supplier"};
tabmode2 = new DefaultTableModel(Baris); tabelSupplier.setModel(tabmode2); String sql =
"select * from tb_supplier order by kode_supplier asc"; try { java.sql.Statement stat =
conn.createStatement(); ResultSet hasil = stat.executeQuery(sql); while (hasil.next()) { String
kode_supplier=hasil.getString("kode_supplier");Stringnama_supplier=hasil.getString("nama_supp
lier"); String[] data = {"", kode_supplier, nama_supplier}; tabmode2.addRow(data);
lebarKolom2(); noTable2(); } } catch (Exception e) { } } public void dataTable3() { Object[] Baris
= {"No", "Kode Barang", "Nama Barang","Supplier"}; tabmode3 = new
DefaultTableModel(Baris); tabelBarang.setModel(tabmode3); String sql = "select * from
tb_barang join tb_supplier on tb_supplier.kode_supplier=tb_barang.supplier order by kode_barang
asc"; public void dataTable4() { Object[] Baris = {"No", "Kode Supplier", "Nama Supplier"};
tabmode2 = new DefaultTableModel(Baris); tabelSupplierUbah.setModel(tabmode2); String sql =
"select * from tb_supplier order by kode_supplier asc"; try { java.sql.Statement stat =
conn.createStatement(); ResultSet hasil = stat.executeQuery(sql); while (hasil.next()) { String
kode_supplier = hasil.getString("kode_supplier"); String nama_supplier =
hasil.getString("nama_supplier"); String[] data = {"", kode_supplier, nama_supplier};
tabmode2.addRow(data); lebarKolom4(); noTable2(); } } catch (Exception e) { } } public void
pencarian(String sql) { Object[] Baris = {"No", "Tanggal", "ID Detail Pembelian", "ID
Pembelian", "Supplier", "Kode Barang", "Nama Barang", "Qty", "No Bukti"}; tabmode = new
DefaultTableModel(Baris); tabelPembelian.setModel(tabmode); int brs =
tabelPembelian.getRowCount(); for (int i = 0; 1 < brs; i++) { tabmode.removeRow(1); } try
{ java.sql.Statement stat = conn.createStatement(); ResultSet hasil = stat.executeQuery(sql); while
(hasil.next()) { String tgl_pembelian = hasil.getString("tgl_pembelian"); String id_dt_pembelian =
hasil.getString("id_dt_pembelian"); String id_pembelian = hasil.getString("id_pembelian"); String
kode_supplier=hasil.getString("kode_supplier");Stringkode_barang=hasil.getString("kode_barang
"); String nama_barang = hasil.getString("nama_barang"); String jumlah_barang =
hasil.getString("jumlah_barang"); String no_bukti = hasil.getString("no_bukti"); String[] data =
{"", tgl_pembelian, id_dt_pembelian, id_pembelian, kode_supplier, kode_barang, nama_barang,
jumlah_barang, no_bukti}; public void pencarian4(String sql) { Object[] Baris = {"No", "Kode
Supplier", "Nama Supplier"}; tabmode2 = new DefaultTableModel(Baris);
tabelSupplierUbah.setModel(tabmode2); int brs = tabelSupplierUbah.getRowCount(); for (int i =
0; 1 < brs; i++) { tabmode2.removeRow(1); } public transaksi_pembelian() { initComponents();
dataTable(); lebarKolom(); tgl_pembelian(); aktif(); kosong(); autoIdPB(); autoIdPB_DT();
txtKodeBarang.requestFocus(); Locale local = new Locale("id", "ID");
Locale.setDefault(local); } /** * 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()
{ ubahTransaksiPembelian = new javax.swing.JDialog(); jPanel5 = new javax.swing.JPanel();
jLabel8 = new javax.swing.JLabel(); txtIdPembelianUbah = new javax.swing.JTextField();
jLabel9 = new javax.swing.JLabel(); txtKodeBarangUbah = new
javax.swing.JTextField();jLabel10=newjavax.swing.JLabel();btnSimpanUbah=newjavax.swing.JB
utton();btnCancelUbah=newjavax.swing.JButton();jLabel11=nejavax.swing.JLabel();btnTanggalU
bah=newcom.toedter.calendar.JDateChooser();txtNamaBarangUbah=newjavax.swing.JTextField()
;txtJumlahBarangUbah=newjavax.swing.JTextField(); jLabel18 = new javax.swing.JLabel();
jLabel19 = new javax.swing.JLabel(); btnCariSupplierUbah = new javax.swing.JButton();
jLabel21 = new javax.swing.JLabel(); txtKodeSupplierUbah = new javax.swing.JTextField();
btnCariBarangUbah = new javax.swing.JButton(); txtIdDetailPembelianUbah = new
javax.swing.JTextField(); txtNoBuktiUbah = new javax.swing.JTextField(); listSupplier = new
javax.swing.JDialog(); jPanel6 = new javax.swing.JPanel(); jLabel15 = new javax.swing.JLabel();
txtCariSupplier = new javax.swing.JTextField(); jScrollPane4 = new javax.swing.JScrollPane();
tabelSupplier = new javax.swing.JTable(); listSupplierUbah = new javax.swing.JDialog(); jPanel7
= new javax.swing.JPanel(); jLabel16 = new javax.swing.JLabel(); txtCariSupplierUbah = new
javax.swing.JTextField(); jScrollPane5 = new javax.swing.JScrollPane(); tabelSupplierUbah =
new javax.swing.JTable(); listKodeBarang = new javax.swing.JDialog(); jPanel8 = new
javax.swing.JPanel(); jLabel17 = new javax.swing.JLabel(); txtCariBarang = new
javax.swing.JTextField(); jScrollPane6 = new javax.swing.JScrollPane(); tabelBarang = new
javax.swing.JTable(); listKodeBarangUbah = new javax.swing.JDialog(); jPanel9 = new
javax.swing.JPanel(); jLabel20 = new javax.swing.JLabel(); txtCariBarangUbah = new
javax.swing.JTextField(); jScrollPane7 = new javax.swing.JScrollPane(); tabelBarangUbah = new
javax.swing.JTable(); jPanel1 = new javax.swing.JPanel(); jPanel2 = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel(); jPanel3 = new javax.swing.JPanel(); jLabel3 = new
javax.swing.JLabel(); txtIdPembelian = new javax.swing.JTextField(); jLabel4 = new
javax.swing.JLabel(); txtKodeBarang = new javax.swing.JTextField(); jLabel5 = new
javax.swing.JLabel(); btnTambah = new javax.swing.JButton(); btnUbah = new
javax.swing.JButton(); btnHapus = new javax.swing.JButton(); btnBersih = new
javax.swing.JButton(); btnCetak = new javax.swing.JButton(); jLabel7 = new
javax.swing.JLabel(); btnTanggal = new com.toedter.calendar.JDateChooser(); txtNamaBarang =
new javax.swing.JTextField(); jLabel12 = new javax.swing.JLabel(); txtJumlahBarang = new
javax.swing.JTextField(); btnCariSupplier = new javax.swing.JButton(); btnSimpan = new
javax.swing.JButton(); jLabel14 = new javax.swing.JLabel(); btnCariBarang = new
javax.swing.JButton(); txtIdDetailPembelian = new javax.swing.JTextField(); jLabel13 = new
javax.swing.JLabel(); txtNoBukti = new javax.swing.JTextField(); txtKodeSupplier = new
javax.swing.JTextField(); jPanel4 = new javax.swing.JPanel(); txtCari = new
javax.swing.JTextField(); jScrollPane2 = new javax.swing.JScrollPane(); tabelPembelian = new
javax.swing.JTable(); btnCari = new javax.swing.JButton(); jLabel6 = new javax.swing.JLabel();
ubahTransaksiPembelian.setTitle("UbahTransaksiPembelian");ubahTransaksiPembelian.setMinim
umSize(newjava.awt.Dimension(450,460));ubahTransaksiPembelian.setResizable(false);
ubahTransaksiPembelian.setSize(new java.awt.Dimension(450, 460)); jPanel5.setBackground(new
java.awt.Color(255, 255, 255)); jPanel5.setMaximumSize(new java.awt.Dimension(500, 300));
jPanel5.setMinimumSize(newjava.awt.Dimension(500,300));jLabel8.setFont(new
java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel8.setText("ID Pembelian");
txtIdPembelianUbah.setEditable(false);txtIdPembelianUbah.setFont(new java.awt.Font("Tahoma",
0, 14)); // NOI18N txtIdPembelianUbah.addKeyListener(new java.awt.event.KeyAdapter()
{ public void keyPressed(java.awt.event.KeyEvent evt)
{ txtIdPembelianUbahKeyPressed(evt); } });
javax.swing.GroupLayoutlistSupplierLayout=newjavax.swing.GroupLayout(listSupplier.getConte
ntPane());listSupplier.getContentPane().setLayout(listSupplierLayout);listSupplierLayout.setHoriz
ontalGroup(listSupplierLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADI
NG.addGroup(listSupplierLayout.createSequentialGroup().addContainerGap().addComponent(jPa
nel6,javax.swing.GroupLayout.PREFERRED_SIZE,430,Short.MAX_VALUE)listSupplierUbah.s
etTitle("ListDataSupplier");listSupplierUbah.setMinimumSize(newjava.awt.Dimension(450,460));
listSupplierUbah.setResizable(false);listSupplierUbah.setSize(new java.awt.Dimension(450,
460)); jPanel7.setBackground(newjava.awt.Color(255,255,255));jPanel7.setMaximumSize(new
java.awt.Dimension(500, 300)); jPanel7.setMinimumSize(new java.awt.Dimension(500, 300));
jLabel16.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel16.setText("Cari
Supplier"); txtCariSupplierUbah.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
txtCariSupplierUbah.addKeyListener(newjava.awt.event.KeyAdapter(){publicvoid
keyTyped(java.awt.event.KeyEvent evt) { txtCariSupplierUbahKeyTyped(evt); } }); new String []
{ "Title 1", "Title 2", "Title 3" } )); tabelSupplierUbah.setRowHeight(20);
tabelSupplierUbah.addMouseListener(new java.awt.event.MouseAdapter() { public void
mouseClicked(java.awt.event.MouseEvent evt) { tabelSupplierUbahMouseClicked(evt); } });
jScrollPane5.setViewportView(tabelSupplierUbah); javax.swing.GroupLayout jPanel7Layout =
newjavax.swing.GroupLayout(jPanel7);jPanel7.setLayout(jPanel7Layout);jPanel7Layout.setHoriz
ontalGroup(.addComponent(txtCariSupplierUbah, javax.swing.GroupLayout.PREFERRED_SIZE,
264,javax.swing.GroupLayout.PREFERRED_SIZE))).addGap(84,84,84)));
jPanel7Layout.setVerticalGroup(.addGroup(jPanel7Layout.createSequentialGroup().addContainer
Gap().addComponent(jLabel16,javax.swing.GroupLayout.PREFERRED_SIZE,30,
javax.swing.GroupLayout.PREFERRED_SIZE).addComponent(txtCariSupplierUbah,
javax.swing.GroupLayout.PREFERRED_SIZE,30,
javax.swing.GroupLayout.PREFERRED_SIZE)).addPreferredGap(javax.swing.LayoutStyle.Com
ponentPlacement.RELATED).addComponent(jScrollPane5,javax.swing.GroupLayout.DEFAULT
_SIZE,375,Short.MAX_VALUE).addContainerGap().addComponent(jPanel7,
javax.swing.GroupLayout.PREFERRED_SIZE,430,Short.MAX_VALUE).addGroup(listSupplier
UbahLayout.createSequentialGroup().addContainerGap().addComponent(jPanel7,javax.swing.Gro
upLayout.DEFAULT_SIZE,javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE).addContainerGap()) );
listKodeBarang.setTitle("ListDataPart");listKodeBarang.setMinimumSize(new
java.awt.Dimension(450, 460)); listKodeBarang.setResizable(false); listKodeBarang.setSize(new
java.awt.Dimension(450, 460)); jPanel8.setBackground(new java.awt.Color(255, 255, 255));
jPanel8.setMaximumSize(new java.awt.Dimension(500, 300)); jPanel8.setMinimumSize(new
java.awt.Dimension(500, 300)); jLabel17.setFont(new java.awt.Font("Tahoma", 0, 14)); //
NOI18N jLabel17.setText("Cari Barang"); txtCariBarang.setFont(new java.awt.Font("Tahoma", 0,
14)); // NOI18N txtCariBarang.addKeyListener(new java.awt.event.KeyAdapter() { public void
keyTyped(java.awt.event.KeyEvenevt){txtCariBarangKeyTyped(evt);}});
tabelBarang.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N tabelBarang.setModel(new
javax.swing.table.DefaultTableModel(.addContainerGap()));javax.swing.GroupLayout
listKodeBarangLayout=newjavax.swing.GroupLayout(listKodeBarang.getContentPane());
listKodeBarangLayout.setHorizontalGroup(.addContainerGap().addComponent(jPanel8,
javax.swing.GroupLayout.PREFERRED_SIZE, 430,
Short.MAX_VALUE) .addContainerGap()) );
listKodeBarangLayout.setVerticalGroup(.addContainerGap().addComponent(jPanel8,
javax.swing.GroupLayout.DEFAULT_SIZE,javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE) .addContainerGap()) ); listKodeBarangUbah.setTitle("List Data Part");
listKodeBarangUbah.setResizable(false);listKodeBarangUbah.setSize(new
java.awt.Dimension(450, 460)); jPanel9.setBackground(new java.awt.Color(255, 255, 255));
txtCariBarangUbah.setFont(newjava.awt.Font("Tahoma",0,14));//NOI18N
txtCariBarangUbah.addKeyListener(newjava.awt.event.KeyAdapter(){publicvoid
keyTyped(java.awt.event.KeyEventevt){txtCariBarangUbahKeyTyped(evt);}});
tabelBarangUbah.setFont(newjava.awt.Font("Tahoma",0,12));//NOI18N
tabelBarangUbah.setModel(new javax.swing.table.DefaultTableModel( new Object [][] { }
jPanel2Layout.setVerticalGroup( ); jPanel3.setBackground(new java.awt.Color(153, 153, 153));
jLabel3.setFont(newjava.awt.Font("Tahoma",0,14));//NOI18NjLabel3.setText("ID
Pembelian");txtIdPembelian.setEditable(false);txtIdPembelian.setFont(new
java.awt.Font("Tahoma",0,14));//NOI18NtxtIdPembelian.addKeyListener(new
java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt)
{ txtIdPembelianKeyPressed(evt); } }); jLabel4.setFont(new java.awt.Font("Tahoma", 0, 14)); //
NOI18N jLabel4.setText("Kode Supplier"); txtKodeBarang.setFont(new java.awt.Font("Tahoma",
0, 14)); // NOI18N txtKodeBarang.addKeyListener(new java.awt.event.KeyAdapter() { public
void keyPressed(java.awt.event.KeyEventevt){txtKodeBarangKeyPressed(evt);}});
jLabel5.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel5.setText("Kode
Barang"); btnTambah.setBackground(new java.awt.Color(0, 0, 255)); btnTambah.setFont(new
java.awt.Font("Tahoma", 0, 12)); // NOI18N btnTambah.setMargin(new java.awt.Insets(0, 0, 0,
0)); btnTambah.setMaximumSize(newjava.awt.Dimension(100,40));
btnTambah.setMinimumSize(newjava.awt.Dimension(100,40));
btnTambah.addActionListener(newjava.awt.event.ActionListener(){publicvoid
actionPerformed(java.awt.event.ActionEvent evt) { btnTambahActionPerformed(evt); } });
btnHapus.setBackground(newjava.awt.Color(0,0,255));btnHapus.setFont(new
java.awt.Font("Tahoma", 0, 12)); // NOI18N btnCetak.setBackground(new java.awt.Color(0, 0,
255)); btnCetak.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N btnCetak.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/gambar/icons8_print_16px_1.png"))); //
NOI18N btnCetak.setText("Cetak");btnCetak.setCursor(new
java.awt.Cursor(java.awt.Cursor.HAND_CURSOR)); btnCetak.setMargin(new java.awt.Insets(0,
0, 0, 0)); btnCetak.addActionListener(new java.awt.event.ActionListener() { public void
actionPerformed(java.awt.event.ActionEvent evt) { btnCetakActionPerformed(evt); } });
txtNamaBarang.setEditable(false); txtNamaBarang.setFont(new java.awt.Font("Tahoma", 0,
14)); // NOI18N txtNamaBarang.addKeyListener(new java.awt.event.KeyAdapter() { public void
keyPressed(java.awt.event.KeyEventevt)
{txtNamaBarangKeyPressed(evt);}});btnSimpan.setBackground(newjava.awt.Color(0,0,255));btn
Simpan.setFont(newjava.awt.Font("Tahoma",0,12));//
NOI18NbtnSimpan.setIcon(newjavax.swing.ImageIcon(getClass().getResource("/gambar/
icons8_save_16px.png")));//
NOI18NbtnSimpan.setText("Simpan");btnSimpan.setCursor(newjava.awt.Cursor(java.awt.Cursor.
HAND_CURSOR));btnSimpan.setMargin(newjava.awt.Insets(0,
0,0,0));btnSimpan.setMaximumSize(newjava.awt.Dimension(100,40));btnSimpan.setMinimumSiz
e(newjava.awt.Dimension(10040));btnSimpan.addActionListener(newjava.awt.event.ActionListen
er(){publicvoidactionPerformed(java.awt.event.ActionEventevt)
{ btnSimpanActionPerformed(evt);});txtIdDetailPembelian.setEditable(false);txtIdDetailPembelia
n.setBackground(newjava.awt.Color(255,255,255));txtIdDetailPembelian.setForeground(newjava.
awt.Color(255,255,255));txtIdDetailPembelian.setBorder;jLabel13.setFont(new
java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel13.setText("No Bukti / SJ");
txtNoBukti.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
txtKodeSupplier.setFont(new
java.awt.Font("Tahoma",0,14));//NOI18NtxtKodeSupplier.addKeyListener(newjava.awt.event.Ke
yAdapter(){publicvoidkeyPressed(java.awt.event.KeyEventevt)
{txtKodeSupplierKeyPressed(evt);}});javax.swing.GroupLayoutjPanel3Layout=newjavax.swing.
GroupLayout(jPanel3);
jPanel3.setLayout(jPanel3Layout);jPanel3Layout.setHorizontalGroup(txtCari.setFont(new
java.awt.Font("Tahoma",0,14));//NOI18NtxtCari.setCursor(newjava.awt.Cursor(java.awt.Cursor.
HAND_CURSOR));txtCari.addKeyListener(new java.awt.event.KeyAdapter() { public void
keyTyped(java.awt.event.KeyEvent evt) { txtCariKeyTyped(evt); } }); private void
txtIdPembelianKeyPressed(java.awt.event.KeyEvent evt) { if (evt.getKeyCode() ==
yEvent.VK_ENTER) { txtKodeSupplier.requestFocus(); } } String tampilan = "yyyy-MM-dd";
SimpleDateFormafmnewSimpleDateFormat(tampilan);Stringtgl_pembelian=String.valueOf(fm.for
mat(btnTanggal.getDate()));try {JOptionPane.showMessageDialog("Data Berhasil Disimpan");
autoIdPB_DT(); kosong2(); dataTable(); data_barang.class.getClass(); lebarKolom();
txtIdPembelian.setEnabled(false);txtKodeSupplier.setEnabled(false);
txtKodeBarang.requestFocus();}catch(SQLException e)
{ JOptionPane.showMessageDialog("Data Gagal Disimpan" + e); } } } private void
btnHapusActionPerformed(java.awt.event.ActionEvent evt) { int ok =
JOptionPane.showConfirmDialog(" Apakah Anda Yakin Ingin " + "Menghapus Data",
"Konfirmasi Dialog", JOptionPane.YES_NO_OPTION); if (ok == 0) { String sql = "delete from
tb_pembelian where id_dt_pembelian='" + txtIdDetailPembelian.getText() + "'"; try
{ PreparedStatementstat=conn.prepareStatement(sql);stat.executeUpdate();
JOptionPane.showMessageDialog("DataBerhasilDihapus"); kosong(); autoIdPB();
autoIdPB_DT(); dataTable(); lebarKolom(); txtIdPembelian.requestFocus(); } catch
(SQLException e) { JOptionPane.showMessageDialog("Data Gagal Dihapus" + e); } } } private
void btnSimpanUbahActionPerformed(java.awt.event.ActionEvent evt) { String sql = "update
tb_pembeliantgl_pembelian=?,id_dt_pembelian=?,id_pembelian=?,kode_supplier=?,kode_barang
=?,nama_barang=?,jumlah_barang=?,no_bukti=? where id_dt_pembelian='" +
txtIdDetailPembelianUbah.getText() + "'"; String tampilan = "yyyy-MM-dd"; SimpleDateFormat
fm=newSimpleDateFormat(tampilan);Stringtgl_pembelian=
String.valueOf(fm.format(btnTanggalUbah.getDate())); try { PreparedStatement stat =
conn.prepareStatement(sql); stat.setString(1, tgl_pembelian.toString()); stat.setString(2,
txtIdDetailPembelianUbah.getText()); stat.setString(3, txtIdPembelianUbah.getText());
stat.setString(4, txtKodeSupplierUbah.getText()); stat.setString(5, txtKodeBarangUbah.getText());
stat.setString(6,txtNamaBarangUbah.getText()); stat.setString(7,
txtJumlahBarangUbah.getText());
stat.setString(8,txtNoBuktiUbah.getText());stat.executeUpdate();
JOptionPane.showMessageDialog("Data Berhasil Diubah"); // String refresh = "select * from
tb_barang";kosong();autoIdPB();autoIdPB_DT();dataTable()lebarKolom();
txtIdPembelian.requestFocus();ubahTransaksiPembelian.dispose();txtKodeBarang.setEnabled(true
);txtKodeSupplier.setEnabled(true);}catch(SQLExceptione)
{JOptionPane.showMessageDialog("DataGagalDiubah"+e); } } private void
btnCancelUbahActionPerformed(java.awt.event.ActionEvent evt)
{ubahTransaksiPembelian.setVisible(false);}privatevoidbtnUbahActionPerformed(java.awt.event.
ActionEventevt){ubahTransaksiPembelian.setLocationRelativeTo(this);
txtIdPembelianUbah.setEditable(false); ubahTransaksiPembelian.setVisible(true); } private void
btnCariActionPerformed(java.awt.event.ActionEvent evt) { String sqlPencarian = "select * from
tb_pembelian where id_pembelian like '%" + txtCari.getText() + "%'" + "or id_dt_pembelian like
'%" + txtCari.getText() + "%'" + "or nama_barang like '%" + txtCari.getText() + "%'" + "or
kode_barang like '%" + txtCari.getText() + "%'" + "or kode_supplier like '%" + txtCari.getText() +
"%'";pencarian(sqlPencarian);lebarKolom();noTable();}privatevoid
btnCariSupplierActionPerformed(java.awt.event.ActionEvent evt) { dataTable2(); lebarKolom2();
listSupplier.setLocationRelativeTo(this);listSupplier.setVisible(true);}Privatevoid
txtNamaBarangUbahKeyPressed(java.awt.event.KeyEvent evt) { if (evt.getKeyCode() ==
KeyEvent.VK_ENTER){txtKodeSupplierUbah.requestFocus(); } } private void
txtJumlahBarangUbahKeyPressed(java.awt.event.KeyEvent evt) { if (evt.getKeyCode() ==
KeyEvent.VK_ENTER){txtNoBuktiUbah.requestFocus();}}privatevoid
tabelSupplierMouseClicked(java.awt.event.MouseEvent evt) { int bar =
tabelSupplier.getSelectedRow(); String a = tabmode2.getValueAt(bar, 0).toString(); String b =
tabmode2.getValueAt(bar,1).toString(); String c = tabmode2.getValueAt(bar, 2).toString();
txtKodeSupplier.setText(b);//txtKategoriUbah.setText(c);listSupplier.dispose();
txtKodeBarang.requestFocus(); } private void txtCariSupplierKeyTyped(java.awt.event.KeyEvent
evt) { String sqlPencarian2 = "select * from tb_supplier where kode_supplier like '%" +
txtCariSupplier.getText() + "%' or nama_supplier like '%" + txtCariSupplier.getText() + "%'";
pencarian2(sqlPencarian2);lebarKolom2();}privatevoid
txtCariSupplierUbahKeyTyped(java.awt.event.KeyEvent evt) { String sqlPencarian4 = "select *
from tb_supplier where kode_supplier like '%" + txtCariSupplierUbah.getText() + "%' or
nama_supplier like '%" + txtCariSupplierUbah.getText() + "%'"; pencarian4(sqlPencarian4);
lebarKolom4(); } private void tabelSupplierUbahMouseClicked(java.awt.event.MouseEvent evt) {
int bar = tabelSupplierUbah.getSelectedRow(); String a = tabmode2.getValueAt(bar, 0).toString();
String b = tabmode2.getValueAt(bar, 1).toString(); String c = tabmode2.getValueAt(bar,
2).toString();txtKodeSupplierUbah.setText(b);listSupplierUbah.dispose();txtKodeBarangUbah.req
uestFocus();}privatevoid btnSimpanActionPerformed(java.awt.event.ActionEvent evt)
{ kosong();
autoIdPB();autoIdPB_DT();dataTable();lebarKolom();txtIdPembelian.setEnabled(true);
txtKodeSupplier.setEnabled(true);}privatevoidbtnCariBarangActionPerformed(java.awt.event.Act
ionEvent evt) { dataTable3(); lebarKolom3(); listKodeBarang.setLocationRelativeTo(this);
listKodeBarang.setVisible(true); } private void txtCariBarangKeyTyped(java.awt.event.KeyEvent
evt) { String sqlPencarian3 = "select * from tb_barang join tb_supplier on
tb_supplier.kode_supplier=tb_barang.supplier where kode_barang like '%" +
txtCariBarang.getText() + "%' or nama_sparepart like '%" + txtCariBarang.getText() + "%'";
pencarian3(sqlPencarian3);lebarKolom3();}privatevoidtabelBarangMouseClicked(java.awt.event.
MouseEvent evt) { int bar = tabelBarang.getSelectedRow(); String a = tabmode3.getValueAt(bar,
0).toString(); String b = tabmode3.getValueAt(bar, 1).toString(); String c =
tabmode3.getValueAt(bar,2).toString();txtKodeBarang.setText(b);txtNamaBarang.setText(c);listK
odeBarang.dispose();txtJumlahBarang.requestFocus();}privatevoidtxtCariBarangUbahKeyTyped(j
ava.awt.event.KeyEvent evt) { String sqlPencarian5 = "select * from tb_barang join tb_supplier on
tb_supplier.kode_supplier=tb_barang.supplier where kode_barang like '%" +
txtCariBarangUbah.getText() + "%' or nama_barang like '%" + txtCariBarangUbah.getText() +
"%'";pencarian5(sqlPencarian5);lebarKolom5();}privatevoidtabelBarangUbahMouseClicked(java.
awt.event.MouseEvent evt) { int bar = tabelBarangUbah.getSelectedRow(); String a =
tabmode3.getValueAt(bar, 0).toString(); String b = tabmode3.getValueAt(bar, 1).toString(); String
ctabmode3.getValueAt(bar2).toString();txtKodeBarangUbah.setText(b);
txtNamaBarangUbah.setText(c);listKodeBarangUbah.dispose();
txtJumlahBarangUbah.requestFocus();}privatevoidbtnCariBarangUbahActionPerformed(java.awt.
event.ActionEventevt)
{dataTable5();lebarKolom5();listKodeBarangUbah.setLocationRelativeTo(this);
listKodeBarangUbah.setVisible(true); } // Variables declaration - do not modify private
javax.swing.JButton btnBersih; private javax.swing.JButton btnCancelUbah; private
javax.swing.JButton btnCari; private javax.swing.JButton btnCariBarang; private
javax.swing.JButton btnCariBarangUbah; private javax.swing.JButton btnCariSupplier; private
javax.swing.JButton btnCariSupplierUbah; private javax.swing.JButton btnCetak; private
javax.swing.JButtonbtnHapus;private javax.swing.JButton btnSimpan; private
javax.swing.JButton btnSimpanUbah;privatejavax.swing.JButtonbtnTambah;private
com.toedter.calendar.JDateChooser btnTanggal; private com.toedter.calendar.JDateChooser
btnTanggalUbah; private javax.swing.JButton btnUbah; private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel10; private javax.swing.JLabel jLabel11; private
javax.swing.JLabel jLabel12; private javax.swing.JLabel jLabel13; private javax.swing.JLabel
jLabel14; private javax.swing.JLabel jLabel15; private javax.swing.JLabel jLabel16; private
javax.swing.JLabel jLabel17; private javax.swing.JLabel jLabel18; private javax.swing.JLabel
jLabel19; private javax.swing.JLabel jLabel20; private javax.swing.JLabel jLabel21; // End of
variables declaration }

Transaksi Penjualan
packagetampilan;importcom.sun.glass.events.KeyEvent;import java.awt.event.ActionEvent;import
java.io.File;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;
importjava.sql.SQLException;importjava.text.ParseException;importjava.text.SimpleDateFormat;i
mportjava.util.Date;importjava.util.HashMap;importjava.util.Locale;importjava.util.Map;importja
va.util.logging.Level;importjava.util.logging.Logger;importjavax.swing.JOptionPane;import
javax.swing.table.DefaultTableModel;importjavax.swing.table.TableColumn;import
koneksi.koneksi;importnet.sf.jasperreports.engine.JasperCompileManager;import
net.sf.jasperreports.engine.JasperFillManager;import net.sf.jasperreports.engine.JasperPrint;import
net.sf.jasperreports.engine.JasperReport;import
net.sf.jasperreports.engine.design.JasperDesign;import
net.sf.jasperreports.engine.xml.JRXmlLoader;import
net.sf.jasperreports.view.JasperViewer;importtampilan.data_barang;publicclass
transaksi_penjualan extends JasperReport JasRep; JasperPrint JasPri; Map param = new
HashMap(); JasperDesign JasDes; private void aktif() { tanggal_penjualan();
txtIdPenjualan.setEnabled(true);txtIdDetailPenjualan.setEnabled(true);
txtKodeCustomer.setEnabled(true);txtKodeBarang.setEnabled(true);
txtNamaBarang.setEnabled(true);txtHargaBarang.setEnabled(true);
txtJumlahBarang.setEnabled(true); txtTotalHarga.setEnabled(true); } protected void kosong()
{ tanggal_penjualan();txtIdPenjualan.setText;txtIdDetailPenjualan.setText;
txtKodeCustomer.setText;txtKodeBarang.setText;txtNamaBarang.setText;
txtHargaBarang.setText;txtJumlahBarang.setText;txtTotalHarga.setText;
txtIdPenjualanBayar.setText; txtBayar.setText; txtTotal.setText; txtKembali.setText; autoIdPJ();
autoIdPJ_DT(); } public void noTable() { int Baris = tabmode.getRowCount(); for (int a = 0; a <
Baris; a++) { String nomor = String.valueOf(a + 1); tabmode.setValueAt(nomor + ".", a, 0); } }
private void autoIdPJ() { try { Connection con = new koneksi().connect(); java.sql.Statement stat
= con.createStatement(); Date tanggal_update = new Date(); String tampilan = "MMyy";
SimpleDateFormat fm = new SimpleDateFormat(tampilan); String tanggal =
String.valueOf(fm.format(btnTanggal.getDate())); String sql = "select max(right (id_penjualan,4))
as no from tb_penjualan where id_penjualan like '%" + "PJ" + tanggal.toString() + "%'"; ResultSet
res = stat.executeQuery(sql); while (res.next()) { if (res.first() == false)
{ txtIdPenjualan.setText("PB" + tanggal.toString() + "0001"); } else { res.last(); int aut_id =
res.getInt(1) + 1; String no = String.valueOf(aut_id); int no_jual = no.length(); // mengatur
jumlah_barang 0 for (int j = 0; j < 4 - no_jual; j++) { no = "0" + no; } txtIdPenjualan.setText("PJ"
+ tanggal.toString() + no); } } res.close(); stat.close(); } catch (Exception e)
{ JOptionPane.showMessageDialog("Terjadi Kesalahan"); } } private void autoIdPJ_DT() { try
{ Connection con = new koneksi().connect(); java.sql.Statement stat = con.createStatement();
String sql_dt = "select max(right (id_dt_penjualan,2)) as no from tb_penjualan where
id_dt_penjualan like '%" + txtIdPenjualan.getText() + "%'"; ResultSet res_dt =
stat.executeQuery(sql_dt); while (res_dt.next()) { if (res_dt.first() == false)
{ txtIdDetailPenjualan.setText(txtIdPenjualan.getText() + "01"); } else { res_dt.last(); int
aut_id_dt = res_dt.getInt(1) + 1; String no_dt = String.valueOf(aut_id_dt); int no_jual_dt =
no_dt.length(); // mengatur jumlah_barang 0 for (int j = 0; j < 2 - no_jual_dt; j++) { no_dt = "0" +
no_dt; } } res_dt.close(); stat.close(); } catch (Exception e)
{ JOptionPane.showMessageDialog("Terjadi Kesalahan"); } } private void totalBayar() { int
jumlahBaris = tabmode4.getRowCount(); int totalBayar = 0; int hargaBarang, jmlhBarang; for (int
i = 0; i < jumlahBaris; i++) { jmlhBarang = Integer.parseInt(tabmode4.getValueAt(i,
2).toString()); hargaBarang = Integer.parseInt(tabmode4.getValueAt(i, 3).toString()); totalBayar =
totalBayar + (jmlhBarang * hargaBarang); txtTotal.setText("" + totalBayar); } } public void
cleanTable() { int baris2 = tabmode4.getRowCount(); for (int a = 0; a < baris2; a++)
{ tabmode4.removeRow(0); } } publicvoidlebarKolom3()
{TableColumncolumn3;tabelBarang.setAutoResizeMode(javax.swing.JTable.AUTO_RESIZE_A
LL_COLUMNS);column3= tabelBarang.getColumnModel().getColumn(0);
column3.setPreferredWidth(40); column3 = tabelBarang.getColumnModel().getColumn(1);
column3.setPreferredWidth(150); column3 = tabelBarang.getColumnModel().getColumn(2);
column3.setPreferredWidth(200); column3 = tabelBarang.getColumnModel().getColumn(3);
column3.setPreferredWidth(100); } public void lebarKolom4({TableColumncolumn2;
tabelCustomerUbah.setAutoResizeMode(javax.swing.JTable.AUTO_RESIZE_ALL_COLUMNS)
;column2=tabelCustomerUbah.getColumnModel().getColumn(0);
column2.setPreferredWidth(40);
column2=tabelCustomerUbah.getColumnModel().getColumn(1);column2.setPreferredWidth(150)
;column2=tabelCustomerUbah.getColumnModel().getColumn(2);
column2.setPreferredWidth(200); } public void lebarKolom6() { TableColumn column4; public
void dataTable() { Object[] Baris = {"No", "Tanggal", "ID Detail Penjualan", "ID Penjualan",
"Kode Customer", "Kode Barang", "Nama Barang", "Harga", "Qty", "Total Harga"}; tabmode =
new DefaultTableModel(Baris); tabelPenjualan.setModel(tabmode); String sql = "select * from
tb_penjualanorderbytanggal_penjualandesc"; try { java.sql.Statement stat =
conn.createStatement(); ResultSet hasil = stat.executeQuery(sql); while (hasil.next()) { String
tanggal_penjualan = hasil.getString("tanggal_penjualan"); String id_dt_penjualan =
hasil.getString("id_dt_penjualan"); String id_penjualan = hasil.getString("id_penjualan"); String
kode_customer = hasil.getString("kode_customer"); String kode_barang =
hasil.getString("kode_barang"); String nama_barang = hasil.getString("nama_barang"); String
harga_barang = hasil.getString("harga_barang"); String jumlah_barang=
hasil.getString("jumlah_barang"); String total_harga = hasil.getString("total_harga"); String[] data
= {"", tanggal_penjualan, id_dt_penjualan, id_penjualan, kode_customer, kode_barang,
nama_barang, harga_barang, jumlah_barang, total_harga}; tabmode3 = new
DefaultTableModel(Baris); tabelBarang.setModel(tabmode3); String sql = "select * from
tb_barang order by kode_barang asc"; try { } public void dataTable5() { Object[] Baris = {"No",
"Kode Barang", "Nama Barang", "Harga Barang"}; tabmode3 = new DefaultTableModel(Baris);
tabelBarangUbah.setModel(tabmode3); String sql = "select * from tb_barang order by
kode_barang asc"; try { java.sql.Statement stat = conn.createStatement(); ResultSet hasil =
stat.executeQuery(sql); while (hasil.next()) { String
kode_barang=hasil.getString("kode_barang");Stringnama_barang=hasil.getString("nama_barang")
; String harga_barang = hasil.getString("harga_jual"); String[] data = {"", kode_barang,
nama_barang, harga_barang}; tabmode3.addRow(data); lebarKolom5(); noTable3(); } } catch
(Exception e) { } } public void dataTable6() { Object[] Baris2 = {"No", "Nama Barang", "Harga
Barang", "Qty", "Total Harga"}; tabmode4 = new DefaultTableModel(Baris2);
tbDetailPenjualan.setModel(tabmode4); String sql = "select * from tb_penjualan where
id_penjualan='" + txtIdPenjualan.getText() + "'"; try { java.sql.Statement stat =
conn.createStatement(); ResultSet hasil2 = stat.executeQuery(sql); while (hasil2.next()) { String
nama_barang = hasil2.getString("nama_barang"); String harga_barang =
hasil2.getString("harga_barang"); String jumlah_barang = hasil2.getString("jumlah_barang");
String total_harga = hasil2.getString("total_harga"); String[] data = {"", nama_barang,
harga_barang, jumlah_barang, total_harga}; tabmode4.addRow(data); noTable5(); } } try
{ java.sql.Statement stat = conn.createStatement(); ResultSet hasil = stat.executeQuery(sql); while
(hasil.next()) { String tanggal_penjualan = hasil.getString("tanggal_penjualan"); String
id_dt_penjualan = hasil.getString("id_dt_penjualan"); String id_penjualan =
hasil.getString("id_penjualan"); String kode_customer = hasil.getString("kode_customer"); String
kode_barang = hasil.getString("kode_barang"); String nama_barang =
hasil.getString("nama_barang"); String jumlah_barang = hasil.getString("jumlah_barang"); } catch
(Exception e) { } ubahTransaksiPenjualan.setTitle("Ubah Transaksi Penjualan");
jLabel20.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel20.setText("Cari
Barang"); txtCariBarangUbah.setFont(new java.awt.Font("Tahoma", 0, 14)); //
NOI18NtxtCariBarangUbah.addKeyListener(newjava.awt.event.KeyAdapter(){publicvoid
keyTyped(java.awt.event.KeyEventevt)
{txtCariBarangUbahKeyTyped(evt);}});javax.swing.GroupLayoutjPanel9Layout=newjavax.swing
.GroupLayout(jPanel9);jPanel9.setLayout(jPanel9Layout);jPanel9Layout.setHorizontalGroup(.add
Component(txtCariBarangUbah,javax.swing.GroupLayout.PREFERRED_SIZE,264,
javax.swing.GroupLayout.PREFERRED_SIZE))).addGap(84,84,84)));
jPanel9Layout.setVerticalGroup(.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacemen
t.RELATED) .addComponent(jScrollPane7, javax.swing.GroupLayout.DEFAULT_SIZE, 375,
Short.MAX_VALUE).addContainerGap())jLabel20.getAccessibleContext().setAccessibleDescript
ion("");javax.swing.GroupLayoutlistKodeBarangUbahLayoutnewjavax.swing.GroupLayout(listKo
deBarangUbah.getContentPane());listKodeBarangUbah.getContentPane().setLayout(listKodeBara
ngUbahLayout);listKodeBarangUbahLayout.setHorizontalGroup(.addGroup(listKodeBarangUbah
Layout.createSequentialGroup()addContainerGap().addComponent(jPanel9,
javax.swing.GroupLayout.PREFERRED_SIZE, 430,
Short.MAX_VALUE) .addContainerGap()) ); .addContainerGap().addComponent(jPanel9,javax.s
wing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE) .addContainerGap()) ); jLabel24.setFont(new java.awt.Font("Tahoma", 0,
14)); // NOI18N jLabel24.setText("Cari Barang"); txtCariBarang.setFont(new
java.awt.Font("Tahoma", 0, 14)); // NOI18N
txtCariBarang.addKeyListener(newjava.awt.event.KeyAdapter(){publicvoid
keyTyped(java.awt.event.KeyEventevt){txtCariBarangKeyTyped(evt);}));
tabelBarang.setRowHeight(20);tabelBarang.addMouseListener(new
java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt)
{ tabelBarangMouseClicked(evt);} });Panel10Layout.createParallelGroup(javax.swing.GroupLayo
ut.Alignment.LEADING).addGroup(javax.swing.GroupLayout.Alignment.TRAILING,jPanel10La
yout.createSequentialGroup() .addContainerGap()));listKodeBarangLayout.setHorizontalGroup(.a
ddContainerGap() .addComponent(jPanel10,javax.swing.GroupLayout.PREFERRED_SIZE,430,
Short.MAX_VALUE).addContainerGap()));listKodeBarangLayout.setVerticalGroup( setClosable(
true)setMaximizable(true);setResizable(true);txtIdPenjualan.setEditable(false);
txtIdPenjualan.setFont(newjava.awt.Font("Tahoma",0,14));//NOI18N
txtIdPenjualan.addKeyListener(nejava.awt.event.KeyAdapter(){publicvoid
keyPressed(java.awt.event.KeyEventevt){txtIdPenjualanKeyPressed(evt);}});
btnTambah.setMaximumSize(newjava.awt.Dimension(100,40));
btnTambah.setMinimumSize(new java.awt.Dimension(100, 40)); jLabel7.setFont(new
java.awt.Font("Tahoma", 0, 14)); // NOI18N
jLabel7.setText("Tanggal");btnTanggal.setDateFormatString("dd-MM-yyyy");
btnTanggal.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel12.setFont(new
java.awt.Font("Tahoma",0,14))//NOI18NjLabel12.setText("NamaBarang");
txtJumlahBarang.setFont(newjava.awt.Font("Tahoma",0,14));//NOI18N
txtJumlahBarang.addKeyListener(newjava.awt.event.KeyAdapter(){publicvoid
keyPressed(java.awt.event.KeyEvent evt) { txtJumlahBarangKeyPressed(evt); }{ public void
actionPerformed(java.awt.event.ActionEventevt){btnSimpanActionPerformed(evt); }
txtIdDetailPenjualan.setEditable(false);txtIdDetailPenjualan.setBackground(new
java.awt.Color(255, 255, 255)); txtIdDetailPenjualan.setForeground(new java.awt.Color(255, 255,
255)); txtIdDetailPenjualan.setBorder; jLabel13.setFont(new java.awt.Font("Tahoma", 0, 14)); //
NOI18N jLabel13.setText("Total Harga"); txtTotalHarga.setFont(new java.awt.Font("Tahoma", 0,
14)); // NOI18N txtTotalHarga.addActionListener(new java.awt.event.ActionListener() { public
void actionPerformed(java.awt.event.ActionEvent evt) { txtTotalHargaActionPerformed(evt); } });
jLabel22.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N jLabel22.setText("Harga
Barang");txtHargaBarang.setEditable(false);txtHargaBarang.setFont(new
java.awt.Font("Tahoma", 0, 14)); // NOI18N txtHargaBarang.addActionListener(new
java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt)
{ txtHargaBarangActionPerformed(evt);}});txtHargaBarang.addKeyListener(new
java.awt.event.KeyAdapter() { btnBayar.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N
btnBayar.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/gambar/icons8_Receive_Cash_50px.png"))); //
NOI18NbtnBayar.setText("Bayar");btnBayar.setCursor(newjava.awt.Cursor(java.awt.Cursor.HAN
D_CURSOR));btnBayar.addActionListener(new java.awt.event.ActionListener() { public void
actionPerformed(java.awt.event.ActionEventevt)
{btnBayarActionPerformed(evt);txtCari.setFont(newjava.awt.Font("Tahoma",0,14));//
NOI18NtxtCari.addKeyListener(newjava.awt.event.KeyAdapter()
{publicvoidkeyTyped(java.awt.event.KeyEventevt)
{txtCariKeyTyped(evt);.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELAT
ED).addComponent(jPanel4,
javax.swing.GroupLayout.DEFAULT_SIZE,javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE).addContainerGap()));jPanel1Layout.setVerticalGroup( jPanel1Layout.creat
eParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.creat
eSequentialGroup().addComponent(jPanel2,
javax.swing.GroupLayout.PREFERRED_SIZE,javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap()) ); javax.swing.GroupLayout
layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout);
layout.setHorizontalGroup( .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE,
); layout.setVerticalGroup( .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) ); setBounds(50, 0, 1342,
600); }// </editor-fold> private void txtIdPenjualanKeyPressed(java.awt.event.KeyEvent evt) { if
(evt.getKeyCode() == KeyEvent.VK_ENTER) { txtKodeCustomer.requestFocus(); } } private
void txtKodeBarangKeyPressed(java.awt.event.KeyEventevt)privatevoid
btnTambahActionPerformed(java.awt.event.ActionEventevt){if
(txtIdPenjualan.getText().equals("")) { JOptionPane.showMessageDialog("ID Penjualan tidak
boleh kosong"); txtIdPenjualan.requestFocus(); } else if (txtKodeCustomer.getText().equals(""))
{ JOptionPane.showMessageDialog("KodeCustomertidakbolehkosong");
txtKodeCustomer.requestFocus();}elseif(txtKodeBarang.getText().equals(""))
{ JOptionPane.showMessageDialog("KodeBarangtidakbolehkosong");
txtKodeBarang.requestFocus();}elseif(txtNamaBarang.getText().equals(""))
{ JOptionPane.showMessageDialog("NamaBarangtidakbolehkosong");
txtNamaBarang.requestFocus();}elseif(txtHargaBarang.getText().equals(""))
{ JOptionPane.showMessageDialog("HargaBarangtidakbolehkosong");
txtHargaBarang.requestFocus();}elseif(txtJumlahBarang.getText().equals(""))
{ JOptionPane.showMessageDialog("Qty tidak boleh kosong");
txtJumlahBarang.requestFocus(); } else if (txtTotalHarga.getText().equals(""))
{ JOptionPane.showMessageDialog("Total Harga tidak boleh kosong");
txtTotalHarga.requestFocus(); } else { String sql = "insert into tb_penjualan values
(?,?,?,?,?,?,?,?,?)"; String tampilan = "yyyy-MM-dd"; SimpleDateFormat fm = new
SimpleDateFormat(tampilan);Strintanggal_penjualan=String.valueOf(fm.format(btnTanggal.getD
ate()));privatevoidbtnHapusActionPerformed(java.awt.event.ActionEventevt)
{intok=JOptionPane.showConfirmDialog(" Apakah Anda Yakin Ingin " + "Menghapus Data",
"Konfirmasi Dialog", JOptionPane.YES_NO_OPTION); if (ok == 0) { String sql = "delete from
tb_penjualan where id_dt_penjualan='" + txtIdDetailPenjualan.getText() + "'"; try
{ PreparedStatement stat = conn.prepareStatement(sql); stat.executeUpdate();
JOptionPane.showMessageDialog("Data Berhasil Dihapus"); kosong(); autoIdPJ();
autoIdPJ_DT(); dataTable(); lebarKolom();
txtIdPenjualan.requestFocus();privatevoidtxtKodeBarangUbahKeyPressed(java.awt.event.KeyEve
ntevt){if(evt.getKeyCode()==KeyEvent.VK_ENTER)
{ btnCariBarangUbahActionPerformed(new ActionEvent(evt.getKeyCode(), evt.getID(), "Cari
Kategori")); } } private void btnSimpanUbahActionPerformed(java.awt.event.ActionEvent evt)
{ String sql = "update
tb_penjualantanggal_penjualan=?,id_dt_penjualan=?,id_penjualan=?,kode_customer=?,kode_bara
ng=?,nama_barang=?,harga_barang=?,jumlah_barang=?,total_harga=? where id_dt_penjualan='"
+ txtIdDetailPenjualanUbah.getText()+"'";SimpleDateFormatfm=new
SimpleDateFormat(tampilan);Stringtanggal_penjualan=String.valueOf(fm.format(btnTanggalUba
h.getDate()));try{PreparedStatementstat= conn.prepareStatement(sql); stat.executeUpdate();
JOptionPane.showMessageDialog("Data Berhasil Diubah"); // String refresh = "select * from
tb_barang";kosong();autoIdPJ();autoIdPJ_DT();dataTable();lebarKolom();txtIdPenjualan.requestF
ocus();ubahTransaksiPenjualan.dispose();txtKodeBarang.setEnabled(true);txtKodeCustomer.setEn
abled(true);}catch(SQLExceptione){ JOptionPane.showMessageDialog("Data Gagal Diubah" +
e); privatevoidbtnCancelUbahActionPerformed(java.awt.event.ActionEventevt)
{ ubahTransaksiPenjualan.setVisible(false);}privatevoidbtnUbahActionPerformed(java.awt.event.
ActionEventevt)
{ubahTransaksiPenjualan.setLocationRelativeTo(this);txtIdPenjualanUbah.setEditable(false);ubah
TransaksiPenjualan.setVisible(true);}privatevoidbtnCariActionPerformed(java.awt.event.ActionE
vent evt) { String sqlPencarian = "select * from tb_penjualan where id_penjualan like '%" +
txtCari.getText() + "%'" + "or id_dt_penjualan like '%" + txtCari.getText() + "%'" + "or
nama_barang like '%" + txtCari.getText() + "%'" + "or kode_barang like '%" + txtCari.getText() +
"%'" + "or kode_customer like '%" + txtCari.getText() + "%'"; pencarian(sqlPencarian);
lebarKolom(); noTable(); } private void tabelPenjualanMouseClicked(java.awt.event.MouseEvent
evt) { int bar = tabelPenjualan.getSelectedRow(); String a = tabmode.getValueAt(bar,
0).toString(); String b = tabmode.getValueAt(bar, 1).toString(); String c =
tabmode.getValueAt(bar, 2).toString(); String d = tabmode.getValueAt(bar, 3).toString(); String e
= tabmode.getValueAt(bar, 4).toString(); String f = tabmode.getValueAt(bar, 5).toString(); String
g = tabmode.getValueAt(bar, 6).toString(); String h = tabmode.getValueAt(bar, 7).toString();
String i = tabmode.getValueAt(bar, 8).toString();
Stringj=tabmode.getValueAt(bar,9).toString();SimpleDateFormatdate=new
SimpleDateFormat("yyyy-MM-dd"); Date dateValue = ; try { dateValue = date.parse((String)
tabelPenjualan.getValueAt(bar,1));}catch(ParseExceptionex)
{ Logger.getLogger(transaksi_penjualan.class.getName()).log(Level.SEVERE,ex);}
btnTanggal.setDate(dateValue);btnTanggalUbah.setDate(dateValue);
txtIdDetailPenjualan.setText(c); txtIdDetailPenjualanUbah.setText(c); txtIdPenjualan.setText(d);
txtIdPenjualanUbah.setText(d); txtIdPenjualanBayar.setText(d); txtKodeCustomer.setText(e);
txtKodeCustomerUbah.setText(e); txtKodeBarang.setText(f); txtKodeBarangUbah.setText(f);
txtNamaBarang.setText(g);txtNamaBarangUbah.setText(g)txtHargaBarang.setText(h);
txtHargaBarangUbah.setText(h); txtJumlahBarang.setText(i); txtJumlahBarangUbah.setText(i);
txtTotalHarga.setText(j); txtTotalHargaUbah.setText(j); txtBayar.setText; txtKembali.setText;
String sql = "select * from tb_pembayaran where id_penjualan ='" + txtIdPenjualan.getText() +
"'"; try { java.sql.Statement stat = conn.createStatement(); ResultSet hasil =
stat.executeQuery(sql); while (hasil.next()) { String tanggal_penjualan =
hasil.getString("tanggal_penjualan"); String
id_penjualan=hasil.getString("id_penjualan");Stringkode_customer=
hasil.getString("kode_customer"); String total_penjualan = hasil.getString("total_penjualan");
String jumlah_pembayaran = hasil.getString("jumlah_pembayaran"); String jumlah_kembali =
hasil.getString("jumlah_kembali");txtIdPenjualanBayar.setText(id_penjualan);
txtTotal.setText(total_penjualan);txtBayar.setText(jumlah_pembayaran);
txtKembali.setText(jumlah_kembali);}}catch(Exceptionex)privatevoid
tabelCustomerMouseClicked(java.awt.event.MouseEventevt){intbar=
tabelCustomer.getSelectedRow(); String a = tabmode2.getValueAt(bar, 0).toString(); String b =
tabmode2.getValueAt(bar, 1).toString(); String c = tabmode2.getValueAt(bar, 2).toString();
txtKodeCustomer.setText(b);//txtKategoriUbah.setText(c);listCustomer.dispose();
txtKodeBarang.requestFocus(); } private void
txtCariCustomerKeyTyped(java.awt.event.KeyEvent evt) { String sqlPencarian2 = "select * from
tb_customer where kode_customer like '%" + txtCariCustomer.getText() + "%' or nama_customer
like '%" + txtCariCustomer.getText() + "%'";
pencarian2(sqlPencarian2);lebarKolom2();}privatevoid
tabelCustomerUbahMouseClicked(java.awt.event.MouseEvent evt) { int bar =
tabelCustomerUbah.getSelectedRow(); String a = tabmode2.getValueAt(bar, 0).toString(); String
b = tabmode2.getValueAt(bar, 1).toString(); String c = tabmode2.getValueAt(bar, 2).toString();
txtKodeCustomerUbah.setText(b);listCustomerUbah.dispose();txtKodeBarangUbah.requestFocus(
);}privatevoid btnSimpanActionPerformed(java.awt.event.ActionEvent evt) { kosong();
autoIdPJ();
autoIdPJ_DT();dataTable();lebarKolom();txtIdPenjualan.setEnabled(true);txtKodeCustomer.setEn
abled(true); }private void txtBayarKeyPressed(java.awt.event.KeyEvent evt) { if
(evt.getKeyCode()==KeyEvent.VK_ENTER)
{btnBayarActionPerformed(newActionEvent(evt.getKeyCode(),evt.getID()"KeyPressHitung"));pr
ivatevoidbtnBayarActionPerformed(java.awt.event.ActionEventevt)
{intkembali=Integer.parseInt(txtBayar.getText())Integer.parseInt(txtTotal.getText());txtKembali.se
tText(""+kembali);if(txtBayar.getText().equals("")|| txtKembali.getText().equals("") )
{ JOptionPane.showMessageDialog("Masukan jumlah yang dibayar", "Pembayaran",
JOptionPane.ERROR_MESSAGE); } else { String sql = "insert into tb_pembayaran values
(?,?,?,?,?,?)"; String tampilan = "yyyy-MM-dd"; SimpleDateFormat fm =
newSimpleDateFormat(tampilan);StringtanggalString.valueOf(fm.format(btnTanggal.getDate()));t
ry{PreparedStatementstat=conn.prepareStatement(sql);stat.setString(1,tanggal.toString());stat.setSt
ring(2,txtIdPenjualan.getText())stat.setString(3,txtKodeCustomer.getText());stat.setString(4,
txtTotal.getText()); stat.setString(5, txtBayar.getText()); stat.setString(6, txtKembali.getText());
stat.executeUpdate();JOptionPane.showMessageDialog("TransaksiBerhasilDibayar","Pembayaran
",JOptionPane.PLAIN_MESSAGE);}catch(SQLExceptione)
{txtIdPenjualanBayar.setText;txtTotal.setText;txtBayar.setText;txtKembali.setText;JOptionPane.s
howMessageDialog("TransaksiIniSudahdibayar","Pembayaran",JOptionPane.ERROR_MESSAG
E);//Variablesdeclaration-donotmodifyprivate javax.swing.JButton btnBayar; private
javax.swing.JButton btnBersih; private
javax.swing.JButtonbtnCancel;privatjavax.swing.JButtontnCancelUbah;private
javax.swing.JButtonbtnCari;privatejavax.swing.JButtonbtnCariBarang;private
javax.swing.JButton btnCariBarangUbah; private javax.swing.JButton btnCariCustomer; private
javax.swing.JButton btnCariCustomerUbah; private javax.swing.JButton btnHapus; private
javax.swing.JButton btnSimpan; private javax.swing.JButton btnSimpanUbah; private
javax.swing.JButton btnTambah; private com.toedter.calendar.JDateChooser btnTanggal; private
com.toedter.calendar.JDateChooser btnTanggalUbah; private javax.swing.JButton btnUbah;
private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel10; private
javax.swing.JLabel jLabel11; private javax.swing.JLabel jLabel12; private javax.swing.JLabel
jLabel13; private javax.swing.JLabel jLabel14; private javax.swing.JLabel jLabel15; private
javax.swing.JLabel jLabel16; private javax.swing.JLabel jLabel17; private javax.swing.JLabel
jLabel18; private javax.swing.JLabel jLabel19; private javax.swing.JLabel jLabel20; private
javax.swing.JLabel jLabel21; private javax.swing.JLabel jLabel22; private javax.swing.JLabel
jLabel23; private javax.swing.JLabel jLabel24; private javax.swing.JLabel jLabel25; private
javax.swing.JLabel jLabel26; private javax.swing.JLabel jLabel27; private javax.swing.JLabel
jLabel28; private javax.swing.JLabel jLabel29; private javax.swing.JLabel jLabel3; private
javax.swing.JLabel jLabel30; private javax.swing.JLabel jLabel31; 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.JLabel
jLabel9; private javax.swing.JPanel jPanel1; private javax.swing.JPanel jPanel10; private
javax.swing.JPanel jPanel2; private javax.swing.JPanel jPanel3; private javax.swing.JPanel
jPanel4; private javax.swing.JPanel jPanel5; private javax.swing.JPanel jPanel6; private
javax.swing.JPanel jPanel7; private javax.swing.JPanel jPanel9; private javax.swing.JScrollPane
jScrollPane2; private javax.swing.JScrollPane jScrollPane3; private javax.swing.JScrollPane
jScrollPane4; private javax.swing.JScrollPane jScrollPane5; private javax.swing.JScrollPane
jScrollPane7; private javax.swing.JScrollPane jScrollPane8; private javax.swing.JDialog
listCustomer; private javax.swing.JDialog listCustomerUbah; private javax.swing.JDialog
listKodeBarang; private javax.swing.JDialog listKodeBarangUbah; private javax.swing.JTable
tabelBarang; private javax.swing.JTable tabelBarangUbah; private javax.swing.JTable
tabelCustomer; private javax.swing.JTable tabelCustomerUbah; private javax.swing.JTable
tabelPenjualan; private javax.swing.JTable tbDetailPenjualan; private javax.swing.JTextField
txtBayar; private javax.swing.JTextField txtCari; private javax.swing.JTextField txtCariBarang;
private javax.swing.JTextField txtCariBarangUbah;
privatejavax.swing.JTextFieldtxtCariCustomer;privatejaax.swing.JTextFieldtxtCariCustomerUbah
;privatejavax.swing.JTextFieldtxtHargaBarang;privatejavax.swing.JTextFieldtxtHargaBarangUba
h;privatejavax.swing.JTextFieldtxtIdDetailPenjualan;privatejavax.swing.JTextField
txtIdDetailPenjualanUbah;privatejavax.swing.JTextFieldtxtIdPenjualan;
privatejavax.swing.JTextFieldtxtIdPenjualanBayar;privatejavax.swing.JTextField
txtIdPenjualanUbah;privatejavax.swing.JTextFieldtxtJumlahBarang;private
javax.swing.JTextField txtJumlahBarangUbah; private javax.swing.JTextField txtKembali; private
javax.swing.JTextField txtKodeBarang; private javax.swing.JTextField txtKodeBarangUbah;
privatejavax.swing.JTextFieldtxtKodeCustomer;privatejavax.swing.JTextField
txtKodeCustomerUbah;privatejavax.swing.JTextFieldtxtNamaBarang;private
javax.swing.JTextField txtNamaBarangUbah; private javax.swing.JTextField txtTotal; private
javax.swing.JTextField txtTotalHarga; private javax.swing.JTextField txtTotalHargaUbah; private
javax.swing.JDialog ubahTransaksiPenjualan; // End of variables declaration