记录一下:使用jpa的模糊查询
/**根据tagid查询粉丝列表分页 **/
@Query(value = "select bean from WechatFans bean where 1 = 1 and bean.appId = :appid and ("
+ "bean.tagidList like CONCAT(',',:tagid,',','%') or bean.tagidList like CONCAT('%',',',:tagid,',','%'))")
Page<WechatFans> selectFans(@Param("appid")String appid, @Param("tagid")Integer tagid, Pageable pageable);
jpa @Query分页实现
直接使用在参数列表加上Pageable 参数;