Modul X_JAVA SWING CRUD JDBC.pdf

7/26/2019 Modul X_JAVA SWING CRUD JDBC.pdf

1/20

Juni 4, 2016 [MODUL PRAKTIKUM PEMROGRAMAN BERORIENTASI OBYEK]

MODUL X

JAVA SWING JDBC CRUD

1. Tujuan

a. Mahasiswa melakukan mengkoneksikan program Java GUI dengan basis data

b. Mahasiswa mampu mengimplementasikan CRUD melalui Java GUI.

c. Mahasiswa mampu mengolah statement SQL melalui program Java GUI.

2. Latihan praktikum

Pada kegiatan praktikum ini, IDE NetBeans digunakan sebagai alat perangkat lunak untuk

melakukan pemrograman Java. IDE NetBeans tidak wajib digunakan pada umumnya tidak wajib

atau bukan patokan sebagai IDE untuk program Java terutama untuk integrasinya ke database.

Adapun jenis database yang dipakai adalah MySQL yang terdapat pada program Web Server

seperti XAMPP, WAMP, dan lainnya. Kegiatan latihan terdiri dari kegiatan-kegiatan berikut ini:

1) Buka IDE NetBeans hingga muncul window yang siap pakai


2/20


2) Aktifkan Web Server yang telah terinstal

3) Pastikan MySQL telah aktif, dan amati port yang dibuka (ditandai kotak warna merah)

4) Kembali ke IDE NetBeans, dan buat project baru (File-New Project)


3/20


5) Pilih tipe JavaJava Application, klik Next

6) Beri nama project, klik Finish

7) Project baru terbentuk


4/20


8) Klik kanan LibrariesAdd Library

9) Cari dan Pilih JDBC MySQL Driver, Klik Add Library

10) Muncul driver MySQL

11) Klik kanan package, pilih New, pilih Other


5/20


12) Pada Categories pilih Swing GUI Forms, dan pada File Types pilih JDialog Form, klik Next

13) Pada menu berikutnya, ganti nama form, dan klik Finish

14) Form terbentuk, lanjutkan dengan klik ganda Form tersebut


6/20


15) Muncul menu Palette

16) Drag drop komponen Palette dengan struktur dan komponen yang sama pada contoh di

bawah

.

Nomor Komponen Property Keterangan/nilai

1. JTabel model Hapus semua baris yang tercipta secara default

2. JPanel1 border Pilihtitled border

3. JLabel1 text Id Pegawai

4. JLabel2 text Nama Lengkap

5. JLabel3 text Jenis Kelamin

6. JLabel4 text Departemen

7. JLabel5 text Posisi

8. JButton1 text Tambah

variabel tombol_tambah9. JButton2 text Update

variabel tombol_update

10. JButton3 text Hapus

variabel tombol_hapus

11. JButton4 text Print All

variabel tombol_print_all


7/20


12. JButton5 text Close

variabel tombol_close

13. JTextField1 text

variabel txtIdPegawai


variabel txtNamaLengkap15. JCombo text Tambahkan item Laki-laki dan Perempuan

variabel cboJenisKelamin


variabel txtDepartemen


variabel txtPosisi


variabel txtGaji

17)

Buat database beserta isinya berdasarkan keterangan di bawah ini.

No Jenis Attribut: Keterangan

1. Database pegawai

2. Tabel data_pegawai

Attribut: Id_Pegawai INTEGER (3) PRIMARY KEY NOT NULL

Attribut: nama_lengkap VARCHAR (40)

Attribut: jenis_kelamin VARCHAR (10)

Attribut: departemen VARCHAR (45)

Attribut: posisi VARCHAR (45)

Attibut: gaji INTEGER (12)

Tabel: data_pegawai

Id_Pegawai nama_lengkap jenis_kelamin departemen posisi gaji

100 Bruce Wayne Laki-laki Admin CEO 18000

101 Barbara Gordon Perempuan IT Staff 9000

