Cara Membuat Aplikasi Penggajian dengan sederhana

Assalamualaikum Guys...

Selamat Pagi.saat ini saya mau menjelaskan tutorial membuat Aplikasi sederhana, ini adalah aplikasi lanjutan dari tugas UTS sebelumnya. yang dimana pada project tugas UTS sebelumnya saya hanya membuat rancangan desainnya saja.

Namun pada project tugas UAS kali ini, saya merubah dan menghubungkan project yang saya buat ini dengan sebuah database mysql.

Untuk File Database yang saya gunakan, rinciannya sebagai berikut :

Nama Database : db_payrol

Daftar Table : payrol

tbl_payrol : Bulan, Tahun, NIK, Nama_Karyawan, Status_Karyawan, Absensi_Kehadiran, Gaji_pokok, Tunjangan_Kesehatan, Tunjangan_Jabatan, Tunjangan_Makan, Tunjangan_Transport, dan Gaji_Bruto

Untuk langkah-langkah sederhana pembuatan database sebagai berikut :

Setelah membuat database yang kita butuhkan selanjutnya membuat Java Package dengan kode sebagai berikut ini :

Jika sudah selesai maka database yang kita buat akan masuk seperti ini

Lalu langsung saja kita test database yang sudah kita buat dengan hasil seperti ini

Pada bagian database kita sudah selesai membuat data yang kita perlukan, selanjutnya kita impor beberapa data yang kita perlukan di dalam netbeans sebagai berikut :

Setelah berhasil melakukan inport langsung membuat Jframe yang kita butuhkan dan masukkan kode sebagai berikut ini :

* To change this license header, choose License Headers in Project Properties.

* To change this template file, choose Tools | Templates

* and open the template in the editor.

package utama;

import java.awt.HeadlessException;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.swing.JOptionPane;

import net.proteanit.sql.DbUtils;

