JDBC : Select/Query/List Table Record

//jangan lupa import java.sql.*;
      //deklarasikan koneksi database
      Connection conn=null; 
      try
      {
          //definisikan driver untuk Database Mysql,
          //setiap Database mempunyai driver yang berbeda-beda,
          //kunjungi situs Database yang anda gunakan untuk mendowload JDBC Driver
         Class.forName("org.gjt.mm.mysql.Driver");                                                                                
        //Setting connection, ingat setiap database mempunyai model konfigurasi URL yang berbeda
         conn = DriverManager.getConnection(                                    
               "jdbc:mysql://localhost:3306/testDB",      
               "root",                                                   
               "root");                                                  
                                            
         //Definisikan statement
         Statement stmt = conn.createStatement();     
         //Definisikan query beserta ResultSet sebagai buffer hasil query
         //khusus untuk SELECT anda harus menggunakan method executeQuery,
         //untuk INSERT,DELETE,UPDATE anda harus menggunakan method executeUpdate
         ResultSet rs = stmt.executeQuery("SELECT * FROM Table1");         
               
         //menampilkan hasil, perulangan sampai end of records                                       
         while(rs.next())                                                       
         {                     
           //mengambil masing-masing record, anda bisa menggunakan method lain
           //selain getString, seperti getInt, getDouble, getFloat
          System.out.println(
          rs.getString("ID") + " || " + rs.getString("NAMA"));    
         }                  
         rs.close();
         stmt.close();
      }                                                                         
      //menghandle Exception
      catch(SQLException e)                                                     
          {                                                                         
           System.out.println("SQLException: " + e.getMessage() );                                     
          }                                                                         
      catch(ClassNotFoundException e)                                           
          {                                                                         
           System.out.println("ClassNotFoundException: " + e.getMessage());     
          }                                                                         
      finally                                                                   
      {                                                                         
         //Clean up resources, menutup koneksi                         
         if(conn != null)                                                       
         {                                                                      
          try                                                                 
          {                                                                   
             conn.close();                                                    
          }                                                                   
          catch (Exception ignored) {}                                        
         }                                                                      
      }