/**
* 分页结果封装对象
*/
@Data
@AllArgsConstructor
@NoArgsConstructor
public class PageResult implements Serializable{
private Long total;//总记录数
private List rows;//当前页结果
}
<!--分页查询检查项-->
<select id="findPage" resultType="com.itheima.pojo.CheckItem">
select * from t_checkitem
<where>
<if test="queryString != null">
code like concat('%',#{queryString},'%') or name like concat('%',#{queryString},'%') or helpCode like concat('%',#{queryString},'%')
</if>
</where>
</select>