/****************************************************************/
/* A Simple JDBC Program                                        */
/****************************************************************/

import java.sql.*;
import oracle.jdbc.driver.*;
import oracle.sql.*;
import java.math.BigDecimal;
import java.util.Map;
import java.io.*; 

class employee   { 
  public static void main (String args []) 
      throws SQLException, IOException { 

    String user, pass, snum, namer;
    int enumber; 

    user = readEntry("userid  : ");
    pass = readEntry("password: ");

 // Connect
    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver ());
    OracleConnection conn = (OracleConnection)
      DriverManager.getConnection("jdbc:oracle:oci8:@ccdb",
                                   user,pass);

    Statement stmt = conn.createStatement (); 

    ResultSet rset = stmt.executeQuery 
        ("select distinct eno,ename,zip,hdate from employees");
    while (rset.next ()) { 
      namer = rset.getString(2); 
      if  ( !rset.wasNull() ) {  
      System.out.println(rset.getInt(1) + "  " +
                         namer             + "  " +
                         rset.getInt(3) + "  " +
                         rset.getDate(4));
    } 
    } 

    System.out.println(); 


    PreparedStatement prepareQuery = conn.prepareStatement (  
         "select eno,ename,zip,hdate from employees where eno = ?");

    System.out.println("Enter -1 to quit program when prompted for employee number");      
    System.out.println();  

    snum = readEntry("employee number : ");

    enumber = Integer.valueOf(snum).intValue();

   while (enumber != -1) {  

    prepareQuery.setInt(1,enumber); 

 // ResultSet rset = prepareQuery.executeQuery(); 
    rset = prepareQuery.executeQuery(); 

    while (rset.next ()) { 
      System.out.println(rset.getInt(1) + "  " +
                         rset.getString(2) + "  " +
                         rset.getInt(3) + "  " +
                         rset.getDate(4));
    } 

    snum = readEntry("employee number : ");

    enumber = Integer.valueOf(snum).intValue();

   }
    conn.close();
  } 

  //readEntry function -- to read input string
  static String readEntry(String prompt) {
     try {
       StringBuffer buffer = new StringBuffer();
       System.out.print(prompt);
       System.out.flush();
       int c = System.in.read();
       while(c != '\n' && c != -1) {
         buffer.append((char)c);
         c = System.in.read();
       }
       return buffer.toString().trim();
     } catch (IOException e) {
       return "";
       }
   }
}