@Override
	public Category getCategory(Integer id) {
		
		Category category = null;
		PreparedStatement pStmt = null;
		ResultSet rs = null;
		
		try {
			
			pStmt = conn.prepareStatement("SELECT * FROM CATEGORY WHERE id = ?;");
			pStmt.setInt(1, id);
			rs = pStmt.executeQuery();
			
			while (rs.next()) {
				
				category = new Category();
				category.setId(id);
				category.setDescription(rs.getString("description"));
				
			}
			
		} catch (SQLException e) {

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