<select id="findByPage" resultMap="allMap" parameterType="java.lang.String">
select <include refid="all"/> from t_user
<if test="username!=null and username!='' ">
<where>
user_name Like '%${username}%'
</where>
</if>
limit #{currentPage},#{pageSize}
</select>
分页模糊查询mapper.xml 数据库语句
最新推荐文章于 2024-05-15 16:43:00 发布