Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- case 2:
- menu = 2;
- while(menu ==2){
- System.out.println("\u000C");
- System.out.println("==============Klasemen Sementara==============");
- rs = stmt.executeQuery("select * from Klasemen");
- System.out.println("No\tNama\tMain\tMenang\tSeri\tKalah\tPoint");
- while(rs.next()){
- idKlas = rs.getInt("id");
- nama_klub = rs.getString("nama_klub");
- main = rs.getInt("Main");
- menang = rs.getInt("Menang");
- seri = rs.getInt("Seri");
- kalah = rs.getInt("Kalah");
- poin = rs.getInt("Point");
- System.out.println(idKlas+"\t"+nama_klub+"\t"+main+"\t"+menang+"\t"+seri+"\t"+kalah+"\t"+poin);
- }
- System.out.println("==============================================");
- System.out.println("1. Update Klasemen");
- System.out.println("2. Delete Klasemen");
- System.out.println("3. Reset Klasemen");
- System.out.println("4. Menu Awal");
- System.out.println("5. Keluar");
- System.out.println("==============================================");
- System.out.print("Pilih Menu : "); pilihan2 = Integer.parseInt(input.readLine());
- System.out.println();
- if (pilihan2 == 1) {
- rs = stmt.executeQuery("select * from Klasemen");
- nama_klub = rs.getString("nama_klub");
- main = rs.getInt("Main");
- menang = rs.getInt("Menang");
- seri = rs.getInt("Seri");
- kalah = rs.getInt("Kalah");
- poin = rs.getInt("Point");
- // String rs = stmt.executeQuery("select count * from Klasemen where Menang and Seri and Kalah");
- // System.out.println(rs);
- // if(){
- // }
- System.out.println("==============================================");
- System.out.println("Masukkan Id Klub : "); idKlas = Integer.parseInt(input.readLine().trim());
- System.out.println("Nama Klub : "+nama_klub);
- System.out.print("Main : "+ main + " >> "); stat_play =Integer.parseInt(input.readLine().trim());
- System.out.print("Menang : "+ menang + " >> "); stat_win =Integer.parseInt(input.readLine().trim());
- System.out.print("Seri : "+ seri + " >> "); stat_draw =Integer.parseInt(input.readLine().trim());
- System.out.print("Kalah : "+ kalah + " >> "); stat_lose =Integer.parseInt(input.readLine().trim());
- System.out.print("Point : "+ poin + " >> "); stat_pts =Integer.parseInt(input.readLine().trim());
- sql = "UPDATE Klasemen SET Main='%s', Menang='%s', Seri='%s', Kalah='%s', Point='%s' WHERE id=%d";
- sql = String.format(sql,stat_play,stat_win,stat_draw,stat_lose,stat_pts, idKlas);
- stmt.execute(sql);
- menu = 2;
- }
- else if(pilihan2 == 2){
- System.out.println("==============================================");
- System.out.println("Masukkan Id Klub : "); idKlas = Integer.parseInt(input.readLine().trim());
- sql = "UPDATE Klasemen SET Main=0, Menang=0, Seri=0, Kalah=0, Point=0 WHERE id=%d";
- sql = String.format(sql, idKlas);
- stmt.execute(sql);
- menu = 2;
- }
- else if(pilihan2 == 3){
- System.out.println("==============================================");
- sql = "UPDATE Klasemen SET Main=0, Menang=0, Seri=0, Kalah=0, Point=0";
- stmt.execute(sql);
- menu = 2;
- }
- else if(pilihan2 == 4){
- System.out.println("\u000C");
- menu = 0;
- }
- else if(pilihan2 == 5){
- System.exit(0);
- }
- }
- break;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement