public void changePrice()
    {
	BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
	String commandArg = null;

	System.out.println("Please enter the stock number of the item.");

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

	String stockNum = commandArg;

	String queryStockNum = "SELECT * FROM Product p WHERE p.stock_number = '" + stockNum + "'";   // make sure the stock number exists
	Statement stmtt = null;
	try {
	    stmtt = custConn.getConnection().createStatement();
	    ResultSet rs = stmtt.executeQuery(queryStockNum);
	} catch (Exception e) {
	    System.out.println("Error looking up Stock number...Exiting.");
	    System.exit(1);
	}

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

	double newPrice = 0;

	try {
	    newPrice = Double.valueOf(commandArg);
	} catch(NumberFormatException nfe) {
	    System.out.println("Enter a number. Exiting.");
	    System.exit(1);
	}

	String updateQuery = "UPDATE Product p SET p.Price = '" + newPrice + "' WHERE p.stock_number = '" + stockNum + "'";

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

	System.out.println("Successfully changed price");

	
    }