解析XML文件字段取值

最新推荐文章于 2023-08-23 14:25:30 发布

Mu Cen

最新推荐文章于 2023-08-23 14:25:30 发布

阅读量1.5k

点赞数

分类专栏： sql java

本文链接：https://blog.csdn.net/hahezhen/article/details/101702529

版权

java 同时被 2 个专栏收录

13 篇文章 0 订阅

订阅专栏

sql

3 篇文章 0 订阅

订阅专栏

@OptLogger(type = OptType.SELECT, module = OptModule.E, desc = "查询BOM数据")
@RequestMapping("/selectByOptimizeFormStream")
@ResponseBody
public List selectByOptimizeFormStream(HttpServletRequest request,HttpServletResponse response) throws DocumentException {
    List<CustomOptimizeBOMInventory> selectAllList = new ArrayList<>();
    Gather gather = new Gather();
    if (allListGather.size() > 0) {
        for (int i = 0; i < allListGather.size(); i++) {
            gather = customElectronicSawMapper.getOptimizeProcedure(allListGather.get(i).getGatherCode());
            //以流的形式读取文件
            byte[] buffer = null;
            if (gather != null) {
                CustomOptimizeBOMInventory customOptimizeBOMInventory = new  CustomOptimizeBOMInventory();
                //获取到的BLOB文件
                buffer = gather.getOptimizeProcedure();
                String tCut = "";
                String qUsed = "";
                try {
                    Document doc = (Document) DocumentHelper.parseText(new String(buffer));
                    Element books = doc.getRootElement();
                    System.out.println("根节点" + books.getName());
                    //在根节点下找子节点
                    Element solution = books.element("Solution");
                    //找到子节点中的属性值
                    tCut = solution.attributeValue("TCut");
                    //System.out.println("tCut为:" + tCut);
                    //获取子节点下的子节点
                    Element solution2 = solution.element("BrdInfo");
                    //找到子节点中的属性值
                    qUsed = solution2.attributeValue("QUsed");
                    //System.out.println("qUsed为：" + qUsed);
                } catch (DocumentException e) {
                    e.printStackTrace();
                }
                //保存取得的数据返回前台
                customOptimizeBOMInventory.settCut(tCut);
                customOptimizeBOMInventory.setqUsed(qUsed);
                customOptimizeBOMInventory.setGatherCode(allListGather.get(i).getGatherCode());
                selectAllList.add(customOptimizeBOMInventory);
            }
        }
    }
    return selectAllList;
}

//jar包下载

dom4j
dom4j
1.6.1