MUHAMMAD DIMAS_ 181011400883_PERTEMUAN KE 9
Tugas Pemograman 2 Pertemuan 9
Program Pendaftaran Seminar
- TextField 1 = nama
- TextField 2 = email
- TextField 3 = no_telp
- TextField 4 = alamat
- ComboBox = statusComboBox
- CheckBox 1 = laki
- CheckBox 2 = perempuan
- CheckBox 3 = bca
- CheckBox 4 = bri
- CheckBox 5 = mandiri
- CheckBox 6 = uang_tunai
- Button 1 = jButton1
- Button 2 = dataTable
- Button 3 = clear
- Button 4 = hapus
public daftar_seminar() {initComponents();koneksi();kosongkan();status();tabel();Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();Dimension frameSize = getSize();setLocation((screenSize.width - frameSize.width) / 3,(screenSize.height - frameSize.height) / 4);}
private void koneksi(){
try{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://127.0.0.1/database_kontak", "root", "");
stat = (Statement) con.createStatement();
}catch (Exception e){
JOptionPane.showMessageDialog(null, e);
}
}
private void kosongkan(){
nama.setText("");
email.setText("");
no_telp.setText("");
alamat.setText("");
nama.requestFocus();
statusComboBox.setSelectedIndex(-1);
}
private void status(){
statusComboBox.setSelectedIndex(-1);
}
private void tabel(){DefaultTableModel t= new DefaultTableModel();t.addColumn("Nama");t.addColumn("Email");t.addColumn("No telp");t.addColumn("Status");t.addColumn("Alamat");t.addColumn("JKelamin");t.addColumn("Pembayaran");Table.setModel(t); try{ res=stat.executeQuery("select * from data_seminar");while (res.next()){t.addRow(new Object[] { res.getString("nama"),res.getString("email"),res.getString("no_telp"),res.getString("status"),res.getString("alamat"),res.getString("jk"),res.getString("bayar")});}} catch (Exception e){JOptionPane.showMessageDialog(rootPane, e);}}
15. Tambahkan actionPerformed pada TextField 1 / nama
try{
res=stat.executeQuery("Select * from data_seminar where "+ "nama='" +nama.getText()
+"'" ); while (res.next())
{ nama.setText(res.getString("nama"));
email.setText(res.getString("email"));
no_telp.setText(res.getString("no_kontak"));
statusComboBox.setSelectedItem(res.getString("status"));
laki.setText(res.getString("jk"));
perempuan.setText(res.getString("jk"));
bca.setText(res.getString("bayar"));
bri.setText(res.getString("bayar"));
mandiri.setText(res.getString("bayar"));
uang_tunai.setText(res.getString("bayar"));
alamat.setText(res.getString("alamat"));
}
} catch (Exception e){
JOptionPane.showMessageDialog(rootPane, e);
}
16. Lalu isikan perintah dibawah ini untuk Button Simpan dan Refresh
17. Dengan cara actionPerformed, Klik kanan - Events - action - actionPerformed
try{
stat.executeUpdate("insert into data_seminar values ("
+"'" + nama.getText()+"',"
+"'" + email.getText()+"',"
+"'" + no_telp.getText()+"',"
+"'" + alamat.getText()+"',"
+"'" + jk+"',"
+"'" + bayar+"',"
+"'" + statusComboBox.getSelectedItem()+ "')");
kosongkan();
JOptionPane.showMessageDialog(null, "Berhasil Menyimpan Data");
} catch (Exception e){
JOptionPane.showMessageDialog(null, "Perintah Salah : "+e);
}
}
DefaultTableModel model = (DefaultTableModel) Table.getModel();
model.setRowCount(0);
tabel();
18. Tambahkan juga actionPerformed untuk Button Hapus
19. Dan tambahkan fitur click Table ke Textfield
20. Klik kanan pada table - Events - Mouse - mouseClicked
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_seminar where nama='"+nama.getText()+"'";
PreparedStatement st=con.prepareStatement(sql);
st.executeUpdate();
JOptionPane.showMessageDialog(null, "Delete Data Sukses");
}
catch (Exception e)
{
JOptionPane.showMessageDialog(null, "Delete Data Gagal");
}
}
int i = Table.getSelectedRow();
if(i==-1){
return;
}
String code = (String)Table.getValueAt(i,0);
String code1 = (String)Table.getValueAt(i,1);
String code2 = (String)Table.getValueAt(i,2);
String code3 = (String)Table.getValueAt(i,3);
String code4 = (String)Table.getValueAt(i,4);
String code5 = (String)Table.getValueAt(i,5);
nama.setText(code);
email.setText(code1);
no_telp.setText(code2);
alamat.setText(code3);
statusComboBox.setSelectedItem(code4);
}
21. Tambahkan action performed pada Button clear
22. Masukan action performed lagi untuk Checkbox laki, perempuan, bca, bri, mandiri dan uang tunai
23. Import MySQL Connector pada Libraries
25. Lalu Run file tersebut
26. Nanti akan muncul tampilan seperti ini
27. Data juga langsung tersimpan kedalam database
Tidak ada komentar: