Aplikasi Data Pegawai

oke sobat, untuk membuat aplikasi di atas terlebih dahulu sobat semua harus buat databasenya.
buatlah databasenya ;

Janganlupasetting  ODBCnyadengancarasebagai :

Control  panelè Administrative ToolsèData Source ODBCèAddèMy SQL connector è Setting Sesuaikeinginanandaèokey

Klik 2 kali adatombol  Saveè

Isikankodeberikut

try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

            Connection con = DriverManager.getConnection("jdbc:odbc:pegawai","","");  //(jdbc:odbc:pegawai// sesuaidenganapa yang di buatpadaodbcnya………..)

            Statement stmt = con.createStatement();

            String sql = "insert into pegawaivalues('"+vnip.getText()+

                                                      "','"+vnama_karyawan.getText()+

                                                      "','"+vtempatlahir.getText()+

                                                      "','"+vtgl.getText()+

                                                      "','"+vstatus.getSelectedItem().toString()+

                                                      "','"+valamat.getText()+

                                                      "','"+vtelp.getText()+"')";

stmt.executeUpdate(sql);

CLEAN();

tampil();

             }            }         

}catch(Exception e){

JOptionPane.showMessageDialog(null,"DataGagalDisimpan" + e);  

        }

Tombol Update è

try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

            Connection con = DriverManager.getConnection("jdbc:odbc:pegawai","","");

            Statement stmt = con.createStatement();

             String sql="Update pegawai set Nama_Pegawai='"+vnama_karyawan.getText()+

                  "',Tmp_Lahir='"+vtempatlahir.getText()+

                  "',Tgl_Lahir='"+vtgl.getText()+ 

                  "',status='"+vstatus.getSelectedItem()+

                  "',alamat='"+valamat.getText()+

                  "',Telpn='"+vtelp.getText()+

                  "' WHERE NIP='"+vnip.getText()+" ' ";

stmt.executeUpdate(sql);

CLEAN();

tampil();

             }                 

}catch(Exception e){

JOptionPane.showMessageDialog(null,"DataGagal Di Update" + e);  

        }

Tombol Delete == >

Try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

            Connection cn = DriverManager.getConnection("jdbc:odbc:pegawai","","");

            String sql="delete from pegawai where Nip = '"+vnip.getText()+"'";

            Statement st = cn.createStatement();

st.executeUpdate(sql);

            }

CLEAN();

tampil();

        } catch (Exception e) {       }

Tombol Cancel è

CLEAN();

tampil();

TombolKeluarè

dispose();

buatlahsebuahfanctionuntukmenampilakan data padajTabledanmembersikanjTextFielddengancarasbagaiberikut:

private void tampil() {

DefaultTableModeltbl= new DefaultTableModel();

tbl.addColumn("Nip");

tbl.addColumn("NamaPegawai");

tbl.addColumn("TempatLahir");

tbl.addColumn("TanggalLahir");

tbl.addColumn("Status");

tbl.addColumn("Alamat");

tbl.addColumn("Telpon");

try{

intnomor=0;

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

           Connection con =DriverManager.getConnection("Jdbc:Odbc:pegawai","","");

           Statement stmt = con.createStatement();

ResultSet RS = stmt.executeQuery("select * from pegawai");

while (RS.next())

           {

tbl.addRow(new Object[]{RS.getString(1),RS.getString(2),RS.getString(3),RS.getString(4)

,RS.getString(5),RS.getString(6),RS.getString(7)});

               }

jTable2.setModel(tbl);

RS.close();

stmt.close();

con.close();

}catch (Exception e)

           {System.err.println(e.getMessage());}

       }

Janganlupamemanggilmetoda di atas di bawahint componentè