/**

* @author mo

public class utama extends javax.swing.JFrame {

public boolean databaru;

/**

* Creates new form utama

public utama() {

initComponents();

GetData(); // tampilkan ke grid

databaru=true;

}

void GetData() {

try{

Connection conn =(Connection)Koneksi.koneksi.koneksiDB();

java.sql.Statement stm = conn.createStatement();

java.sql.ResultSet sql = stm.executeQuery("select * from payrol");

Ttable.setModel(DbUtils.resultSetToTableModel(sql));

}

catch (SQLException | HeadlessException e){

}

void kosongkan() {

//Mengosongkan TextField

jComboBox1.setSelectedItem(null);

jComboBox2.setSelectedItem(null);

Nik.setText(null);

Nkaryawan.setText(null);

jComboBox3.setSelectedItem(null);

Ahadir.setText(null);

Gpokok.setText(null);

Tkesehatan.setText(null);

TJabatan.setText(null);

Tmakan.setText(null);

Ttransport.setText(null);

Tbruto.setText(null);

}

/**

* 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")

// <editor-fold defaultstate="collapsed" desc="Generated Code">

private void initComponents() {

Tbruto = new javax.swing.JTextField();

Gpokok = new javax.swing.JTextField();

jComboBox1 = new javax.swing.JComboBox<>();

jComboBox2 = new javax.swing.JComboBox<>();

jLabel8 = new javax.swing.JLabel();

jComboBox3 = new javax.swing.JComboBox<>();

jLabel9 = new javax.swing.JLabel();

jLabel10 = new javax.swing.JLabel();

jLabel11 = new javax.swing.JLabel();

jLabel13 = new javax.swing.JLabel();

jLabel14 = new javax.swing.JLabel();

Tkesehatan = new javax.swing.JTextField();

TJabatan = new javax.swing.JTextField();

Tmakan = new javax.swing.JTextField();

Nik = new javax.swing.JTextField();

jLabel1 = new javax.swing.JLabel();

jLabel2 = new javax.swing.JLabel();

jLabel3 = new javax.swing.JLabel();

Ttransport = new javax.swing.JTextField();

jLabel4 = new javax.swing.JLabel();

jLabel5 = new javax.swing.JLabel();

jLabel6 = new javax.swing.JLabel();

jLabel7 = new javax.swing.JLabel();

Nkaryawan = new javax.swing.JTextField();

Ahadir = new javax.swing.JTextField();

BTHITUNG = new javax.swing.JToggleButton();

Tsave = new javax.swing.JToggleButton();

jScrollPane1 = new javax.swing.JScrollPane();

Ttable = new javax.swing.JTable();

Tnew = new javax.swing.JToggleButton();

Tdelete = new javax.swing.JToggleButton();

Tupdate = new javax.swing.JToggleButton();

jToggleButton6 = new javax.swing.JToggleButton();

Tcari1 = new javax.swing.JButton();

jButton1 = new javax.swing.JButton();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

addWindowListener(new java.awt.event.WindowAdapter() {

public void windowActivated(java.awt.event.WindowEvent evt) {

formWindowActivated(evt);

}

});

Tbruto.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

TbrutoActionPerformed(evt);

}

});

Gpokok.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

GpokokActionPerformed(evt);

}

});

jComboBox1.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "=Bulan=", "Januari", "Februari", "Maret", "April", "Mei", "Juni", "Juli", "Agustus", "September", "Oktober", "November", "Desember" }));

jComboBox2.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "=Tahun=" }));

jComboBox2.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

jComboBox2ActionPerformed(evt);

}

});

jLabel8.setText("Gaji Pokok");

jComboBox3.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "=Golongan=", "Karyawan Tetap", "Karyawan Kontrak", "Magang" }));

jComboBox3.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

jComboBox3ActionPerformed(evt);

}

});

jLabel9.setText("Tunjangan Kesehatan");

jLabel10.setText("Tunjangan Jabatan");

jLabel11.setText("Tunjangan Makan");

jLabel13.setText("Tunjangan Transport");

jLabel14.setText("Gaji Bruto");

Tkesehatan.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

TkesehatanActionPerformed(evt);

}

});

TJabatan.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

TJabatanActionPerformed(evt);

}

});

Tmakan.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

TmakanActionPerformed(evt);

}

});

Nik.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

NikActionPerformed(evt);

}

});

jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N

jLabel1.setText("DATA PENERIMAAN GAJI KARYAWAN");

jLabel2.setText("Bulan");

jLabel3.setText("Tahun");

Ttransport.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

TtransportActionPerformed(evt);

}

});

jLabel4.setText("NIK");

jLabel5.setText("Nama Karyawan");

jLabel6.setText("Status Karyawan");

jLabel7.setText("Absensi Kehadiran");

Nkaryawan.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

NkaryawanActionPerformed(evt);

}

});

Ahadir.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

AhadirActionPerformed(evt);

}

});

BTHITUNG.setText("HITUNG");

BTHITUNG.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

BTHITUNGActionPerformed(evt);

}

});

Tsave.setText("SIMPAN");

Tsave.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

TsaveActionPerformed(evt);

}

});

Ttable.setModel(new javax.swing.table.DefaultTableModel(

new Object [][] {

{null, null, null, null},

{null, null, null, null}

new String [] {

"Title 1", "Title 2", "Title 3", "Title 4"

}

));

jScrollPane1.setViewportView(Ttable);

Tnew.setText("BARU");

Tnew.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

TnewActionPerformed(evt);

}

});

Tdelete.setText("HAPUS");

Tdelete.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

TdeleteActionPerformed(evt);

}

});

Tupdate.setText("UPDATE");

Tupdate.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

TupdateActionPerformed(evt);

}

});

jToggleButton6.setText("KELUAR");

jToggleButton6.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

jToggleButton6ActionPerformed(evt);

}

});

Tcari1.setText("cari");

Tcari1.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

Tcari1ActionPerformed(evt);

}

});

jButton1.setText("REFRESH");

jButton1.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

jButton1ActionPerformed(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()

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(layout.createSequentialGroup()

.addGap(19, 19, 19)

.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 627, Short.MAX_VALUE))

.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()

.addContainerGap()

.addComponent(jButton1)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addComponent(Tupdate)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(Tdelete)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel9)

.addComponent(jLabel8)

.addComponent(jLabel10)

.addComponent(jLabel11)

.addComponent(jLabel14)

.addComponent(jLabel13)

.addGroup(layout.createSequentialGroup()

.addComponent(Tsave)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(BTHITUNG)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(Tnew)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jToggleButton6)))))

.addContainerGap())

.addGroup(layout.createSequentialGroup()

.addGap(116, 116, 116)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel1)

.addGroup(layout.createSequentialGroup()

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)

.addComponent(Nik)

.addComponent(Nkaryawan)

.addComponent(Ahadir)

.addComponent(jComboBox3, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jComboBox2, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 137, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(Tcari1)))

.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(layout.createSequentialGroup()

.addContainerGap()

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(layout.createSequentialGroup()

.addComponent(jLabel7)

.addGap(558, 558, 558))

.addGroup(layout.createSequentialGroup()

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(layout.createSequentialGroup()

.addComponent(jLabel6)

.addGap(0, 0, Short.MAX_VALUE))

.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel2)

.addComponent(jLabel3)

.addComponent(jLabel4)

.addComponent(jLabel5))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(Tbruto, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 137, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(Ttransport, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 137, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(Tmakan, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 137, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(TJabatan, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 137, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(Tkesehatan, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 137, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(Gpokok, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 137, javax.swing.GroupLayout.PREFERRED_SIZE))))

.addContainerGap()))))

);

layout.setVerticalGroup(

layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(layout.createSequentialGroup()

.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 53, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 43, Short.MAX_VALUE)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jComboBox1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jLabel8, javax.swing.GroupLayout.Alignment.TRAILING))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)

.addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jLabel9))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(Nik, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(Tcari1)

.addComponent(jLabel10))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(Nkaryawan, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jLabel11))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jComboBox3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jLabel13))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(Ahadir, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jLabel14))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(BTHITUNG)

.addComponent(Tsave)

.addComponent(Tnew)

.addComponent(Tdelete)

.addComponent(Tupdate)

.addComponent(jToggleButton6)

.addComponent(jButton1))

.addGap(33, 33, 33)

.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 211, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(84, 84, 84))

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(layout.createSequentialGroup()

.addGap(99, 99, 99)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(layout.createSequentialGroup()

.addGap(7, 7, 7)

.addComponent(jLabel2)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addComponent(jLabel3)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addComponent(jLabel4))

.addGroup(layout.createSequentialGroup()

.addComponent(Gpokok, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(6, 6, 6)

.addComponent(Tkesehatan, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(TJabatan, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel5)

.addComponent(Tmakan, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel6)

.addComponent(Ttransport, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel7)

.addComponent(Tbruto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addContainerGap(357, Short.MAX_VALUE)))

);

pack();

}// </editor-fold>

private void TbrutoActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

private void GpokokActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

private void jComboBox2ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

private void jComboBox3ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

if(jComboBox3.getSelectedItem()== "Karyawan Tetap"){

Gpokok.setText("2000000");

Tkesehatan.setText("10000");

Tmakan.setText("20000");

Ttransport.setText("30000");

TJabatan.setText("30000");

}

else if(jComboBox3.getSelectedItem()== "Karyawan Kontrak"){

Gpokok.setText("1500000");

Tkesehatan.setText("10000");

Tmakan.setText("20000");

Ttransport.setText("30000");

TJabatan.setText("20000");

}

else if (jComboBox3.getSelectedItem()== "Magang"){

Gpokok.setText("500000");

Tkesehatan.setText("10000");

Tmakan.setText("20000");

Ttransport.setText("30000");

TJabatan.setText("0");

}

else {

Gpokok.setText(" ");

Tkesehatan.setText(" ");

Tmakan.setText(" ");

Ttransport.setText(" ");

TJabatan.setText(" ");

}

private void TkesehatanActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

private void TJabatanActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

private void TmakanActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

private void NikActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

private void TtransportActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

private void NkaryawanActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

private void AhadirActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

private void formWindowActivated(java.awt.event.WindowEvent evt) {

// TODO add your handling code here:

for(int n=2030;n>=1995;n--){

jComboBox2.addItem(""+n);}

}

private void BTHITUNGActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

int kerajinan=Integer.parseInt(Tkesehatan.getText());

int makan=Integer.parseInt(Tmakan.getText());

int transport=Integer.parseInt(Ttransport.getText());

int jabatan=Integer.parseInt(TJabatan.getText());

int hasil=(((kerajinan+makan+transport+jabatan)*Integer.parseInt

(Ahadir.getText()))+Integer.parseInt(Gpokok.getText()));

Tbruto.setText(""+hasil);

}

private void TsaveActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

databaru = true; // prosess simpan atau edit

try{

String sql = "insert into payrol values('"+ jComboBox1.getSelectedItem()+"',"

+ "'" + jComboBox2.getSelectedItem()+"',"

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

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

+ "'" + jComboBox3.getSelectedItem()+"',"

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

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

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

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

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

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

+ "'" + Tbruto.getText()+"')";

java.sql.Connection conn = (java.sql.Connection)Koneksi.koneksi.koneksiDB();

java.sql.PreparedStatement pst = conn.prepareStatement(sql);

pst.execute();

JOptionPane.showMessageDialog(null, "Berhasil disimpan");

}catch (SQLException | HeadlessException e){

JOptionPane.showMessageDialog(null, e);

}

kosongkan();

GetData();

Nik.requestFocus();

}

private void TnewActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

databaru=true;

kosongkan();

Nik.requestFocus();

}

private void TdeleteActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

int x=

JOptionPane.showConfirmDialog(null, "Yakin Mau diHapus?", "Konfirmasi", JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);

//Jika Pilihan Yes dipilih

if(x==JOptionPane.YES_OPTION)

{

try{ //hapus data

String sql ="delete from payrol where Nik='"+Nik.getText()+"'";

java.sql.Connection conn = (java.sql.Connection)Koneksi.koneksi.koneksiDB();

java.sql.PreparedStatement pst = conn.prepareStatement(sql);

pst.execute();

JOptionPane.showMessageDialog(null, "Data akan dihapus?");

databaru=true;

}catch (SQLException | HeadlessException e){

}

}else {

kosongkan();

Nik.requestFocus();

}

GetData();

kosongkan();

Nik.requestFocus();

}

private void TupdateActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

databaru=true;

try{

String sql = "update payrol SET Bulan='"+jComboBox1.getSelectedItem()+"',Tahun='"+jComboBox2.getSelectedItem()+"',Nama_Karyawan='"+Nkaryawan.getText()+"',Status_Karyawan='"+jComboBox3.getSelectedItem()+"',Absensi_Kehadiran='"+Ahadir.getText()+"',Gaji_Pokok='"+Gpokok.getText()+"',Tunjangan_Kesehatan='"+Tkesehatan.getText()+"',Tunjangan_Jabatan='"+TJabatan.getText()+"',Tunjangan_Makan='"+Tmakan.getText()+"',Tunjangan_Transport='"+Ttransport.getText()+"',Gaji_Bruto='"+Tbruto.getText()+"' where NIK='"+Nik.getText()+"'";

java.sql.Connection conn = (java.sql.Connection)Koneksi.koneksi.koneksiDB();

java.sql.PreparedStatement pst = conn.prepareStatement(sql);

pst.execute();

JOptionPane.showMessageDialog(null, "Berhasil TerUpdate");

}catch (SQLException | HeadlessException e) {

JOptionPane.showMessageDialog(null, e);

}

private void jToggleButton6ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

System.exit(0);

}

private void Tcari1ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

try {

String sql = "Select * from payrol where Nik like '"+Nik.getText()+"'";

java.sql.Connection conn = (java.sql.Connection)Koneksi.koneksi.koneksiDB();

java.sql.PreparedStatement pst = conn.prepareStatement(sql);

ResultSet RS=pst.executeQuery(sql);

if(RS.next()){

jComboBox1.setSelectedItem(RS.getString(1));

jComboBox2.setSelectedItem(RS.getString(2));

Nik.setText(RS.getString(3));

Nkaryawan.setText(RS.getString(4));

jComboBox3.setSelectedItem(RS.getString(5));

Ahadir.setText(RS.getString(6));

Gpokok.setText(RS.getString(7));

TJabatan.setText(RS.getString(8));

Tkesehatan.setText(RS.getString(9));

Tmakan.setText(RS.getString(10));

Ttransport.setText(RS.getString(11));

Tbruto.setText(RS.getString(12));

}else {

JOptionPane.showMessageDialog(null, "Data Tidak Ada");

}

} catch (SQLException e) {

JOptionPane.showMessageDialog(null, e);

}

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

GetData(); // tampilkan ke grid

databaru=true;

}

/**

* @param args the command line arguments

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(utama.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

} catch (InstantiationException ex) {

java.util.logging.Logger.getLogger(utama.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

} catch (IllegalAccessException ex) {

java.util.logging.Logger.getLogger(utama.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

} catch (javax.swing.UnsupportedLookAndFeelException ex) {

java.util.logging.Logger.getLogger(utama.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 utama().setVisible(true);

}

});

}

// Variables declaration - do not modify

private javax.swing.JTextField Ahadir;

private javax.swing.JToggleButton BTHITUNG;

private javax.swing.JTextField Gpokok;

private javax.swing.JTextField Nik;

private javax.swing.JTextField Nkaryawan;

private javax.swing.JTextField TJabatan;

private javax.swing.JTextField Tbruto;

private javax.swing.JButton Tcari1;

private javax.swing.JToggleButton Tdelete;

private javax.swing.JTextField Tkesehatan;

private javax.swing.JTextField Tmakan;

private javax.swing.JToggleButton Tnew;

private javax.swing.JToggleButton Tsave;

private javax.swing.JTable Ttable;

private javax.swing.JTextField Ttransport;

private javax.swing.JToggleButton Tupdate;

private javax.swing.JButton jButton1;

private javax.swing.JComboBox<String> jComboBox1;

private javax.swing.JComboBox<String> jComboBox2;

private javax.swing.JComboBox<String> jComboBox3;

private javax.swing.JLabel jLabel1;

private javax.swing.JLabel jLabel10;

private javax.swing.JLabel jLabel11;

private javax.swing.JLabel jLabel13;

private javax.swing.JLabel jLabel14;

private javax.swing.JLabel jLabel2;

private javax.swing.JLabel jLabel3;

private javax.swing.JLabel jLabel4;

private javax.swing.JLabel jLabel5;

private javax.swing.JLabel jLabel6;

private javax.swing.JLabel jLabel7;

private javax.swing.JLabel jLabel8;

private javax.swing.JLabel jLabel9;

private javax.swing.JScrollPane jScrollPane1;

private javax.swing.JToggleButton jToggleButton6;

// End of variables declaration

}

Jika sudah tidak ada kode yang dianggap salah pada saat melakukan run program akan menghasilkan seperti ini.

Nahh selesai sudah beberapa penjelasan saya Terimakasih kepada dosen pembimbing kami bapak Agus yang sudah membimbing kita.

Sekian dari saya
Adlan ismadika
05TPLM001

161011400273

Wassalamualaikum..

Kumpulan Bagi Info

Cari

Cara Membuat Aplikasi Penggajian dengan sederhana

Komentar

Posting Komentar