sql practicum 2

package exercises;

import java.io.*;
import java.sql.*;

/*
 * @author Kenton Dang
 */

public class JCBD {
	static Connection conn		= null;
	static Statement stmt		= null;
	static String dbURL			= "jdbc:oracle:thin:@127.0.0.1:1521:XE";
	static String user			= "PROJECTS";
	static String password		= "projects";

	public JCBD() { }

	static BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
	static String custID = "";
	static String notShipped = "Not Shipped";
	static String shipped = "Shipped";
	static int counter = 0;

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

		try {
			conn = DriverManager.getConnection(dbURL, user, password);
			conn.clearWarnings();
			System.out.println("Connection opened! For driver ==> Oracle 11XE");
			stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery("select * from VQ3");
			ResultSetMetaData meta = rs.getMetaData();

			while (!custID.equalsIgnoreCase("X")) {

				System.out.print("Enter Customer ID: ");
				custID = br.readLine();
				System.out.println("");
				System.out.println("Statistics for [COMPANYNAME] By [NAME]");
				System.out.println("");
				System.out.printf("%4s   %4s    %7s\n", meta.getColumnName(1), meta.getColumnName(3), meta.getColumnName(4));
				System.out.println("");

				while (rs.next()){
					if (custID.equalsIgnoreCase(rs.getString(2))){
						System.out.printf(" %4s   %8s  %8s\n", rs.getString("ORDERID"), rs.getString("ORDERDATE"), rs.getString("SHIPPEDDATE"));
					}
				}//end of rs.next

			}//end of X while
		} catch (SQLException e) {
			System.err.println(e.getMessage());
		} catch (IOException e) {
			e.printStackTrace();
		}

	} // end of main

}//class