@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);
}
}
mybatis plus实现分页
最新推荐文章于 2024-08-05 10:44:08 发布