18) Buat class Config.java untuk koneksi ke Form

package jdbc_crud;

public class Config {

public static final String DATABASE_NAME = "PEGAWAI";public static final String DATABASE_SERVER = "localhost";public static final String DATABASE_USER_ID = "root";public static final String DATABASE_PASSWORD = "";

public static final String connection_url = "jdbc:mysql://" + DATABASE_SERVER +"/" + DATABASE_NAME;}


8/20


19) Buat class DBUtilities.java untuk inisialisasi class dan database

package jdbc_crud;

import java.sql.*;

public class DBUtilities {

Connection connection = null;Statement statement = null;ResultSet resultSet = null;

public DBUtilities() throws SQLException {try {

connection = DriverManager.getConnection(Config.connection_url,Config.DATABASE_USER_ID, Config.DATABASE_PASSWORD);

} catch (SQLException ex) {System.out.println("Terjadi kesalahan: " + ex.getMessage());

}}

public Connection getConnection() {return connection;

}

public void ExecuteSQLStatement(String sql_stmt) {try {

statement = connection.createStatement();

statement.executeUpdate(sql_stmt);} catch (SQLException ex) {

System.out.println("Terjadi kesalahan: " + ex.getMessage());}

}}

20) Buat class ResultSetTableModel.java untuk menerima parameter string statement SQL yang

digunakan untuk menerima data.

package jdbc_crud;

import java.sql.*;import javax.swing.table.AbstractTableModel;

public class ResultSetTableModel extends AbstractTableModel {

private Connection connection;private final Statement statement;

private ResultSet resultSet;private ResultSetMetaData metaData;private int numberOfRows;

private boolean connectedToDatabase = false;

private void SetDatabaseURL() throws SQLException {try {


} catch (SQLException sex) {


9/20


System.out.println(sex.getMessage());}

}

public ResultSetTableModel(String query) throws SQLException {

SetDatabaseURL();


statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

connectedToDatabase = true;

if (!connectedToDatabase) {throw new IllegalStateException("Tidak tersambung dengan Database");

}

resultSet = statement.executeQuery(query);metaData = resultSet.getMetaData();resultSet.last();

numberOfRows = resultSet.getRow();

fireTableStructureChanged();

}

@Overridepublic Class getColumnClass(int column) throws IllegalStateException {


}

try {String className = metaData.getColumnClassName(column + 1);return Class.forName(className);

} catch (ClassNotFoundException | SQLException ex) {System.out.println(ex.getMessage());}

return Object.class;}

@Overridepublic int getColumnCount() throws IllegalStateException {


}

try {return metaData.getColumnCount();

} catch (SQLException sex) {System.out.println(sex.getMessage());}

return 0;}

@Overridepublic String getColumnName(int column) throws IllegalStateException {



10/20


}

try {return metaData.getColumnName(column + 1);

} catch (SQLException sex) {System.out.println(sex.getMessage());

}

return "";}

@Overridepublic int getRowCount() throws IllegalStateException {


}

return numberOfRows;}

@Overridepublic Object getValueAt(int row, int column)

throws IllegalStateException {if (!connectedToDatabase) {throw new IllegalStateException("Tidak tersambung dengan Database");

}

try {resultSet.absolute(row + 1);return resultSet.getObject(column + 1);


}

return "";}

public void disconnectFromDatabase() {if (connectedToDatabase) {try {

resultSet.close();statement.close();connection.close();


} finally {connectedToDatabase = false;

}}

}}

21) Pada class project yang utama, masukkan kode berikut

/** To change this license header, choose License Headers in Project Properties.* To change this template file, choose Tools | Templates* and open the template in the editor.*/package jdbc_crud;


11/20


import java.sql.SQLException;import javax.swing.JOptionPane;import javax.swing.SwingConstants;import javax.swing.event.ListSelectionEvent;import javax.swing.table.DefaultTableCellRenderer;

