<resultMap class="gecFile" id="gecPendingFile">
<result column="FILE_ID" property="fileId" />
<result column="FILE_NAME" property="fileName"/>
<result column="REQUEST_ID" property="requestId"/>
<result column="SCHEDULED_AT" property="scheduledAt" />
</resultMap>
<select id="getPendingFiles" resultMap="gecPendingFile" parameterClass ="java.util.Date">
SELECT file_id, file_name,request_id
FROM gec_file
WHERE STATUS = 'P'
AND SCHEDULED_AT = #scheduledAt:DATE#
</select>
其中parameterClass是参数对应的类型