modul database_sistem penggajian pegawai

46
MODUL PEMROGRAMAN VISUAL JAVA DI S U S U N OLEH MUTAMMIMUL ULA,S.KOM.,M.CS

Upload: isnhacaviacobaya

Post on 28-Dec-2015

39 views

Category:

Documents


0 download

DESCRIPTION

from sir Dasril.. my teach

TRANSCRIPT

Page 1: Modul Database_sistem Penggajian Pegawai

MODUL PEMROGRAMAN VISUAL JAVA

DI

S

U

S

U

N

OLEH

MUTAMMIMUL ULA,S.KOM.,M.CS

Page 2: Modul Database_sistem Penggajian Pegawai

BAB I

XAMPP DAN JAVA

1. Install JAVA

Untuk mengistal java dengan keseluruhan, terlebih dulu kit amengistallkan jdk-7u9-windows-i586 Setelah sukses baru dilanjutkan dengan Netbeans-7.2.1-ml-windows.

a. Buka JDK pada java.

b. Tekan Next, maka akan muncul

c. Tekan Next, maka akan muncul

Page 3: Modul Database_sistem Penggajian Pegawai

Ikuti langkah JDK ini sampai finish, setelah finish maka akan dilanjutkan dengan pengistalan Netbeans.

a. Pilih Netbeans lalu jalankan sampai selesai

2. INSTALL XAMPP

XAMPP merupakan sebuah paket instalasi untuk PHP, APACHE dan MySQL. Dengan menggunakan XAMPP, kita tidak perlu lagi repot menginstall ketiga software itu secara terpisah.

XAMPP sendiri ada dua macam, yakni paket komplit dan satunya lagi adalah paket portable lite.XAMPP paket komplit itu isinya adalah: Apache MySQL PHP phpMyAdmin FileZilla FTP Server Tomcat Strawberry Perl Portable XAMPP Control Panel

Page 4: Modul Database_sistem Penggajian Pegawai

Sedangkan XAMPP Portable Lite isinya hanya aplikasi PHP dan MySQL, lebih enteng dan cocok buat yang sering memakai kedua aplikasi tersebut.Nah, kali ini saya akan menuliskan tentang panduan cara instal XAMPP di PC. Berhubung saya pakainya Windows, maka panduan ini juga diperuntukkan PC Windows ya.

1. Jalankan file xampp-win32-1.7.1-installer.exe (atau versi lainnya)

2. Kemudian akan tampil pilihan untuk memilih bahasa ketika proses instalasi berjalan. Silakan pilih  bahasa Indonesian atau English, kecuali anda menguasai bahasa lainnya. 

3. Proses instalasi akan dimulai. Klik next untuk memulainya.

4. Setelah anda menekan NEXT, maka selanjutnya anda akan ditanya, dimana anda akan menginstal XAMPP ini, klo saya meletakkanya di posisi defaultnya saja,yaitu di C:\xampp

Page 5: Modul Database_sistem Penggajian Pegawai

5. Setelah menentukan dimana akan menginstal XAMPP tersebut, berikutnya adalah menentukan mana saja yang akan diinstal, LIHAT BAGIAN BAWAH!!! Disana terdapat apache dan My SQL serta File zilla, beri tanda centang pada Apache dan My Sql, Apache berguna sebagai server lokal, jadi anda akan membuat web seolah2 online, dan My Sql digunakan sebagai database, dimana dengan data base pengerjaan web akan lebih mudah serta dapat autosave, sehingga anda tidak perlu khawatir.

6. Tunggu beberapa saat sampai proses instalasi selesai.

Page 6: Modul Database_sistem Penggajian Pegawai

7. Instalasi selesai

8. Sampai tahap ini, berarti kita sudah menginstal XAMPP. Itu berarti kita sudah selesai menginstall PHP, APACHE dan MYSQL. setelah selesai mengklik finish biasanya ada comand prompt muncul sebentar, tungguin aja, paling beberapa detik juga hilang, gambarnya seperti ini.

9. Setelah itu akan keluar message box seperti ini. Klik OK saja.

Page 7: Modul Database_sistem Penggajian Pegawai

10. Setelah itu akan muncul lagi satu message box, disini pilih saja YES.

11. Setelah itu, Akan muncul XAMPP di sebelah kanan bawah, Note: PASTIKAN KEADAAN APACHE DAN MY SQL DALAM KEADAAN RUNNING!!! JIKA APACHE TIDAK AKTIF MAKA BROWSER MENUNJUKAN OFFLINE MODE DAN JIKA MY SQL TIDAK AKTIF, MAKA DATABASE TIDAK AKAN BISA DI BUAT.

12. Nyalakan Apache dan Mysql dengan mengklik tombol Start. Buka web browser anda, lalu ketikkan http:// http://localhost/xampp/ Jika tampilannya seperti di bawah ini, maka apache sudah terinstall dengan benar.

Page 8: Modul Database_sistem Penggajian Pegawai

BAB II

MEMBUAT DATABASE

I. Membuat Database

Pada program yang akan saya buat ini saya menggunakan database Mysql. Yang

pembuatan databasenya itu melalui Xampp/PhpMyAdmin.

Berikut langkah-langkahnya.

1. Ketikkan pada browser anda, http://localhost/phpmyadmin/, maka akan muncul

tampilan sebagai berikut

2. Selanjutnya klik tab “Database”

3. Akan muncul :

Buat database dengan nama “penggajian” kemudian klik Create.

Page 9: Modul Database_sistem Penggajian Pegawai

4. Selanjutnya buat 4 buah table didalam database dengan nama “absensi”, “gaji”,

“jabatan”,”golongan”, “pegawai”.

5. Tabel absensi

6. Tabel gaji

7. Tabel jabatan

9. Tabel golongan

Page 10: Modul Database_sistem Penggajian Pegawai

10.Tabel pegawai

z

z

11.Tahap pembuatan Database dan Tabel telah selesai.

