<select id="getRowCount" resultType="int">
select count(*)
from sys_logs
<where>
<if test="username != null and username != ''">
username like concat("%",#{username},"%")
</if>
</where>
</select>
<select id="findPageObjects" resultType="com.cy.pojo.SysLog">
select *
from sys_logs
<where>
<if test="username != null and username != ''">
username like concat("%",#{username},"%")
</if>
</where>
order by createdTime desc
limit #{startIndex},#{pageSize}
</select>
抽取可重用的sql片段
<sql id="pus">
from sys_logs
<where>
<if test="username != null and username != ''">
username like concat("%",#{username},"%")
</if>
</where>
</sql>
<select id="getRowCount" resultType="int">
select count(*)
<include refid="pus"></include>
</select>
<select id="findPageObjects" resultType="com.cy.pojo.SysLog">
select *
<include refid="pus"></include>
order by createdTime desc
limit #{startIndex},#{pageSize}
</select>