Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /**
- * @title aplikasi survey data mahasiswa ftmipa
- * @author (KELOMPOK)
- * @version (ver.1)
- */
- import java.io.BufferedReader;
- import java.io.IOException;
- import java.io.InputStreamReader;
- import java.util.Scanner;
- import java.sql.DriverManager;
- import java.sql.Connection;
- import java.sql.Statement;
- import java.sql.ResultSet;
- import java.sql.PreparedStatement;
- public class AplikasiSurveymhs
- {
- /* DEKLARASI PUBLIC VARIABEL */
- static String text_jurusan,var_nama,raw_var_pilihan,pilihanMenu="";;
- static boolean var_pilihan = true,var_pekerjaan_yn,var_loop_action1=true;
- static InputStreamReader inputStreamReader = new InputStreamReader(System.in);
- static BufferedReader input = new BufferedReader(inputStreamReader);
- static Scanner inputan = new Scanner(System.in);
- static int total_data=0;
- //PARAMETER JDBC UNTUK KONEKSI DATABASE
- static String JDBC_DRIVER = "com.mysql.jdbc.Driver"; //konektor jdbc driver
- static String DB_URL = "jdbc:mysql://localhost/db_survey_mhs"; //alamat server database
- static String USER = "root"; //user database
- static String PASS = "12345678"; //password database
- //ALIAS OBJECT KE VARIABEL
- static Connection conn=null;
- static Statement stmt=null;
- static ResultSet rs=null;
- //variabel untuk inputan
- static String dataPekerjaan_nmperusahaan=null,dataPekerjaan_jnsperusahaan=null,dataPekerjaan_jabatan=null;
- //variabel untuk query
- static int rowsInserted_tb_mahasiswa;
- static String sql_tb_mahasiswa_select,text_bekerja;
- /* procedure start koneksi database */
- static void startConnectionDB() throws IOException{
- try{
- Class.forName(JDBC_DRIVER);
- //KONEKSI DATABASE
- conn = DriverManager.getConnection(DB_URL,USER,PASS);
- //objek statement
- stmt = conn.createStatement();
- }catch (Exception e){
- e.printStackTrace();
- }
- }
- /*fungsi get total data yang tidak bekerja*/
- static int getDatapekerjaan_no() throws IOException{
- int var_totBkj_no=0;
- String sql_tb_mahasiswaMhstdkbekerja;
- try{
- //procedure start koneksi
- startConnectionDB();
- sql_tb_mahasiswaMhstdkbekerja ="SELECT COUNT(*) FROM tb_mahasiswa WHERE nm_perusahaan IS NULL";
- ResultSet rsMhsbekerja_no;
- rsMhsbekerja_no = stmt.executeQuery(sql_tb_mahasiswaMhstdkbekerja);
- while (rsMhsbekerja_no.next()){
- var_totBkj_no=rsMhsbekerja_no.getInt("COUNT(*)");
- }
- //closing statement and connection
- stmt.close();
- conn.close();
- }catch (Exception e){
- e.printStackTrace();
- }
- return var_totBkj_no;
- }
- /*fungsi get total data yang bekerja*/
- static int getDatapekerjaan_yes() throws IOException{
- int var_totBkj_yes=0;
- String sql_tb_mahasiswaMhsbekerja;
- try{
- //procedure start koneksi
- startConnectionDB();
- sql_tb_mahasiswaMhsbekerja = "SELECT COUNT(*) FROM tb_mahasiswa WHERE nm_perusahaan IS NOT NULL";
- ResultSet rsMhsbekerja_yes;
- rsMhsbekerja_yes = stmt.executeQuery(sql_tb_mahasiswaMhsbekerja);
- while (rsMhsbekerja_yes.next()){
- var_totBkj_yes=rsMhsbekerja_yes.getInt("COUNT(*)");
- }
- //closing statement and connection
- stmt.close();
- conn.close();
- }catch (Exception e){
- e.printStackTrace();
- }
- return var_totBkj_yes;
- }
- /* fungsi get total data smk stm sma berdasarkan tahun */
- static int getDataTahun(int var_tahun,String var_pendidikan) throws IOException{
- int var_totTahun=0;
- String sql_tb_mahasiswa_thn;
- try{
- //procedure start koneksi
- startConnectionDB();
- String clearPevar = var_pendidikan.trim();
- sql_tb_mahasiswa_thn = "SELECT COUNT(*) FROM tb_mahasiswa WHERE mhs_angkatan="+var_tahun+" AND type_sekolah="+"'"+clearPevar+"'";
- ResultSet rsMhsTotal_thn;
- rsMhsTotal_thn = stmt.executeQuery(sql_tb_mahasiswa_thn);
- while (rsMhsTotal_thn.next()){
- var_totTahun=rsMhsTotal_thn.getInt("COUNT(*)");
- }
- //closing statement and connection
- stmt.close();
- conn.close();
- }catch (Exception e){
- e.printStackTrace();
- }
- return var_totTahun;
- }
- /*
- * procedure untuk summary statistik dan konversi total data menjadi persentase
- * limitasi perhitungan tahun dari angkatan ke 2000 sampai 2018
- */
- static void statistikData() throws IOException{
- try{
- int totalData = getTotalData(), thn_awal = 2000 , thn_skrg = 2018, counter=0,totDatabkj_no=0,totDatabkj_yes=0;
- int thnnya_smk=0,thnnya_sma=0,thnnya_stm=0,totalData_smk=0,totalData_stm=0,totalData_sma=0,totalData_1=0;
- int persenDt_totDt=0,persenDt_smk=0,persenDt_sma=0,persenDt_stm=0,persenDt_Ybkj=0,persenDt_Nbkj=0;
- int selisih = thn_skrg-thn_awal;
- String type_skolah="";
- int[] thn_angkatanMhs = new int[selisih];
- if(totalData==0){
- System.out.println("Belum ada data");
- }else{
- persenDt_totDt = (totalData/totalData)*100;
- totDatabkj_no=getDatapekerjaan_no();
- totDatabkj_yes=getDatapekerjaan_yes();
- persenDt_Ybkj=(totDatabkj_yes*100)/totalData;
- persenDt_Nbkj=(totDatabkj_no*100)/totalData;
- System.out.println("");
- System.out.println("");
- System.out.println("=====================================================");
- System.out.println("| SUMMARY |");
- System.out.println("=====================================================");
- System.out.println("total data: "+totalData);
- System.out.println();
- System.out.println("+------------------- PEKERJA -------------------+");
- System.out.println("+----------------------+------------------------+");
- System.out.println("| bekerja | tidak bekerja |");
- System.out.println("| "+persenDt_Ybkj+"%"+" | "+persenDt_Nbkj+"%"+" |");
- System.out.println("+-----------------------------------------------+");
- System.out.println();
- System.out.println("+------------------- Total %data -------------------+");
- System.out.println("");
- while (true){
- if(getDataTahun(thn_awal,"smk")>0){
- type_skolah="smk";
- thnnya_smk=thn_awal;
- totalData_smk=getDataTahun(thn_awal,"smk");
- persenDt_smk=(totalData_smk*100)/totalData;
- System.out.println("tahun : "+thnnya_smk+"\n%total data smk : "+persenDt_smk+"%");
- }
- if(getDataTahun(thn_awal,"stm")>0){
- type_skolah="stm";
- thnnya_stm=thn_awal;
- totalData_stm=getDataTahun(thn_awal,"stm");
- persenDt_stm=(totalData_stm*100)/totalData;
- System.out.println("tahun : "+thnnya_stm+"\n%total data stm : "+persenDt_stm+"%");
- }
- if(getDataTahun(thn_awal,"sma")>0){
- thnnya_sma=thn_awal;
- type_skolah="sma";
- totalData_sma=getDataTahun(thn_awal,"sma");
- persenDt_sma=(totalData_sma*100)/totalData;
- System.out.println("tahun : "+thnnya_sma+"\n%total data sma : "+persenDt_sma+"%");
- }
- if (counter==selisih){
- break; //for stop while above
- }
- thn_awal++;
- counter=counter+1;
- }
- System.out.println("");
- System.out.println("+---------------------------------------------------+");
- }
- }catch (Exception e){
- e.printStackTrace();
- }
- }
- /*
- * CASE OF FTMIPA
- * ARSITEKTUR 201745100086
- * TEKNIK INDUSTRI 201744100820
- * INFORMATIKA 201743170054
- * PEND FISIKA 201742100001
- * PEND BIOLOGI 201741100113
- * PEND MATEMATIKA 201713100576
- */
- static String getNamajurusan(String raw_var_jurusan){
- String text_jurusan="";
- if (raw_var_jurusan.equals("41")){
- text_jurusan = "PEND BIOLOGI";
- }else if (raw_var_jurusan.equals("42")){
- text_jurusan = "PEND FISIKA";
- }else if (raw_var_jurusan.equals("43")){
- text_jurusan = "TEKNIK INFORMATIKA";
- }else if (raw_var_jurusan.equals("44")){
- text_jurusan = "TEKNIK INDUSTRI";
- }else if (raw_var_jurusan.equals("45")){
- text_jurusan = "ARSITEKTUR";
- }else if (raw_var_jurusan.equals("13")){
- text_jurusan = "PEND MATEMATIKA";
- }
- return text_jurusan;
- }
- /*
- * PROCEDURE UNTUK TAMPILKAN SEMUA DATA
- */
- static void showAllData(int raw_var_limit){
- int no=1;
- try{
- //procedure start koneksi
- startConnectionDB();
- //query untuk show all data
- sql_tb_mahasiswa_select = "SELECT * from tb_mahasiswa LIMIT "+raw_var_limit;
- //eksekusi query ; rows di simpan di objek resultset aka rs
- rs = stmt.executeQuery(sql_tb_mahasiswa_select);
- System.out.println("Total data : "+getTotalData());
- System.out.println("");
- System.out.println("--------------------- DATA MAHASISWA ---------------------------");
- System.out.println("+----+--------------+------------------------+-------------+-----------+");
- System.out.println("| No | Npm | jurusan | Lulusan | Bekerja |");
- System.out.println("+----+--------------+------------------------+-------------+-----------+");
- while (rs.next()){
- if(rs.getString("nm_perusahaan")==null){
- text_bekerja="tidak bekerja";
- }else{
- text_bekerja=rs.getString("nm_perusahaan");
- }
- System.out.println(
- "| "+no+" "
- +"| "+rs.getString("mhs_npm")+""
- +"| "+getNamajurusan(rs.getString("mhs_jurusan"))+" "
- +"| "+rs.getString("nm_sekolah")+""
- +"| "+text_bekerja
- +" |"
- );
- no=no+1;
- }
- System.out.println("+----+--------------+------------------------+-------------+-----------+");
- //closing statement and connection
- stmt.close();
- conn.close();
- System.out.println("");
- do{
- System.out.println("[e]edit | [r]delete | [d]detail | [c]cancel");
- System.out.print("action (e/r/d/c) : ");
- String action_1 = input.readLine().toLowerCase();;
- if(action_1.equals("e")){
- System.out.print("Please enter npm : ");
- String action_detail_e = input.readLine();
- System.out.println("[1]Data diri \n[2]Data Pendidikan \n[3]Data Pekerjaan");
- System.out.print("Please enter option (1/2/3) : ");
- String action_detail_eo = input.readLine();
- int what_edit = Integer.parseInt(action_detail_eo);
- editData(action_detail_e,what_edit);
- }else if(action_1.equals("r")){
- System.out.print("Please enter npm : ");
- String action_detail_r = input.readLine();
- deleteData(action_detail_r);
- }else if(action_1.equals("d")){
- System.out.print("Please enter npm : ");
- String action_detail = input.readLine();
- detailData(action_detail);
- }else if(action_1.equals("c")){
- var_loop_action1=false;
- }else{
- System.out.println("no action !");
- }
- System.out.print("try again ? : (y/n)");
- String action_2 = input.readLine().toLowerCase();;
- if(action_2.equals("y")){
- var_loop_action1=true;
- }else if(action_2.equals("n")){
- var_loop_action1=false;
- }else{
- System.out.println("option not available ...");
- }
- }while(var_loop_action1);
- System.out.println("");
- }catch (Exception e){
- e.printStackTrace();
- }
- }
- /*
- * PROCEDURE UNTUK INPUT DATA
- * .trim() -> untuk menghapus whitespace dari inputan data
- */
- static void inserData() throws IOException{
- String sql_tb_mahasiswa_insert;
- boolean yakin=true;
- try{
- do{
- System.out.print("Npm : ");
- String i_npmData = input.readLine().trim();
- long npmData = Long.parseLong(i_npmData);
- System.out.print("Nama : ");
- String dataNama = input.readLine().trim();
- System.out.println("");
- System.out.println("-----------DATA PENDIDIKAN --------");
- System.out.print("Nama Sekolah : ");
- String dataSekolahnama = input.readLine().trim();
- System.out.print("Swasta/Negri : ");
- String dataSekolahjenis = input.readLine().trim();
- System.out.print("Jurusan Sekolah : ");
- String dataSekolahjurusan = input.readLine().trim();
- System.out.print("Bekerja (yes/no) : ");
- String dataPekerjaan = input.readLine().toLowerCase();;
- if (dataPekerjaan.equals("yes") || dataPekerjaan.equals("y")){//yes or y
- var_pekerjaan_yn=true;
- System.out.println("");
- System.out.println("-----------DATA PEKERJAAN --------");
- System.out.print("Jenis perusahaan (PT/CV/etc) : ");
- String dataPekerjaan_jnsperusahaan = input.readLine().trim();
- System.out.print("Nama perusahaan : ");
- dataPekerjaan_nmperusahaan = input.readLine().trim();
- System.out.print("Jabatan : ");
- dataPekerjaan_jabatan = input.readLine().trim();
- }else if(dataPekerjaan.equals("no") || dataPekerjaan.equals("n")){//no or n
- var_pekerjaan_yn=false;
- System.out.println("");
- System.out.println("");
- }
- System.out.print("Input correct (yes/no) : ");
- String var_yakin = input.readLine().toLowerCase();;
- if(var_yakin.equals("no") || var_yakin.equals("n")){
- yakin=true;
- }else if(var_yakin.equals("yes") || var_yakin.equals("y")){
- /* ex: 20164350xxxx
- * substring untuk mendapatkan angkatan dan jurusan
- * substring untuk mendapatkan type sekolah
- */
- String dataSekolahtype = dataSekolahnama.substring(0,3);
- String raw_npm = Long.toString(npmData); //parsing long to string
- String raw_jurusan = raw_npm.substring(4,6);
- String raw_thn_angkatan = raw_npm.substring(0,4);
- // System.out.println("text sekolah = "+dataSekolahtype);
- // System.out.println("raw jurusan = "+raw_jurusan);
- if (var_pekerjaan_yn==false){
- //value = null on database identified is null aka no value
- dataPekerjaan_nmperusahaan=null;
- dataPekerjaan_jnsperusahaan=null;
- dataPekerjaan_jabatan=null;
- }
- //procedure start koneksi
- startConnectionDB();
- //query insert data
- sql_tb_mahasiswa_insert="INSERT INTO tb_mahasiswa (mhs_npm,mhs_nama,mhs_jurusan,mhs_angkatan,nm_perusahaan,jenis_perusahaan,jabatan,nm_sekolah,jenis_sekolah,jurusan_sekolah,type_sekolah)"+ "VALUES (?,?,?,?,?,?,?,?,?,?,?)";
- //untuk query insert tb_mahasiswa
- PreparedStatement statement_tb_mahasiswa_insert = conn.prepareStatement(sql_tb_mahasiswa_insert);
- statement_tb_mahasiswa_insert.setString(1, raw_npm);
- statement_tb_mahasiswa_insert.setString(2, dataNama);
- statement_tb_mahasiswa_insert.setString(3, raw_jurusan);
- statement_tb_mahasiswa_insert.setString(4, raw_thn_angkatan);
- statement_tb_mahasiswa_insert.setString(5, dataPekerjaan_nmperusahaan);
- statement_tb_mahasiswa_insert.setString(6, dataPekerjaan_jnsperusahaan);
- statement_tb_mahasiswa_insert.setString(7, dataPekerjaan_jabatan);
- statement_tb_mahasiswa_insert.setString(8, dataSekolahnama);
- statement_tb_mahasiswa_insert.setString(9, dataSekolahjenis);
- statement_tb_mahasiswa_insert.setString(10, dataSekolahjurusan);
- statement_tb_mahasiswa_insert.setString(11, dataSekolahtype);
- //execute query insert tb_mahasisaw
- rowsInserted_tb_mahasiswa = statement_tb_mahasiswa_insert.executeUpdate();
- if (rowsInserted_tb_mahasiswa > 0) {
- System.out.println("new data was inserted successfully!");
- }else {
- System.out.println("new data insert failed!");
- }
- //closing statement and connection
- stmt.close();
- conn.close();
- yakin=false;
- }else{
- System.out.println("no option !");
- }
- }while(yakin);
- }catch (Exception e){
- e.printStackTrace();
- }
- }
- /*
- * PROCEDURE UNTUK EDIT 1 DATA
- */
- static void editData(String var_npm_Fdetail,int var_what_edit)throws IOException{
- if (var_what_edit==1){//edit data diri
- try{
- //procedure start koneksi
- startConnectionDB();
- System.out.print("Nama : ");
- String dataNama = input.readLine().trim();
- String sql_tb_mahasiswa_update= "UPDATE tb_mahasiswa SET mhs_nama =? WHERE mhs_npm="+var_npm_Fdetail;
- PreparedStatement statement_tb_mahasiswa_update = conn.prepareStatement(sql_tb_mahasiswa_update);
- statement_tb_mahasiswa_update.setString(1, dataNama);
- rowsInserted_tb_mahasiswa = statement_tb_mahasiswa_update.executeUpdate();
- if (rowsInserted_tb_mahasiswa > 0) {
- System.out.println("Nama updated successfully!");
- }else {
- System.out.println("Nama update failed!");
- }
- //closing statement and connection
- stmt.close();
- conn.close();
- }catch (Exception e){
- e.printStackTrace();
- }
- }else if(var_what_edit==2){//edit data pendidikan
- try{
- //procedure start koneksi
- startConnectionDB();
- System.out.println("");
- System.out.println("-----------DATA PENDIDIKAN --------");
- System.out.print("Nama Sekolah : ");
- String dataSekolahnama = input.readLine().trim();
- System.out.print("Swasta/Negri : ");
- String dataSekolahjenis = input.readLine().trim();
- System.out.print("Jurusan Sekolah : ");
- String dataSekolahjurusan = input.readLine().trim();
- String dataSekolahtype = dataSekolahnama.substring(0,3);
- String sql_tb_mahasiswa_update= "UPDATE tb_mahasiswa SET nm_sekolah =?,jenis_sekolah=?,jurusan_sekolah=? ,type_sekolah=? WHERE mhs_npm="+var_npm_Fdetail;
- PreparedStatement statement_tb_mahasiswa_update = conn.prepareStatement(sql_tb_mahasiswa_update);
- statement_tb_mahasiswa_update.setString(1, dataSekolahnama);
- statement_tb_mahasiswa_update.setString(2, dataSekolahjenis);
- statement_tb_mahasiswa_update.setString(3, dataSekolahjurusan);
- statement_tb_mahasiswa_update.setString(4, dataSekolahtype);
- rowsInserted_tb_mahasiswa = statement_tb_mahasiswa_update.executeUpdate();
- if (rowsInserted_tb_mahasiswa > 0) {
- System.out.println("Pendidikan updated successfully!");
- }else {
- System.out.println("Pendidikan update failed!");
- }
- //closing statement and connection
- stmt.close();
- conn.close();
- }catch (Exception e){
- e.printStackTrace();
- }
- }else if(var_what_edit==3){//edit data pekerjaan
- try{
- //procedure start koneksi
- startConnectionDB();
- System.out.println("");
- System.out.println("-----------DATA PEKERJAAN --------");
- System.out.print("Jenis perusahaan (PT/CV/etc) : ");
- String dataPekerjaan_jnsperusahaan = input.readLine().trim();
- System.out.print("Nama perusahaan ) : ");
- dataPekerjaan_nmperusahaan = input.readLine().trim();
- System.out.print("Jabatan : ");
- dataPekerjaan_jabatan = input.readLine().trim();
- String sql_tb_mahasiswa_update= "UPDATE tb_mahasiswa SET jenis_perusahaan =?,nm_perusahaan=?,jabatan=? WHERE mhs_npm="+var_npm_Fdetail;
- PreparedStatement statement_tb_mahasiswa_update = conn.prepareStatement(sql_tb_mahasiswa_update);
- statement_tb_mahasiswa_update.setString(1, dataPekerjaan_jnsperusahaan);
- statement_tb_mahasiswa_update.setString(2, dataPekerjaan_nmperusahaan);
- statement_tb_mahasiswa_update.setString(3, dataPekerjaan_jabatan);
- rowsInserted_tb_mahasiswa = statement_tb_mahasiswa_update.executeUpdate();
- if (rowsInserted_tb_mahasiswa > 0) {
- System.out.println("Pekerjaan updated successfully!");
- }else {
- System.out.println("Pekerjaan update failed!");
- }
- //closing statement and connection
- stmt.close();
- conn.close();
- }catch (Exception e){
- e.printStackTrace();
- }
- }else{
- System.out.println("no option for update !");
- }
- }
- /*
- * PROCEDURE UNTUK DELETE 1 DATA
- */
- static void deleteData(String var_npm_Fdetail) throws IOException{
- String sql_tb_mahasiswa_delete;
- int rowsDeleted_tb_mahasiswa;
- try{
- //procedure start koneksi
- startConnectionDB();
- sql_tb_mahasiswa_delete = "DELETE FROM tb_mahasiswa WHERE mhs_npm= ?";
- PreparedStatement statement_tb_mahasiswa_delete = conn.prepareStatement(sql_tb_mahasiswa_delete);
- statement_tb_mahasiswa_delete.setString(1, var_npm_Fdetail);
- //execute query delete tb_mahasisaw
- rowsDeleted_tb_mahasiswa = statement_tb_mahasiswa_delete.executeUpdate();
- if (rowsDeleted_tb_mahasiswa > 0) {
- System.out.println("delete data successfully!");
- }else {
- System.out.println("delete data failed!");
- }
- //closing statement and connection
- stmt.close();
- conn.close();
- }catch (Exception e){
- e.printStackTrace();
- }
- }
- /*
- * FUNGSI mengetahui total data yang ada di database
- */
- static int getTotalData() throws IOException{
- int var_total_data=0;
- String sql_tb_mahasiswa_select_total;
- try{
- //procedure start koneksi
- startConnectionDB();
- sql_tb_mahasiswa_select_total = "SELECT COUNT(*) FROM tb_mahasiswa";
- ResultSet rs_mhsTotal ;
- rs_mhsTotal = stmt.executeQuery(sql_tb_mahasiswa_select_total);
- while (rs_mhsTotal.next()){
- var_total_data=rs_mhsTotal.getInt("COUNT(*)");
- }
- //closing statement and connection
- stmt.close();
- conn.close();
- }catch (Exception e){
- e.printStackTrace();
- }
- return var_total_data;
- }
- /*
- * PROCEDURE UNTUK DETAIL 1 DATA
- */
- static void detailData(String var_npm_Fdetail) throws IOException{
- String sql_tb_mahasiswa_select1row;
- try{
- //procedure start koneksi
- startConnectionDB();
- //query untuk show all data
- sql_tb_mahasiswa_select1row = "SELECT * from tb_mahasiswa WHERE mhs_npm= "+var_npm_Fdetail;
- //eksekusi query ; rows di simpan di objek resultset aka rs
- rs = stmt.executeQuery(sql_tb_mahasiswa_select1row);
- if(rs.next()==true){
- if(rs.getString("nm_perusahaan")==null){
- text_bekerja="tidak bekerja";
- }else{
- text_bekerja=rs.getString("nm_perusahaan");
- }
- System.out.println("");
- System.out.println("------------------- DATA "+var_npm_Fdetail+" ----------------");
- System.out.print("nama mhs ");System.out.println(": "+rs.getString("mhs_nama")+"");
- System.out.print("jurusan ");System.out.println(": "+rs.getString("jurusan_sekolah")+"");
- System.out.print("bekerja ");System.out.println(": "+text_bekerja+"");
- System.out.print("lulusan ");System.out.println(": "+rs.getString("nm_sekolah")+"");
- System.out.println("");
- System.out.println("------------------------------------------------------");
- System.out.println("");
- }else{
- System.out.println("npm data not found !");
- }
- //closing statement and connection
- stmt.close();
- conn.close();
- }catch (Exception e){
- e.printStackTrace();
- }
- }
- /*
- * PROCEDURE UNTUK TAMPIL MENU
- */
- public static void showMenu() throws IOException{
- try{
- do{
- System.out.println("===================================");
- System.out.println("| MENU |");
- System.out.println("===================================");
- System.out.print("| ");System.out.print("[1] Show all data(detail) ");System.out.println("|");
- System.out.print("| ");System.out.print("[2] Input new data ");System.out.println("|");
- System.out.print("| ");System.out.print("[3] Statistics summary ");System.out.println("|");
- System.out.print("| ");System.out.print("[4] cancel or exit ");System.out.println("|");
- System.out.println("===================================");
- System.out.print("| ");System.out.print("Select one (1/2/3) :");pilihanMenu= input.readLine();
- System.out.println("===================================");
- int pil = Integer.parseInt(pilihanMenu);
- switch (pil){
- case 1://untuk melihat smua data
- System.out.println("");
- System.out.print("Please give limit data (*)number format = ");
- String i_raw_var_limit= input.readLine();
- int raw_var_limit = Integer.parseInt(i_raw_var_limit);
- showAllData(raw_var_limit);
- break;
- case 2://untuk input 1 data
- inserData();
- break;
- case 3://untuk sumarry statistic data
- statistikData();
- break;
- case 4://untuk exit
- System.out.println(" exit ...");
- System.exit(0);
- break;
- default :
- System.out.println("menu not found !");
- break;
- }
- System.out.println("");
- System.out.println("");
- System.out.print("BACK TO MAIN MENU (y/n) ? ");
- String var_pilihan_1 = input.readLine().toLowerCase();
- if (var_pilihan_1.equals("y")){
- var_pilihan=true;
- }else if (var_pilihan_1.equals("n")){
- System.out.println("exit ! .... ");
- var_pilihan=false;
- System.exit(0);
- }else{
- System.out.println("option not available , exit ...");
- System.exit(0);
- }
- } while (var_pilihan);
- }catch (IOException e){
- System.err.println(e.getMessage());
- }
- }
- public static void main (String[] args){
- try{
- System.out.println("--------------------------------------------------------");
- System.out.println("| APLIKASI SURVEY DATA STATISTIK MAHASISWA FTMIPA |");
- System.out.println("--------------------------------------------------------");
- //tampilan menu awal
- showMenu();
- }catch (Exception e){
- System.err.println(e.getMessage());
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement