/*******************************************************************
*                                                                  *
*  This program shows how to list the courses taken by students.   *
*                                                                  *
*******************************************************************/

// Import the following packages and class to use JDBC.
import  java.sql.*;
import  java.io.*;
import  oracle.jdbc.*;
import  oracle.jdbc.pool.OracleDataSource;

class  ListCourses {
  public static void  main( String args[ ] ) throws SQLException {
    String user     = "user_id";
    String password = "password";
    String database = "20.185.147.112:1521/xe";

    // Open an OracleDataSource and get a connection.
    OracleDataSource ods = new OracleDataSource( );
    ods.setURL     ( "jdbc:oracle:thin:@" + database );
    ods.setUser    ( user );
    ods.setPassword( password );
    Connection conn = ods.getConnection( );

    try {
      Statement stmt = conn.createStatement( );
      String query  = "SELECT s.name, c.title FROM ";
             query += "student1 s, course1 c, take1 t WHERE ( ";
      for ( int i=0;  i<args.length;  i++ ) {
        if ( i != 0 )  query += " OR ";
        query += "UPPER(s.name)";
        if ( args[i].trim( ).equals( "POKE MON" ) ||
             args[i].trim( ).equals( "SPONGE BOB" ) )
          query += " = '" + args[i].trim( ) + "' ";
        else
          query += " LIKE '%" + args[i].trim( ) + "%' ";
      }
      query += " ) AND s.sid=t.sid AND t.cid=c.cid ";
      System.out.println( query );

      ResultSet rset = stmt.executeQuery( query );
      // Iterate through the result and print the data.
      if ( !rset.next( ) )
        System.out.println( "No classes are found!" );
      else
        do {
          System.out.print  ( rset.getString(1) + ": " );
          System.out.println( rset.getString(2) );
        } while ( rset.next( ) );

      // Close the ResultSet and Statement.
      rset.close( );
      stmt.close( );
    }
    catch ( SQLException ex ) {
      System.out.println( ex );
    }
    // Close the Connection.
    conn.close( );
  }
}