tugas PBO :)

import java.sql.Connection;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.ResultSetMetaData;
import java.sql.ResultSet;
import java.util.Scanner;
public class ClsMain
{
  
       public static void main(String[] args)
       {
           
              try
              {
                     Scanner in = new Scanner(System.in);
                     boolean cari = false;
                  
                     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                  
                     Connection CN = DriverManager.getConnection("jdbc:odbc:wiwik");
                  
                     Statement ST = CN.createStatement();
                  
                     ResultSet RS = ST.executeQuery("select * from data_mahasiswa");
                                                    
                     ResultSetMetaData MD = RS.getMetaData();
                                      
                     System.out.print("Username : ");String nama = in.nextLine();
                     System.out.print("Password : ");String pass = in.nextLine();
                  
                     while (RS.next() && cari==false)
                     {
                           if(nama.equalsIgnoreCase((String) RS.getObject(1)) &&    
                             pass.equalsIgnoreCase ((String) RS.getObject(2)))
                            {
                                  System.out.print("Anggota");
                                  cari=true;
                           }
                        
                     }
                     if(cari==false)
                     {
                           System.out.print("Bukan Anggota");
                        
                     }
              }

              catch(Exception e)
              {
                     e.printStackTrace();
              }          
       }
}

0 komentar:

Posting Komentar