/*
Navicat Premium Data Transfer
Source Server :
Source Server Type : MySQL
Source Server Version :80024
Source Host :
Source Schema :
Target Server Type : MySQL
Target Server Version :80024
File Encoding :65001
Date: 03/01/2022 19:13:53
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS =0;
-- ----------------------------
-- Table structure for base_category1
-- ----------------------------
DROP TABLE IF EXISTS `base_category1`;
CREATE TABLE `base_category1`(`id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '编号',
`name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分类名称',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT =18 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT ='一级分类表' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of base_category1
-- ----------------------------
INSERT INTO `base_category1` VALUES (1, '图书、音像、电子书刊');
INSERT INTO `base_category1` VALUES (2, '手机');
INSERT INTO `base_category1` VALUES (3, '家用电器');
INSERT INTO `base_category1` VALUES (4, '数码');
INSERT INTO `base_category1` VALUES (5, '家居家装');
INSERT INTO `base_category1` VALUES (6, '电脑办公');
INSERT INTO `base_category1` VALUES (7, '厨具');
INSERT INTO `base_category1` VALUES (8, '个护化妆');
INSERT INTO `base_category1` VALUES (9, '服饰内衣');
INSERT INTO `base_category1` VALUES (10, '钟表');
INSERT INTO `base_category1` VALUES (11, '鞋靴');
INSERT INTO `base_category1` VALUES (12, '母婴');
INSERT INTO `base_category1` VALUES (13, '礼品箱包');
INSERT INTO `base_category1` VALUES (14, '食品饮料、保健食品');
INSERT INTO `base_category1` VALUES (15, '珠宝');
INSERT INTO `base_category1` VALUES (16, '汽车用品');
INSERT INTO `base_category1` VALUES (17, '运动健康');
SET FOREIGN_KEY_CHECKS =1;
<?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="top.interesting.mapper.BaseCategory1Mapper"><select id="selectLists"resultType="top.interesting.entity.BaseCategory1">select * from `base_category1`</select></mapper>
创建BaseCategory1ServiceImpl实现类
@Service
public class BaseCategory1ServiceImpl implements IBaseCategory1Service{
@Autowired
public BaseCategory1Mapper baseCategory1Mapper;
@Override
public PageInfo<BaseCategory1> selectLists(Integer pageNum, Integer pageSize){
PageHelper.startPage(pageNum,pageSize);
List<BaseCategory1> pageInfo = baseCategory1Mapper.selectLists(pageNum, pageSize);return new PageInfo<>(pageInfo);};}
创建CategoryController控制层
@RestController
@RequestMapping("/product")
public class CategoryController {
@Autowired
private IBaseCategory1Service category1Service;
/**
*1.查询一级分类
*/
@GetMapping("/getCategory1")
public Result getCategory1(@RequestParam(value="pageNo",defaultValue="1")int pageNo,
@RequestParam(value="pageSize",defaultValue="10")int pageSize){
PageInfo<BaseCategory1> list = category1Service.selectLists(pageNo, pageSize);
//分页查询所有的一级分类
return Result.ok(list);}}
配置启动类启动项目即可
@SpringBootApplication
@MapperScan("top.interesting.mapper")
public class ProductApplication {
public static void main(String[] args){
SpringApplication.run(ProductApplication.class, args);}}