Tugas Before UAS Pegawai
Pegawai.java
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package java2012_11110446;
/**
*
* @author ridwan020920
*/
public class pegawai {
private int nip;
private String nama;
private String jabatan;
private String jeniskelamin;
public pegawai () {
}
public int getNip() {
return nip;
}
public void setNip(int nip) {
this.nip = nip;
}
public String getNama() {
return nama;
}
public void setNama(String nama) {
this.nama = nama;
}
public String getJabatan() {
return jabatan;
}
public void setJabatan(String jabatan) {
this.jabatan = jabatan;
}
public String getJeniskelamin() {
return jeniskelamin;
}
public void setJeniskelamin(String jeniskelamin) {
this.jeniskelamin = jeniskelamin;
}
}
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package java2012_11110446;
/**
*
* @author ridwan020920
*/
public class pegawai {
private int nip;
private String nama;
private String jabatan;
private String jeniskelamin;
public pegawai () {
}
public int getNip() {
return nip;
}
public void setNip(int nip) {
this.nip = nip;
}
public String getNama() {
return nama;
}
public void setNama(String nama) {
this.nama = nama;
}
public String getJabatan() {
return jabatan;
}
public void setJabatan(String jabatan) {
this.jabatan = jabatan;
}
public String getJeniskelamin() {
return jeniskelamin;
}
public void setJeniskelamin(String jeniskelamin) {
this.jeniskelamin = jeniskelamin;
}
}
Konek.java
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package java2012_11110446;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
/**
*
* @author ridwan020920
*/
public class konek {
Connection con = null;
Statement st = null;
String url = "jdbc:mysql://localhost:3306/java2012_db";
String user = "root";
String pass = "";
public konek() {
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection(url,user,pass);
st = con.createStatement();
}catch(Exception ex){
ex.printStackTrace();
}
}
public List getPersons(){
ResultSet rs = null;
List
persons = new ArrayList();
try{
rs = st.executeQuery("SELECT NIP, NAMA, JABATAN, JENISKELAMIN FROM t_pegawai");
while(rs.next()){
pegawai p =new pegawai();
p.setNip(rs.getInt(1));
p.setNama(rs.getString(2));
p.setJabatan(rs.getString(3));
p.setJeniskelamin(rs.getString(4));
persons.add(p);
}
}catch(Exception ex){
ex.printStackTrace();
}
return persons;
}
public pegawai getPersons(int nip){
ResultSet rs = null;
pegawai p = null;
try{
String sql = "SELECT NIP, NAMA, JABATAN, JENISKELAMIN FROM t_pegawai WHERE NIP = ?";
PreparedStatement ps = con.prepareStatement(sql);
ps.setInt(1, nip);
rs = ps.executeQuery();
while(rs.next()){
p = new pegawai();
p.setNip(rs.getInt(1));
p.setNama(rs.getString(2));
p.setJabatan(rs.getString(3));
p.setJeniskelamin(rs.getString(4));
// pegawai.add(p);
}
}catch(Exception ex){
ex.printStackTrace();
}
return p;
}
public int insert(pegawai p){
int result = 0;
try{
result = st.executeUpdate("INSERT INTO t_pegawai(nip, nama, jabatan, jeniskelamin)" + "VALUES("+p.getNip()+",'"+p.getNama()+"','"+p.getJabatan()+"',"+"'"+p.getJeniskelamin()+"')");
}catch(Exception ex){
ex.printStackTrace();
}
return result;
}
public int edit(pegawai p){
int result = 0;
try{
result = st.executeUpdate("UPDATE t_pegawai SET NAMA='"+p.getNama()+"', ALAMAT='"+p.getJabatan()+"', JABATAN='"+p.getJeniskelamin()+"' WHERE NIM = '"+p.getNip()+"'");
}catch(Exception ex){
ex.printStackTrace();
}
return result;
}
public int delete(pegawai p){
int result = 0;
try{
result = st.executeUpdate("DELETE FROM t_pegawai WHERE NIP="+p.getNip()+"");
}catch(Exception ex){
ex.printStackTrace();
}
return result;
}
}
formpegawai.java
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
/*
* formpegawai.java
*
* Created on 14 Des 11, 19:43:41
*/
package java2012_11110446;
import java.util.ArrayList;
import java.util.List;
import javax.swing.*;
/**
*
* @author ridwan020920
*/
public class formpegawai extends javax.swing.JFrame {
konek knks = new konek();
List persons = new ArrayList();
int currentRow = 0;
private Object t_anggota;
String newOrUpdate = "NEW";
/** Creates new form formpegawai */
public formpegawai() {
initComponents();
}
private void setEditData(boolean isEdit)
{
txtnip.setEnabled(isEdit);
txtnama.setEnabled(isEdit);
cmbjabatan.setEnabled(isEdit);
rbtnlakilaki.setEnabled(isEdit);
rbtnperempuan.setEnabled(isEdit);
}
/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// //GEN-BEGIN:initComponents
private void initComponents() {
buttonGroup1 = new javax.swing.ButtonGroup();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
btnnew = new javax.swing.JButton();
txtnip = new javax.swing.JTextField();
txtnama = new javax.swing.JTextField();
cmbjabatan = new javax.swing.JComboBox();
rbtnlakilaki = new javax.swing.JRadioButton();
rbtnperempuan = new javax.swing.JRadioButton();
btncari = new javax.swing.JButton();
btnsave = new javax.swing.JButton();
btndelete = new javax.swing.JButton();
btnedit = new javax.swing.JButton();
btnclose = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jLabel1.setText("NIP");
jLabel2.setText("Nama");
jLabel3.setText("Jabatan");
jLabel4.setText("Jenis Kelamin");
btnnew.setText("new");
btnnew.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnnewActionPerformed(evt);
}
});
txtnip.setColumns(5);
txtnama.setColumns(10);
cmbjabatan.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "DEPT HEAD", "SUB DEPT", "ANALYST", "ADMIN" }));
buttonGroup1.add(rbtnlakilaki);
rbtnlakilaki.setText("Laki-laki");
buttonGroup1.add(rbtnperempuan);
rbtnperempuan.setText("Perempuan");
rbtnperempuan.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
rbtnperempuanActionPerformed(evt);
}
});
btncari.setText("cari");
btncari.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btncariActionPerformed(evt);
}
});
btnsave.setText("save");
btnsave.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnsaveActionPerformed(evt);
}
});
btndelete.setText("delete");
btndelete.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btndeleteActionPerformed(evt);
}
});
btnedit.setText("edit");
btnedit.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btneditActionPerformed(evt);
}
});
btnclose.setText("close");
btnclose.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btncloseActionPerformed(evt);
}
});
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(41, 41, 41)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel2)
.addComponent(jLabel3)
.addComponent(jLabel4)
.addComponent(jLabel1))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 62, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(rbtnlakilaki, javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(cmbjabatan, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(txtnama, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addComponent(rbtnperempuan))
.addGroup(layout.createSequentialGroup()
.addComponent(txtnip, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(btncari)))
.addContainerGap(51, Short.MAX_VALUE))
.addGroup(layout.createSequentialGroup()
.addGap(78, 78, 78)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(btnnew)
.addGap(18, 18, 18)
.addComponent(btnsave)
.addGap(18, 18, 18)
.addComponent(btndelete))
.addGroup(layout.createSequentialGroup()
.addGap(45, 45, 45)
.addComponent(btnedit)
.addGap(18, 18, 18)
.addComponent(btnclose)))
.addContainerGap(109, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(36, 36, 36)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1)
.addComponent(txtnip, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(btncari))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(txtnama, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(cmbjabatan, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel4)
.addComponent(rbtnlakilaki)
.addComponent(rbtnperempuan))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(btnnew)
.addComponent(btnsave)
.addComponent(btndelete))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(btnedit)
.addComponent(btnclose))
.addContainerGap(40, Short.MAX_VALUE))
);
pack();
}// //GEN-END:initComponents
private void rbtnperempuanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_rbtnperempuanActionPerformed
// TODO add your handling code here:
}//GEN-LAST:event_rbtnperempuanActionPerformed
private void btnnewActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnnewActionPerformed
// TODO add your handling code here:
txtnip.setText("");
txtnama.setText("");
buttonGroup1.clearSelection();
cmbjabatan.setSelectedIndex(0);
txtnip.setEditable(true);
txtnama.setEditable(true);
setEditData(true);
txtnip.requestFocus();
}//GEN-LAST:event_btnnewActionPerformed
private void btnsaveActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnsaveActionPerformed
// TODO add your handling code here:
if(newOrUpdate.equals("UPDATE"))
{
int nip = Integer.parseInt(txtnip.getText());
String nama = txtnama.getText();
String jabatan = cmbjabatan.getSelectedItem().toString();
String jeniskelamin = "LAKI-LAKI";
if(rbtnperempuan.isSelected())
jeniskelamin = "PEREMPUAN";
pegawai p = new pegawai();
p.setNip(nip);
p.setNama(nama);
p.setJabatan(jabatan);
p.setJeniskelamin(jeniskelamin);
konek k = new konek();
int result = k.edit(p);
JOptionPane.showMessageDialog(this,"Data berhasil disimpan","Informasi",JOptionPane.INFORMATION_MESSAGE);
}
else
{
pegawai p = new pegawai();
p.setNip(Integer.parseInt(txtnip.getText()));
p.setNama(txtnama.getText());
if (cmbjabatan.getSelectedItem().toString().equalsIgnoreCase("DEPT HEAD")){
p.setJabatan("DEPT HEAD");
}
else if (cmbjabatan.getSelectedItem().toString().equalsIgnoreCase("SUB DEPT")){
p.setJabatan("SUB DEPT");
}
else if (cmbjabatan.getSelectedItem().toString().equalsIgnoreCase("ANALYST")){
p.setJabatan("ANALYST");
}
else if (cmbjabatan.getSelectedItem().toString().equalsIgnoreCase("ADMIN")){
p.setJabatan("ADMIN");
}
if (rbtnlakilaki.isSelected()){
p.setJeniskelamin("Laki-laki");
}
else
p.setJeniskelamin("Perempuan");
if(knks.insert(p)>0){
loadData();
currentRow = persons.size()-1;
bindData();
JOptionPane.showMessageDialog(this,"Data berhasil disimpan","Informasi", JOptionPane.INFORMATION_MESSAGE);
txtnip.setEditable(false);
txtnama.setEditable(false);
cmbjabatan.setSelectedIndex(0);
buttonGroup1.clearSelection();
}else{
JOptionPane.showMessageDialog(this,"Data gagal disimpan","Informasi", JOptionPane.INFORMATION_MESSAGE);
}
}
}//GEN-LAST:event_btnsaveActionPerformed
private void btndeleteActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btndeleteActionPerformed
// TODO add your handling code here:
pegawai p = persons.get(currentRow);
if(knks.delete(p)>0){
loadData();
currentRow = currentRow-1;
bindData();
JOptionPane.showMessageDialog(this,"Data berhasil dihapus","Informasi",JOptionPane.INFORMATION_MESSAGE);
}else{
JOptionPane.showMessageDialog(this,"Data gagal dihapus","Informasi",JOptionPane.INFORMATION_MESSAGE);
}
}//GEN-LAST:event_btndeleteActionPerformed
private void btncloseActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btncloseActionPerformed
// TODO add your handling code here:
int answer = JOptionPane.showConfirmDialog(null,"Ingin Keluar?","Pertanyaan",JOptionPane.YES_NO_OPTION);
if(answer == JOptionPane.YES_OPTION){
System.exit(0);
}
else{
return;
}
}//GEN-LAST:event_btncloseActionPerformed
private void btncariActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btncariActionPerformed
// TODO add your handling code here:
if(txtnip.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null,"nip tidak boleh kosong", "Warning",JOptionPane.INFORMATION_MESSAGE );
return;
}
int nip = Integer.parseInt(txtnip.getText());
konek konek = new konek();
pegawai peg = konek.getPersons(nip);
if(peg!= null)
{
txtnama.setText(peg.getNama());
if(peg.getJabatan().equalsIgnoreCase("DEPT HEAD"))
cmbjabatan.setSelectedIndex(0);
else if(peg.getJabatan().equalsIgnoreCase("SUB DEPT"))
cmbjabatan.setSelectedIndex(1);
else if(peg.getJabatan().equalsIgnoreCase("ANALYST"))
cmbjabatan.setSelectedIndex(2);
else if(peg.getJabatan().equalsIgnoreCase("ADMIN"))
cmbjabatan.setSelectedIndex(3);
else
cmbjabatan.setSelectedIndex(0);
if(peg.getJeniskelamin().equalsIgnoreCase("LAKI-LAKI"))
rbtnlakilaki.setSelected(true);
else
rbtnperempuan.setSelected(true);
// setEditData(false);
}
else
JOptionPane.showMessageDialog(null,"Data tidak ditemukan", "Warning",JOptionPane.INFORMATION_MESSAGE );
}//GEN-LAST:event_btncariActionPerformed
private void btneditActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btneditActionPerformed
// TODO add your handling code here:
// pegawai p = new pegawai();
// p.setNip(Integer.parseInt(txtnip.getText()));
// p.setNama(txtnama.getText());
// if (cmbjabatan.getSelectedItem().toString().equalsIgnoreCase("DEPT HEAD")){
// p.setJabatan("DEPT HEAD");
// }
// else if (cmbjabatan.getSelectedItem().toString().equalsIgnoreCase("SUB DEPT")){
// p.setJabatan("SUB DEPT");
// }
// else if (cmbjabatan.getSelectedItem().toString().equalsIgnoreCase("ANALYST")){
// p.setJabatan("ANALYST");
// }
// else if (cmbjabatan.getSelectedItem().toString().equalsIgnoreCase("ADMIN")){
// p.setJabatan("ADMIN");
// }
// if (rbtnlakilaki.isSelected()){
// p.setJeniskelamin("Laki-laki");
// }
// else
// p.setJeniskelamin("Perempuan");
// if(knks.edit(p)>0){
// loadData();
// currentRow = persons.size()-1;
// bindData();
// JOptionPane.showMessageDialog(this,"Data berhasil diedit","Informasi", JOptionPane.INFORMATION_MESSAGE);
// txtnip.setEditable(false);
// txtnama.setEditable(false);
// cmbjabatan.setSelectedIndex(0);
// buttonGroup1.clearSelection();
// }else{
// JOptionPane.showMessageDialog(this,"Data gagal disimpan","Informasi", JOptionPane.INFORMATION_MESSAGE);
// }
int nip = Integer.parseInt(txtnip.getText());
String nama = txtnama.getText();
String jabatan = cmbjabatan.getSelectedItem().toString();
String jeniskelamin = "LAKI-LAKI";
if(rbtnperempuan.isSelected())
jeniskelamin = "PEREMPUAN";
pegawai p = new pegawai();
p.setNip(nip);
p.setNama(nama);
p.setJabatan(jabatan);
p.setJeniskelamin(jeniskelamin);
konek k = new konek();
int result = k.edit(p);
JOptionPane.showMessageDialog(this,"Data berhasil disimpan","Informasi",JOptionPane.INFORMATION_MESSAGE);
setEditData(true);
// newOrUpdate = "UPDATE";
}//GEN-LAST:event_btneditActionPerformed
private void loadData(){
persons = knks.getPersons();
}
private void bindData(){
if(persons.size()>0){
pegawai p = persons.get(currentRow);
txtnip.setText(p.getNip()+"");
txtnama.setText(p.getNama());
cmbjabatan.setSelectedItem(p.getJabatan());
}else{
currentRow = 0;
txtnip.setText("");
txtnama.setText("");
cmbjabatan.setSelectedIndex(0);
buttonGroup1.clearSelection();
}
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new formpegawai().setVisible(true);
}
});
}
// Variables declaration - do not modify//GEN-BEGIN:variables
private javax.swing.JButton btncari;
private javax.swing.JButton btnclose;
private javax.swing.JButton btndelete;
private javax.swing.JButton btnedit;
private javax.swing.JButton btnnew;
private javax.swing.JButton btnsave;
private javax.swing.ButtonGroup buttonGroup1;
private javax.swing.JComboBox cmbjabatan;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JRadioButton rbtnlakilaki;
private javax.swing.JRadioButton rbtnperempuan;
private javax.swing.JTextField txtnama;
private javax.swing.JTextField txtnip;
// End of variables declaration//GEN-END:variables
}
Main.java
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package java2012_11110446;
/**
*
* @author ridwan020920
*/
public class Main {
/**
* @param args the command line arguments
*/
public static void main(String[] args) {
// TODO code application logic here
new formpegawai().setVisible(true);
}
}
Comments
Post a Comment