Tutorial Pemrograman Java Netbeans Dengan Mysql
Pemrograman II
2016
Membuat Aplikasi Inventory Barang Tahap Awal Buatlah rancangan database dengan susunan tabel sebagai berikut: barang -
kd_barang varchar(10) primary key
-
nama_barang varchar(30)
-
kategori varchar(10)
-
qty int
users -
id int auto_increment primary key
-
username varchar(30)
-
password varchar(15)
-
level varchar(10)
request -
id_request int auto_increment primary key
-
kd_barang varchar(10)
-
id int
-
tgl_request date
Tahap Pengembangan
1. Buatlah project baru dalam netbeans,beri nama Inventory. Untuk create main class tidak perlu dicentang. Kemudian klik finish.
Farida Nurlaila
Page 2
Pemrograman II
2016
Membuat Aplikasi Inventory Barang Tahap Awal Buatlah rancangan database dengan susunan tabel sebagai berikut: barang -
kd_barang varchar(10) primary key
-
nama_barang varchar(30)
-
kategori varchar(10)
-
qty int
users -
id int auto_increment primary key
-
username varchar(30)
-
password varchar(15)
-
level varchar(10)
request -
id_request int auto_increment primary key
-
kd_barang varchar(10)
-
id int
-
tgl_request date
Tahap Pengembangan
1. Buatlah project baru dalam netbeans,beri nama Inventory. Untuk create main class tidak perlu dicentang. Kemudian klik finish.
Farida Nurlaila
Page 2
Pemrograman II
2016
2. Tambahkan dateTimePicker pada swing control Pallete dengan mengklik Tools pada menu bar-pallete-Swing/AWT Components. Kemudian akan tampil halaman berikut:
3. Klik Add from JAR pada gambar di atas, kemudian browse ke directory netbeans C:\Program Files\NetBeans 8.0.1\ide\modules\ext\swingx-all-1.6.4.jar 4. Kemudian klik next,akan tampil halaman berikut kemudian pilih JXDatePicker dan klik finish.
Farida Nurlaila
Page 3
Pemrograman II
2016
5. Buatlah sebuah package dengan klik kanan pada source package kemudian pilih java package, beri nama package tersebut dengan model. 6. Klik kanan pada package model, pilih java class kemudian beri nama Koneksi. Isikan class Koneksi dengan source code berikut: public static String driver = "com.mysql.jdbc.Driver"; public static String database = "jdbc:mysql://localhost:3306/inventory"; public static String user = "root"; public static String password = "";
Farida Nurlaila
Page 4
Pemrograman II
2016
7. Buatlah sebuah package baru dengan nama view, kemudian klik kanan pada package view kemudian pilih JFrameForm(beri nama LoginForm). 8. Buatlah LoginForm dengan tampilan seperti gambar berikut(username menggunakan textfield,password menggunakan password field):
9. Klik kanan pada button reset pilih events-actionPerformed, kemudian isikan source code berikut: txtUsername.setText(""); txtPassword.setText(""); 10. Klik kanan pada button login pilih events-actionPerformed, kemudian isikan source code berikut: if(txtUsername.getText().isEmpty()) { JOptionPane.showMessageDialog(null, "Username harus diisi!"); if (txtPassword.getPassword().length == 0){ JOptionPane.showMessageDialog(null, "Password harus diisi!"); }else{ JOptionPane.showMessageDialog(null, "Username Kosong!"); } } else if (txtPassword.getPassword().length == 0) JOptionPane.showMessageDialog(null, "Password harus diisi!"); else{
Farida Nurlaila
Page 5
Pemrograman II
2016
String user = txtUsername.getText(); char[] pass = txtPassword.getPassword(); String pwd = String.copyValueOf(pass); if(validate_login(user,pwd)) JOptionPane.showMessageDialog(null, "Login Sukses"); else JOptionPane.showMessageDialog(null, "Gagal Login"); } 11. Generate validate login, kemudian isikan source code berikut: try{ Class.forName(Koneksi.driver); // MySQL database connection Connection conn = DriverManager.getConnection(Koneksi.database+"?user="+ Koneksi.user+"&password="+Koneksi.password+""); //mencocokan isian textfield username dan password ke database PreparedStatement pst = conn.prepareStatement( "Select * from users where username=? and password=?"); pst.setString(1, username); pst.setString(2, password); ResultSet rs = pst.executeQuery(); if(rs.next()){ // mendeklarasikan form utama dan create constructor MainForm formUtama = new MainForm(username,password); formUtama.setVisible(true); this.dispose(); return true; } else{ return false; } } catch(Exception e){ e.printStackTrace(); return false; } 12. Pada static void String, deklarasikan kembali form login LoginForm login = new LoginForm(); login.setVisible(true); 13. Debug aplikasi
Farida Nurlaila
Page 6
Pemrograman II
2016
14. Klik kanan pada package view, pilih JFrameForm beri nama MainForm. Buatlah desainnya seperti gambar di bawah
Tambahkan menu item barang dan tambah user pada master data, me nu item request barang dan cek data transaksi, menu item g anti password pada option. 15. Tambahkan deklarasi berikut diantara class MainForm public static FormBarang formBarang = new FormBarang(); public static FormUser formUser = new FormUser(); private String pass,user; 16. Tambahkan constructor pada MainForm public MainForm(String username, String password) { pass = password; user = username; initComponents(); setFrame(0.9,true); } 17. Generate method setFrame private void setFrame(double scale, boolean middle) { Toolkit tk = Toolkit.getDefaultToolkit(); Dimension dt = tk.getScreenSize(); setSize((int)(scale*dt.getWidth()), (int)(scale*dt.getHeight())); if (middle){ setLocation((int)((dt.getWidth()-getWidth())/2), (int)((dt.getHeight()-getHeight())/2)); } }
Farida Nurlaila
Page 7
Pemrograman II
2016
18. Buatlah class Barang pada package model dan tambahkan source code berikut package model; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import javax.swing.JOptionPane; /** * * @author Farida */ public class Barang { private String kdBarang,namaBarang,kategori; private int qty; public String getKdBarang() { return kdBarang; } public void setKdBarang(String kdBarang) { this.kdBarang = kdBarang; } public String getNamaBarang() { return namaBarang; } public void setNamaBarang(String namaBarang) { this.namaBarang = namaBarang; } public String getKategori() { return kategori; } public void setKategori(String kategori) { this.kategori = kategori; }
Farida Nurlaila
Page 8
Pemrograman II
2016
public int getQty() { return qty; } public void setQty(int qty) { this.qty = qty; } public boolean simpan_barang() { int jumlahSimpan=0; try { Class.forName(Koneksi.driver); // MySQL database connection Connection conn = DriverManager.getConnection(Koneksi.database+"?user="+Koneksi.user+"&password="+Kon eksi.password+""); PreparedStatement pst = conn.prepareStatement("INSERT INTO barang(kd_barang, nama_barang, kategori, qty) VALUES (?,?,?,?)"); pst.setString(1, kdBarang); pst.setString(2, namaBarang); pst.setString(3, kategori); pst.setInt(4, qty); jumlahSimpan = pst.executeUpdate(); if(jumlahSimpan > 0) { JOptionPane.showMessageDialog(null, "simpan data berhasil"); } }catch(Exception e) { } return true; } } 19. Buatlah class User pada package model dan t ambahkan source code berikut
Farida Nurlaila
Page 9
Pemrograman II
2016
package model; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.swing.JOptionPane;
/** * * @author Farida */ public class User {
private Connection conn=null; private PreparedStatement pst = null; private String username,password,level,old_password; public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getLevel() { return level; }
Farida Nurlaila
Page 10
Pemrograman II
2016
public void setLevel(String level) { this.level = level; } public String getOld_password() { return old_password; } public void setOld_password(String old_password) { this.old_password = old_password; } public boolean simpan_datauser() { int jumlahSimpan = 0; try { getConnection(); pst = conn.prepareStatement("INSERT INTO users(username, password, level) VALUES (?,?,?)"); pst.setString(1, username); pst.setString(2, password); pst.setString(3, level); jumlahSimpan = pst.executeUpdate(); if(jumlahSimpan > 0) { JOptionPane.showMessageDialog(null, "simpan data berhasil"); } }catch(Exception e) { } return true; } public Connection getConnection() throws ClassNotFoundException, SQLException { Class.forName(Koneksi.driver); // MySQL database connection conn = DriverManager.getConnection(Koneksi.database+"?user="+ Koneksi.user+"&password="+Koneksi.password+"");
Farida Nurlaila
Page 11
Pemrograman II
2016
return conn; } public boolean updatePassword() { try { getConnection(); pst = conn.prepareStatement( "Select * from users where password=?"); pst.setString(1, old_password); ResultSet rs = pst.executeQuery(); if(rs.next()){ updateEx(); } else { JOptionPane.showMessageDialog(null, "password lama tidak sesuai!"); } } catch(Exception e) { } return true; } private void updateEx() { int jumlah = 0; try { getConnection(); pst = conn.prepareStatement("UPDATE users SET password=? WHERE username=?"); pst.setString(1, password); pst.setString(2, username); jumlah = pst.executeUpdate(); if(jumlah > 0)
Farida Nurlaila
Page 12
Pemrograman II
2016
{ JOptionPane.showMessageDialog(null, "update data berhasil"); } }catch(Exception e) { JOptionPane.showMessageDialog(null, e); } } } 20. Buatlah class Request dan tambahkan source code berikut package model; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.swing.JOptionPane; /** * * @author Farida */ public class Request { private String tgl_request,kd_barang; private int user_id,stok; private Connection conn; private PreparedStatement pst = null; public String getTgl_request() { return tgl_request; } public void setTgl_request(String tgl_request) { this.tgl_request = tgl_request; } public String getKd_barang() {
Farida Nurlaila
Page 13
Pemrograman II
2016
return kd_barang; } public void setKd_barang(String kd_barang) { this.kd_barang = kd_barang; } public int getUser_id() { return user_id; } public void setUser_id(int user_id) { this.user_id = user_id; } public int getStok() { return stok; } public void setStok(int stok) { this.stok = stok; } public Connection getConn() { return conn; } public void setConn(Connection conn) { this.conn = conn; } public PreparedStatement getPst() { return pst; } public void setPst(PreparedStatement pst) { this.pst = pst; } public Connection getConnection() throws ClassNotFoundException, SQLException { Class.forName(Koneksi.driver); // MySQL database connection conn = DriverManager.getConnection(Koneksi.database+"?user="+
Farida Nurlaila
Page 14
Pemrograman II
2016
Koneksi.user+"&password="+Koneksi.password+""); return conn; } public boolean simpan_request() { int jumlahSimpan = 0; try { getConnection(); pst = conn.prepareStatement("INSERT INTO request(kd_barang, id, tgl_request) VALUES (?,?,?)"); pst.setString(1, kd_barang); pst.setInt(2, user_id); pst.setString(3, tgl_request); jumlahSimpan = pst.executeUpdate(); if(jumlahSimpan > 0) { //JOptionPane.showMessageDialog(null, "simpan data berhasil"); sumStok(); } }catch(Exception e) { JOptionPane.showMessageDialog(null, "simpan data gagal="+ e); } return true; } private void updateStok(int jml) { int jumlah = 0; try { getConnection(); pst = conn.prepareStatement("UPDATE barang SET qty=? WHERE kd_barang=?"); pst.setInt(1, jml);
Farida Nurlaila
Page 15
Pemrograman II
2016
pst.setString(2, kd_barang); jumlah = pst.executeUpdate(); if(jumlah > 0) { JOptionPane.showMessageDialog(null, "simpan data berhasil"); } }catch(Exception e) { JOptionPane.showMessageDialog(null, e); } } private void sumStok() { int jml_stok =0; try { getConnection(); pst = conn.prepareStatement( "Select qty from barang where kd_barang=?"); pst.setString(1, kd_barang); ResultSet rs = pst.executeQuery(); if(rs.next()){ stok = rs.getInt("qty"); jml_stok = stok - 1; updateStok(jml_stok); } } catch(Exception e) { } } } 21. Pada menu keluar tambahkan event MouseClicked dan tambahkan System.exit(0);
Farida Nurlaila
Page 16
Pemrograman II
2016
22. Tambahkan source code untuk menampilkan masing-masing form dari MainForm Form barang private void jMenuItemBarangActionPerformed(java.awt.event.ActionEvent evt) { if (formBarang.isVisible()) { try { formBarang.setSelected(true); } catch (Exception ex) {} } else { formBarang = new FormBarang(); mdiDesktopPane.add(formBarang); formBarang.setVisible(true); } } Form Tambah User private void jMenuItemUserActionPerformed(java.awt.event.ActionEvent evt) { if (formUser.isVisible()) { try { formUser.setSelected(true); } catch (Exception ex) {} } else { formUser = new FormUser(); mdiDesktopPane.add(formUser); formUser.setVisible(true); } } Form Ganti Password private void menuItemGantiPasswordActionPerformed(java.awt.event.ActionEvent evt) { FormUbahPassword formReInputPass = new FormUbahPassword(user,pass); if (formReInputPass.isVisible()) { try { formReInputPass.setSelected(true); } catch (Exception ex) {} } else { //formReInputPass = new FormUbahPassword(); mdiDesktopPane.add(formReInputPass); formReInputPass.setVisible(true); } }
Farida Nurlaila
Page 17
Pemrograman II
2016
Form Request private void jMenuItemRequestActionPerformed(java.awt.event.ActionEvent evt) { FormTransaksi transaksiRequest = new FormTransaksi(user); if (transaksiRequest.isVisible()) { try { transaksiRequest.setSelected(true); } catch (Exception ex) {} } else { //formReInputPass = new FormUbahPassword(); mdiDesktopPane.add(transaksiRequest); transaksiRequest.setVisible(true); } } Form cek data private void jMenuItemCekDataActionPerformed(java.awt.event.ActionEvent evt) { FormDataTransaksi dataTransaksi = new FormDataTransaksi(); if (dataTransaksi.isVisible()) { try { dataTransaksi.setSelected(true); } catch (Exception ex) {} } else { mdiDesktopPane.add(dataTransaksi); dataTransaksi.setVisible(true); } } 23. Buatlah form barang pada package view dengan tampilan seperti gambar
Farida Nurlaila
Page 18
Pemrograman II
2016
package view; import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; import java.sql.ResultSet; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import model.Barang; import model.Koneksi; /** * * @author Farida */ public class FormBarang extends javax.swing.JInternalFrame {
Farida Nurlaila
Page 19
Pemrograman II
2016
private String kode_barang,nama_barang,kategori_barang; private int stok; private int baris; private static final Object[] columnNames = {"Kode Barang", "Nama Barang", "Kategori", "Stok"}; DefaultTableModel mdl = new DefaultTableModel(columnNames,baris); /** * Creates new form FormBarang */ public FormBarang() { initComponents(); } private void btnSimpanActionPerformed(java.awt.event.ActionEvent evt) {
Barang brg = new Barang(); if(txtKode.getText().isEmpty() || txtNamaBarang.getText().isEmpty() ||txtQty.getText().isEmpty()) { JOptionPane.showMessageDialog(null,"textbox masih kosong!"); } else { kode_barang = txtKode.getText(); nama_barang = txtNamaBarang.getText(); kategori_barang = cmbKategori.getSelectedItem().toString(); stok = Integer.parseInt(txtQty.getText()); brg.setKdBarang(kode_barang); brg.setNamaBarang(nama_barang); brg.setKategori(kategori_barang); brg.setQty(stok); brg.simpan_barang(); } }
Farida Nurlaila
Page 20
Pemrograman II
2016
private void btnResetActionPerformed(java.awt.event.ActionEvent evt) { txtKode.setText(""); txtNamaBarang.setText(""); txtQty.setText(""); cmbKategori.setSelectedIndex(0); } private void btnTutupActionPerformed(java.awt.event.ActionEvent evt) { this.dispose(); } private void formComponentShown(java.awt.event.ComponentEvent evt) { jTable1.setModel(mdl); try{ Class.forName(Koneksi.driver); // MySQL database connection Connection conn = DriverManager.getConnection(Koneksi.database+"?user="+ Koneksi.user+"&password="+Koneksi.password+""); Statement s = conn.createStatement(); String sql = "SELECT * FROM barang"; ResultSet r = s.executeQuery(sql); while(r.next()){ Object [] o = new Object[4]; o[0] = r.getString("kd_barang"); o[1] = r.getString("nama_barang"); o[2] = r.getString("kategori"); o[3] = r.getString("qty"); mdl.addRow(o); } } catch(Exception e){ e.printStackTrace(); } } } 24. Buatlah form input user
Farida Nurlaila
Page 21
Pemrograman II
2016
package view; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import model.Koneksi; import model.User; /** * * @author Farida */
Farida Nurlaila
Page 22
Pemrograman II
2016
public class FormUser extends javax.swing.JInternalFrame { private String user,pass,level; private int baris; private static final Object[] columnNames = {"User ID", "Username", "Level"}; DefaultTableModel mdl = new DefaultTableModel(columnNames,baris); /** * Creates new form FormUser */ public FormUser() { initComponents(); } private void btnSimpanActionPerformed(java.awt.event.ActionEvent evt) { User dataUser = new User(); if(txtUser.getText().isEmpty() || txtPass.getPassword().length == 0) { JOptionPane.showMessageDialog(null, "TextBox Tidak boleh kosong!"); }else{ user = txtUser.getText(); char[] password = txtPass.getPassword(); pass = String.copyValueOf(password); level = cmbLevel.getSelectedItem().toString(); dataUser.setUsername(user); dataUser.setPassword(pass); dataUser.setLevel(level); dataUser.simpan_datauser(); jTable1.setModel(mdl); } } private void formComponentShown(java.awt.event.ComponentEvent evt) { jTable1.setModel(mdl); try{ Class.forName(Koneksi.driver); // MySQL database connection Connection conn = DriverManager.getConnection(Koneksi.database+"?user="+ Koneksi.user+"&password="+Koneksi.password+""); Statement s = conn.createStatement(); String sql = "SELECT * FROM users"; ResultSet r = s.executeQuery(sql);
Farida Nurlaila
Page 23
Pemrograman II
2016
while(r.next()){ Object [] o = new Object[3]; o[0] = r.getString("id"); o[1] = r.getString("username"); o[2] = r.getString("level"); mdl.addRow(o); } } catch(Exception e){ e.printStackTrace(); } } private void btnResetActionPerformed(java.awt.event.ActionEvent evt) { txtUser.setText(""); txtPass.setText(""); cmbLevel.setSelectedIndex(0); } private void btnTutupActionPerformed(java.awt.event.ActionEvent evt) { this.dispose(); } } 25. Buatlah form ubah password
Farida Nurlaila
Page 24
Pemrograman II
2016
package view; import javax.swing.JOptionPane; import model.User; /** * * @author Farida */ public class FormUbahPassword extends javax.swing.JInternalFrame { private String old_pass,new_pass,password,username; /** * Creates new form FormUbahPassword */
public FormUbahPassword(String user, String pass) { password = pass; username = user; initComponents(); txtUser.setText(username); txtUser.enable(false); }
private void btnTutupActionPerformed(java.awt.event.ActionEvent evt) { this.dispose(); } private void btnResetActionPerformed(java.awt.event.ActionEvent evt) { txtOldPass.setText(""); txtNewPass.setText(""); } private void btnSimpanActionPerformed(java.awt.event.ActionEvent evt) { User data_user = new User(); if(txtOldPass.getPassword().length == 0 || txtNewPass.getPassword().length == 0)
Farida Nurlaila
Page 25
Pemrograman II
2016
{ JOptionPane.showMessageDialog(null,"password harus diisi!"); } else { char [] o_p = txtOldPass.getPassword(); char [] n_p = txtNewPass.getPassword(); old_pass = String.copyValueOf(o_p); new_pass = String.copyValueOf(n_p); data_user.setUsername(username); data_user.setPassword(new_pass); data_user.setOld_password(old_pass); data_user.updatePassword(); } } } 26. Buatlah form transaksi
Farida Nurlaila
Page 26
Pemrograman II
2016
package view; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.TreeMap; import javax.swing.JOptionPane; import model.Koneksi; import model.Request; /** * * @author Farida */ public class FormTransaksi extends javax.swing.JInternalFrame {
private String date,username,id_barang,nama_barang; private int id_user; private TreeMap categoryMap = new TreeMap(); /** * Creates new form FormTransaksi */ public FormTransaksi(String user) { username = user; initComponents(); getCombobox(); getIdUser(); } private void btnTutupActionPerformed(java.awt.event.ActionEvent evt) { this.dispose(); }
Farida Nurlaila
Page 27
Pemrograman II
2016
private void btnSimpanActionPerformed(java.awt.event.ActionEvent evt) { //DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy"); //datePickerRequest.setFormats(dateFormat); DateFormat sysDate = new SimpleDateFormat("yyyy/MM/dd"); date = sysDate.format(datePickerRequest.getDate()).toString(); Request req = new Request(); req.setUser_id(id_user); req.setKd_barang(id_barang); req.setTgl_request(date); req.simpan_request(); }
// Variables declaration - do not modify private javax.swing.JButton btnSimpan; private javax.swing.JButton btnTutup; private javax.swing.JComboBox cmbBarang; private org.jdesktop.swingx.JXDatePicker datePickerRequest; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; // End of variables declaration private void getCombobox() { try { Class.forName(Koneksi.driver); Connection conn = DriverManager.getConnection(Koneksi.database+"?user="+ Koneksi.user+"&password="+Koneksi.password+""); Statement stat = conn.createStatement(); ResultSet rs = stat.executeQuery("SELECT kd_barang, nama_barang FROM barang"); cmbBarang.removeAllItems(); cmbBarang.addItem("-Pilih-"); while(rs.next()){ nama_barang = rs.getString("nama_barang"); id_barang = rs.getString("kd_barang"); cmbBarang.addItem(nama_barang); categoryMap.put(id_barang, nama_barang); } rs.close();
Farida Nurlaila
Page 28
Pemrograman II
2016
conn.close(); } catch (Exception e){ JOptionPane.showMessageDialog(this, e.toString()); e.printStackTrace(); } } private void getIdUser() { try { Class.forName(Koneksi.driver); Connection conn = DriverManager.getConnection(Koneksi.database+"?user="+ Koneksi.user+"&password="+Koneksi.password+""); PreparedStatement pst = conn.prepareStatement( "Select id from users where username=?"); pst.setString(1, username); ResultSet rs = pst.executeQuery(); if(rs.next()){ id_user = rs.getInt("id"); } } catch(Exception e) { JOptionPane.showMessageDialog(null, e); } } } 27. Buatlah form cek data transaksi
Farida Nurlaila
Page 29
Pemrograman II
2016
package view; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.text.DateFormat; import java.text.SimpleDateFormat; import javax.swing.table.DefaultTableModel; import model.Koneksi; /** * * @author Farida */ public class FormDataTransaksi extends javax.swing.JInternalFrame {
Farida Nurlaila
Page 30
Pemrograman II
2016
private String tgl_mulai,tgl_akhir; private int baris; private static final Object[] columnNames = {"Tanggal", "Nama Karyawan", "Nama Barang"}; DefaultTableModel mdl = new DefaultTableModel(columnNames,baris); /** * Creates new form FormDataTransaksi */ public FormDataTransaksi() { initComponents(); } private void btnSortActionPerformed(java.awt.event.ActionEvent evt) { DateFormat sysDate = new SimpleDateFormat("yyyy/MM/dd"); tgl_mulai = sysDate.format(jXDatePickerMulai.getDate()).toString(); tgl_akhir = sysDate.format(jXDatePickerAkhir.getDate()).toString(); try{ Class.forName(Koneksi.driver); // MySQL database connection Connection conn = DriverManager.getConnection(Koneksi.database+"?user="+ Koneksi.user+"&password="+Koneksi.password+""); PreparedStatement pst = conn.prepareStatement( "Select request.tgl_request,users.username,barang.nama_barang from request JOIN barang ON barang.kd_barang=request.kd_barang JOIN users ON users.id=request.id WHERE request.tgl_request BETWEEN ? AND ?");
pst.setString(1, tgl_mulai); pst.setString(2, tgl_akhir); ResultSet rs = pst.executeQuery(); while(rs.next()){ Object [] o = new Object[3]; o[0] = rs.getString("tgl_request"); o[1] = rs.getString("username"); o[2] = rs.getString("nama_barang"); mdl.addRow(o); } } catch(Exception e){
Farida Nurlaila
Page 31
