formData-JSon，java解析Excle，获取父类泛型，spring整合jpa实现条件分页查询

• 本文为原创：欢迎转载学习。

  1 . java生成Excel分析：（可以参考官网）

创建HSSFWorkbook
创建HSSFSheet
创建Row
获取row填充数据：row.getCell(0).getStringCellValue()

@Action(value="uploadAreaInfo")    public String uploadAreaInfo() throws Exception{        List<Area> list = new ArrayList<Area>();        //利用poi的hssp格式解析        // 加载excel对象        HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(file));        //读取工作蒲第一个sheet        HSSFSheet sheet = wb.getSheetAt(0);        //读取工作蒲中的每一行的数据        for (Row row : sheet) {            //一行数据对应一个对象            if (row.getRowNum()==0) {                //跳过第一行                continue;            }            if (row.getCell(0)==null                     ||StringUtils.isBlank( row.getCell(0).getStringCellValue())) {                //跳过空行                continue;            }            //将每一行的数据            Area area = new  Area();            area.setId(row.getCell(0).getStringCellValue());            area.setProvince(row.getCell(1).getStringCellValue());            area.setCity(row.getCell(2).getStringCellValue());            area.setDistrict(row.getCell(3).getStringCellValue());            area.setPostcode(row.getCell(4).getStringCellValue());            list.add(area);        }        //调用业务层保存        areaService.save(list);        return NONE;    }

• POI官网的链接地址：http://poi.apache.org/

  2 . 将表单的数据转换成json格式数据

$.fn.serializeJson = function() {    var serializeObj = {};    var array = this.serializeArray();    var str = this.serialize();    $(array).each(function() {        if(serializeObj[this.name]) {            if($.isArray(serializeObj[this.name])) {                serializeObj[this.name].push(this.value);            } else {                serializeObj[this.name] = [serializeObj[this.name], this.value];            }        } else {            serializeObj[this.name] = this.value;        }    });    return serializeObj;}

3.获取父类的泛型

        //动态获取当前类的父类的对象        Type type = this.getClass().getGenericSuperclass();                 ParameterizedType parameterizedType = (ParameterizedType) type;        //获取第一个泛型参数        Class<T> modelClass = (Class<T>)parameterizedType.getActualTypeArguments()[0];        try {            model = modelClass.newInstance();        } catch (Exception e) {            e.printStackTrace();        } 

4 . jquery easyUi的分页查询数据

//分页的数据    private Integer page;    private Integer rows;    public void setPage(Integer page) {        this.page = page;    }    public void setRows(Integer rows) {        this.rows = rows;    }    public Integer getPage() {        return page;    }    public Integer getRows() {        return rows;    }    protected <T> void pushPageInfo(Page<T> result){        Map<String,Object> map = new HashMap<>();        map.put("total", result.getTotalElements());        map.put("rows", result.getContent());        ActionContext.getContext().getValueStack().push(map);    }

5 . Spring整合jpa实现分页查询和条件查询代码截取

    //查询数据并分页显示    @Action(value="findAllArea",results = {@Result(name="success",type="json")})    public String findAllArea(){        //分页数据封装        Pageable pageable = new  PageRequest(page-1, rows);        //tiao条件封装        Specification<Area> specification = new Specification<Area>() {    @Override    public Predicate toPredicate(Root<Area> root, CriteriaQuery<?> query, CriteriaBuilder cb) {        System.out.println(root);        System.out.println(query);        System.out.println(cb);        //添加查询条件         List<Predicate> list = new ArrayList<>();        if (StringUtils.isNotBlank(area.getProvince())) {            Predicate p1 = cb.like(root.get("province")                        .as(String.class), area.getProvince()+"%");            System.out.println(root.get("province").as(String.class));        System.out.println(area.getProvince());            list.add(p1);                }        if (StringUtils.isNotBlank(area.getCity())) {            Predicate p2 = cb.like(root.get("city")                            .as(String.class), area.getCity()+"%");                    list.add(p2);                }        if (StringUtils.isNotBlank(area.getDistrict())) {            Predicate p3 = cb.like(root.get("district")                            .as(String.class), area.getDistrict()+"%");                    list.add(p3);                }                return cb.and(list.toArray(new Predicate[0]));            }        };        Page<Area> result =areaService.findAllAreaInfo(pageable,specification);        Map<String,Object> map = new HashMap<>();        map.put("total", result.getTotalElements());        map.put("rows", result.getContent());        ActionContext.getContext().getValueStack().push(map);        return SUCCESS;    }