public void customerAdjust()
    {

	BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
	String commandArg = null;

	System.out.println("Please enter the customer ID.");

	try{
	    commandArg = br.readLine();
	} catch(IOException ioe) {
	    System.out.println("Error reading customer ID.Exiting...");
	    System.exit(1);
	}

	String custID = commandArg;

	String queryCustID = "SELECT * FROM Customer c WHERE c.customer_ID = '" + custID + "'";
	Statement stmt = null;
	try {
	    stmt = custConn.getConnection().createStatement();
	    ResultSet rs = stmt.executeQuery(queryCustID);
	} catch(Exception e) {
	    System.out.println("Error looking up Customer ID. Exiting.");
	    System.exit(1);
	}

	System.out.println("Enter the new status of the customer.");
	
	try {
	    commandArg = br.readLine();
	} catch (IOException ioe) {
	    System.out.println("Error reading status. Exiting.");
	    System.exit(1);
	}

	String newStatus = commandArg;

	String updateStatus = "UPDATE Customer SET status = '" + newStatus + "' WHERE customer_ID = '" + custID + "'";

	try {
	    //Statement stm = custConn.getConnection().createStatement();
	    int r = stmt.executeUpdate(updateStatus);
	} catch (Exception e) {
	    System.out.println("Error changing customer status. Exiting.");
	    System.exit(1);
	}

	System.out.println("Successfully changed customer status.");

	
    }