myabtis封装的mapper

1.全找findAll

@RestController
@RequestMapping("/brand")
public class BrandController {

    @Autowired
    private BrandService brandService; 
 @GetMapping
    public Result findAll(){
        List<Brand> list = brandService.findAll();
        return new Result( true, StatusCode.OK,"查询成功",list );
    }
}



public interface BrandService {

    /**
     * 查询全部数据
     * @return
     */

List<Brand> findAll();
}



@Service
public class BrandServiceImpl implements BrandService {

    @Autowired
    private BrandMapper brandMapper;
@Autowired
private BrandMapper brandMAapper；
public List<Brand> findAll{return brandMapper.selectAll();}


/**
 * 品牌数据访问接口
 */
public interface BrandMapper extends Mapper<Brand> {


}

2.根据id找

@RestController
@RequestMapping("/brand")
public class BrandController {
@GetMapping("/id")
pbublic Result findById( @PathVariable Integer id){
        Brand brand = brandService.findById( id );
        return new Result( true,StatusCode.OK,"查询成功",brand );
    }
}


public interface BrandService {
  Brand findById(Integer id);
}

@Service
public class BrandServiceImpl implements BrandService {

    @Autowired
    private BrandMapper brandMapper; @Override
    public Brand findById(Integer id) {
        return brandMapper.selectByPrimaryKey( id );
    }


import tk.mybatis.mapper.common.Mapper;

/**
 * 品牌数据访问接口
 */
public interface BrandMapper extends Mapper<Brand> {


}

3.新增

/**
     * 新增数据
     * @param brand
     * @return
     */
    @PostMapping
    public Result add( @RequestBody Brand brand){
        brandService.add( brand );
        return new Result(true,StatusCode.OK,"添加成功"  );
    }




void add（Brand brand）;





public void add (Brand brand){
brandMapper.insert(brand);}


import tk.mybatis.mapper.common.Mapper;

/**
 * 品牌数据访问接口
 */
public interface BrandMapper extends Mapper<Brand> {


}

4.修改

@PutMapping("/id")

public Result update (@PathVariable Integer id,@RequestBody Brand brand){
brand.setId(id);
brandService.update(brand);
return new Result(true,StatueCode.Ok."修改成功")；
}


void update(Brand brand); 




public void update(Brand brand){
//brandMapper.update(brand);
brandMapper.updateByPrimaryKey(brand);


}

5.删除

@RequestMapping("/id")
public Result delete(@PathVariable Integer id){
brandServie.delete(id);
return new Result (true,StatuesCode.OK,"删除成功");

}




void delete（Integer id）;

@Service
public void delete(Integer id){
brandMapper.deleteByPrimaryKey(id);
}

6.根据条件查询

@GetMapping
public Result findList(@RequestParam Map<String,String>searchMap){
List<Brand> list=brandService.findList(searchMap);
return new Result(ture,StatusCode.OK.list);
}



list<Brand> findList( Map<String,String> searchMap)


public List<Brand> findList(Map<String,String> searchMap){
Example example=this.createEWxample(searchMap)
return brandMapper.selecctByExample(example);
}

private Example createExample(Map<String,String> searchMap){
Example example=new Example(Brand.class);
 Example.Criteria criteria=example.createCriteria();
criteria.andLike("name","%"+searchMap.get("name")+"%");

retuen example;
}

7.分页

    @GetMapping("/page/{page}/{size}")
    public Result findPage(@PathVariable int page,@PathVariable int size ){
        Page<Brand> brandPage = brandService.findPage( page, size );
        PageResult pageResult=new PageResult( brandPage.getTotal(),brandPage.getResult()  );
        return new Result( true,StatusCode.OK,"查询成功",pageResult );
    }

    Page<Brand> findPage(int page, int size);


    @Override
    public Page<Brand> findPage(int page, int size) {
        PageHelper.startPage( page,size );
        return (Page<Brand>)brandMapper.selectAll();
    }

8分页加条件

 /**
     * 条件+分页
     * @param searchMap 查询条件
     * @param page 页码
     * @param size 页大小
     * @return
     */
    @GetMapping("/search/{page}/{size}")
    public Result findPage(  @RequestParam Map<String,String> searchMap, @PathVariable int page,@PathVariable int size ){
        Page<Brand> brandPage = brandService.findPage(searchMap, page, size );
        PageResult pageResult=new PageResult( brandPage.getTotal(),brandPage.getResult()  );
        return new Result( true,StatusCode.OK,"查询成功",pageResult );
    }

  /**
     * 条件+分页
     * @param searchMap 查询条件
     * @param page 页码
     * @param size 页大小
     * @return
     */
    Page<Brand> findPage(Map<String, String> searchMap, int page, int size);


  @Override
    public Page<Brand> findPage(Map<String, String> searchMap, int page, int size) {
        PageHelper.startPage( page,size );
        Example example = createExample( searchMap );
        return (Page<Brand>)brandMapper.selectByExample( example );
    }