rendered paste bodyimport java.io.*;import javax.swing.*;import java.sql.*;import java.net.URL;import java.lang.*;import java.util.Calendar;public class TIcketMovieDOS{ String [][] duser,dfilm,dlaporan; int datai,dataj,pesen,datak,datal; int [] temp = new int [99]; String [] hlaporan = new String [999]; Calendar kalender; String userl="guest"; Connection koneksi; Statement st; ResultSet datauser; String sql; PreparedStatement prest; public static void main(String args[]){ TIcketMovieDOS apl = new TIcketMovieDOS(); } public TIcketMovieDOS(){ dapatkandata(); dapatkandate(); menu(); } public void menu(){ System.out.println("\n|-----------------------------------------------------------------------------|"); System.out.println("| TICKET MOVIE, by RADITYO.H & MELANY.T 31109036 & 31109005 |"); System.out.println("|-----------------------------------------------------------------------------|"); System.out.println("\nlogin as : "+userl+"\n"); System.out.println("|---------------------------------------|"); System.out.println("| MENU |"); System.out.println("|---------------------------------------|"); System.out.println("| 1. GANTI LOGIN KARYAWAN |"); System.out.println("| 2. PESAN TIKET |"); System.out.println("| 3. DATABASE FILM |"); System.out.println("| 4. LAPORAN |"); System.out.println("| 5. KELUAR |"); System.out.println("|---------------------------------------|\n"); System.out.print(">> "); int inputm = input(); switch(inputm){ case 1: login();break; case 2: pesan();break; case 3: database();break; case 4: laporan();break; case 5: System.exit(1);break; default: System.out.println("*Error : "); System.out.println(">Inputkan sesuai angka yg tertera di Menu\n"); menu(); } menu(); } public void login(){ System.out.println("\n|---------------------------------------|"); System.out.println("| LOGIN |"); System.out.println("|---------------------------------------|"); System.out.println("| Hint ! Masukkan USERNAME dan PASSWORD |"); System.out.println("| untuk Login Karyawan / Admin. |"); System.out.println("|---------------------------------------|"); System.out.print("USERNAME : "); String tuser = inputs(); System.out.print("PASSWORD : "); String tpass = inputs(); for (int i=(datai-1);i>=0;i--) { if (duser[i][0].equals(tuser)&&duser[i][1].equals(tpass)) { userl=duser[i][0]; cekadmin(); JOptionPane.showMessageDialog(null,"Login Success, Welcome '"+userl+"' Ready to Work"); System.out.println("*Sukses : "); System.out.println(">Login Success, Welcome '"+userl+"' Ready to Work\n"); break; } if (i==0) { JOptionPane.showMessageDialog(null,"Username dan Password tidak cocok","KESALAHAN",0); System.out.println("*Error : "); System.out.println(">Username dan Password tidak cocok !\n"); menu(); } } } public void cekadmin(){ if (duser[temp[0]][2].equals("true")){ // frame1.setTitle("Cinema 31 UWIKA // Selamat Datang Admin '"+cfl_t1.getText()+"' //"); } else{ // frame1.setTitle("Cinema 31 UWIKA // Selamat Datang Karyawan '"+cfl_t1.getText()+"' //"); } } public void pesan(){ System.out.println("\n|---------------------------------------|"); System.out.println("| PESAN TIKET |"); System.out.println("|---------------------------------------|"); System.out.println("| Hint ! Masukkan theater kebrp yg akan |"); System.out.println("| dipsan setelah itu masukkan jumlah |"); System.out.println("| kursi yg akan dipesan oleh konsumen. |"); System.out.println("|---------------------------------------|"); dapatkandate(); for(int i = 0;i<dataj;i++){ if ((dfilm[i][2].equals(Integer.toString(temp[1])))&&(dfilm[i][3].equals(Integer.toString(temp[2])))&&(dfilm[i][4].equals(Integer.toString(temp[3])))) { if (dfilm[i][5].equals("1")) temp[4]=i; else if(dfilm[i][5].equals("2")) temp[5]=i; else if (dfilm[i][5].equals("3")) temp[6]=i; } } System.out.println("|-----------------------------------------------------------------------------|"); System.out.println("*Theater : Date "+temp[1]+"-"+temp[2]+"-"+temp[3]+" Clock "+temp[11]+":"+temp[12]+":"+temp[13]); System.out.println(" >> Theater 1 - 13.30 : "+dfilm[temp[4]][1]); System.out.println(" > Sisa Kursi : "+dfilm[temp[4]][8]+" Harga Tiket : Rp."+dfilm[temp[4]][6]); System.out.println(" >> Theater 2 - 13.30 : "+dfilm[temp[5]][1]); System.out.println(" > Sisa Kursi : "+dfilm[temp[5]][8]+" Harga Tiket : Rp."+dfilm[temp[5]][6]); System.out.println(" >> Theater 3 - 13.30 : "+dfilm[temp[6]][1]); System.out.println(" > Sisa Kursi : "+dfilm[temp[6]][8]+" Harga Tiket : Rp."+dfilm[temp[6]][6]+"\n"); System.out.println("|-----------------------------------------------------------------------------|"); System.out.print("Theater>> "); int studio = input(); //cek kursi //jika y lanjut //jika t ulang masukkan switch (studio) { case 1 :{ if ((Integer.parseInt(dfilm[temp[4]][8]))>0) { break; } else { System.out.println("*Theater Penuh :"); System.out.println(">Maaf Kursi Theater 1 telah habis dipesan, Silahkan pesan theater lainnya."); pesan(); } break; } case 2 :{ if ((Integer.parseInt(dfilm[temp[5]][8]))>0) { break; } else { System.out.println("*Theater Penuh :"); System.out.println(">Maaf Kursi Theater 2 telah habis dipesan, Silahkan pesan theater lainnya."); pesan(); } break; } case 3 :{ if ((Integer.parseInt(dfilm[temp[6]][8]))>0) { break; } else { System.out.println("*Theater Penuh :"); System.out.println(">Maaf Kursi Theater 3 telah habis dipesan, Silahkan pesan theater lainnya."); pesan(); } break; } default :{ System.out.println("*Error : "); System.out.println(">Inputan bukan 1 / 2 / 3"); menu(); break; } } System.out.print("Pesan Kursi>> "); int kursi = input(); //cek kursi //jika y edit database berkurang kursi //jika t ulang masukkan try{ st = koneksi.createStatement(); datauser = st.executeQuery("SELECT * FROM TableFilm "); switch (studio) { case 1 :{ int cek = (Integer.parseInt(dfilm[temp[4]][8]))-kursi; if (cek>=0) { int temps = (Integer.parseInt(dfilm[temp[4]][8]))-kursi; dfilm[temp[4]][8]=Integer.toString(temps); int biaya = kursi*Integer.parseInt(dfilm[temp[4]][6]); sql = "UPDATE TableFilm SET kursi = ? WHERE ID = ?"; prest = koneksi.prepareStatement(sql); prest.setInt(1,Integer.parseInt(dfilm[temp[4]][8])); prest.setInt(2,Integer.parseInt(dfilm[temp[4]][0])); prest.executeUpdate(); System.out.println("|-----------------------------------------------------------------------------|"); System.out.println("*PEMESANAN TIKET BERHASIL : (THEATHER 1, MOVIE :"+dfilm[temp[4]][1]+")"); System.out.println(">"+kursi+" Kursi dipesan, pada Theather 1, Sebesar Rp."+biaya); System.out.println(">Terima kasih"); System.out.println("|-----------------------------------------------------------------------------|"); lpr(kursi,1,biaya,userl); break; } else { System.out.println("*Error :"); System.out.println(">Maaf Kursi Theater 1 yg tersedia hanya."+dfilm[temp[4]][8]+" Kursi"); pesan(); } break; } case 2 :{ int cek = (Integer.parseInt(dfilm[temp[5]][8]))-kursi; if (cek>=0) { int temps = (Integer.parseInt(dfilm[temp[5]][8]))-kursi; dfilm[temp[5]][8]=Integer.toString(temps); int biaya = kursi*Integer.parseInt(dfilm[temp[5]][6]); sql = "UPDATE TableFilm SET kursi = ? WHERE ID = ?"; prest = koneksi.prepareStatement(sql); prest.setInt(1,Integer.parseInt(dfilm[temp[5]][8])); prest.setInt(2,Integer.parseInt(dfilm[temp[5]][0])); prest.executeUpdate(); System.out.println("|-----------------------------------------------------------------------------|"); System.out.println("*PEMESANAN TIKET BERHASIL : (THEATHER 2, MOVIE :"+dfilm[temp[5]][1]+")"); System.out.println(">"+kursi+" Kursi dipesan, pada Theather 2, Sebesar Rp."+biaya); System.out.println(">Terima kasih"); System.out.println("|-----------------------------------------------------------------------------|"); lpr(kursi,2,biaya,userl); break; } else { System.out.println("*Error :"); System.out.println(">Maaf Kursi Theater 2 yg tersedia hanya."+dfilm[temp[5]][8]+" Kursi"); pesan(); } break; } case 3 :{ int cek = (Integer.parseInt(dfilm[temp[6]][8]))-kursi; if (cek>=0) { int temps = (Integer.parseInt(dfilm[temp[6]][8]))-kursi; dfilm[temp[6]][8]=Integer.toString(temps); int biaya = kursi*Integer.parseInt(dfilm[temp[6]][6]); sql = "UPDATE TableFilm SET kursi = ? WHERE ID = ?"; prest = koneksi.prepareStatement(sql); prest.setInt(1,Integer.parseInt(dfilm[temp[6]][8])); prest.setInt(2,Integer.parseInt(dfilm[temp[6]][0])); prest.executeUpdate(); System.out.println("|-----------------------------------------------------------------------------|"); System.out.println("*PEMESANAN TIKET BERHASIL : (THEATHER 3, MOVIE :"+dfilm[temp[6]][1]+")"); System.out.println(">"+kursi+" Kursi dipesan, pada Theather 3, Sebesar Rp."+biaya); System.out.println(">Terima kasih"); System.out.println("|-----------------------------------------------------------------------------|"); lpr(kursi,3,biaya,userl); break; } else { System.out.println("*Error :"); System.out.println(">Maaf Kursi Theater 3 yg tersedia hanya."+dfilm[temp[6]][8]+" Kursi"); pesan(); } break; } } } catch(Exception ex){ System.out.println("*SQL Error :"); System.out.println(">"+ex.getMessage()); } System.out.print("\n*Message : \n>Pesan lagi ? (Y/T) : "); String lagi = inputs(); if (lagi.equals("y")||lagi.equals("Y")) pesan(); menu(); System.out.println(""); } public void database(){ System.out.println("\n|---------------------------------------|"); System.out.println("| DATABASE |"); System.out.println("|---------------------------------------|"); System.out.println("| Hint ! Pilih Tabel yg akan dibuka. |"); System.out.println("| setelah itu pilih mode View, Edit, |"); System.out.println("| Insert atau Delete. |"); System.out.println("|---------------------------------------|"); System.out.println("| 1. TABEL DATABASE USER |"); System.out.println("| 2. TABEL DATABASE FILM |"); System.out.println("| 3. TABEL LAPORAN |"); System.out.println("| 4. KEMBALI KE MENU SEBELUMNYA |"); System.out.println("|---------------------------------------|\n"); System.out.print(">> "); int inputm = input(); switch(inputm){ case 1: tabeldbuser();break; case 2: tabeldbfilm();break; case 3: tabeldblaporan();break; case 4: menu();break; default: System.out.println("*Error : "); System.out.println(">Inputkan sesuai angka yg tertera di Menu\n"); database(); } database(); } public void tabeldbuser(){ System.out.println("\n|---------------------------------------|"); System.out.println("| TABEL DB USER |"); System.out.println("|---------------------------------------|"); System.out.println("| 1. TAMPILKAN |"); System.out.println("| 2. TAMBAH DATA |"); System.out.println("| 3. HAMPUS DATA |"); System.out.println("| 4. EDIT DATA |"); System.out.println("| 5. KEMBALI KE MENU SEBELUMNYA |"); System.out.println("|---------------------------------------|\n"); System.out.print(">> "); int inputm = input(); switch(inputm){ case 1: tampilkandata(1);break; case 2: tambahdata(1);break; case 3: hapusdata(1);break; case 4: editdata(1);break; case 5: database();break; default: System.out.println("*Error : "); System.out.println(">Inputkan sesuai angka yg tertera di Menu\n"); tabeldbuser(); } tabeldbuser(); } public void tabeldbfilm(){ System.out.println("\n|---------------------------------------|"); System.out.println("| TABEL DB FILM |"); System.out.println("|---------------------------------------|"); System.out.println("| 1. TAMPILKAN |"); System.out.println("| 2. TAMBAH DATA |"); System.out.println("| 3. HAMPUS DATA |"); System.out.println("| 4. EDIT DATA |"); System.out.println("| 5. KEMBALI KE MENU SEBELUMNYA |"); System.out.println("|---------------------------------------|\n"); System.out.print(">> "); int inputm = input(); switch(inputm){ case 1: tampilkandata(2);break; case 2: tambahdata(2);break; case 3: hapusdata(2);break; case 4: editdata(2);break; case 5: database();break; default: System.out.println("*Error : "); System.out.println(">Inputkan sesuai angka yg tertera di Menu\n"); tabeldbfilm(); } tabeldbfilm(); } public void tabeldblaporan(){ System.out.println("\n|---------------------------------------|"); System.out.println("| TABEL DB LAPORAN |"); System.out.println("|---------------------------------------|"); System.out.println("| 1. TAMPILKAN |"); System.out.println("| 2. KEMBALI KE MENU SEBELUMNYA |"); System.out.println("|---------------------------------------|\n"); System.out.print(">> "); int inputm = input(); switch(inputm){ case 1: tampilkandata(3);break; case 2: database();break; default: System.out.println("*Error : "); System.out.println(">Inputkan sesuai angka yg tertera di Menu\n"); tabeldblaporan(); } tabeldblaporan(); } public void tampilkandata(int x){ try{ switch (x){ case 1:{ sql = "SELECT * FROM TableUser "; prest = koneksi.prepareStatement(sql); datauser=prest.executeQuery(); duser = new String [999][999]; datai=0; System.out.println("|------------------------------DATABASE USER----------------------------------|"); while (datauser.next()){ duser[datai][3] = Integer.toString(datauser.getInt(1)); duser[datai][0] = datauser.getString(2); duser[datai][1] = datauser.getString(3); duser[datai][2] = Boolean.toString(datauser.getBoolean(4)); System.out.println("ID:" +duser[datai][3] +" |User:"+duser[datai][0]+" |Pass :"+duser[datai][1]+" |Admin:"+duser[datai][2]); datai++; } System.out.println("|-----------------------------------------------------------------------------|"); break; } case 2:{ sql = "SELECT * FROM TableFilm "; prest = koneksi.prepareStatement(sql); datauser=prest.executeQuery(); dfilm = new String [999][999]; dataj=0; System.out.println("|------------------------------DATABASE FILM----------------------------------|"); while (datauser.next()){ dfilm[dataj][0] = Integer.toString(datauser.getInt(1)); dfilm[dataj][1] = datauser.getString(2); for(int i=3; i<=8;i++){ dfilm[dataj][(i-1)] = Integer.toString(datauser.getInt(i)); } dfilm[dataj][8] = Integer.toString(datauser.getInt(34)); System.out.print("ID:" +dfilm[dataj][0]); System.out.print(" | Nama:"+dfilm[dataj][1]); System.out.print(" | Tgl:"+dfilm[dataj][2]); System.out.print("-"+dfilm[dataj][3]); System.out.print("-"+dfilm[dataj][4]); System.out.print(" | Theater:"+dfilm[dataj][5]); System.out.print(" | HTM:"+dfilm[dataj][6]); System.out.println(" | Kursi:"+dfilm[dataj][8]); dataj++; } System.out.println("|-----------------------------------------------------------------------------|"); break; } case 3:{ System.out.println("|----------------------------DATABASE LAPORAN---------------------------------|"); for (int i=0;i<=datal;i++){ for (int j=0;j<datak;j++){ System.out.println(j+">"+dlaporan[i][j]); } } System.out.println("|-----------------------------------------------------------------------------|"); break; } } } catch(Exception e){ System.out.println (" Pesan Kesalahan : " + e.getMessage()); } } public void tambahdata(int x){ try{ switch (x){ case 1:{ String n_user=null; String n_pass=null; String n_super=null; System.out.print("New Username : "); n_user=inputs(); System.out.print(" Password : "); n_pass=inputs(); System.out.print(" Admin (Y/T) : "); n_super=inputs(); String y=null; if (n_super.equals("Y")||n_super.equals("y")) y="true"; else y="false"; System.out.println("ID: Auto |User: "+n_user+" |Pass : "+n_pass+" |Admin: "+y); System.out.print("Yakin untuk ditambahkan ke databse (Y/T)? "); String lagi = inputs(); if (lagi.equals("y")||lagi.equals("Y")) { sql = "INSERT INTO TableUser VALUES(?, ? , ? , ? )"; prest = koneksi.prepareStatement(sql); prest.setInt(1,(Integer.parseInt(duser[(datai-1)][3])+1)); prest.setString(2,n_user); prest.setString(3,n_pass); if (n_super.equals("Y")||n_super.equals("y")) prest.setBoolean(4,true); else prest.setBoolean(4,false); prest.executeUpdate(); System.out.println("*Message : Sukses data "+n_user+" telah ditambahkan."); } break; } case 2:{ String n_film=null; int n_DD=0; int n_MM=0; int n_YYYY=0; int n_theater=0; int n_HTM=0; int n_kursi=0; System.out.print("New Name Film : "); n_film=inputs(); System.out.print(" Tanggal : "); n_DD=input(); System.out.print(" Bulan : "); n_MM=input(); System.out.print(" Tahun : "); n_YYYY=input(); System.out.print(" Theater : "); n_theater=input(); System.out.print(" Harga Tiket : "); n_HTM=input(); System.out.print(" Jumlah Kursi Slot : "); n_kursi=input(); System.out.print("ID: Auto"); System.out.print(" | Nama: "+n_film); System.out.print(" | Tgl: "+n_DD); System.out.print("-"+n_MM); System.out.print("-"+n_YYYY); System.out.print(" | Theater: "+n_theater); System.out.print(" | HTM: "+n_HTM); System.out.println(" | Kursi: "+n_kursi); System.out.print("Yakin untuk ditambahkan ke databse (Y/T)? "); String lagi = inputs(); if (lagi.equals("y")||lagi.equals("Y")) { sql = "INSERT INTO TableFilm VALUES( ? , ? , ? , ? , ? , ? , ? , ? , '0' , '0' , '0' , '0' , '0' , '0' , '0' , '0' , '0' , '0' , '0' , '0' , '0' ,'0' , '0' , '0' , '0' , '0' , '0' , '0' , '0' , '0' , '0' , '0' , '0' , ? )"; prest = koneksi.prepareStatement(sql); prest.setInt(1,(Integer.parseInt(dfilm[(dataj-1)][3])+1)); prest.setString(2,n_film); prest.setInt(3,n_DD); prest.setInt(4,n_MM); prest.setInt(5,n_YYYY); prest.setInt(6,n_theater); prest.setInt(7,n_HTM); prest.setInt(8,(n_HTM+10000)); prest.setInt(9,n_kursi); prest.executeUpdate(); System.out.println("*Message : Sukses data "+n_film+" telah ditambahkan."); } break; } case 3:{ break; } } } catch(Exception e){ System.out.println (" Pesan Kesalahan : " + e.getMessage()); } } public void hapusdata(int x){ System.out.print("ID yg akan dihapus (kecuali 1,batal=0)>> "); int idhapus = input(); if ((idhapus==0)||(idhapus==1)){ database(); } try{ switch (x){ case 1:{ sql = "SELECT * FROM TableUser WHERE ID = ?"; prest = koneksi.prepareStatement(sql); prest.setInt(1,idhapus); prest.executeQuery(); ResultSet rs = prest.executeQuery(); while (rs.next()){ System.out.println("ID: " +rs.getInt(1) +" |User: "+rs.getString(2)+" |Pass : "+rs.getString(3)+" |Admin: "+rs.getBoolean(4)); } System.out.print("ID: "+idhapus+ " yakin untuk dihapus ? "); String lagi = inputs(); if (lagi.equals("y")||lagi.equals("Y")) { sql = "DELETE FROM TableUser WHERE ID = ?"; prest = koneksi.prepareStatement(sql); prest.setInt(1,idhapus); prest.executeUpdate(); System.out.println("*Message : Sukses ID "+idhapus+" telah dihapus."); } break; } case 2:{ sql = "SELECT * FROM TableFilm WHERE ID = ?"; prest = koneksi.prepareStatement(sql); prest.setInt(1,idhapus); prest.executeQuery(); ResultSet rs = prest.executeQuery(); while (rs.next()){ System.out.print("ID: " +rs.getInt(1)); System.out.print(" | Nama: "+rs.getString(2)); System.out.print(" | Tgl: "+rs.getInt(3)); System.out.print("-"+rs.getInt(4)); System.out.print("-"+rs.getInt(5)); System.out.print(" | Theater: "+rs.getInt(6)); System.out.print(" | HTM: "+rs.getInt(7)); System.out.println(" | Kursi: "+rs.getInt(33)); } System.out.print("ID: "+idhapus+ " yakin untuk dihapus ? "); String lagi = inputs(); if (lagi.equals("y")||lagi.equals("Y")) { sql = "DELETE FROM TableFilm WHERE ID = ?"; prest = koneksi.prepareStatement(sql); prest.setInt(1,idhapus); prest.executeUpdate(); System.out.println("*Message : Sukses ID "+idhapus+" telah dihapus."); } break; } case 3:{ break; } } } catch(Exception e){ System.out.println (" Pesan Kesalahan : " + e.getMessage()); } } public void editdata(int x){ System.out.print("ID yg akan diedit (kecuali 1,batal=0)>> "); int idedit = input(); if ((idedit==0)||(idedit==1)){ database(); } try{ switch (x){ case 1:{ sql = "SELECT * FROM TableUser WHERE ID = ?"; prest = koneksi.prepareStatement(sql); prest.setInt(1,idedit); prest.executeQuery(); ResultSet rs = prest.executeQuery(); while (rs.next()){ System.out.println("ID: " +rs.getInt(1) +" |User: "+rs.getString(2)+" |Pass : "+rs.getString(3)+" |Admin: "+rs.getBoolean(4)); } System.out.print("ID: "+idedit+ " yakin untuk diedit (Y/T)? "); String lagi = inputs(); String n_user=null; String n_pass=null; String n_super=null; if (lagi.equals("y")||lagi.equals("Y")) { System.out.print("New Username : "); n_user=inputs(); System.out.print(" Password : "); n_pass=inputs(); System.out.print(" Admin (Y/T) : "); n_super=inputs(); } else break; System.out.print("ID: "+idedit+ " yakin untuk diganti dengan yg baru (Y/T)? "); lagi = inputs(); if (lagi.equals("y")||lagi.equals("Y")) { sql = "UPDATE TableUser SET username = ?, password = ?, super = ? WHERE ID = ?"; prest = koneksi.prepareStatement(sql); prest.setString(1,n_user); prest.setString(2,n_pass); if (n_super.equals("Y")||n_super.equals("y")) prest.setBoolean(3,true); else prest.setBoolean(3,false); prest.setInt(4,idedit); prest.executeUpdate(); System.out.println("*Message : Sukses ID "+idedit+" telah diedit."); } break; } case 2:{ sql = "SELECT * FROM TableFilm WHERE ID = ?"; prest = koneksi.prepareStatement(sql); prest.setInt(1,idedit); prest.executeQuery(); ResultSet rs = prest.executeQuery(); while (rs.next()){ System.out.print("ID: " +rs.getInt(1)); System.out.print(" | Nama: "+rs.getString(2)); System.out.print(" | Tgl: "+rs.getInt(3)); System.out.print("-"+rs.getInt(4)); System.out.print("-"+rs.getInt(5)); System.out.print(" | Theater: "+rs.getInt(6)); System.out.print(" | HTM: "+rs.getInt(7)); System.out.println(" | Kursi: "+rs.getInt(34)); } System.out.print("ID: "+idedit+ " yakin untuk diedit ? (Y/T)"); String lagi = inputs(); String n_film=null; int n_DD=0; int n_MM=0; int n_YYYY=0; int n_theater=0; int n_HTM=0; int n_kursi=0; if (lagi.equals("y")||lagi.equals("Y")) { System.out.print("New Name Film : "); n_film=inputs(); System.out.print(" Tanggal : "); n_DD=input(); System.out.print(" Bulan : "); n_MM=input(); System.out.print(" Tahun : "); n_YYYY=input(); System.out.print(" Theater : "); n_theater=input(); System.out.print(" Harga Tiket : "); n_HTM=input(); System.out.print(" Jumlah Kursi Slot : "); n_kursi=input(); } else break; System.out.print("ID: "+idedit+ " yakin untuk diganti dengan yg baru (Y/T)? "); lagi = inputs(); if (lagi.equals("y")||lagi.equals("Y")) { sql = "UPDATE TableFilm SET nama_movie = ?, tgl = ?, bln = ?, thn = ?, theater = ?, htm = ?, kursi = ? WHERE ID = ?"; prest = koneksi.prepareStatement(sql); prest.setString(1,n_film); prest.setInt(2,n_DD); prest.setInt(3,n_MM); prest.setInt(4,n_YYYY); prest.setInt(5,n_theater); prest.setInt(6,n_HTM); prest.setInt(7,n_kursi); prest.setInt(8,idedit); prest.executeUpdate(); System.out.println("*Message : Sukses ID "+idedit+" telah diedit."); } break; } case 3:{ break; } } } catch(Exception e){ System.out.println (" Pesan Kesalahan : " + e.getMessage()); } } public void laporan(){ System.out.println("\n|---------------------------------------|"); System.out.println("| LAPORAN |"); System.out.println("|---------------------------------------|"); System.out.println("| Hint ! Hanya Laporan daftar hasil |"); System.out.println("| pembelian tiket cinema . |"); System.out.println("|---------------------------------------|"); System.out.println("|----------------------------DATABASE LAPORAN---------------------------------|"); for (int i=0;i<=datal;i++){ for (int j=0;j<datak;j++){ System.out.println(j+">"+dlaporan[i][j]); } } System.out.println("|-----------------------------------------------------------------------------|"); System.out.println("Press Enter untuk Kembali."); String gguna=inputs(); } public void lpr(int x,int y,int z,String a){ dapatkandate(); dlaporan[datal][datak] = temp[1]+"-"+temp[2]+"-"+temp[3]+"|"+temp[11]+":"+temp[12]+":"+temp[13]+" >"+a+": ["+x+"] Tiket di Theater ["+y+"], Profit Rp."+z+"."; datak++; if (datak==900){ datal++; datak=0; } } public void dapatkandate(){ kalender = Calendar.getInstance(); temp[1]=kalender.get(Calendar.DATE); temp[2]=kalender.get(Calendar.MONTH); temp[3]=kalender.get(Calendar.YEAR);temp[2]++; temp[11]=kalender.get(Calendar.HOUR_OF_DAY); temp[12]=kalender.get(Calendar.MINUTE); temp[13]=kalender.get(Calendar.SECOND); // System.out.println("*Check Date : "+temp[1]+"-"+temp[2]+"-"+temp[3]+"*");// System.out.println("*Check Clock : "+temp[11]+":"+temp[12]+":"+temp[13]+"*"); } public void dapatkandata(){ // Daftarkan driver JDBC yang akan digunakan try{ System.out.println("Koneksi ke Server...."); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // Koneksikan ke DSN System.out.println("Koneksi ke Database...."); koneksi = DriverManager.getConnection("jdbc:odbc:DatabaseFilm"); // Buat statement yang akan dieksekusi st = koneksi.createStatement(); // Eksekusi statement dan simpan query-nya ke resultset datauser = st.executeQuery(" SELECT * FROM TableUser "); // Ambil hasil resultset-nya System.out.println("Loading Database User...."); duser = new String [999][999]; datai=0; while (datauser.next()){ duser[datai][3] = Integer.toString(datauser.getInt(1)); duser[datai][0] = datauser.getString(2); duser[datai][1] = datauser.getString(3); duser[datai][2] = Boolean.toString(datauser.getBoolean(4)); System.out.println("ID:" +duser[datai][3] +" |User:"+duser[datai][0]+" |Pass :"+duser[datai][1]+" |Admin:"+duser[datai][2]); datai++; } for (int j=0;j<datai;j++){ } System.out.println (" Pesan : "+datai+ " User Database telah berhasil diload dengan sukses !"); // JOptionPane.showMessageDialog(null,datai+ " User Database telah berhasil diload dengan sukses !","Database Load Sukses",1); // Eksekusi statement dan simpan query-nya ke resultset st = koneksi.createStatement(); datauser = st.executeQuery(" SELECT * FROM TableFilm "); System.out.println("Loading Database Film...."); // Ambil hasil resultset-nya dfilm = new String [999][999]; dataj=0; while (datauser.next()){ dfilm[dataj][0] = Integer.toString(datauser.getInt(1)); dfilm[dataj][1] = datauser.getString(2); for(int i=3; i<=8;i++){ dfilm[dataj][(i-1)] = Integer.toString(datauser.getInt(i)); } dfilm[dataj][8] = Integer.toString(datauser.getInt(34)); System.out.print("ID:" +dfilm[dataj][0]); System.out.print(" | Nama:"+dfilm[dataj][1]); System.out.print(" | Tgl:"+dfilm[dataj][2]); System.out.print("-"+dfilm[dataj][3]); System.out.print("-"+dfilm[dataj][4]); System.out.print(" | Theater:"+dfilm[dataj][5]); System.out.print(" | HTM:"+dfilm[dataj][6]); System.out.println(" | Kursi:"+dfilm[dataj][8]); dataj++; } System.out.println (" Pesan : "+dataj+ " Film Database telah berhasil diload dengan sukses !\n\n\n\n\n\n\n"); // JOptionPane.showMessageDialog(null,dataj+ " Film Database telah berhasil diload dengan sukses !","Database Load Sukses",1); dlaporan = new String [999][999]; datak=0;datal=0; // Tutup koneksinya //koneksi.close(); } catch (Exception ex) { System.out.println (" Pesan Kesalahan : " + ex.getMessage()); JOptionPane.showMessageDialog(null,ex.getMessage(),"Database Load Gagal",0); } } public int input() { BufferedReader brf = new BufferedReader(new InputStreamReader(System.in)); String Input = null; try { Input = brf.readLine(); Integer.parseInt(Input); } catch (Exception e) { Integer.parseInt(Input = "0"); } int Data = Integer.valueOf(Input).intValue(); return Data; } public String inputs() { BufferedReader brf = new BufferedReader(new InputStreamReader(System.in)); String Input = null; try { Input = brf.readLine(); } catch (Exception e) { Input = "null"; } String Data = String.valueOf(Input); return Data; }}