“Catatan : nama database dengan nama yang ada delisting harus sama, karna data

di listing program akan dipanggil sesuai dengan nama databasenya di mySql.

Karna beda huruf saja itu mempengaruhi dalam proses penyimpanan data.”

Page 11: Modul Database_sistem Penggajian Pegawai

BAB III

MEMASUKKAN DATABASE

Untuk memasukka database dengan MYSQL yang telah di buat, ikutilah langkah berikut :

1. ketik pada browser http://localhsot/phpmyadmin. Pilih Databases,

2. Ketik nama database dengan Nama “penggajian”, kemudian pilih Create,

3. Pilih tab Export, pada database penggajian, lalu centang “save as file, lalu klik go

Page 12: Modul Database_sistem Penggajian Pegawai

8. Pilih import, lalu choose file sql kita, setelah itu klik go

Page 13: Modul Database_sistem Penggajian Pegawai

BAB IV

MENDESIGN TAMPILAN GUI

1. Pilih New Project, pilih java Application, kemudian pilih next. Setelah keluar tab baru Java Application, tulis nama projetnya “PenggajianPegawai”, kemudian pilih finish.

2. Setelah membuat poject baru, klik kanan pada <default package>, kemudian New, kemudian JFrame Form,

1

1 2

3

Page 14: Modul Database_sistem Penggajian Pegawai

3. Desain form, seperti gambar di bawah,Form1Atur Properties pada tab paling kanan, sebagai berikut ;- Form1

Name : pageutama

Form 2

Atur Properties pada tab paling kanan, sebagai berikut ;- Form2

Name : pegawai- Combobox1

Model : Tanggal 1-31- lCombobox2

Model : Bulanjanuari – desember- Combobox3

Model : Tahun1950 - 1996

Page 15: Modul Database_sistem Penggajian Pegawai

Form 3

Atur Properties pada tab paling kanan, sebagai berikut ;- Form3

Name : absen

Form 4

Atur Properties pada tab paling kanan, sebagai berikut ;- Form4

Name : login

Form 5

Atur Properties pada tab paling kanan, sebagai berikut ;- Form5

Name : gaji- Combobox1

Model : pilih nip pegawai100411001 - 100411020

Page 16: Modul Database_sistem Penggajian Pegawai

Form 6

Atur Properties pada tab paling kanan, sebagai berikut ;- Form6

Name : cari- Combobox1

Model : pilih jabatansecurity, administrasi, keuangan, kepala bagian- Table1

Model :

Page 17: Modul Database_sistem Penggajian Pegawai

BAB V

EDIT LISTING

1. Pada form1 (pageutama) :a. Button Biodata Pegawai

Klik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,new pegawai ().setVisible(true);dispose();

b. Button AbsensiKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,new absen ().setVisible(true);dispose();

c. Button Hitung GajiKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,new absen ().setVisible(true);dispose();

d. Button PencarianKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,new cari ().setVisible(true);dispose();

e. Button LogoutKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,new login().setVisible(true);dispose();

2. Pada form2 (pegawai):a. TextField1 (Nip)

Klik kanan, pilih Events Mouse mouseReleased, copy paste listing dibawah,String nip=jTextField1.getText();String nama=jTextField2.getText();String jenis_kel=jRadioButton1.getText();String tgl_lahir=(String) jComboBox1.getSelectedItem();String bulan_lahir=(String) jComboBox2.getSelectedItem();String tahun_lahir=(String) jComboBox3.getSelectedItem();String status=jRadioButton3.getText();String pendidikan=(String) jComboBox5.getSelectedItem();String jml_anak =jTextField3.getText();String kode_gol =(String) jComboBox8.getSelectedItem();String kode_jabatan =(String) jComboBox9.getSelectedItem();

Page 18: Modul Database_sistem Penggajian Pegawai

nip = jTextField1.getText();JOptionPane.showMessageDialog(null,"Testing=" +nip);try { con = DriverManager.getConnection(url, "root", ""); String SQL = "Select *from pegawai where nip = '"+nip+"'"; stmt = con.createStatement(); ResultSet rslt = stmt.executeQuery(SQL); while (rslt.next()){ nip = rslt.getString ("nip"); nama = rslt.getString ("nama"); jenis_kel = rslt.getString ("jenis_kel"); tgl_lahir = rslt.getString ("tgl_lahir"); bulan_lahir = rslt.getString ("bulan_lahir"); tahun_lahir = rslt.getString ("tahun_lahir"); status = rslt.getString ("status"); pendidikan = rslt.getString ("pendidikan"); jml_anak = rslt.getString ("jml_anak"); kode_gol = rslt.getString ("kode_gol"); kode_jabatan = rslt.getString ("kode_jabatan");

jTextField2.setText(nama);jRadioButton1.setName(jenis_kel);jComboBox1.setSelectedItem(tgl_lahir);jComboBox2.setSelectedItem(bulan_lahir);jComboBox3.setSelectedItem(tahun_lahir);jRadioButton3.setText(status);jComboBox5.setSelectedItem(pendidikan);jTextField3.setText(jml_anak);jComboBox8.setSelectedItem(kode_gol);jComboBox9.setSelectedItem(kode_jabatan);

}} catch (Exception ex){ System.err.println("Exception :"+ex.getMessage());}

}

b. Button SimpanKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,

