public int checkInventory()
    {
	 
	System.out.println("Enter the stock number you wish to check the quantity of");
	BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
	String stock_number = null;
	try {
	    stock_number = br.readLine();
	} catch (IOException ioe) {
	    System.out.println("Error reading stock number. Exiting.");
	    System.exit(0);
	}
	Statement st = null;
	try {
	    st = custConn.getConnection().createStatement();

	    String qry = "SELECT P.quantity FROM ProductDepot P WHERE P.stock_number = '" + stock_number + "'";
		
	    ResultSet rs = st.executeQuery(qry);
	    //Right now, this displays nothing if there is no matching ID. Might fix later.
	    while (rs.next())
		{
		    System.out.println("Quantity: " + rs.getInt(1));
		}
			

	} catch (Exception e) {
	    System.out.println("Error. Exiting.");
	}
	return 0;
		
    }