mybatis plus实现分页

@Data
@AllArgsConstructor
@NoArgsConstructor
@TableName("region")
@Accessors(chain = true)
@Entity
@EqualsAndHashCode(callSuper = false)
@ApiModel(value = "行政区域", description = "行政区域")
public class Region {

	@TableId(type = IdType.ID_WORKER_STR) // mybatis-plus主键注解
	@IsAutoIncrement // 自增
	@IsKey // actable主键注解
	@Id
	@ApiModelProperty(value = "行政区域编码")
	@Column(name = "rid")
	@TableField(value = "rid")
	private String rId;

	@ApiModelProperty(value = "行政区域级别")
	private Integer level;

	@ApiModelProperty(value = "行政区域名称")
	private String regionName;

	@ApiModelProperty(value = "上级编码")
	private String parentId;

	@ApiModelProperty(value = "是否删除")
	private Integer isDeleted;
}



public interface RegionMapper extends BaseMapper<Region> {

	/**
	 * 分页查询
	 * 
	 * @param page
	 * @return
	 */
	public IPage<Region> selectPage(IPage<Region> page);

}



public interface IRegionService extends IService<Region> {
	/**
	 * 分页查询
	 * 
	 * @param page
	 * @return
	 */
	public IPage<Region> selectPage(Integer pageNo, Integer pageSize);
}


@Service
public class RegionServiceImpl extends ServiceImpl<RegionMapper, Region> implements IRegionService {


	@Override
	public IPage<Region> selectPage(Integer pageNo, Integer pageSize) {
       // 参数一是当前页,参数二是每页记录数
		IPage<Region> page = new Page<>(pageNo, pageSize);
		page = mapper.selectPage(page);
		return page;
	}

}


<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.yf.jingqiao.mapper.RegionMapper">

	<!-- 新增 -->
	<insert id="add" parameterType="com.yf.jingqiao.entity.Region">
		INSERT INTO region
		(rid, level, region_name, parent_id, is_deleted)
		VALUES
		(#{rId}, #{level}, #{regionName}, #{parentId}, #{isDeleted})
	</insert>


	<!-- 删除 -->
	<delete id="deleteById" parameterType="string">
		DELETE FROM region WHERE rid=#{rId}
	</delete>

	<!-- 修改 -->
	<update id="update"
		parameterType="com.yf.jingqiao.entity.Region">
		UPDATE region SET rid=#{rId}, level=#{level}, region_name=#{regionName},
		parent_id=#{parentId}, is_deleted=#{isDeleted} WHERE rid=#{rId}
	</update>
	
	<!-- 查询 -->
	   <select id="selectPage" resultType="com.yf.jingqiao.entity.Region">
         SELECT rid, level, region_name, parent_id, is_deleted FROM region
    </select>
</mapper>


@Slf4j
@Api(tags = "渠道类型管理")
@RestController
@RequestMapping("/basebusiness/channelType")
public class ChannelTypeController {
	@Autowired
	private IChannelTypeService channelTypeService;

	/**
	 * 分页列表查询
	 *
	 * @param channelType
	 * @param pageNo
	 * @param pageSize
	 * @param req
	 * @return
	 */
	@AutoLog(value = "渠道类型-分页列表查询")
	@ApiOperation(value = "渠道类型-分页列表查询", notes = "渠道类型-分页列表查询")
	@GetMapping(value = "/list")
	public Result<?> queryPageList(ChannelType channelType,
			@RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
			@RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize, 
       HttpServletRequest req) {
		IPage<ChannelType> page = channelTypeService.selectPage(pageNo, pageSize);
		return Result.ok(page);
	}

}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值