if (rdLaki.isSelected()){ if(rdMenikah.isSelected()){String nip=jTextField1.getText();String nama=jTextField2.getText();String jenis_kel=rdLaki.getText();String jenis_kel2=rdPerempuan.getText();String tgl_lahir=(String) jComboBox1.getSelectedItem();String bulan_lahir=(String) jComboBox2.getSelectedItem();String tahun_lahir=(String) jComboBox3.getSelectedItem();String status=rdMenikah.getText();String status2=rdBelummenikah.getText();String pendidikan=(String) jComboBox5.getSelectedItem();String jml_anak =jTextField3.getText();String kode_gol =(String) jComboBox5.getSelectedItem();String kode_jabatan =(String) jComboBox6.getSelectedItem();String jabatan =(String) jComboBox7.getSelectedItem();

JOptionPane.showMessageDialog(null,nip +"\n" + nama+"\n"+ jenis_kel+"\n"+ jenis_kel2+"\n" +tgl_lahir+"\n"+bulan_lahir+"\n"+tahun_lahir+"\n"+ status+"\n"+status2+"\n"+pendidikan+"\n"+jml_anak+ "\n"+ kode_gol+"\n"+kode_jabatan+jabatan);try { con = DriverManager.getConnection(url,"root",""); System.out.println("Database Ditemukan"); stmt = con.createStatement();

Page 19: Modul Database_sistem Penggajian Pegawai

String SQL = "insert into pegawai values('" +nip+ "','" +nama+ "', '" +jenis_kel+ "', '" +jenis_kel2+ "', '"+tgl_lahir+ "', '" +tgl_lahir+"', '" +tgl_lahir+ "','" +status+ "', '" +status2+"','"+pendidikan+ "', '" +jml_anak+ "','" +kode_gol+"', '" +kode_jabatan+ "', '"+jabatan+ "')"; stmt.executeUpdate(SQL); } catch (SQLException ex){ System.err.println("SQL Exception:"+ex.getMessage()); } } else if(rdBelummenikah.isSelected()){String nip=jTextField1.getText();String nama=jTextField2.getText();String jenis_kel=rdLaki.getText();String jenis_kel2=rdPerempuan.getText();String tgl_lahir=(String) jComboBox1.getSelectedItem();String bulan_lahir=(String) jComboBox2.getSelectedItem();String tahun_lahir=(String) jComboBox3.getSelectedItem();String status=rdMenikah.getText();String status2=rdBelummenikah.getText();String pendidikan=(String) jComboBox5.getSelectedItem();String jml_anak =jTextField3.getText();String kode_gol =(String) jComboBox5.getSelectedItem();String kode_jabatan =(String) jComboBox6.getSelectedItem();String jabatan =(String) jComboBox7.getSelectedItem();String JenKel="";

JOptionPane.showMessageDialog(null,nip +"\n" + nama+"\n"+ jenis_kel+"\n"+ jenis_kel2+"\n" +tgl_lahir+"\n"+bulan_lahir+"\n"+tahun_lahir+"\n"+ status+"\n"+status2+"\n"+pendidikan+"\n"+jml_anak+ "\n"+ kode_gol+"\n"+kode_jabatan+jabatan);try { con = DriverManager.getConnection(url,"root",""); System.out.println("Database Ditemukan"); stmt = con.createStatement(); String SQL = "insert into pegawai values('" +nip+ "','" +nama+ "', '" +jenis_kel+ "', '" +jenis_kel2+ "', '"+tgl_lahir+ "', '" +tgl_lahir+"', '" +tgl_lahir+ "','" +status+ "', '" +status2+"','"+pendidikan+ "', '" +jml_anak+ "','" +kode_gol+"', '" +kode_jabatan+ "', '"+jabatan+ "')"; stmt.executeUpdate(SQL); } catch (SQLException ex){ System.err.println("SQL Exception:"+ex.getMessage()); } }} else if (rdPerempuan.isSelected()){ if(rdMenikah.isSelected()){String nip=jTextField1.getText();String nama=jTextField2.getText();String jenis_kel=rdLaki.getText();String jenis_kel2=rdPerempuan.getText();String tgl_lahir=(String) jComboBox1.getSelectedItem();String bulan_lahir=(String) jComboBox2.getSelectedItem();String tahun_lahir=(String) jComboBox3.getSelectedItem();String status=rdMenikah.getText();String status2=rdBelummenikah.getText();String pendidikan=(String) jComboBox5.getSelectedItem();String jml_anak =jTextField3.getText();String kode_gol =(String) jComboBox5.getSelectedItem();String kode_jabatan =(String) jComboBox6.getSelectedItem();String jabatan =(String) jComboBox7.getSelectedItem();JOptionPane.showMessageDialog(null,nip +"\n" + nama+"\n"+ jenis_kel+"\n"+ jenis_kel2+"\n" +tgl_lahir+"\n"+bulan_lahir+"\n"+tahun_lahir+"\n"+ status+"\n"+status2+"\n"+pendidikan+"\n"+jml_anak+ "\n"+ kode_gol+"\n"+kode_jabatan+jabatan);try { con = DriverManager.getConnection(url,"root",""); System.out.println("Database Ditemukan"); stmt = con.createStatement(); String SQL = "insert into pegawai values('" +nip+ "','" +nama+ "', '" +jenis_kel+ "', '" +jenis_kel2+ "', '"+tgl_lahir+ "', '" +tgl_lahir+"', '" +tgl_lahir+ "','" +status+ "', '" +status2+"','"+pendidikan+ "', '" +jml_anak+ "','" +kode_gol+"', '" +kode_jabatan+ "', '"+jabatan+ "')"; stmt.executeUpdate(SQL); } catch (SQLException ex){ System.err.println("SQL Exception:"+ex.getMessage()); }

Page 20: Modul Database_sistem Penggajian Pegawai

} else if(rdBelummenikah.isSelected()){String nip=jTextField1.getText();String nama=jTextField2.getText();String jenis_kel=rdLaki.getText();String jenis_kel2=rdPerempuan.getText();String tgl_lahir=(String) jComboBox1.getSelectedItem();String bulan_lahir=(String) jComboBox2.getSelectedItem();String tahun_lahir=(String) jComboBox3.getSelectedItem();String status=rdMenikah.getText();String status2=rdBelummenikah.getText();String pendidikan=(String) jComboBox5.getSelectedItem();String jml_anak =jTextField3.getText();String kode_gol =(String) jComboBox5.getSelectedItem();String kode_jabatan =(String) jComboBox6.getSelectedItem();String jabatan =(String) jComboBox7.getSelectedItem();JOptionPane.showMessageDialog(null,nip +"\n" + nama+"\n"+ jenis_kel+"\n"+ jenis_kel2+"\n" +tgl_lahir+"\n"+bulan_lahir+"\n"+tahun_lahir+"\n"+ status+"\n"+status2+"\n"+pendidikan+"\n"+jml_anak+ "\n"+ kode_gol+"\n"+kode_jabatan+jabatan);try { con = DriverManager.getConnection(url,"root",""); System.out.println("Database Ditemukan"); stmt = con.createStatement(); String SQL = "insert into pegawai values('" +nip+ "','" +nama+ "', '" +jenis_kel+ "', '" +jenis_kel2+ "', '"+tgl_lahir+ "', '" +tgl_lahir+"', '" +tgl_lahir+ "','" +status+ "', '" +status2+"','"+pendidikan+ "', '" +jml_anak+ "','" +kode_gol+"', '" +kode_jabatan+ "', '"+jabatan+ "')"; stmt.executeUpdate(SQL); } catch (SQLException ex){ System.err.println("SQL Exception:"+ex.getMessage()); } } }

