mapper
如下所示:
<select id="selectActivityDoPagination" parameterType="java.lang.String"
resultMap="activity">
select
ID ,
ACTIVITY_CODE ,
ACTIVITY_DESCRIPTION ,
INDIRECT_RECOMMEND ,
to_char(CREATE_TIME,'yyyy-mm-dd hh24:mi:ss') CREATE_TIME,
to_char(LAST_MODIFIED,'yyyy-mm-dd hh24:mi:ss') LAST_MODIFIED ,
BANNER_PATH
from
${tableName}
where 1=1
<!-- 支持模糊查询 -->
<if test="activityCode != null and activityCode != ''">
and ACTIVITY_CODE=#{activityCode}
</if>
<if test="activityName != null and activityName != ''">
and ACTIVITY_NAME=#{activityName}
</if>
<if test="indirectRecommend != null and indirectRecommend != ''">
and INDIRECT_RECOMMEND=#{indirectRecommend}
</if>
<if test="createTime != null and createTime != ''">
and TO_CHAR(CREATE_TIME,'YYYY-MM-DD') = '${createTime}'
</if>
<if test="lastModified != null and lastModified != ''">
and TO_CHAR(LAST_MODIFIED,'YYYY-MM-DD') = '${lastModified}'
</if>
order by ID asc
</select>
<resultMap id="activity" type="com.smp.model.Activity">
<id column="ID" property="id" jdbcType="INTEGER" />
<result column="ACTIVITY_CODE" property="activityCode" jdbcType="VARCHAR" />
<result column="ACTIVITY_NAME" property="activityName" jdbcType="VARCHAR" />
<result column="ACTIVITY_DESCRIPTION" property="activityDescription" jdbcType="VARCHAR" />
<result column="INDIRECT_RECOMMEND" property="indirectRecommend" jdbcType="VARCHAR" />
<result column="CREATE_TIME" property="createTime" jdbcType="BIGINT" />
<result column="LAST_MODIFIED" property="lastModified" jdbcType="BIGINT" />
<result column="BANNER_PATH" property="bannerPath" jdbcType="VARCHAR" />
</resultMap>
其中com.smp.model.Activity 对应的是项目中的一个POJO的实体类