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;
}
}

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

Popular posts from this blog

Windows XP SP3 Product Key

SEF pada Virtuemart

Tentang google page rank