c. Button hapusKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,

String nip=jTextField1.getText();String nama=jTextField2.getText();String jenis_kel=rdLaki.getText();String jenis_kel2=rdPerempuan.getText();String tgl_lahir=(String) jComboBox1.getSelectedItem();String bulan_lahir=(String) jComboBox2.getSelectedItem();String tahun_lahir=(String) jComboBox3.getSelectedItem();String status=rdMenikah.getText();String status2=rdBelummenikah.getText();String pendidikan=(String) jComboBox5.getSelectedItem();String jml_anak =jTextField3.getText();String kode_gol =(String) jComboBox5.getSelectedItem();String kode_jabatan =(String) jComboBox6.getSelectedItem();String jabatan =(String) jComboBox7.getSelectedItem();

nip= jTextField1.getText(); JOptionPane.showMessageDialog(null,"Tasking ="+nip); try{ con = DriverManager.getConnection(url, "root",""); String sql ="Select*from pegawai where nip='"+nip+" ' "; stmt = con.createStatement(); ResultSet rslt = stmt.executeQuery(sql); if (rslt.next()){ JOptionPane.showMessageDialog(null,"Testing1="+nip); nip = rslt.getString ("nip"); nama = rslt.getString ("nama");

jTextField2.setText(nama);

Page 21: Modul Database_sistem Penggajian Pegawai

int ok= JOptionPane.showConfirmDialog(null,"Benar ingin Hapus?","informasi", JOptionPane.YES_NO_OPTION); if (ok==0){ String sql2 = "delete from pegawai where nip = '"+nip+"'"; try { con = DriverManager.getConnection(url, "root",""); Statement s1 = con.createStatement(); s1.executeUpdate(sql2);} catch (SQLException e){ JOptionPane.showMessageDialog(null,"Error:"+e);

}jTextField1.setText(" ");jTextField2.setText(" ");jTextField3.setText(" ");

} } elseJOptionPane.showMessageDialog(null,"nip tidak ditemukan");

} catch (Exception ex){ System.err.println("Exception:"+ ex.getMessage() ); }

d. Button EditKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawahString nip=jTextField1.getText();String nama=jTextField2.getText();String jenis_kel=rdLaki.getText();String jenis_kel2=rdPerempuan.getText();String tgl_lahir=(String) jComboBox1.getSelectedItem();String bulan_lahir=(String) jComboBox2.getSelectedItem();String tahun_lahir=(String) jComboBox3.getSelectedItem();String status=rdMenikah.getText();String status2=rdBelummenikah.getText();String pendidikan=(String) jComboBox5.getSelectedItem();String jml_anak =jTextField3.getText();String kode_gol =(String) jComboBox5.getSelectedItem();String kode_jabatan =(String) jComboBox6.getSelectedItem();String jabatan =(String) jComboBox7.getSelectedItem();

JOptionPane.showMessageDialog(null,nip +"\n" + nama+"\n"+ jenis_kel+"\n"+ jenis_kel2+"\n" +tgl_lahir+"\n"+bulan_lahir+"\n"+tahun_lahir+"\n"+ status+"\n"+status2+"\n"+pendidikan+"\n"+jml_anak+ "\n"+ kode_gol+"\n"+kode_jabatan+jabatan);String SQL2="Update pegawai set nama ='"+nama+"',jenis_kel='"+jenis_kel+"',jenis_kel2='"+jenis_kel2+"',tgl_lahir='"+tgl_lahir+"',bulan_lahir='"+bulan_lahir+"',tahun_lahir='"+tahun_lahir+"',status='"+status+"',status2='"+status2+"',pendidikan='"+pendidikan+"',jml_anak='"+jml_anak+"',kode_gol='"+kode_gol+"',kode_jabatan='"+kode_jabatan+ "',jabatan='"+jabatan+"'where nip='"+nip+"'";try { con = DriverManager.getConnection(url, "root",""); Statement s1 = con.createStatement(); s1.executeUpdate(SQL2);} catch (SQLException e){ JOptionPane.showMessageDialog(null,"Error:"+e);

}

Page 22: Modul Database_sistem Penggajian Pegawai

jTextField1.setText(" ");jTextField2.setText(" ");jTextField3.setText(" ");jTextField4.setText(" ");

jComboBox1.setSelectedItem(" ");jComboBox2.setSelectedItem(" ");jComboBox3.setSelectedItem(" ");jComboBox5.setSelectedItem(" ");

}

e. Button RefreshKlik kanan, pilih Events ActionActionPerformed, copy paste listing dibawah,dispose();new pegawai ().setVisible(true);