/**

** @author Enggar*/public class FormCRUD extends javax.swing.JDialog {

boolean addRecord = false;

private void clearInputBoxes() {txtIdPegawai.setText("");txtNamaLengkap.setText("");cboJenisKelamin.setSelectedItem("");txtDepartemen.setText("");txtPosisi.setText("");txtGaji.setText("");

}

private void addNew() throws SQLException {String sql_stmt = "INSERT INTO Data_Pegawai

(Id_Pegawai,nama_lengkap,departemen, jenis_kelamin,posisi,gaji)";sql_stmt += " VALUES ('"+ txtIdPegawai.getText() + "','" +

txtNamaLengkap.getText() + "','" + cboJenisKelamin.getSelectedItem().toString()+ "','" + txtDepartemen.getText() + "','" + txtPosisi.getText() + "','" +txtGaji.getText() + "')";

DBUtilities dbUtilities = new DBUtilities();

dbUtilities.ExecuteSQLStatement(sql_stmt);}

private void updateRecord() throws SQLException {String sql_stmt = "UPDATE Data_Pegawai SET Id_Pegawai = '" +txtIdPegawai.getText() + "'";

sql_stmt += "'nama_lengkap = '" + txtNamaLengkap.getText() + "'";sql_stmt += ",jenis_kelamin = '" +

cboJenisKelamin.getSelectedItem().toString() + "'";sql_stmt += ",departemen = '" + txtDepartemen.getText() + "'";sql_stmt += ",posisi = '" + txtPosisi.getText() + "'";sql_stmt += ",gaji = '" + txtGaji.getText() + "'";sql_stmt += " WHERE Id_Pegawai = '" + txtIdPegawai.getText() + "'";



private void deleteRecord() throws SQLException {String sql_stmt = "DELETE FROM Data_Pegawai WHERE Id_Pegawai = '" +

txtIdPegawai.getText() + "'";



private void loadRecords() throws SQLException {


12/20


String sql_stmt = "SELECT * FROM Data_Pegawai;";

ResultSetTableModel tableModel = new ResultSetTableModel(sql_stmt);

jTable1.setModel(tableModel);

jTable1.getSelectionModel().addListSelectionListener((ListSelectionEvent event)-> {

try {if (jTable1.getSelectedRow() >= 0) {

Object Id_Pegawai =jTable1.getValueAt(jTable1.getSelectedRow(), 0);

Object nama_lengkap =jTable1.getValueAt(jTable1.getSelectedRow(), 1);

Object jenis_kelamin =jTable1.getValueAt(jTable1.getSelectedRow(), 2);

Object departemen =jTable1.getValueAt(jTable1.getSelectedRow(), 3);

Object posisi =jTable1.getValueAt(jTable1.getSelectedRow(), 4);

Object gaji = jTable1.getValueAt(jTable1.getSelectedRow(),5);

txtIdPegawai.setText(Id_Pegawai.toString());txtNamaLengkap.setText(nama_lengkap.toString());cboJenisKelamin.setSelectedItem(jenis_kelamin.toString());txtDepartemen.setText(departemen.toString());txtPosisi.setText(posisi.toString());txtGaji.setText(gaji.toString());

}} catch (Exception ex) {

System.out.println(ex.getMessage());}

});

DefaultTableCellRenderer rightRenderer = newDefaultTableCellRenderer();rightRenderer.setHorizontalAlignment(SwingConstants.LEFT);jTable1.getColumnModel().getColumn(0).setCellRenderer(rightRenderer);

}

/*** Creates new form FormCRUD*/public FormCRUD(java.awt.Frame parent, boolean modal) {

super(parent, modal);initComponents();

}

/**

* This method is called from within the constructor to initialize theform.* WARNING: Do NOT modify this code. The content of this method is always* regenerated by the Form Editor.*/@SuppressWarnings("unchecked")// private void initComponents() {

jScrollPane1 = new javax.swing.JScrollPane();jTable1 = new javax.swing.JTable();


13/20


jPanel1 = new javax.swing.JPanel();jLabel1 = new javax.swing.JLabel();jLabel2 = new javax.swing.JLabel();jLabel3 = new javax.swing.JLabel();jLabel4 = new javax.swing.JLabel();jLabel5 = new javax.swing.JLabel();jLabel6 = new javax.swing.JLabel();

txtIdPegawai = new javax.swing.JTextField();txtPosisi = new javax.swing.JTextField();txtNamaLengkap = new javax.swing.JTextField();txtGaji = new javax.swing.JTextField();txtDepartemen = new javax.swing.JTextField();cboJenisKelamin = new javax.swing.JComboBox();tombol_tambah = new javax.swing.JButton();tombol_update = new javax.swing.JButton();tombol_hapus = new javax.swing.JButton();tombol_print_all = new javax.swing.JButton();tombol_close = new javax.swing.JButton();

setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);

jTable1.setModel(new javax.swing.table.DefaultTableModel(

new Object [][] {{},{},{},{}

},new String [] {

}));jScrollPane1.setViewportView(jTable1);

jPanel1.setBorder(javax.swing.BorderFactory.createLineBorder(newjava.awt.Color(0, 0, 0)));

jPanel1.setToolTipText("Menu");

jPanel1.setName("Menu"); // NOI18N

jLabel1.setText("ID Karyawan");

jLabel2.setText("Nama Lengkap");

jLabel3.setText("Jenis Kelamin");

jLabel4.setText("Posisi");

jLabel5.setText("Departemen");

jLabel6.setText("Gaji");

cboJenisKelamin.setModel(new javax.swing.DefaultComboBoxModel(new

String[] { "Laki-laki", "Perempuan" }));cboJenisKelamin.setToolTipText("");

javax.swing.GroupLayout jPanel1Layout = newjavax.swing.GroupLayout(jPanel1);

jPanel1.setLayout(jPanel1Layout);jPanel1Layout.setHorizontalGroup(

jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(jPanel1Layout.createSequentialGroup()

.addContainerGap()


14/20


.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel1)



.addComponent(jLabel2))

.addGap(22, 22, 22)


.addGroup(jPanel1Layout.createSequentialGroup()


.addComponent(txtNamaLengkap,javax.swing.GroupLayout.PREFERRED_SIZE, 146,javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(txtIdPegawai,javax.swing.GroupLayout.PREFERRED_SIZE, 146,javax.swing.GroupLayout.PREFERRED_SIZE))

.addContainerGap())



.addComponent(txtPosisi,javax.swing.GroupLayout.PREFERRED_SIZE, 146,javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(cboJenisKelamin,javax.swing.GroupLayout.PREFERRED_SIZE, 99,javax.swing.GroupLayout.PREFERRED_SIZE))

.addGap(44, 44, 44)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)


.addComponent(jLabel5))



.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 20,Short.MAX_VALUE)

