anee mau sharee projeck sederhana lagi nihh moga bermanfaat buat pembelajaran kalian..
di sini ane mau bikin program sederhana tentang sistem penggajihan karyawan dengan menggunakan Sistem Out Println.. berbeda dengan postingan ane sebelum nya Program berbasis OBJEK, bagi yang pengen comot program berbasis objek silahkn ajee kunjungi postingan ane sebelumnya..
langsung aja ya gaessss
bikin database nya dulu
( ane make MS. ACCESS )
untuk mengkoneksikn nya, ane udah jelasin caranya di postingan ane sebelumnya ( cara mengkoneksikan database ke Java )..
NEXT...
buka JCreator enteee, lalu klik new project !!!!
dan mari copas ini listing codingnya..
// program cv.aceng grup
import java.io.*;
import java.sql.*;
import javax.swing.*;
class Gaji{
String NIK, Nama, Alamat, Gol, Gaji;
public static void main (String [] args)throws IOException{
Gaji f = new Gaji();
f.menu();
}
void menu()throws IOException{
System.out.println("+--------------------------+");
System.out.println("| CV. A C E N G G R O U P |");
System.out.println("+--------------------------+");
System.out.println("| P E N G G A J I A N |");
System.out.println("+--------------------------+");
System.out.println("|(1) Tambah Data |");
System.out.println("|(2) Edit Data |");
System.out.println("|(3) Hapus Data |");
System.out.println("|(4) Cari Data |");
System.out.println("|(5) Tampilkan Data |");
System.out.println("+--------------------------+");
System.out.println("|(?) Input key: |");
System.out.println("+--------------------------+");
InputStreamReader Stream = new InputStreamReader(System.in);
BufferedReader buffering = new BufferedReader(Stream);
String pilih = buffering.readLine();
if(pilih.equalsIgnoreCase("1")){System.out.println("Tambah Data : ");
Gaji f = new Gaji();
f.tambahdata();
}
else if (pilih.equalsIgnoreCase("2")){System.out.println("Edit Data : ");
Gaji f = new Gaji();
f.editdata();
}
else if (pilih.equalsIgnoreCase("3")){System.out.println("Hapus Data : ");
Gaji f = new Gaji();
f.hapusdata();
}
else if (pilih.equalsIgnoreCase("4")){System.out.println("Cari Data : ");
Gaji f = new Gaji();
f.caridata();
}
else if (pilih.equalsIgnoreCase("5")){System.out.println("Tampilkan Data : ");
Gaji f = new Gaji();
f.tampilkandata();
}
else {System.out.println("Key tidak terdefinisi. Please check Your key!");
Gaji f = new Gaji();
f.menu();
}
}
void tambahdata()throws IOException{
InputStreamReader Stream = new InputStreamReader(System.in);
BufferedReader buffering = new BufferedReader(Stream);
System.out.print("NIK : ");
NIK = buffering.readLine();
System.out.print("Nama Karyawan : ");
Nama = buffering.readLine();
System.out.print("Alamat : ");
Alamat = buffering.readLine();
System.out.print("Golongan : ");
Gol = buffering.readLine();
System.out.print("Gaji : ");
Gaji = buffering.readLine();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:AksesGaji;uid='admin';pw='admin'");
Statement StatKu = con.createStatement();
String sql = "insert into Gaji values('"+NIK+"','"+Nama+"','"+Alamat+"','"+Gol+"','"+Gaji+"')";
StatKu.executeUpdate(sql);
StatKu.close();
con.close();
System.out.println("Data berhasil ditambahkan");
}
catch (Exception Ex){System.out.println("Data tidak dapat dijalankan query");
}
Gaji f = new Gaji();
f.menu();
}
void editdata()throws IOException{
InputStreamReader Stream = new InputStreamReader(System.in);
BufferedReader buffering = new BufferedReader(Stream);
System.out.print("NIK : ");
NIK = buffering.readLine();
System.out.print("Nama Karyawan : ");
Nama = buffering.readLine();
System.out.print("Alamat : ");
Alamat = buffering.readLine();
System.out.print("Golongan : ");
Gol = buffering.readLine();
System.out.print("Gaji : ");
Gaji = buffering.readLine();
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:AksesGaji;uid='admin';pw='admin'");
Statement StatKu = con.createStatement();
String edit = "update Gaji set NIK='"+NIK+"', Nama_Karyawan='"+Nama+"', Alamat='"+Alamat+"', Gol='"+Gol+"' where NIK='"+NIK+"'";
StatKu.executeUpdate(edit);
StatKu.close();
con.close();
System.out.println("Data berhasil diubah.");
}
catch (Exception ex){System.out.println("Data tidak dapat diubah.");
}
Gaji f = new Gaji();
f.menu();
}
void hapusdata()throws IOException{
InputStreamReader Stream = new InputStreamReader(System.in);
BufferedReader buffering = new BufferedReader(Stream);
System.out.print("Input NIK : ");
NIK = buffering.readLine();
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:AksesGaji;uid='admin';pw='admin'");
Statement StatKu = con.createStatement();
String hapus = "delete from Gaji where NIK='"+NIK+"'";
StatKu.executeUpdate(hapus);
StatKu.close();
con.close();
System.out.println("Data dengan NIK."+NIK+" berhasil dihapus.");
}
catch (Exception ex){System.out.println("Data tidak berhasil dihapus.");
}
Gaji f = new Gaji();
f.menu();
}
void caridata()throws IOException{
System.out.println("+---------------------------+");
System.out.println("| F A R I S L A S H |");
System.out.println("+---------------------------+");
System.out.println("| C A R I D A T A |");
System.out.println("+---------------------------+");
System.out.println("|(1) Berdasarkan NIK |");
System.out.println("|(2) Berdasarkan Nama |");
System.out.println("|(3) Berdasarkan Alamat |");
System.out.println("|(4) Berdasarkan Golongan |");
System.out.println("|(5) Berdasarkan Gaji |");
System.out.println("+---------------------------+");
System.out.println("|(?) Input key : |");
System.out.println("+---------------------------+");
InputStreamReader Stream = new InputStreamReader(System.in);
BufferedReader buffering = new BufferedReader(Stream);
String pilih = buffering.readLine();
if (pilih.equalsIgnoreCase("1")){System.out.println("Cari berdasarkan NIK :");
Gaji f = new Gaji();
f.caridatanik();
}
else if (pilih.equalsIgnoreCase("2")){System.out.println("Cari berdasarkan Nama Karyawan :");
Gaji f = new Gaji();
f.caridatanama();
}
else if (pilih.equalsIgnoreCase("3")){System.out.println("Cari berdasarkan Alamat : ");
Gaji f = new Gaji();
f.caridataalamat();
}
else if (pilih.equalsIgnoreCase("4")){System.out.println("Cari berdasarkan Golongan : ");
Gaji f = new Gaji();
f.caridatagol();
}
else if (pilih.equalsIgnoreCase("5")){System.out.println("Cari berdasarkan Gaji : ");
Gaji f = new Gaji();
f.caridatagaji();
}
else {System.out.println("Key tidak terdefinisi. Please check Your key!");
Gaji f = new Gaji();
f.caridata();
}
}
void caridatanik()throws IOException{
InputStreamReader Stream = new InputStreamReader(System.in);
BufferedReader buffering = new BufferedReader(Stream);
System.out.println("Operator : = Or > Or < Or >= Or <= Or <> Or LIKE");
System.out.print("Pilih Operator : ");
String Opr = buffering.readLine();
System.out.print("NIK : ");
NIK = buffering.readLine();
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:AksesGaji;uid='admin';pw='admin'");
Statement StatKu = con.createStatement();
String Search = "select * from Gaji where NIK "+Opr+" '%"+NIK+"%' order by Nama_Karyawan asc";
ResultSet set = StatKu.executeQuery(Search);
while (set.next()){
String sNIK = set.getString("NIK");
String sNama = set.getString("Nama_Karyawan");
String sAlamat = set.getString("Alamat");
String sGol = set.getString("Gol");
String sGaji = set.getString("Gaji");
System.out.println("NIK : " + sNIK);
System.out.println("Nama Karyawan : " + sNama);
System.out.println("Alamat : " + sAlamat);
System.out.println("Golongan : " + sGol);
System.out.println("Gaji : " + sGaji);
System.out.println("");
}
System.out.println("Data berhasil ditemukan.");
StatKu.close();
con.close();
}
catch (Exception ex){System.out.println("Query tidak dapat dijalankan. Please check Your data!");
}
Gaji f = new Gaji();
f.menu();
}
void caridatanama()throws IOException{
InputStreamReader Stream = new InputStreamReader(System.in);
BufferedReader buffering = new BufferedReader(Stream);
System.out.println("Operator : LIKE, Or <>");
System.out.print("Input Operator : ");
String Opr = buffering.readLine();
System.out.print("Nama Karyawan : ");
Nama = buffering.readLine();
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:AksesGaji;uid='admin';pw='admin'");
Statement StatKu = con.createStatement();
String Cari = "select * from Gaji where Nama_Karyawan "+Opr+" '%"+Nama+"%' order by Nama_Karyawan asc";
ResultSet set = StatKu.executeQuery(Cari);
while (set.next()){
String sNIK = set.getString("NIK");
String sNama = set.getString("Nama_Karyawan");
String sAlamat = set.getString("Alamat");
String sGol = set.getString("Gol");
String sGaji = set.getString("Gaji");
System.out.println("NIK : " + sNIK);
System.out.println("Nama Karyawan : " + sNama);
System.out.println("Alamat : " + sAlamat);
System.out.println("Golongan : " + sGol);
System.out.println("Gaji : " + sGaji);
System.out.println("");
}
StatKu.close();
con.close();
System.out.println("Data berhasil dijalankan.");
}
catch (Exception ex){System.out.println("Query tidak dapat dijalankan. Please check Your data!");
}
Gaji f = new Gaji();
f.menu();
}
void caridataalamat()throws IOException{
InputStreamReader Stream = new InputStreamReader(System.in);
BufferedReader buffering = new BufferedReader(Stream);
System.out.println("Operator : LIKE or <>");
System.out.print("Input Operator : ");
String Opr = buffering.readLine();
System.out.print("Alamat : ");
Alamat = buffering.readLine();
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:AksesGaji;uid='admin';pw='admin'");
Statement StatKu = con.createStatement();
String Cari = "select * from Gaji where Alamat "+Opr+" '%"+Alamat+"%' order by Nama_Karyawan asc";
ResultSet set = StatKu.executeQuery(Cari);
while (set.next()){
String sNIK = set.getString("NIK");
String sNama = set.getString("Nama_Karyawan");
String sAlamat = set.getString("Alamat");
String sGol = set.getString("Gol");
String sGaji = set.getString("Gaji");
System.out.println("NIK : " + sNIK);
System.out.println("Nama Karyawan : " + sNama);
System.out.println("Alamat : " + sAlamat);
System.out.println("Golongan : " + sGol);
System.out.println("Gaji : " + sGaji);
System.out.println("");
}
StatKu.close();
con.close();
System.out.println("Data berhasil ditemukan.");
}
catch (Exception ex){System.out.println("Query tidak dapat dijalankan. Please check Your data!");
}
Gaji f = new Gaji();
f.menu();
}
void caridatagol()throws IOException{
InputStreamReader Stream = new InputStreamReader(System.in);
BufferedReader buffering = new BufferedReader(Stream);
System.out.println("Operator : = Or LIKE Or <>");
System.out.print("Input Operator : ");
String Opr = buffering.readLine();
System.out.print("Golongan : ");
Gol = buffering.readLine();
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:AksesGaji;uid='admin';pw='admin'");
Statement StatKu = con.createStatement();
String Cari = "select * from Gaji where Gol "+Opr+" '"+Gol+"' order by Nama_Karyawan asc";
ResultSet set = StatKu.executeQuery(Cari);
while (set.next()){
String sNIK = set.getString("NIK");
String sNama = set.getString("Nama_Karyawan");
String sAlamat = set.getString("Alamat");
String sGol = set.getString("Gol");
String sGaji = set.getString("Gaji");
System.out.println("NIK : " + sNIK);
System.out.println("Nama Karyawan : " + sNama);
System.out.println("Alamat : " + sAlamat);
System.out.println("Golongan : " + sGol);
System.out.println("Gaji : " + sGaji);
System.out.println("");
}
StatKu.close();
con.close();
System.out.println("Data berhasil ditemukan.");
}
catch (Exception ex){System.out.println("Query tidak dapat dijalankan. Please check Your data!");
}
Gaji f = new Gaji();
f.menu();
}
void caridatagaji()throws IOException{
InputStreamReader Stream = new InputStreamReader(System.in);
BufferedReader buffering = new BufferedReader(Stream);
System.out.println("Operator : = Or > Or < Or >= Or <= Or <> Or LIKE Or NOT");
System.out.print("Input Operator : ");
String Opr = buffering.readLine();
System.out.print("Gaji : ");
Gaji = buffering.readLine();
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:AksesGaji;uid='admin';pw='admin'");
Statement StatKu = con.createStatement();
String Cari = "select * from Gaji where Gaji "+Opr+" '"+Gaji+"' order by Nama_Karyawan asc";
ResultSet set = StatKu.executeQuery(Cari);
while (set.next()){
String sNIK = set.getString("NIK");
String sNama = set.getString("Nama_Karyawan");
String sAlamat = set.getString("Alamat");
String sGol = set.getString("Gol");
String sGaji = set.getString("Gaji");
System.out.println("NIK : " + sNIK);
System.out.println("Nama Karyawan : " + sNama);
System.out.println("Alamat : " + sAlamat);
System.out.println("Golongan : " + sGol);
System.out.println("Gaji : " + sGaji);
System.out.println("");
}
StatKu.close();
con.close();
System.out.println("Data berhasil ditemukan.");
}
catch (Exception ex){System.out.println("Query tidak dapat dijalankan. Please check Your data!");
}
Gaji f = new Gaji();
f.menu();
}
void tampilkandata()throws IOException{
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:AksesGaji;uid='admin';pw='admin'");
Statement StatKu = con.createStatement();
String SQL = "select * from Gaji order by Nama_Karyawan asc";
ResultSet set = StatKu.executeQuery(SQL);
while (set.next()){
String sNIK = set.getString("NIK");
String sNama = set.getString("Nama_Karyawan");
String sAlamat = set.getString("Alamat");
String sGol = set.getString("Gol");
String sGaji = set.getString("Gaji");
System.out.println("NIK : " + sNIK);
System.out.println("Nama Karyawan : " + sNama);
System.out.println("Alamat : " + sAlamat);
System.out.println("Golongan : " + sGol);
System.out.println("Gaji : " + sGaji);
System.out.println("");
}
StatKu.close();
con.close();
System.out.println("Seluruh data berhasil ditampilkan.");
}
catch (Exception ex){System.out.println("Query tidak berjalan. Please check your variable!");
}
Gaji f = new Gaji();
f.menu();
}
}
dan hasil penampakan nya kaya gini gaessss
sekian terima kasih, moga pahala nya ngalir selalu ke Aneeeee !!!! Ahahahaha
Tidak ada komentar:
Posting Komentar