f. Button CariKlik kanan, pilih Events Action ActionPerformed, copy paste listing dibawah,String nip=jTextField1.getText();String nama=jTextField2.getText();String jenis_kel=rdLaki.getText();String jenis_kel2=rdPerempuan.getText();String tgl_lahir=(String) jComboBox1.getSelectedItem();String bulan_lahir=(String) jComboBox2.getSelectedItem();String tahun_lahir=(String) jComboBox3.getSelectedItem();String status=rdMenikah.getText();String status2=rdBelummenikah.getText();String pendidikan=(String) jComboBox5.getSelectedItem();String jml_anak =jTextField3.getText();String kode_gol =(String) jComboBox5.getSelectedItem();String kode_jabatan =(String) jComboBox6.getSelectedItem();String jabatan =(String) jComboBox7.getSelectedItem();

nip = jTextField4.getText();JOptionPane.showMessageDialog(null,"Testing=" +nip);try { con = DriverManager.getConnection(url, "root", ""); String SQL = "Select *from pegawai where nip = '"+nip+"'"; stmt = con.createStatement(); ResultSet rslt = stmt.executeQuery(SQL); if (rslt.next()){ nip = rslt.getString ("nip"); nama = rslt.getString ("nama"); jenis_kel = rslt.getString ("jenis_kel"); jenis_kel2 = rslt.getString ("jenis_kel2"); tgl_lahir = rslt.getString ("tgl_lahir"); bulan_lahir = rslt.getString ("bulan_lahir"); tahun_lahir = rslt.getString ("tahun_lahir"); status = rslt.getString ("status"); status2 = rslt.getString ("status2"); pendidikan = rslt.getString ("pendidikan"); jml_anak = rslt.getString ("jml_anak"); kode_gol = rslt.getString ("kode_gol"); kode_jabatan = rslt.getString ("kode_jabatan"); jabatan = rslt.getString ("jabatan");

jTextField1.setText(nip);jTextField2.setText(nama);rdLaki.setName(jenis_kel);rdPerempuan.setName(jenis_kel2);jComboBox1.setSelectedItem(tgl_lahir);jComboBox2.setSelectedItem(bulan_lahir);jComboBox3.setSelectedItem(tahun_lahir);rdMenikah.setText(status);rdBelummenikah.setText(status2);jComboBox5.setSelectedItem(pendidikan);

Page 23: Modul Database_sistem Penggajian Pegawai

jTextField3.setText(jml_anak);jComboBox5.setSelectedItem(kode_gol);jComboBox6.setSelectedItem(kode_jabatan);jComboBox7.setSelectedItem(jabatan);JOptionPane.showMessageDialog(null,"nip di temukan");

} elseJOptionPane.showMessageDialog(null,"nip tidak ditemukan");} catch (Exception ex){ System.err.println("Exception :"+ex.getMessage());}

g. Button BackKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,pageutama h = new pageutama(); h.setVisible(true); dispose();

