@Override
	public Set<Category> getCategories() {

		Set<Category> categories = new HashSet<Category>();
		PreparedStatement pStmt = null;
		ResultSet rs = null;
		
		try {
			
			pStmt = conn.prepareStatement("SELECT * FROM CATEGORY ORDER BY id");
			rs = pStmt.executeQuery();
			
			while (rs.next()) {
				
				Category category = new Category(); 
				category.setId(rs.getInt("id"));
				category.setDescription(rs.getString("description"));
				categories.add(category);
				
			}
			
		} catch (SQLException e) {

			e.printStackTrace();
			
		} finally {
			
			closeResource(pStmt);
			closeResource(rs);
			
		}
		
		return categories;
		
	}