Untuk membuat form karyawan, kita perlu membuat data karyawan pada database.
Contohnya :
create table karyawan (
nama_user char(8) not null primary key,
nama varchar(30) not null,
alamat varchar(30),
notelp varchar(12),
level varchar(5) not null,
password varchar(10) not null )
Untuk membuat database bisa menggunakan mySQL JDBC pada netbeans dengan mengkoneksikan program XAMPP.
Berikut ini, source code form Karyawan pada Java Netbean :
/* * To change this template, choose Tools | Templates * and open the template in the editor.
*/
/*
* FormKaryawan.java
*
*
Created on Apr 28, 2013, 1:26:51 PM
*/
package DataRental;
import Rental.koneksi.Database;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
/**
*
* @author ALIENWARE
*/
public class FormKaryawan extends javax.swing.JInternalFrame {
private Database db;
private ResultSet rs;
private Statement st;
String query = "";
DefaultTableModel dtModel;
String modeOperasi = "";
int kursor = 0;
private void isikanTabel() {
String[] tblHeader = {"User", "Nama", "Alamat", "NoTelp",
"Level", "Password"};
dtModel = new DefaultTableModel (null, tblHeader);
kosongkanTabel();
try {
query = "select * from karyawan";
st = db.koneksi.createStatement();
rs = st.executeQuery(query);
while (rs.next()) {
String[] tbData = {rs.getString("nama_user"), rs.getString("nama"),
rs.getString("alamat"), rs.getString("notelp"),
rs.getString("level"), rs.getString("password")};
dtModel.addRow(tbData);
}
}
catch (SQLException se) {
se.printStackTrace();
System.exit(0);
}
tbKaryawan.setModel(dtModel);
if (tbKaryawan.getRowCount() > 0) {
tbKaryawan.addRowSelectionInterval(0, 0);
tampilkanDiText();
}
}
private void kosongkanTabel(){
int row = dtModel.getRowCount();
for (int i = 0; i <
row; i++) {
dtModel.removeRow(0);
}
}
private void bersihText() {
txtIdKaryawan.setText("");
txtNama.setText("");
txtAlamat.setText("");
txtNotelp.setText("");
txtPassword.setText("");
rbUser.setSelected(true);
}
private void aktifText(boolean aktif) {
txtIdKaryawan.setEnabled(aktif);
txtNama.setEnabled(aktif);
txtAlamat.setEnabled(aktif);
txtNotelp.setEnabled(aktif);
txtPassword.setEnabled(aktif);
}
private void aktifSimpan(boolean aktif) {
btnSimpan.setEnabled(aktif);
btnEdit.setEnabled(!aktif);
btnBatal.setEnabled(aktif);
btnHapus.setEnabled(!aktif);
}
private void tampilkanDiText() {
int baris = tbKaryawan.getSelectedRow();
txtIdKaryawan.setText(dtModel.getValueAt(baris, 0).toString());
txtNama.setText(dtModel.getValueAt(baris, 1).toString());
txtAlamat.setText(dtModel.getValueAt(baris, 2).toString());
txtNotelp.setText(dtModel.getValueAt(baris, 3).toString());
String level = dtModel.getValueAt(baris, 4).toString();
if (level.equals("user")) {
rbUser.setSelected(true);
}
else {
rbAdmin.setSelected(true);
}
txtPassword.setText(dtModel.getValueAt(baris, 5).toString());
lblDataKe.setText("data ke : " + (kursor + 1) + " / " +
tbKaryawan.getRowCount());
aktifText(false);
aktifSimpan(false);
}
private void tambahBaru() {
txtIdKaryawan.requestFocus();
bersihText();
}
private void prosesinsertData(String id_karyawan, String nama, String alamat,
String notelp, String level, String password) {
try {
query = "insert into karyawan values('" + id_karyawan + "','"
+ nama + "','" + alamat + "','" + notelp + "','" +
level + "','" + password + "')";
PreparedStatement presttmt = db.koneksi.prepareStatement(query);
presttmt.executeUpdate(query);
}catch (SQLException se) {
JOptionPane.showMessageDialog(null,
"Terjadi kesalahan input data! error :"+ se,
"Kesalahan", JOptionPane.ERROR_MESSAGE);
System.exit(0);
}
}
private void prosesupdateData(String id_karyawan, String nama, String alamat,
String notelp, String level, String password) {
try {
query = "update karyawan set nama='"+nama+"',alamat='"+ alamat
+"',notelp='"+notelp+"',level='"+level+"',password='"+
password+"' where id_karyawan='"+id_karyawan+"'";
PreparedStatement presttmt = db.koneksi.prepareStatement(query);
presttmt.executeUpdate(query);
}catch (SQLException se) {
JOptionPane.showMessageDialog(null,
"Terjadi kesalahan update data! error :"+ se,
"Kesalahan", JOptionPane.ERROR_MESSAGE);
System.exit(0);
}
}
Lanjut ke Form Karyawan 2