h. Listing tambahanimport java.io.FileWriter;import java.io.IOException;import javax.swing.JOptionPane;import java.sql.*;public class pegawai extends javax.swing.JFrame { Statement stmt;Connection con;String url ="jdbc:mysql://localhost:3306/penggajian";

public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(pegawai.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(pegawai.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(pegawai.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(pegawai.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold>

/* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() {

public void run() { new pegawai().setVisible(true); } }); try {

Class.forName("com.mysql.jdbc.Driver");System.out.println("Driver ditemukan");

}catch (Exception e){System.out.println("Error"+e);} } // Variables declaration - do not modify private javax.swing.ButtonGroup buttonGroup1; private javax.swing.ButtonGroup buttonGroup2; private javax.swing.JButton jButton1; private javax.swing.JButton jButton3; private javax.swing.JButton jButton4; private javax.swing.JButton jButton5; private javax.swing.JButton jButton6; private javax.swing.JButton jButton7; private javax.swing.JComboBox jComboBox1; private javax.swing.JComboBox jComboBox2; private javax.swing.JComboBox jComboBox3;

Page 24: Modul Database_sistem Penggajian Pegawai

private javax.swing.JComboBox jComboBox5; private javax.swing.JComboBox jComboBox8; private javax.swing.JComboBox jComboBox9; private javax.swing.JFrame jFrame1; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel15; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel21; private javax.swing.JLabel jLabel22; private javax.swing.JLabel jLabel23; private javax.swing.JLabel jLabel24; private javax.swing.JLabel jLabel26; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel5; private javax.swing.JLabel jLabel6; private javax.swing.JPanel jPanel1; private javax.swing.JRadioButton jRadioButton1; private javax.swing.JRadioButton jRadioButton2; private javax.swing.JRadioButton jRadioButton3; private javax.swing.JRadioButton jRadioButton4; private javax.swing.JTextField jTextField1; private javax.swing.JTextField jTextField2; private javax.swing.JTextField jTextField3; private javax.swing.JTextField jTextField4; // End of variables declaration }

3. Pada form3(absen) :a. TextField1 (Kode Absensi)

Klik kanan, pilih Events Mouse mouseReleased, copy paste listing dibawah,String kode_absensi = jTextField1.getText();String nip =(String) jComboBox1.getSelectedItem();String jmlh_jam_kerja=jTextField2.getText();String jmlh_jam_tdk_masuk=jTextField3.getText();String total_jam_masuk=jTextField4.getText();

kode_absensi = jTextField1.getText();JOptionPane.showMessageDialog(null,"Testing=" +kode_absensi);try { con = DriverManager.getConnection(url, "root", ""); String SQL = "Select *from absensi where kode_absensi = '"+kode_absensi+"'"; stmt = con.createStatement(); ResultSet rslt = stmt.executeQuery(SQL); while (rslt.next()){ kode_absensi = rslt.getString ("kode_absensi"); nip = rslt.getString ("nip"); total_jam_masuk= rslt.getString ("kehadiran");

jComboBox1.setSelectedItem(nip);jTextField4.setText(total_jam_masuk);

}} catch (Exception ex){ System.err.println("Exception :"+ex.getMessage());}

b. Combobox1 (Nip)Klik kanan, pilih Events PopupMenuPopupMenuWillBecomeVisible, copy paste listing dibawah,jComboBox1.removeAllItems(); try{ con=DriverManager.getConnection(url,"root",""); stmt=con.createStatement(); String sql="select nip from pegawai"; ResultSet s=stmt.executeQuery(sql);

while(s.next()){

String kode=s.getString("nip"); jComboBox1.addItem(kode); } }

Page 25: Modul Database_sistem Penggajian Pegawai

catch(Exception ex){ System.err.println("Exception ex:"+ex.getMessage()); }

c. Button SimpanKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,String kode_absensi=jTextField1.getText();String nip=(String) jComboBox1.getSelectedItem();String jmlh_jam_kerja=jTextField3.getText();String jmlh_jam_tdk_masuk=jTextField4.getText();String total_jam_masuk=jTextField5.getText();

JOptionPane.showMessageDialog(null,kode_absensi +"\n" + nip+"\n"+ jmlh_jam_kerja+"\n"+jmlh_jam_tdk_masuk+"\n"+total_jam_masuk);try { con = DriverManager.getConnection(url,"root",""); System.out.println("Database Ditemukan"); stmt = con.createStatement(); String SQL = "insert into absensi values('" +kode_absensi+ "','" +nip+ "','" +total_jam_masuk+ "')"; stmt.executeUpdate(SQL); } catch (SQLException ex){ System.err.println("SQL Exception:"+ex.getMessage()); }

d. Button HapusKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,c

e. Button Hitung jumlah jam masuk kerjaKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,long a,b; long c; a=Long.parseLong(jTextField3.getText()); b=Long.parseLong(jTextField4.getText()); c=a-b; jTextField5.setText(""+c);

f. Button BackKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,new pageutama().setVisible(true); dispose();

g. Listing tambahanimport java.io.FileWriter;import java.io.IOException;import javax.swing.JOptionPane;import java.sql.*;

public class absen extends javax.swing.JFrame { Statement stmt;Connection con;String url ="jdbc:mysql://localhost:3306/penggajian";

public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } }

Page 26: Modul Database_sistem Penggajian Pegawai

} catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(absen.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(absen.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(absen.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(absen.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold>

/* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() {

public void run() { new absen().setVisible(true); } }); try {

Class.forName("com.mysql.jdbc.Driver");System.out.println("Driver ditemukan");

}catch (Exception e){System.out.println("Error"+e);} } // Variables declaration - do not modify private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JButton jButton4; private javax.swing.JButton jButton5; private javax.swing.JComboBox jComboBox1; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel5; private javax.swing.JLabel jLabel6; private javax.swing.JLabel jLabel7; private javax.swing.JLabel jLabel8; private javax.swing.JTextField jTextField1; private javax.swing.JTextField jTextField3; private javax.swing.JTextField jTextField4; private javax.swing.JTextField jTextField5; // End of variables declaration }

4. Pada form4 (login) :a. Button Login

Klik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,String username = jTextField1.getText();String password = jPasswordField1.getText();

if (username.equals("dedek")&& password.equals("12345")){ new pageutama().setVisible(true); dispose();}else

{ JOptionPane.showMessageDialog(null, "Login Gagal");}

b. Button ExitKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,dispose();

c. Lisitng Tambahanimport javax.swing.JOptionPane;

Page 27: Modul Database_sistem Penggajian Pegawai

import javax.swing.JOptionPane;import java.sql.*;

public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(login.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(login.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(login.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(login.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold>

/* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() {

public void run() { new login().setVisible(true); } }); try { Class.forName("com.mysql.jdbc.Driver"); System.out.println("Driver berhasil ditemukan....."); } catch(Exception e) { System.out.println("error"+e);

} } // Variables declaration - do not modify private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JPanel jPanel1; private javax.swing.JPanel jPanel2; private javax.swing.JPasswordField jPasswordField1; private javax.swing.JTextField jTextField1; // End of variables declaration }

5. Pada form5 (gaji) :a. TextField1 (No_Slip)

Klik kanan, pilih Events Mouse mouseReleased, copy paste listing dibawah,String no_slip=jTextField1.getText();

Page 28: Modul Database_sistem Penggajian Pegawai

String tanggal_gaji=jTextField3.getText();String tunjangan_anak=jTextField4.getText();String tunjangan_pasangan=jTextField5.getText();String tunjangan_jabatan=jTextField8.getText();String gaji_pokok=jTextField9.getText();String gaji_bersih=jTextField11.getText();

no_slip = jTextField1.getText();JOptionPane.showMessageDialog(null,"Testing=" +no_slip);try { con = DriverManager.getConnection(url, "root", ""); String SQL = "Select *from gaji where no_slip= '"+no_slip+"'"; stmt = con.createStatement(); ResultSet rslt = stmt.executeQuery(SQL); while (rslt.next()){ no_slip= rslt.getString ("no_slip"); tanggal_gaji = rslt.getString ("tanggal_gaji"); tunjangan_anak = rslt.getString ("tunjangan_anak"); tunjangan_pasangan = rslt.getString ("tunjangan_pasangan"); tunjangan_jabatan = rslt.getString ("tunjangan_jabatan"); gaji_pokok = rslt.getString ("gaji_pokok"); gaji_bersih = rslt.getString ("gaji_bersih");

jTextField3.setText(tanggal_gaji);jTextField4.setText(tunjangan_anak);jTextField5.setText(tunjangan_pasangan);jTextField8.setText(tunjangan_jabatan);jTextField9.setText(gaji_pokok);jTextField11.setText(gaji_bersih);

}} catch (Exception ex){ System.err.println("Exception :"+ex.getMessage());}

b. Combobox1 (pilih nip pegawai)Klik kanan, pilih Events PopupMenuPopupMenuWillBecomeVisible, copy paste listing dibawah,jComboBox1.removeAllItems(); try{ con=DriverManager.getConnection(url,"root",""); stmt=con.createStatement(); String sql="select nip from pegawai"; ResultSet s=stmt.executeQuery(sql);

while(s.next()){

String kode=s.getString("nip"); jComboBox1.addItem(kode); } } catch(Exception ex){ System.err.println("Exception ex:"+ex.getMessage()); }

c. Button simpanKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,String no_slip=jTextField1.getText();String tanggal_gaji=jTextField3.getText();String nip=(String) jComboBox1.getSelectedItem();String tunjangan_anak=jTextField4.getText();String tunjangan_pasangan=jTextField5.getText();String tunjangan_jabatan=jTextField8.getText();String gaji_pokok=jTextField9.getText();String gaji_bersih=jTextField11.getText();

JOptionPane.showMessageDialog(null,no_slip +"\n" +tanggal_gaji+"\n"+tunjangan_anak+"\n"+ tunjangan_pasangan+"\n"+tunjangan_jabatan+"\n"+ gaji_pokok+"\n"+ gaji_bersih);try { con = DriverManager.getConnection(url,"root",""); System.out.println("Database Ditemukan");

Page 29: Modul Database_sistem Penggajian Pegawai

stmt = con.createStatement(); String SQL = "insert into gaji values('" +no_slip+ "','" +nip+ "','" +tanggal_gaji+ "','" +tunjangan_anak+ "', '" +tunjangan_pasangan+"','" +tunjangan_jabatan+ "', '" +gaji_pokok+ "','" +gaji_bersih+ "')"; stmt.executeUpdate(SQL); } catch (SQLException ex){ System.err.println("SQL Exception:"+ex.getMessage()); }

d. Button EditKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,String no_slip=jTextField1.getText();String tanggal_gaji=jTextField3.getText();String tunjangan_anak=jTextField4.getText();String tunjangan_pasangan=jTextField5.getText();String tunjangan_jabatan=jTextField8.getText();String gaji_pokok=jTextField9.getText();String gaji_bersih=jTextField11.getText();

JOptionPane.showMessageDialog(null,no_slip +"\n" +tanggal_gaji+"\n"+tunjangan_anak+"\n"+ tunjangan_pasangan+"\n"+tunjangan_jabatan+"\n"+ gaji_pokok+"\n"+ gaji_bersih);

String SQL2="Update gaji set tanggal_gaji ='"+tanggal_gaji+"',tunjangan_anak='"+tunjangan_anak+"',tunjangan_pasangan='"+tunjangan_pasangan+"',tunjangan_jabatan='"+tunjangan_jabatan+"',gaji_pokok='"+gaji_pokok+"',gaji_bersih='"+gaji_bersih+"'";

try { con = DriverManager.getConnection(url, "root",""); Statement s1 = con.createStatement(); s1.executeUpdate(SQL2);} catch (SQLException e){ JOptionPane.showMessageDialog(null,"Error:"+e); }

jTextField1.setText(" "); jTextField3.setText(" ");

e. Button hapusKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,String no_slip=jTextField1.getText();String tanggal_gaji=jTextField3.getText();String tunjangan_anak=jTextField4.getText();String tunjangan_pasangan=jTextField5.getText();String tunjangan_jabatan=jTextField8.getText();String gaji_pokok=jTextField9.getText();String gaji_bersih=jTextField11.getText();

no_slip= jTextField1.getText(); JOptionPane.showMessageDialog(null,"Tasking ="+no_slip); try{ con = DriverManager.getConnection(url, "root",""); String sql ="Select*from gaji where no_slip='"+no_slip+" ' "; stmt = con.createStatement(); ResultSet rslt = stmt.executeQuery(sql); if (rslt.next()){ JOptionPane.showMessageDialog(null,"Testing1="+no_slip); no_slip= rslt.getString ("no_slip"); tanggal_gaji = rslt.getString ("tanggal_gaji"); tunjangan_anak = rslt.getString ("tunjangan_anak"); tunjangan_pasangan = rslt.getString ("tunjangan_pasangan"); tunjangan_jabatan = rslt.getString ("tunjangan_jabatan"); gaji_pokok = rslt.getString ("gaji_pokok"); gaji_bersih = rslt.getString ("gaji_bersih");

jTextField3.setText(tanggal_gaji);jTextField4.setText(tunjangan_anak);jTextField5.setText(tunjangan_pasangan);jTextField8.setText(tunjangan_jabatan);jTextField9.setText(gaji_pokok);jTextField11.setText(gaji_bersih);

Page 30: Modul Database_sistem Penggajian Pegawai

int ok= JOptionPane.showConfirmDialog(null,"Benar ingin Hapus?","informasi", JOptionPane.YES_NO_OPTION); if (ok==0){ String sql2 = "delete from gaji where no_slip = '"+no_slip+"'"; try { con = DriverManager.getConnection(url, "root",""); Statement s1 = con.createStatement(); s1.executeUpdate(sql2);} catch (SQLException e){ JOptionPane.showMessageDialog(null,"Error:"+e);

}jTextField1.setText(" ");jTextField3.setText(" ");jTextField4.setText(" ");jTextField5.setText(" ");jTextField8.setText(" ");jTextField9.setText(" "); jTextField11.setText(" "); } elseJOptionPane.showMessageDialog(null,"no_slip tidak ditemukan");

} }

catch (Exception ex){ System.err.println("Exception:"+ ex.getMessage() ); }

f. Button BackKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,new pageutama().setVisible(true); dispose();

g. Button Hitung Total GajiKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,

double nilai1; double nilai2; double nilai3; double nilai4; double nilai5; String hasil;

nilai1=Double.valueOf(jTextField4.getText()); nilai2=Double.valueOf(jTextField5.getText()); nilai3=Double.valueOf(jTextField8.getText()); nilai4=Double.valueOf(jTextField9.getText());

nilai5=((nilai1+nilai2+nilai3+nilai4)); hasil=String.valueOf(nilai5); jTextField11.setText(hasil);

6. Pada form6 (cari):a. Button Sortir

Klik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,Object[] Baris1={"NIP","NAMA","KODE JABATAN","JABATAN","KODE GOLONGAN","GAJI POKOK"}; model=new DefaultTableModel(null,Baris1); jTable1.setModel(model);

try{ con=(Connection) DriverManager.getConnection(url,"root","");

String sql="SELECT pegawai.nip, pegawai.nama, jabatan.kode_jabatan, jabatan.jabatan, golongan.kode_gol, gaji.gaji_pokok FROM pegawai,jabatan,golongan,gaji where pegawai.nip=gaji.nip AND jabatan.kode_jabatan=pegawai.kode_jabatan AND golongan.kode_gol=pegawai.kode_gol AND jabatan like '%"+jComboBox1.getSelectedItem()+"%' order by nip asc";

Statement stmt=(Statement) con.createStatement(); ResultSet l=stmt.executeQuery(sql); while(l.next()){

String nip=l.getString("nip");

Page 31: Modul Database_sistem Penggajian Pegawai

String nama=l.getString("nama"); String kode_jabatan=l.getString("kode_jabatan"); String jabatan=l.getString("jabatan"); String kode_gol=l.getString("kode_gol"); String gaji_pokok=l.getString("gaji_pokok");

String[] dataField={nip,nama,kode_jabatan,jabatan,kode_gol,gaji_pokok}; model.addRow(dataField); } } catch(Exception ex){ System.err.println("Exception :"+ex.getMessage());

}

b. Button backKlik kanan, pilih Events Mouse mouseClicked, copy paste listing dibawah,new pageutama().setVisible(true);dispose();

c. Lisitng Tambahanimport com.mysql.jdbc.Connection;import com.mysql.jdbc.Statement;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.util.logging.Level;import java.util.logging.Logger;import javax.swing.table.DefaultTableModel;

public class cari extends javax.swing.JFrame {

Connection con; Statement stmt;

String url="jdbc:mysql://localhost:3306/penggajian";public void koneksi(){

// memangil fungsi konek() untuk melakukan koneksimain("localhost","penggajian","root",""); // tinggal mengganti dengan nama database yang kamu buat tadi..}

// Program untuk melakukan koneksi public void main(String server,String db,String user,String passwd){

System.out.println("Keterangan"); //memanggil driver try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { System.out.println( "Ada kesalahan Driver JDBC tidak berhasil Load"); return; } System.out.println("Mysql JDBC Driver berhasil di Load"); con = null;

try { con = (Connection) DriverManager.getConnection(url,"root",""); } catch (SQLException e) { System.out.println("Tidak bisa koneksi ke database"); return; } if (con != null) System.out.println("Berhasil Koneksi!"); else System.out.println("Koneksi Gagal........ !"); }

private DefaultTableModel model;

/** Creates new form laporan */ public cari() { initComponents();

Page 32: Modul Database_sistem Penggajian Pegawai

Object[] Baris1={"NIP","NAMA","KODE JABATAN","JABATAN","KODE GOLONGAN","GAJI POKOK"}; model=new DefaultTableModel(null,Baris1); jTable1.setModel(model);

try{ con=(Connection) DriverManager.getConnection(url,"root","");

String sql="SELECT pegawai.nip, pegawai.nama, jabatan.kode_jabatan, jabatan.jabatan, golongan.kode_gol, gaji.gaji_pokok FROM pegawai,jabatan,golongan,gaji where pegawai.nip=gaji.nip AND jabatan.kode_jabatan=pegawai.kode_jabatan AND golongan.kode_gol=pegawai.kode_gol";

Statement stmt=(Statement) con.createStatement(); ResultSet l=stmt.executeQuery(sql); while(l.next()){

String nip=l.getString("nip"); String nama=l.getString("nama"); String kode_jabatan=l.getString("kode_jabatan"); String jabatan=l.getString("jabatan"); String kode_gol=l.getString("kode_gol"); String gaji_pokok=l.getString("gaji_pokok");

String[] dataField={nip,nama,kode_jabatan,jabatan,kode_gol,gaji_pokok}; model.addRow(dataField); } } catch(Exception ex){ System.err.println("Exception :"+ex.getMessage());

}

}

public static void main(String[] args) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(cari.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(cari.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(cari.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(cari.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold>

/* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() {

public void run() { new cari().setVisible(true); } }); try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException ex) {

Page 33: Modul Database_sistem Penggajian Pegawai

Logger.getLogger(cari.class.getName()).log(Level.SEVERE, null, ex); } System.err.println("Driver ditemukan");

}

// Variables declaration - do not modify private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JButton jButton3; private javax.swing.JButton jButton4; private javax.swing.JComboBox jComboBox1; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JPanel jPanel1; private javax.swing.JPanel jPanel2; private javax.swing.JScrollPane jScrollPane1; private javax.swing.JTable jTable1; private javax.swing.JTextField jTextField1; // End of variables declaration

}

BAB VIPENGATURAN

1. Pengaturan Main Menu

Page 34: Modul Database_sistem Penggajian Pegawai

2. Pengaturan Driver

Driver yang digunakan untuk koneksi database MYSQL ke java yaitu, JDBCcara pengaturannya,

Page 35: Modul Database_sistem Penggajian Pegawai

3. Koneksi program dengan database, dengan cara klik services – databases- klik new connection,

Lalu pada driver pilih MySQL(Connector/Jdriver), klik next

Lalu pada nama database, isi sesuai dengan nama database, lalu test connection, klo success tekan finish..

Page 36: Modul Database_sistem Penggajian Pegawai

BAB VIIPENGENALAN PROGRAM

1. Form loginUsername : dedekPassword : 12345

2. Form Utama, pada form utama useradmin dapat mengakses segala menu-menu yang telah disediakan.

3. Form Biodata Pegawai

Page 37: Modul Database_sistem Penggajian Pegawai

4. Form Absensi

5. Form Hitung Gaji

Page 38: Modul Database_sistem Penggajian Pegawai

6. Form Pencarian