public static ArrayList<Category> showAll() {
        ArrayList<Category> category = new ArrayList<Category>();
        Database db = dbconnect();
            try {	
		db.prepare("SELECT * FROM problem_category ORDER BY CategoryID");
		ResultSet rs = db.executeQuery();
		while(rs.next()) {
			category.add(CategoryObject(rs));
		}
                db.close();
        } catch (SQLException e) {
            Error_Frame.Error(e.toString());
        } 
         return category;
	}