Membuat Form Karyawan dengan Java Netbeans

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