BOS项目及知识点总结 _02

组合条件分页查询

<script type="text/javascript">
              $(function(){
                  $("#searchBtn").click(function(){
//                    组装数据
                      var formData = $("#searchForm").serializeJSON(); 
                      //封装表单,   
                      **$("#grid").datagrid('load',formData);**
                  })
              })
            </script>

后端代码，dao层接口需要继承 JpaSpecificationExecutor

@Action("courierAction_findByPage")
    public void findByPage(){
//      条件查询
//      model.getCourierNum();//工号
//      model.getStandard().getName();  收派标准的名称
//      model.getType(); //类型
//      model.getCompany()  //公司

//      Specification  相当于 DetachedCriteria
        DetachedCriteria dc = DetachedCriteria.forClass(Courier.class);
        if(StringUtils.isNotBlank(model.getCourierNum())){
            dc.add(Restrictions.like("courierNum", model.getCourierNum()));
        }

        Specification<Courier>  specification = new Specification<Courier>() {
            @Override
            public Predicate toPredicate(Root<Courier> root, CriteriaQuery<?> query, CriteriaBuilder cb) {
//              root 查询对象的主体
//              cb  相当于 Restrictions
                //工号
                List<Predicate> list = new ArrayList<Predicate>();//把组装的条件对象先存放到这个集合中
                if(StringUtils.isNotBlank(model.getCourierNum())){
                    Predicate predicate1 = cb.like(root.get("courierNum").as(String.class), "%"+model.getCourierNum()+"%");
//                  return predicate;
                    list.add(predicate1);
                }
//              收派标准的名称
                if(model.getStandard()!=null&&StringUtils.isNotBlank(model.getStandard().getName())){
//                  需要关联收派标准对象 select * from Courier c inner join standard s 
                    Join<Object, Object> join = root.join("standard");   
                    Predicate predicate2 = cb.like(join.get("name").as(String.class), "%"+model.getStandard().getName()+"%");
//                  return predicate2;
                    list.add(predicate2);
                }
                //类型
                if(StringUtils.isNotBlank(model.getType())){
                    Predicate predicate3 = cb.like(root.get("type").as(String.class), "%"+model.getType()+"%");
//                  return predicate3;
                    list.add(predicate3);
                }
                //公司
                if(StringUtils.isNotBlank(model.getCompany())){
                    Predicate predicate4 = cb.like(root.get("company").as(String.class), "%"+model.getCompany()+"%");
//                  return predicate4;
                    list.add(predicate4);
                }
//              判断list的size是否为0，如果为0直接return null
                if(list.size()==0){
                    return null;
                }
//              list转成数组再转成Predicate对象
                Predicate[] predicates = new Predicate[list.size()];
                predicates = list.toArray(predicates);
                return cb.and(predicates);
            }
        };

        Pageable pageable = new  PageRequest(page-1, rows);
        Page page = service.findByPage(specification,pageable);
//      拼装datagrid分页时需要的数据格式
//      {"total":100,"rows":[{},{},{}]}
        Map<String,Object> map = new HashMap<String,Object>();
        map.put("total", page.getTotalElements());
        map.put("rows", page.getContent());
        JsonConfig jsonConfig = new JsonConfig();
//      设置在转json时排除的字段
        jsonConfig.setExcludes(new String[]{"fixedAreas"});
        String string = JSONObject.fromObject(map, jsonConfig).toString();
        HttpServletResponse response = ServletActionContext.getResponse();
        response.setContentType("application/json;charset=utf-8");
        try {
            response.getWriter().write(string);
        } catch (IOException e) {
            e.printStackTrace();
        }       
    }

一键上传

jQuery OCUpload一键上传插件
前端代码

 $("#button-import").upload({
                      action:'../../areaAction_importXls.action',
                      //名字要和后端属性name名一样
                      name:'myFile'
                  })

action层代码

private File myFile;
    public File getMyFile() {
        return myFile;
    }

    public void setMyFile(File myFile) {
        this.myFile = myFile;
    }
@Action("areaAction_importXls")
    public void importXls(){
        System.out.println(myFile);
    }

service层

@Override
    public void importXls(FileInputStream fileInputStream) {
//      1、获取workbook对象
        try {
        HSSFWorkbook book = new HSSFWorkbook(fileInputStream);
        HSSFSheet sheet = book.getSheetAt(0);
        int lastRowNum = sheet.getLastRowNum();
        Area area  = null;
        List<Area> list = new ArrayList<Area>();
        for (int i = 1; i <= lastRowNum; i++) {
          HSSFRow row = sheet.getRow(i);
          String id = row.getCell(0).getStringCellValue();
          String province = row.getCell(1).getStringCellValue();
          String city = row.getCell(2).getStringCellValue();
          String district = row.getCell(3).getStringCellValue();
          String postcode = row.getCell(4).getStringCellValue();
          area = new Area();
          area.setId(id);
          area.setProvince(province);
          area.setCity(city);
          area.setDistrict(district);
          area.setPostcode(postcode);

          province = province.substring(0, province.length()-1);
          city = city.substring(0, city.length()-1);
          district = district.substring(0, district.length()-1);
          //          城市编码
          String citycode = PinYin4jUtils.hanziToPinyin(city,"");
          area.setCitycode(citycode);
            //          简码
          String[] headByString = PinYin4jUtils.getHeadByString(province+city+district);
          String shortcode = StringUtils.join(headByString);
          area.setShortcode(shortcode);
             list.add(area);
        }
        dao.save(list);
        } 
        catch (IOException e) {
            e.printStackTrace();
        }
    }