商品分类-新增分类-级联查询
新增功能,首先实现级联查询
1、实现步骤
1.1、 Service 服务层
package com.ego.service;
import com.ego.pojo.GoodsCategory;
import com.ego.vo.GoodsCategoryVo;
import java.util.List;
/**
* 商品分类service
*/
public interface GoodsCategoryServicei {
/**
* 根据parentId查询商品分类列表
*
* @param parentId
* @return
*/
List<GoodsCategory> selectCategoryList(short parentId);
/**
* 保存商品分类
* @param goodsCategory
* @return
*/
int categorySave(GoodsCategory goodsCategory);
/**
* 查询商品分类列表页面
* @return
*/
List<GoodsCategoryVo> selectCatoryListForView();
}
GoodsCategoryServiceImpl
package com.ego.service.impl;
import com.ego.mapper.GoodsCategoryMapper;
import com.ego.pojo.GoodsCategory;
import com.ego.pojo.GoodsCategoryExample;
import com.ego.service.GoodsCategoryServicei;
import com.ego.vo.GoodsCategoryVo;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.ArrayList;
import java.util.List;
/**
* 商品分类service
*/
@Service
public class GoodsCategoryServiceImpl implements GoodsCategoryServicei {
@Autowired
private GoodsCategoryMapper goodsCategoryMapper;
/**
* 根据parentId查询商品分类列表
*
* @param parentId
* @return
*/
@Override
public List<GoodsCategory> selectCategoryList(short parentId) {
//创建example对象
GoodsCategoryExample example = new GoodsCategoryExample();
//创建查询对象并设置查询查询参数
example.createCriteria().andParentIdEqualTo(parentId);
//查询
return goodsCategoryMapper.selectByExample(example);
}
/**
* 保存商品分类
*
* @param goodsCategory
* @return
*/
@Override
public int categorySave(GoodsCategory goodsCategory) {
return goodsCategoryMapper.insertSelective(goodsCategory);
}
/**
* 查询商品分类列表页面
*
* @return
*/
@Override
public List<GoodsCategoryVo> selectCatoryListForView() {
//创建example对象
GoodsCategoryExample example = new GoodsCategoryExample();
//创建查询对象并设置参数
example.createCriteria().andParentIdEqualTo((short) 0).andLevelEqualTo((byte) 1