SELECT id AS id,
pharumo_id AS pharumoId,
code AS code,
family_name AS familyName,
first_name AS firstName,
family_name_kana AS familyNameKana,
first_name_kana AS firstNameKana,
gender AS gender,
address AS address,
tel AS tel
FROM tbl_patient
WHERE birthday = #{id}
其中的生日是在MYSQL数据库中的DATE类型。
我的映射器界面是这样的:
public interface PatientMapper {
void insertPatient(Patient patient);
Patient getPatientById(Integer id);
Integer getPatientCount();
List getPatientsByBirthday(Date bday);
}
我试图用特别的生日来查询病人为:
Calendar cal1 = new GregorianCalendar(1980, 8, 15);
Date bday=cal1.getTime();
List plist=mapper.getPatientsByBirthday(bday);
即使有与给定的最新记录,这回空单。
Anytips?
+0
在XML文件中分享您的Mapper接口实现和结果映射。 –
2012-08-29 18:26:13