@Override
	public List<Patient> getlistPatient() throws Exception {
		
		BasicConfigurator.configure();
		log.debug("getlistPatient method called...");
		
	    List<Patient> list=new ArrayList<Patient>();
	    Statement stmt = null;
		Connection conn=JDBCManager.getConnection();
		try {
			stmt = conn.createStatement();
			String sql = "SELECT * FROM Patient";
			
			ResultSet rs = stmt.executeQuery(sql);
			while(rs.next()){
				 Patient 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"));
				 list.add(pt);
            }
			
		 } catch (SQLException e) {
			 throw e;
		 }finally{
             conn.close();
         }
		return list;
       }