Scribd
Upload
23 views5 pages

Praktikum 2

The document outlines a Java program for an admin management system, detailing the design of the form and the code implementation. It includes functionalities for adding, saving, deleting, and searching admin data, as well as updating the display table. The program utilizes a database connection and handles user interactions through various buttons and text fields.

Uploaded by

Wina Yolanda
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
23 views5 pages

Praktikum 2

The document outlines a Java program for an admin management system, detailing the design of the form and the code implementation. It includes functionalities for adding, saving, deleting, and searching admin data, as well as updating the display table. The program utilizes a database connection and handles user interactions through various buttons and text fields.

Uploaded by

Wina Yolanda
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 5

Praktikum 2 Bahasa Pemrograman 3 20181

Program Admin
1. Desain Form

2. Kode program
- Import library
package view;
import java.sql.*;
import javax.swing.*;
import database.Konekdb;
import javax.swing.table.DefaultTableModel;

- Deklarasi variable
public class FormAdmin extends javax.swing.JFrame {
private Connection conn;
private Statement stt;

- Kode program pada constructor


public FormAdmin() {
initComponents();
bersih();
tampildata();
btnHapus.setEnabled(false);
}

- Kode program pada tombol tambah


private void btnTambahActionPerformed(java.awt.event.ActionEvent evt) {
bersih();
txtid.requestFocus();
}
Praktikum 2 Bahasa Pemrograman 3 20181

- Kode program pada tombol simpan


private void btnSimpanActionPerformed(java.awt.event.ActionEvent evt) {

try{
String id=txtid.getText();
String nama =txtnama.getText();
String pass = txtpassword.getText();
String stat=null ;
if(rbaktif.isSelected()){
stat = "1";
}
if(rbtidakaktif.isSelected()){
stat = "0";
}
conn = Konekdb.getKoneksi();
stt = conn.createStatement();
String label = btnSimpan.getText();
if(label.equals("Simpan")){
String sql = "insert into admin "
+ "values('"+ id +"', '"+ nama +"','"+ pass +"','"+ stat +"')";
stt.executeUpdate(sql);
conn.close();
stt.close();
JOptionPane.showMessageDialog(null,"Data berhasil di simpan");
}
else {
String sql = "update admin set adminnama='"+ nama +"', "
+ "adminpass= md5('"+ pass +"'), "
+ "adminstatus='"+ stat +"'"
+ "where adminid='"+ id +"' ";
stt.executeUpdate(sql);
stt.close();
conn.close();
JOptionPane.showMessageDialog(null,"Data berhasil di update");
}
bersih();
tampildata();

}catch (Exception e){


JOptionPane.showMessageDialog(null,"Proses penyimpanan gagal/koneksi
gagal.." + e);
System.out.println(e.getMessage());
}
}
Praktikum 2 Bahasa Pemrograman 3 20181

- Kode program pada tombol hapus


private void btnHapusActionPerformed(java.awt.event.ActionEvent evt) {
int Pilih = JOptionPane.showConfirmDialog(null,"Hapus data ini ...
?","Konfirmasi",JOptionPane.YES_NO_OPTION);

if(Pilih == JOptionPane.YES_OPTION){
try {
conn = Konekdb.getKoneksi();
stt = conn.createStatement();
String sql ="delete from admin where adminid='"+ txtid.getText() +"'";
stt.executeUpdate(sql);
stt.close();
conn.close();
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "Error " + e);
}
}
}

- Kode program pada table mouse cklik


private void tabelMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
if(evt.getClickCount()==1){
int j = tabel.getSelectedRow();
String id = tabel.getValueAt(j, 0).toString();
txtid.setText(id);
cekdata();
}
}

- Kode program pada textfield cari


private void txtcariActionPerformed(java.awt.event.ActionEvent evt) {
DefaultTableModel tbl = new DefaultTableModel();
tbl.addColumn("Id Admin");
tbl.addColumn("Nama");
tbl.addColumn("Status");

try{
conn = Konekdb.getKoneksi();
stt = conn.createStatement();

String sql = "SELECT adminid, adminnama, "


+ "IF(adminstatus=1,'Aktif','Tidak Aktif') AS stat "
+ "FROM admin where adminnama like '%"+ txtcari.getText() +"%'";
Praktikum 2 Bahasa Pemrograman 3 20181
ResultSet rs = stt.executeQuery(sql);
while(rs.next())
{
tbl.addRow(new Object[]{
rs.getString(1),
rs.getString(2),
rs.getString(3)
});
}
tabel.setModel(tbl);
conn.close();
}catch (SQLException e){
JOptionPane.showMessageDialog(null, "Ada Kesalahan"+e);
}
}

- Method bersih, tampildata dan cekdata


private void bersih(){
txtid.setText("");
txtnama.setText("");
txtpassword.setText("");
}

private void tampildata(){


DefaultTableModel tbl = new DefaultTableModel();
tbl.addColumn("Id Admin");
tbl.addColumn("Nama");
tbl.addColumn("Status");
try{
conn = Konekdb.getKoneksi();
stt = conn.createStatement();

String sql = "SELECT adminid, adminnama, "


+ "IF(adminstatus=1,'Aktif','Tidak Aktif') AS stat "
+ "FROM admin";
ResultSet rs = stt.executeQuery(sql);
while(rs.next())
while(rs.next())
{
tbl.addRow(new Object[]{
rs.getString(1),
rs.getString(2),
rs.getString(3)
});
}
Praktikum 2 Bahasa Pemrograman 3 20181
tabel.setModel(tbl);
conn.close();
}catch (SQLException e){
JOptionPane.showMessageDialog(null, "Ada Kesalahan"+e);
}
}

private void cekdata(){


try {
conn = Konekdb.getKoneksi();
stt = conn.createStatement();
String sql = "select * from admin where adminid='"+ txtid.getText() +"'";
ResultSet rs = stt.executeQuery(sql);
if (rs.next()){
btnSimpan.setText("Update");
btnHapus.setEnabled(true);
txtnama.setText(rs.getString("adminnama"));
txtpassword.setText(rs.getString("adminpass"));
String stat ="";
stat = rs.getString("adminstatus");

if (stat.equals("1")){
rbaktif.setSelected(true);
}
else
rbtidakaktif.setSelected(true);
}

} catch (Exception e) {
JOptionPane.showMessageDialog(null, "Error " + e);
}
}

3. Tampilan program

You might also like