.addComponent(txtGaji,javax.swing.GroupLayout.PREFERRED_SIZE, 146,javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(42, 42, 42)).addGroup(jPanel1Layout.createSequentialGroup()

.addGap(18, 18, 18)

.addComponent(txtDepartemen,

javax.swing.GroupLayout.PREFERRED_SIZE, 146,javax.swing.GroupLayout.PREFERRED_SIZE)

.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))))));jPanel1Layout.setVerticalGroup(

jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(jPanel1Layout.createSequentialGroup()

.addContainerGap()


15/20


.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)


.addComponent(txtIdPegawai,javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,javax.swing.GroupLayout.PREFERRED_SIZE))

.addGap(20, 20, 20)



.addComponent(txtNamaLengkap,javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,javax.swing.GroupLayout.PREFERRED_SIZE))

.addGap(18, 18, 18)




.addComponent(cboJenisKelamin,javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,

javax.swing.GroupLayout.PREFERRED_SIZE).addComponent(txtDepartemen,javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,javax.swing.GroupLayout.PREFERRED_SIZE))

.addGap(18, 18, 18)




.addComponent(txtPosisi,javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(txtGaji,javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,

javax.swing.GroupLayout.PREFERRED_SIZE)).addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE,Short.MAX_VALUE))

);

