ibatis mysql date_MyBatis的：查询java.util.Date与MYSQL数据库

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