- Pada pertemuan 16 dan 17 ini, buatlah manajemen user, untuk menambah user dan menghapus user yang dapat login.
1. Buka Xampp dan aktifkan Apache dan MySQL.
2. Buka NetBeans
3. Buat JFrame baru.
4. Buat tampilan seperti ini. Hampir sama seperti forum login.
5. Tambahkan source code seperti ini.
private Connection con;
private Statement stat;
/**
* Creates new form daftar
*/
public daftar() {
initComponents();
koneksi();
clear();
}
private void clear(){
jTextField1.setText(null);
jTextField2.setText(null);
jTextField1.requestFocus();
}
void koneksi() {
try {
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:Mysql://127.0.0.1/pendaftaranseminar","root","");
stat=con.createStatement();
}catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {try {stat.executeUpdate("insert into data_user values ("+ "'" + jTextField1.getText()+"',"+ "'" + jTextField2.getText() +" ') ");JOptionPane.showMessageDialog(null, "Berhasil Menyimpan Data");}catch (Exception e){JOptionPane.showMessageDialog(rootPane, "Gagal");}clear();}private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {login lg = new login();lg.setVisible(true);dispose();}
8. Pada menu Hapus akun klik kanan events - mouse - mouseClicked, dan juga tambahkan code untuk button menu. Tambahkan source code :
private void jMenu2MouseClicked(java.awt.event.MouseEvent evt) {hapus hps = new hapus();hps.setVisible(true);dispose();}private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {daftar dft = new daftar();dft.setVisible(true);dispose();// TODO add your handling code here:}
private Connection con;private Statement stat;private ResultSet res;private String t;private DefaultTableModel dtm;/*** Creates new form hapus*/public hapus() {initComponents();koneksi();//memanggil public void Koneksi();tabel();//memanggil public void Tabel();kosongkan();}private void koneksi() {try {Class.forName("com.mysql.jdbc.Driver");con=DriverManager.getConnection("jdbc:Mysql://127.0.0.1/pendaftaranseminar","root","");stat=con.createStatement();}catch(Exception e){JOptionPane.showMessageDialog(null, e);}}private void kosongkan() //variabel kosongkan untuk menghapus data yang diinput pada :{jTextField1.setText(""); //JTextFieldjTextField2.setText(""); //JTextFieldjTextField1.requestFocus(); //kursor kembali ke JTextField}
private void tabel(){DefaultTableModel t= new DefaultTableModel();t.addColumn("username");t.addColumn("password");jTable1.setModel(t);String cari = jTextField1.getText();try{int no = 1;String sql = "select * from data_user where username like '%" + cari + "%'";java.sql.Statement stat = con.createStatement();java.sql.ResultSet res = stat.executeQuery(sql);while(res.next()){t.addRow(new Object[] {res.getString("username"), res.getString("password"),});}}catch (Exception e) {JOptionPane.showMessageDialog(rootPane, e);}}
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {login lg = new login();lg.setVisible(true);dispose();}private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {int ok=JOptionPane.showConfirmDialog(null,"Apakah Yakin Mendelete record ini???","Confirmation",JOptionPane.YES_NO_CANCEL_OPTION);if (ok==0){try{String sql="delete from data_user where username='"+jTextField1.getText()+"'";PreparedStatement st=con.prepareStatement(sql);st.executeUpdate();JOptionPane.showMessageDialog(null, "Delete Data Sukses");}catch (Exception e){JOptionPane.showMessageDialog(null, "Delete Data Gagal");}}}
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {DefaultTableModel model = (DefaultTableModel) jTable1.getModel();model.setRowCount(2);tabel();}private void jTextField1KeyReleased(java.awt.event.KeyEvent evt) {tabel();// TODO add your handling code here:}private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {int i = jTable1.getSelectedRow();if(i==-1){return;}String code = (String)jTable1.getValueAt(i,0);String code1 = (String)jTable1.getValueAt(i,1);jTextField1.setText(code);jTextField2.setText(code1); // TODO add your handling code here:}
15. Setelah semua selesai, klik run untuk mencoba dan akan tampil seperti gambar dibawah ini.
0 Response to "Rifka Heryadi_171011400875_Pertemuan 16_17"
Posting Komentar