@Override
	public Patient getPatient(int healthRecord) throws Exception {
		log.debug("getPatient method called...");
		PreparedStatement stmt = null;
		Patient pt=null;
		Connection conn=JDBCManager.getConnection();
		try {
			
			String sql = "SELECT * FROM Patient where HealthRecordNumber=?";
			stmt = conn.prepareStatement(sql);
			stmt.setInt(1,healthRecord);
			ResultSet rs = stmt.executeQuery();
						
			while(rs.next()){
				  pt=new Patient();
				 pt.setHealthRecNo(rs.getInt("HealthRecordNumber"));
				 pt.setFirstName(rs.getString("FirstName"));
				 pt.setLastName(rs.getString("LastName"));
				 pt.setGender(rs.getString("Gender"));
				 pt.setAge(rs.getInt("Age"));				 
            }			
		 } catch (SQLException e) {
            throw e;
		 }finally{
            conn.close();
	     }
		return pt;
	}