/****************************************************************/
/* JDBC Example -- Create Table (Example 5.4.2)                 */
/* Chapter 5; Oracle Programming -- A Primer                    */
/*            by R. Sunderraman                                 */
/****************************************************************/
import java.sql.*; 
import java.io.*; 

class create_table { 

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

    String query, query1, user, password;
    query =  "create table deleted_scores (" +
             "sid       varchar2(5) not null," +
             "term      varchar2(10) not null," +
             "lineno    number(4) not null," +
             "compname  varchar2(15) not null," +
             "points    number(4) check(points >= 0))";
           
    try {
      Class.forName ("oracle.jdbc.driver.OracleDriver");
    } catch (ClassNotFoundException e) {
        System.out.println(" Haha... Could not load driver");
      }

	user = "ytu";
	password = "ytu";
	
    String connString = "jdbc:oracle:thin:@//netcluster.csee.usf.edu:1521/XE";
                Connection conn = DriverManager.getConnection(connString, user, password);

	
query1 = "select * from system.players where h_feet = ? and h_inches = ?";

PreparedStatement ps = conn.prepareStatement(query1);
ps.setInt(1, 6);
ps.setInt(2, 10);

    //query1 = "select * from system.players";
    //Statement stmt = conn.createStatement ();
    ResultSet rset;
 
    try {
      //stmt.executeUpdate(query1);
	  //rset = stmt.executeQuery(query1);
	  
	  rset = ps.executeQuery();
    } catch (SQLException e) {
      System.out.println("Could not execute query!");
      return;
    }
    System.out.println("Query executed");

    ResultSetMetaData md = rset.getMetaData();
	int count = md.getColumnCount();
	
    while (rset.next ()) {
		for(int i = 1; i <= count; i++)
			System.out.print ( rset.getString(i) + "\t");
		System.out.print("\n");
   }

  }


  //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 "";
       }
   }

}