@Mapper
public interface DemandCommentMapper extends BaseMapper{
@Select("SELECT "
+ “a.id as ‘id’,a.create_date as ‘createDate’,a.content as ‘content’,”
+ “a.parent_id as ‘parentId’,a.first_comment_id as ‘firstCommentId’,”
+ “b.id as ‘fromUser.id’,b.realname as ‘fromUser.realname’,b.avatar as ‘fromUser.avatar’,”
+ "c.id as ‘toUser.id’,c.realname as ‘toUser.realname’,c.avatar as ‘toUser.avatar’ "
+ "FROM t_demand_comment a "
+ "LEFT JOIN t_user b ON b.id = a.from_uid "
+ "LEFT JOIN t_user c ON c.id = a.to_uid "
+ "WHERE a.demand_id = #{demandId} "
+ “ORDER BY a.create_date ASC”
+ “LIMIT #{startNo},#{pageSize}”)
public List listDemandComment(@Param(“demandId”) Long demandId,
@Param(“startNo”) Integer pageNo,
@Param(“pageSize”) Integer pageSize);
复制代码
这样整个语句是写死的,如果我想根据pageNo与pageSize是否为空来判断是否需要分页,该怎么做呢?
如果使用xml来配置的话可以用
LIMIT #{startNo},#{pageSize} 如果是用@Select 这种该如何做呢?方法:用script标签包围,然后像xml语法一样书写
复制代码
@Mapper
public interface DemandCommentMapper extends BaseMapper{
@Select("”)
public List listDemandComment(@Param(“demandId”) Long demandId,
@Param(“startNo”) Integer pageNo,
@Param(“pageSize”) Integer pageSize);
复制代码
项目实例
复制代码
@Select("")
public List getTaobao(@Param(“status”) Integer status);