可以这样吧:

<resultMap id="get-product-result" class="com.paic.epass.cardcenter.dto.UserDTO">
<result property="empo" column="empo"/>
<result property="um_id" column="employee_id"/>
<result property="status" column="status"/>
<result property="matchID" column="match_id"/>
<result property="operator" column="create_by"/>
<result property="createDate" column="create_time"/>
</resultMap>

<statement id="selectRecord" resultMap="get-product-result" >
select empo,employee_id,status,match_id,card_holder.create_by,card_holder.create_time from CARD_HOLDER,CARD
<dynamic prepend="where">
<isNotEmpty prepend="and" property="empo">
empo = #empo#
</isNotEmpty>

<isNotEmpty prepend="and" property="um_id">
employee_id = #um_id#
</isNotEmpty>

<isNotEmpty prepend="and" property="status">
status = #status#
</isNotEmpty>

<isNotEmpty prepend="and" property="matchID">
match_id = #matchID#
</isNotEmpty>

<isNotEmpty prepend="and" property="operator">
CARD_HOLDER.create_by = #operator#
</isNotEmpty>

</dynamic>
and CARD_HOLDER.CARD_ID = CARD.ID order by card_id asc
</statement>
但是不知如何过滤NULL值更好点,比如 and create_time is not null