public static ArrayList<Product> showAll() {
        ArrayList<Product> products = new ArrayList<Product>();
        Database db = dbconnect();
            try {	
                db.prepare("SELECT * FROM product ORDER BY PID");
		ResultSet rs = db.executeQuery();
		while(rs.next()) {
			products.add(ProductObject(rs));
		}
                db.close();
        } catch (SQLException e) {
            Error_Frame.Error(e.toString());
        } 
         return products;
	}