tombol_tambah.setText("Tambah");tombol_tambah.setActionCommand("tombol_tambah");tombol_tambah.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {tombol_tambahActionPerformed(evt);

}});

tombol_update.setText("Update");tombol_update.setActionCommand("tombol_update");

tombol_update.addActionListener(new java.awt.event.ActionListener() {public void actionPerformed(java.awt.event.ActionEvent evt) {tombol_updateActionPerformed(evt);

}});

tombol_hapus.setText("Hapus");tombol_hapus.setActionCommand("tombol_hapus");tombol_hapus.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {tombol_hapusActionPerformed(evt);


16/20


}});

tombol_print_all.setText("Print All");tombol_print_all.setActionCommand("tombol_print_all");tombol_print_all.addActionListener(new java.awt.event.ActionListener()

{

public void actionPerformed(java.awt.event.ActionEvent evt) {tombol_print_allActionPerformed(evt);}

});

tombol_close.setText("Close");tombol_close.setActionCommand("tombol_close");tombol_close.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {tombol_closeActionPerformed(evt);

}});

javax.swing.GroupLayout layout = newjavax.swing.GroupLayout(getContentPane());

getContentPane().setLayout(layout);layout.setHorizontalGroup(

layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout.createSequentialGroup()

.addContainerGap()

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,false)

.addComponent(jPanel1,javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,Short.MAX_VALUE)

.addComponent(jScrollPane1)

.addGroup(layout.createSequentialGroup().addGap(57, 57, 57)

.addComponent(tombol_tambah).addGap(18, 18, 18)

.addComponent(tombol_update)

.addGap(18, 18, 18)

.addComponent(tombol_hapus)

.addGap(18, 18, 18)

.addComponent(tombol_print_all)

.addGap(18, 18, 18)

.addComponent(tombol_close))).addContainerGap(19, Short.MAX_VALUE))

);layout.setVerticalGroup(

layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout.createSequentialGroup()

.addContainerGap().addComponent(jScrollPane1,javax.swing.GroupLayout.PREFERRED_SIZE, 91,javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED).addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE,

javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED,javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)


17/20


.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(tombol_tambah)

.addComponent(tombol_update)

.addComponent(tombol_hapus)

.addComponent(tombol_print_all)

.addComponent(tombol_close)).addContainerGap()));

jPanel1.getAccessibleContext().setAccessibleName("Menu Pegawai");

pack();}//