publicPegawai() {

initComponents();

tampil();

private void CLEAN(){

vnip.setText("");

vnama_karyawan.setText("");

vtempatlahir.setText("");

vtgl.setText("");

vstatus.setSelectedItem("");

valamat.setText("");

vtelp.setText("");

    }

Untuksearching  codingnyasebagaiberikut :

Dengancaraklik 2 kali jTextFieldNIP

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

            Connection cn = DriverManager.getConnection("jdbc:odbc:pegawai","","");

            String sql = "select * from pegawai where nip = '"+vnip.getText()+"'";

            Statement stat = cn.createStatement();

ResultSet set = stat.executeQuery(sql);

while(set.next()) {

vnama_karyawan.setText(set.getString("Nama_Pegawai"));

vtempatlahir.setText(set.getString("Tmp_Lahir"));

vtgl.setText(set.getString("Tgl_Lahir"));

vstatus.setSelectedItem(set.getString("Status"));

valamat.setText(set.getString("Alamat"));

vtelp.setText(set.getString("Telpn"));           

}set.close();           

            } catch(Exception e) {

System.out.println(e.getMessage());

            }

Jalankan program isitextfieldnipdengankodetertentuè enter

Kita lanjutpada form yang ke-2

Tambahkan table pada data base dengannamadata_gaji

kodingnyatidakjauhberbedapada form sebelumnya

tapiadaperbedaanpada searching dancomboboxnya

padajTextField No buktigajibuatkodingberikut;

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

            Connection cn = DriverManager.getConnection("jdbc:odbc:pegawai","","");

            String sql = "select * from gaji where No_Bukti_Gaji = '"+vnbg.getText()+"'";

            Statement stat = cn.createStatement();

ResultSet set = stat.executeQuery(sql);

while(set.next()) {

vnip.setSelectedItem(set.getString("Nip"));

vgolongan.setSelectedItem(set.getString("Golongan"));

vgaji.setText(set.getString("Gaji_Pokok"));

vtunj.setText(set.getString("Tunj_Lain"));

vbulan.setText(set.getString("Gaji_Per_Bulan"));

            } set.close();           

            } catch(Exception e) {System.out.println(e.getMessage());}

Dan padacombobox nip buat coding berikut:

String a="",b="",c="",d="";

try{

            Object np=vnip.getSelectedItem();

            a=np.toString();

            Connection cn = DriverManager.getConnection("jdbc:odbc:pegawai","","");

            String sql="select * from pegawai where Nip='"+a+"'";

            Statement st=cn.createStatement();

ResultSetrs=st.executeQuery(sql);

while (rs.next())

        {

            b=rs.getString("Nama_Pegawai");

            c=rs.getString("Status");

            d=rs.getString("Telpn");          

        }

vnama.setText(b);

vstatus.setText(c);

vtelp.setText(d);           

}catch (Exception e){}

Tambahkanfanctionberikut

public void tampilnid()

        {

try{

            Connection cn=DriverManager.getConnection("jdbc:odbc:pegawai","","");

            String sql="select*from pegawai";

            Statement st=cn.createStatement();

ResultSetrs=st.executeQuery(sql);

while(rs.next())

            {

                String kode=rs.getString("nip");

vnip.addItem(kode);

            }

}catch (Exception e){} kut:

Padacomboboxgolongangantilah model nyadengancaraklikkanancomboboxèpropertisèmodelègantidengan (I,II,III,IV);

Selanjutnyaklik 2 kali comboboxgolonganlalumasukkankodeberikut:

intpilih;

pilih=vgolongan.getSelectedIndex();

intgaji=0;

if(pilih==0){

gaji=0;

}else if(pilih==1){

gaji=1000000;

}else if(pilih==2){

gaji=2000000;

}else if(pilih==3){

gaji=3000000;

}else{

gaji=4000000;

        }

vgaji.setText(String.valueOf(gaji));

untukjTextFiaeldTunjanganisikankodeberikutèklik 2 kali

inttunj;

intgaji;

int gaper;

gaji=Integer.parseInt(vgaji.getText());

tunj=Integer.parseInt(vtunj.getText());

gaper=tunj + gaji;

vbulan.setText(String.valueOf(gaper));

Jalankan program isitextfieldtunjangandenganangkatertentuè enter

padagajiperbulanhilangkancentang editable nyadengancaraklikkanantextfieldtersebutèpropertisèeditable(hilangkancentangnya)

untukmenampilkan data pada table samadengancarasebelumnyabegitujugadengan clean-nya.

Thank you…………………………