23 0 152 KB
Membuat Form Data Pelanggan
1. Koneksi Database package koneksi; import java.sql.*; public class koneksi { private Connection koneksi; public Connection connect(){ try{ Class.forName("com.mysql.jdbc.Driver"); System.out.println("berhasil konek"); } catch(ClassNotFoundException ex){ System.out.println("gagal koneksi"+ex); } String url = "jdbc:mysql://localhost/penjualan"; try{ koneksi = DriverManager.getConnection(url,"root",""); System.out.println("berhasil koneksi database");
} catch (SQLException ex){ System.out.println("gagal koneksi database"+ex); } return koneksi; } }
2. Import dan Method Pelanggan package penjualan; import java.sql.*; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import java.awt.event.KeyEvent; import koneksi.koneksi; public class pelanggan extends javax.swing.JFrame { private Connection conn = new koneksi().connect(); private DefaultTableModel tabmode; public pelanggan() { initComponents(); kosong(); aktif(); datatable(); } 3. Method Aktif protected void aktif(){ txtid.requestFocus(); } 4. Method Kosong protected void kosong(){ txtid.setText(""); txtnm.setText(""); txttelp.setText(""); txtalamat.setText(""); txtcari.setText(""); buttonGroup1.clearSelection(); }
5. Datatable dan Cari protected void datatable(){ Object[] Baris ={"ID Pelanggan","Nama","Jenis Kelamin","No. Telepon","Alamat"}; tabmode = new DefaultTableModel(null, Baris); String cariitem=txtcari.getText(); try { String sql = "SELECT * FROM pelanggan where id like '%"+cariitem+"%' or nmplgn like '%"+cariitem+"%' order by id asc"; Statement stat = conn.createStatement(); ResultSet hasil = stat.executeQuery(sql); while (hasil.next()){ tabmode.addRow(new Object[]{ hasil.getString(1), hasil.getString(2), hasil.getString(3), hasil.getString(4), hasil.getString(5) }); } tblplgn.setModel(tabmode); } catch (Exception e) { JOptionPane.showMessageDialog(null, "data gagal dipanggil"+e); } } 6. Tombol Simpan private void bsimpanActionPerformed(java.awt.event.ActionEvent evt) { String jenis = null; if(rlaki.isSelected()){ jenis = "Laki-Laki"; }else if(rperempuan.isSelected()){ jenis = "Perempuan"; } String sql = "insert into pelanggan values (?,?,?,?,?)"; try{ PreparedStatement stat = conn.prepareStatement(sql); stat.setString(1, txtid.getText()); stat.setString(2, txtnm.getText()); stat.setString(3, jenis); stat.setString(4, txttelp.getText()); stat.setString(5, txtalamat.getText()); stat.executeUpdate(); JOptionPane.showMessageDialog(null, "data berhasil disimpan"); kosong(); txtid.requestFocus(); } catch (SQLException e){ JOptionPane.showMessageDialog(null, "data gagal disimpan"+e); }
datatable(); } 7. Tombol Ubah private void bubahActionPerformed(java.awt.event.ActionEvent evt) { String jenis = null; if(rlaki.isSelected()){ jenis = "Laki-Laki"; }else if(rperempuan.isSelected()){ jenis = "Perempuan"; } try{ String sql = "update pelanggan set nmplgn=?,jenis=?,telepon=?,alamat=? where id='"+txtid.getText()+"'"; PreparedStatement stat = conn.prepareStatement(sql); stat.setString(1, txtnm.getText()); stat.setString(2, jenis); stat.setString(3, txttelp.getText()); stat.setString(4, txtalamat.getText()); stat.executeUpdate(); JOptionPane.showMessageDialog(null, "data berhasil diubah"); kosong(); txtid.requestFocus(); } catch (SQLException e){ JOptionPane.showMessageDialog(null, "data gagal diubah"+e); } datatable(); } 8. Tombol Hapus private void bhapusActionPerformed(java.awt.event.ActionEvent evt) { int ok = JOptionPane.showConfirmDialog(null,"hapus","konfirmasi dialog",JOptionPane.YES_NO_OPTION); if (ok==0){ String sql = "delete from pelanggan where id ='"+txtid.getText()+"'"; try{ PreparedStatement stat = conn.prepareStatement(sql); stat.executeUpdate(); JOptionPane.showMessageDialog(null, "data berhasil dihapus"); kosong(); txtid.requestFocus(); } catch (SQLException e){ JOptionPane.showMessageDialog(null, "data gagal dihapus"+e); } datatable(); } }
9. Tombol Keluar private void bkeluarActionPerformed(java.awt.event.ActionEvent evt) { dispose(); } 10. Tombol Batal private void bbatalActionPerformed(java.awt.event.ActionEvent evt) { kosong(); datatable(); } 11. Table Klik private void tblplgnMouseClicked(java.awt.event.MouseEvent evt) { int bar = tblplgn.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(); txtid.setText(a); txtnm.setText(b); if ("Laki-Laki".equals(c)) { rlaki.setSelected(true); } else{ rperempuan.setSelected(true); } txttelp.setText(d); txtalamat.setText(e); } 12. Tombol Cari private void bcariActionPerformed(java.awt.event.ActionEvent evt) { datatable(); } 13. Text Cari KeyPressed private void txtcariKeyPressed(java.awt.event.KeyEvent evt) { if (evt.getKeyCode() == KeyEvent.VK_ENTER) { datatable(); } }