private void formWindowOpened(java.awt.event.WindowEvent evt) {try {

loadRecords();} catch (SQLException ex) {


}

private void tombol_tambahActionPerformed(java.awt.event.ActionEvent evt) {// TODO add your handling code here:addRecord = true;

clearInputBoxes();

txtNamaLengkap.requestFocus();}

private void tombol_hapusActionPerformed(java.awt.event.ActionEvent evt) {// TODO add your handling code here:int dialogResult = JOptionPane.showConfirmDialog(null, "Yakin mau

hapus?", "Konfirmasi penghapusan?", JOptionPane.YES_NO_OPTION);

if (dialogResult == JOptionPane.YES_OPTION) {try {

deleteRecord();



}}

private void tombol_closeActionPerformed(java.awt.event.ActionEvent evt) {// TODO add your handling code here:System.exit(1);

}

private void tombol_updateActionPerformed(java.awt.event.ActionEvent evt) {// TODO add your handling code here:int dialogResult = JOptionPane.showConfirmDialog(null, "Yakin mau

update?", "KOnfirmasi update?", JOptionPane.YES_NO_OPTION);

if (dialogResult == JOptionPane.YES_OPTION) {


18/20


try {if (addRecord == true) {

addNew();} else {

updateRecord();}

addRecord = false;



}}

private void tombol_print_allActionPerformed(java.awt.event.ActionEventevt) {

// TODO add your handling code here://DisplayReports displayReports = new DisplayReports();

//displayReports.showEmployees();

}

/*** @param args the command line arguments*/public static void main(String args[]) {

/* Set the Nimbus look and feel *////* If Nimbus (introduced in Java SE 6) is not available, stay with the

default look and feel.* For details see

http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html*/

try {for (javax.swing.UIManager.LookAndFeelInfo info :javax.swing.UIManager.getInstalledLookAndFeels()) {

if ("Nimbus".equals(info.getName())) {javax.swing.UIManager.setLookAndFeel(info.getClassName());break;

}}

} catch (ClassNotFoundException ex) {

java.util.logging.Logger.getLogger(FormCRUD.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

} catch (InstantiationException ex) {

java.util.logging.Logger.getLogger(FormCRUD.class.getName()).log(java.util.logg

ing.Level.SEVERE, null, ex);} catch (IllegalAccessException ex) {


} catch (javax.swing.UnsupportedLookAndFeelException ex) {


}//


19/20


/* Create and display the dialog */java.awt.EventQueue.invokeLater(new Runnable() {

public void run() {FormCRUD dialog = new FormCRUD(new javax.swing.JFrame(), true);dialog.addWindowListener(new java.awt.event.WindowAdapter() {

@Override

public void windowClosing(java.awt.event.WindowEvent e) {System.exit(0);}

});dialog.setVisible(true);

}});

}

// Variables declaration - do not modifyprivate javax.swing.JComboBox cboJenisKelamin;private javax.swing.JLabel jLabel1;private javax.swing.JLabel jLabel2;private javax.swing.JLabel jLabel3;private javax.swing.JLabel jLabel4;

private javax.swing.JLabel jLabel5;private javax.swing.JLabel jLabel6;private javax.swing.JPanel jPanel1;private javax.swing.JScrollPane jScrollPane1;private javax.swing.JTable jTable1;private javax.swing.JButton tombol_close;private javax.swing.JButton tombol_hapus;private javax.swing.JButton tombol_print_all;private javax.swing.JButton tombol_tambah;private javax.swing.JButton tombol_update;private javax.swing.JTextField txtDepartemen;private javax.swing.JTextField txtGaji;private javax.swing.JTextField txtIdPegawai;private javax.swing.JTextField txtNamaLengkap;private javax.swing.JTextField txtPosisi;

// End of variables declaration}

22) Update JDBC_CRUD.java

/** To change this license header, choose License Headers in Project Properties.* To change this template file, choose Tools | Templates* and open the template in the editor.*/package jdbc_crud;

import javax.swing.JDialog;

import javax.swing.UIManager;import javax.swing.UnsupportedLookAndFeelException;

/**** @author Enggar*/public class JDBC_CRUD {

/*** @param args the command line arguments


20/20


*/public static void main(String[] args) {

// TODO code application logic heretry {

// Set System L&FUIManager.setLookAndFeel(

UIManager.getSystemLookAndFeelClassName());

} catch (UnsupportedLookAndFeelException | ClassNotFoundException |InstantiationException | IllegalAccessException ex) {System.out.println(ex.getMessage());

}FormCRUD sForm = new FormCRUD(null, false);sForm.setDefaultCloseOperation(JDialog.DISPOSE_ON_CLOSE);sForm.pack();sForm.setLocationRelativeTo(null);

sForm.setVisible(true);}

}

23)

Jalankan project

3. Tugas Praktikum

1) Rubah Id_Pegawai menjadiauto_incrementsehingga pada saat penambahan data, tidak

perlu menginputkan ID Pegawai!

2) Tombol Print All belum berfungsi dengan baik. Buat hasil eksekusi tombol Print All untuk

menampilkan data dalam bentuk laporan menggunakan Jasper Reports (plugin telah

disediakan, diperbolehkan menggunakan versi lain)!

Modul X_JAVA SWING CRUD JDBC.pdf

Documents