Day21

1. 分页查询功能
   Controller:

 @Slf4j
@Controller
@RequestMapping(value = "/packingCode")
   public class PackingCodeController{
@Resource
private PackingCodeService packingCodeService;


 @RequestMapping(value = "/list")
    public ModelAndView list(HttpServletRequest request) {
        ModelAndView modelAndView = new ModelAndView();
        modelAndView.setViewName("packing-code/list");
        return modelAndView;



   @RequestMapping("/findpackingCodeList")
    @ResponseBody
    public PageResult findpackingCodeList(int pageNo, int pageSize, PackingCodeDto packingCodeDto){
        PageResult result = new PageResult();
         try {
            StringUtil.checkIllegalCharacter(packingCodeDto);//处理特殊字符
        } catch (InstantiationException e) {  //实例化异常
            e.printStackTrace();   //堆栈跟踪，异常时显示更深调用信息
        } catch (IllegalAccessException e) {//安全权限异常
            e.printStackTrace();
        }
        try {
            StringUtil.checkIllegalCharacter(packingCodeDto);
            Page< PackingCodeDto> page=packingCodeService.findpackingCodeList(pageNo,pageSize,packingCodeDto);
            result.setMsg(Vm.SUCCESS);
            result.setRows(page.getRecords());
            result.setTotal(page.getTotal());
        }catch (Exception e){
            result.setMsg(Vm.FAIL);
            log.error("查询....失败"+e.getMessage(),e);
            return result;
        }
        return result;
    }
}

Service

public interface PackingCodeService {
    Page<PackingCodeDto> findPackingCodeList(int pageNo, int pageSize, PackingCodeDto packingCodeDto);
    }

ServiceImpl

@Transactional
@Service
public class PackingCodeServiceImpl implements PackingCodeService {
@Resource
    private PackingCodeDao packingCodeDao;
    @Override
    public Page<PackingCodeDto> findPackingCodeList(int pageNo, int pageSize, PackingCodeDto packingCodeDto) {
        Page<PackingCodeDto> page = new Page<>(pageNo,pageSize);
        List<PackingCodeDto> list = packingCodeDao.findYyy(packingCodeDto,page);
        page.setRecords(list);
        return page;
    }
}

Dao

 List<PackingCodeDto> findPackingCodeList(PackingCodeDto packingCodeDto,@Param("page") Page<PackingCodeDto> page);

2. 通过id删除分页中的一个数据(Mybaits plus自带deleteById，所以无需写Dao)

Controller

@Slf4j
@Controller
@RequestMapping(value = "/packingCode")
public class PackingCodeController{
 @Resource
    private PackingCodeService packingCodeService;

 @RequestMapping(value = "/list")
    public ModelAndView list(HttpServletRequest request) {
        ModelAndView modelAndView = new ModelAndView();
        modelAndView.setViewName("packing-code/list");
        return modelAndView;

@RequestMapping("/deleteById")
    public ObjectResult deleteById(String idsListStr, HttpSession session) {
        ObjectResult result = new ObjectResult();
        User user = WebUtils.getUserBySession(session);
        if (null == user) {
            result.setMsg(Vm.USER_NOT_LOGIN);
            result.setFlag(false);
            return result;
        }
        try {
            if (StringUtils.isBlank(idsListStr)) {
                result.setMsg(Vm.DELETE_FAIL);
                return result;
            }
            packingCodeService.deleteById(idsListStr);
            result.setMsg(Vm.DELETE_SUCCESS);
            result.setFlag(true);
        } catch (Exception e) {
            String emsg = e.getMessage();
            if (emsg.contains(Vm.MSG_EXCEPTION)) {
                if (StringUtils.isNotBlank(emsg)) {
                    String[] msgs = emsg.split(",");
                    result.setMsg(msgs[0]);
                }
            } else {
                result.setMsg(Vm.DELETE_FAIL);
            }
            log.error("包装码删除失败" + e.getMessage(), e);
            result.setFlag(false);
            return result;
        }
        return result;
    }
}}

Service

public interface PackingCodeService{
void deleteById(String idsListStr);
```}

ServiceImpl

@Transactional
@Service
public class PackingCodeServiceImpl implements PackingCodeService{
@Resource
    private PackingCodeDao packingCodeDao;
     @Override
    public void deleteById(String idsListStr) {
        String[] ids = idsListStr.split(",");
        for (String id : ids) {
//判断字符串是否为空
            if (StringUtils.isNotBlank(id)) {
                PackingCode packingCode = packingCodeDao.selectById(id);
                if (null == packingCode) {
                    throw new MsgException(Vm.PACKING_CODE_DOSE_NOT_EXIST + ";" + Vm.MSG_EXCEPTION);
                }
//删除
                packingCodeDao.deleteById(id);
            }
        }
    }
}