Assalamualaikum wr wb.
Saya akan menjelaskan tentang program input
data karyawan dan saya akan menjelaskan dibawah ini.
·
Deskripsi
Program Data Karyawan ini
saya buat untuk melengkapi tugas UAS Algoritma 2 dan saya akan menjelaskan cara
kerja dari program ini setelah login akan menampilkan nama,NIK,jabatan,gaji dan
alamat
1.pertama buatlah data basenya
2. buka aplikasi netbeans lalu buat JFrame nya seperti dibawah ini
3.isi dan masukan plihan anda dengan benar
seperti dibawah ini
4.inilah source code
/*
* 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 donny;
import com.mysql.jdbc.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;
import javax.swing.table.DefaultTableModel;
import javax.swing.JOptionPane;
import koneksi.coken;
/**
*
*
@author donnychand
*/
public class proses extends
javax.swing.JFrame {
int gaji;
/**
* Creates new form proses
*/
public proses() {
initComponents();
datatable();
}
/**
* 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() {
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
DATAKARYAWAN = new javax.swing.JLabel();
NIK = new javax.swing.JLabel();
NAMA = new javax.swing.JLabel();
JABATAN = new javax.swing.JLabel();
GAJIPOKOK = new javax.swing.JLabel();
ALAMAT = new javax.swing.JLabel();
Text1 = new javax.swing.JTextField();
Text2 = new javax.swing.JTextField();
CMB1 = new javax.swing.JComboBox<>();
Text3 = new javax.swing.JTextField();
SAVE = new javax.swing.JButton();
REFRESH = new javax.swing.JButton();
EXIT = new javax.swing.JButton();
jScrollPane2 = new
javax.swing.JScrollPane();
table = new javax.swing.JTable();
jScrollPane3 = new javax.swing.JScrollPane();
Txt4 = new javax.swing.JTextArea();
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null}
},
new String [] {
"Title 1", "Title 2",
"Title 3", "Title 4"
}
));
jScrollPane1.setViewportView(jTable1);
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
DATAKARYAWAN.setText("DATA KARYAWAN");
NIK.setText("NIK");
NAMA.setText("NAMA");
JABATAN.setText("JABATAN");
GAJIPOKOK.setText("GAJI KARYAWAN");
ALAMAT.setText("ALAMAT");
Text1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
Text1ActionPerformed(evt);
}
});
CMB1.setModel(new javax.swing.DefaultComboBoxModel<>(new String[]
{ "======", "DIREKTUR", "STAFF",
"KARYAWAN", "ANGGOTA" }));
CMB1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
CMB1ActionPerformed(evt);
}
});
SAVE.setText("SAVE");
SAVE.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
SAVEActionPerformed(evt);
}
});
REFRESH.setText("REFRESH");
REFRESH.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
REFRESHActionPerformed(evt);
}
});
EXIT.setText("EXIT");
table.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null}
},
new String [] {
"Title 1",
"Title 2", "Title 3", "Title 4"
}
));
jScrollPane2.setViewportView(table);
Txt4.setColumns(20);
Txt4.setRows(5);
jScrollPane3.setViewportView(Txt4);
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(javax.swing.GroupLayout.Alignment.TRAILING,
layout.createSequentialGroup()
.addGap(0, 0,
Short.MAX_VALUE)
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 754,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(159,
159, 159)
.addComponent(DATAKARYAWAN))
.addGroup(layout.createSequentialGroup()
.addGap(23, 23,
23)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(NIK)
.addComponent(NAMA)
.addComponent(JABATAN)
.addComponent(ALAMAT)
.addComponent(GAJIPOKOK))
.addGap(74, 74,
74)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addComponent(Text1)
.addComponent(Text2)
.addComponent(CMB1, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(Text3)
.addComponent(jScrollPane3, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE))))
.addGap(0, 0, Short.MAX_VALUE)))
.addContainerGap())
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(SAVE)
.addGap(103, 103, 103)
.addComponent(REFRESH,
javax.swing.GroupLayout.PREFERRED_SIZE, 78,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(130, 130, 130)
.addComponent(EXIT)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(DATAKARYAWAN)
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(NIK)
.addComponent(Text1,
javax.swing.GroupLayout.PREFERRED_SIZE, 22,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(NAMA)
.addComponent(Text2,
javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(22, 22, 22)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(JABATAN)
.addComponent(CMB1,
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(GAJIPOKOK)
.addComponent(Text3,
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.LEADING)
.addComponent(ALAMAT)
.addComponent(jScrollPane3,
javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 48,
Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(SAVE)
.addComponent(REFRESH,
javax.swing.GroupLayout.PREFERRED_SIZE, 23,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(EXIT))
.addGap(52, 52, 52)
.addComponent(jScrollPane2,
javax.swing.GroupLayout.PREFERRED_SIZE, 92,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(171, 171, 171))
);
pack();
}// </editor-fold>
private void SAVEActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String nik=Text1.getText();
String nama=Text2.getText();
String jabata=(String)CMB1.getSelectedItem();
String gaji=Text3.getText();
String alamat=Txt4.getText();
try{
Statement sta =(Statement) coken.GetConnection().createStatement();
sta.executeUpdate("INSERT INTO tbdonny
VALUES('"+nik+"','"+nama+"','"+jabata+"','"+gaji+"','"+alamat+"')");
JOptionPane.showMessageDialog(null,"sukses");
}catch(Exception e){
JOptionPane.showMessageDialog(null,"Terjadi kesalahan");
}
}
private void REFRESHActionPerformed(java.awt.event.ActionEvent evt)
{
// TODO add your handling code here:
DefaultTableModel tbl = new DefaultTableModel();
tbl.addColumn("NIK");
tbl.addColumn("Nama");
tbl.addColumn("Jabatan");
tbl.addColumn("Gaji");
tbl.addColumn("Alamat");
table.setModel(tbl);
try{
Statement sta=(Statement) coken.GetConnection().createStatement();
ResultSet res=sta.executeQuery("SELECT * FROM tbdonny");
while(res.next())
{
tbl.addRow(new Object[]{
res.getString("nik"),
res.getString("nama"),
res.getString("jabata"),
res.getString("gaji"),
res.getString("alamat")
});
table.setModel(tbl);
}
}catch(Exception e){
JOptionPane.showMessageDialog(null,"Terjadi Kesalahan saat
menampilkan data");
}
}
private void CMB1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
if(CMB1.getSelectedItem().equals("DIREKTUR")){
gaji=5000000;
Text3.setText(""+gaji);
}
else if(CMB1.getSelectedItem().equals("STAFF")){
gaji=4000000;
Text3.setText(""+gaji);
}
else if(CMB1.getSelectedItem().equals("KARYAWAN")){
gaji=4000000;
Text3.setText(""+gaji);
}
else if(CMB1.getSelectedItem().equals("ANGGOTA")){
gaji=3000000;
Text3.setText(""+gaji);
}
}
private void Text1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
public void datatable(){
DefaultTableModel tbl = new DefaultTableModel();
tbl.addColumn("NIK");
tbl.addColumn("Nama");
tbl.addColumn("Jabatan");
tbl.addColumn("Gaji");
tbl.addColumn("Alamat");
table.setModel(tbl);
try{
Statement sta=(Statement) coken.GetConnection().createStatement();
ResultSet res=sta.executeQuery("SELECT * FROM tbdonny");
while(res.next())
{
tbl.addRow(new Object[]{
res.getString("nik"),
res.getString("nama"),
res.getString("jabata"),
res.getString("gaji"),
res.getString("alamat")
});
table.setModel(tbl);
}
}catch(Exception e){
JOptionPane.showMessageDialog(null,"Terjadi Kesalahan saat
menampilkan data");
}
}
/**
* @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(proses.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(proses.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(proses.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(proses.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 proses().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JLabel ALAMAT;
private javax.swing.JComboBox<String> CMB1;
private javax.swing.JLabel DATAKARYAWAN;
private javax.swing.JButton EXIT;
private javax.swing.JLabel GAJIPOKOK;
private javax.swing.JLabel JABATAN;
private javax.swing.JLabel NAMA;
private javax.swing.JLabel NIK;
private javax.swing.JButton REFRESH;
private javax.swing.JButton SAVE;
private javax.swing.JTextField Text1;
private javax.swing.JTextField Text2;
private javax.swing.JTextField Text3;
private javax.swing.JTextArea Txt4;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JScrollPane jScrollPane3;
private javax.swing.JTable jTable1;
private javax.swing.JTable table;
// End of variables declaration
Berikut
Sourcode koneksi dibawah 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 koneksi;
import com.mysql.jdbc.Driver;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
*
*
@author donnychand
*/
public class coken {
public static Connection koneksi;
public static Connection GetConnection()throws SQLException {
if(koneksi==null){
new Driver();
koneksi=DriverManager.getConnection("jdbc:mysql://localhost/dbdonny","root","");
}
return koneksi;
}
}
Sekian dan terimakasih semoga bermanfaat.
Dari saya Donny septiandi
Tidak ada komentar:
Posting Komentar