Java基础 – XML解析转成Bean以及Bean转成XML（附带案例）

1. JAXB – Java Architecturefor XML Binding – 面向XML绑定的Java体系结构

1.1 注解

// 1. 需要解析什么访问权限的javaBean字段 == 如果是私有字段，类上必须加上此注解
@XmlAccessorType(XmlAccessType.FIELD) 

// 2. 使用什么标签名包裹该类的全部属性
@XmlRootElement(name="student") 

// 3. 该类的属性字段的值需要什么标签进行包裹
@XmlElement(name="name",required = true)

// 4. 属性字段是容器对象如Collection，需要什么标签包裹该字段遍历的元素
@XmlElementWrapper(name = "students")
@XmlElement(name="name")  // 遍历的每个JavaBean的属性值由该 定义的标签进行包裹

// 5. 可以迭代容器字段
@XmlAnyElement

// 4. 定义属性字段序列化、反序列化的顺序
@XmlType(propOrder = {"id", "name"})

//在XmlRootElement根这个节点添加属性
@XmlAttribute(name = "xx", required = true)

1.2 使用

Student.java

@Data
@NoArgsConstructor
@AllArgsConstructor
@XmlAccessorType(XmlAccessType.FIELD)   //定义xml序列化的字段类型
@XmlRootElement(name="student")    //定义xml中跟属性
public class Student {
    
    //xml属性映射
    @XmlElement(name="name",required = true)
    private String name;

    @XmlElement(name="year",required = true)
    private Integer year;

}

student.xml

<?xml version="1.0"?>
<student>
    <name>lrc</name>
    <year>22</year>
</student>

测试1 – 反序列化xml文件成JavaBean对象

    @Test
    public void test1() throws Exception {
        Class clazz = Student.class;

        //实参中包含需要解析的类
        JAXBContext jaxbContext = JAXBContext.newInstance(clazz);

        //xml文件解析成JavaBean对象器
        Unmarshaller unmarshaller = jaxbContext.createUnmarshaller();

        //序列化
        File file = new File("C:\\Users\\Administrator\\Desktop\\student.xml");
        Object student = unmarshaller.unmarshal(file);


        System.out.println(student);
        System.out.println(student.getClass().getName());
    }

测试2 – 序列化普通JavaBean对象

	@Test
    public void test2() throws JAXBException {

        Class clazz = Student.class;

        //实参中包含需要解析的类
        JAXBContext jaxbContext = JAXBContext.newInstance(clazz);

        //javaBean序列化xml文件器
        Marshaller marshaller = jaxbContext.createMarshaller();
        //是否格式化xml文件
        marshaller.setProperty(Marshaller.JAXB_FORMATTED_OUTPUT,true);
        
        //序列化
        Student student = new Student("lcj", 25);
        marshaller.marshal(student, new File("C:\\Users\\Administrator\\Desktop\\student2.xml"));

    }

测试3 – 序列化JavaBean对象字段中含有容器Collection -> xml字符串

Student.java

@Data
@NoArgsConstructor
@AllArgsConstructor
@EqualsAndHashCode(callSuper = true)
@ToString(callSuper = true)
@XmlAccessorType(XmlAccessType.FIELD)
@XmlRootElement(name="studentxx")
public class Student extends BaseDomain implements Play{

    @XmlElement(name="name",required = true)
    private String name;

    @XmlElement(name="year",required = true)
    private Integer year;

    @Override
    public void play() {
        System.out.println(name + "：正在玩游戏");
    }
}

Teacher.java

@Data
@NoArgsConstructor
@AllArgsConstructor
@XmlRootElement(name = "teacher")
@XmlAccessorType(XmlAccessType.FIELD)
public class Teacher {

    @XmlElement(name = "teacherName")
    String name;

    @XmlElement(name = "teacherSubject")
    String subject;

    @XmlElementWrapper(name = "students") //将该字段的内容写在<students>节点里面
    @XmlElement(name = "student")  //指定每个Student对象的父标签，并且Student的@XmlRootElement属性失效
    List<Student> students;

}

 
测试JavaBean中含有容器字段

    @Test
    public void test6() throws JAXBException {
        //1. 序列化的对象
        List<Student> students = new ArrayList<>();
        students.add(new Student("lrc", 20));
        students.add(new Student("lcj", 25));
        Teacher teacher = new Teacher("昌老师", "数学", students);

        JAXBContext jaxbContext = JAXBContext.newInstance(Teacher.class);

        // 2. xml序列化器
        Marshaller marshaller = jaxbContext.createMarshaller();
        //序列化后的xml是否需要格式化输出
        marshaller.setProperty(Marshaller.JAXB_FORMATTED_OUTPUT, true);
        //取消这个标签的显示<?xml version="1.0" encoding="utf-8" standalone="yes"?>
        marshaller.setProperty(Marshaller.JAXB_FRAGMENT,true);
        //编码格式
        marshaller.setProperty(Marshaller.JAXB_ENCODING,"utf-8");

        // 3. 序列化
        StringWriter sw = new StringWriter();
        marshaller.marshal(teacher, sw);

        //4.打印
        System.out.println(sw.toString());

    }

测试4 – 序列化容器对象

   @Test
    public void test7() throws JAXBException {

        //必须使用包装类 - 否则输出不了任何东西
        List<Student> students = new ArrayList<>();
        students.add(new Student("lrc", 20));
        students.add(new Student("lcj", 25));


        QName tagName = new QName("myStudents");
        JAXBElement<ListWrapper> jaxbElement = new JAXBElement<>(tagName, ListWrapper.class, new ListWrapper(students));
        
        //生成xml上下文 - 定义解析的类型
        JAXBContext jaxbContext = JAXBContext.newInstance(Student.class, ListWrapper.class);

        // 2. xml序列化器
        Marshaller marshaller = jaxbContext.createMarshaller();
        marshaller.setProperty(Marshaller.JAXB_FORMATTED_OUTPUT, true);

        // 3. 序列化
        StringWriter sw = new StringWriter();
        marshaller.marshal(jaxbElement, sw);

        //4.打印
        System.out.println(sw.toString());

    }
    //内部类必须是静态 - list包装类
    @AllArgsConstructor
    static class  ListWrapper {
        @XmlAnyElement  //必须使用这个注解 - 可以迭代容器元素 - 可以生效Student的@XmlRootElement(name="studentxx")注解
        //@XmlElement(name = "student") - 上面的注解可以替换成这个 - 取代了Student的@XmlRootElement(name="studentxx")注解
        List<Student> students;
    }

测试5 – 复杂报文解析

参考文章：https://blog.csdn.net/wn084/article/details/80853587

//@XmlAccessorType(XmlAccessType.FIELD)
如果你得字段是private类型且将@XmlElement放在属性上面，则必须在类上添加这个注解

 
RowCrmResult.java

@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
@Accessors(chain = true)
@XmlAccessorType(XmlAccessType.FIELD) //定义xml序列化的字段类型
@XmlRootElement(name = "outputdatas")
public class RowCrmResult {
    
    /**
     * 结果里面的状态码
     */
    @XmlElement(name = "resultcode", nillable = true)
    public String resultcode;

    /**
     * 结果里面的失败原因
     */
    @XmlElement(name = "reason", nillable = true)
    public String reason;


    @XmlElementWrapper(name = "results")
    @XmlElement(name = "result", nillable = true)
    public List<Result> results;


    @Data
    @NoArgsConstructor
    @AllArgsConstructor
    @Builder
    @Accessors(chain = true)
    @XmlAccessorType(XmlAccessType.FIELD)
    @XmlRootElement(name = "result")
    public static class Result {

        @XmlAttribute(name = "set_id")
        private String setId;

        @XmlAttribute(name = "rows")
        private Integer rowNum;

        @XmlAttribute(name = "cols")
        private Integer colNum;

        @XmlElement(name = "row", nillable = true)
        private List<Row> rows;
        
    }

    @Data
    @NoArgsConstructor
    @AllArgsConstructor
    @Builder
    @Accessors(chain = true)
    @XmlRootElement
    @XmlAccessorType(XmlAccessType.FIELD)
    public static class Row {

        @XmlAttribute(name = "rownum")
        private Integer rownum;
        
        @XmlElement(name = "col", nillable = true)
        private List<Col> cols;
        
    }

    @Data
    @NoArgsConstructor
    @AllArgsConstructor
    @Builder
    @Accessors(chain = true)
    @XmlAccessorType(XmlAccessType.FIELD)
    @XmlRootElement
    public static class Col {

        @XmlAttribute(name = "colnum")
        private String colnum;
        
        @XmlAttribute(name = "param_id")
        private String paramId;

        @XmlAttribute(name = "param_name")
        private String paramName;

        @XmlValue
        private String content;
        
    }
    
    
}

开始解析
Test.java

    /**
     * 格式化响应内容 == 去除其他没用的字符，并格式化XML
     *    使用的是hutool工具包
     * @param content
     * @return
     */
    public static String formatResponseContent(String content) {
        content = StrUtil.replace(content, "<![CDATA[", "");
        content = StrUtil.replace(content, "]]>", "");
        content = StrUtil.subBetween(content, "<osb:recvData xmlns:osb=\"mboss-esb/osb\">", "</osb:recvData>");
        content= StrUtil.replace(content,"\\", "");
        content = XmlUtil.format(content);
        return content;
    }    

    @SneakyThrows
    public static void main(String[] args) {
        String content = "XML内容 == 即下面的【解析前的XML】";
        
        content = formatResponseContent(content);
        System.out.println(content);


        JAXBContext jaxbContext = JAXBContext.newInstance(RowCrmResult.class);



        //xml文件解析成JavaBean对象器
        Unmarshaller unmarshaller = jaxbContext.createUnmarshaller();


        RowCrmResult rowCrmResult = (RowCrmResult) unmarshaller.unmarshal(new ByteArrayInputStream(content.getBytes()));

        System.out.println(rowCrmResult);
    }

 
 
解析前的XML

<?xml version="1.0" encoding="utf-8"?>
<mbos:callResponse xmlns:mbos="mboss-esb">
    <osb:recvData xmlns:osb="mboss-esb/osb">
        <outputdatas>
            <resultcode>0</resultcode>
            <reason>OK</reason>
            <results sets="2">
                <result rows="5" cols="28" set_id="201">
                    <row rownum="1">
                        <col colnum="1" param_id="2157001" param_name="申请单标识">3000010101960</col>
                        <col colnum="2" param_id="2157002" param_name="申请单编码">HZ20210912950057232</col>
                        <col colnum="3" param_id="2157003" param_name="申请单状态">200000</col>
                        <col colnum="4" param_id="2157004" param_name="订单标识">3500018696696</col>
                        <col colnum="5" param_id="2157005" param_name="订单编码">752210912410694015</col>
                        <col colnum="6" param_id="2157006" param_name="订单状态">201300</col>
                        <col colnum="7" param_id="2157007" param_name="订单状态说明">开通中</col>
                        <col colnum="8" param_id="2157008" param_name="状态原因">1000</col>
                        <col colnum="9" param_id="2157009" param_name="订单类型">000</col>
                        <col colnum="10" param_id="2157010" param_name="受理工号">90000000671</col>
                        <col colnum="11" param_id="2157011" param_name="受理时间">20210912093601</col>
                        <col colnum="12" param_id="2157012" param_name="受理机构">752000000</col>
                        <col colnum="13" param_id="2157013" param_name="受理工位">752</col>
                        <col colnum="14" param_id="2157014" param_name="套餐名称" />
                        <col colnum="15" param_id="2157015" param_name="服务标识">3500005312442</col>
                        <col colnum="16" param_id="2157016" param_name="业务号码">CZCZKD2294432695</col>
                        <col colnum="17" param_id="2157017" param_name="产品标识">2340</col>
                        <col colnum="18" param_id="2157018" param_name="产品名称">快捷宽带</col>
                        <col colnum="19" param_id="2157019" param_name="状态时间">未竣工</col>
                        <col colnum="20" param_id="2157020" param_name="业务编码">CZCZKD_001</col>
                        <col colnum="21" param_id="2157021" param_name="业务名称">快捷宽带订购</col>
                        <col colnum="22" param_id="2157022" param_name="客户名称">何志聪</col>
                        <col colnum="23" param_id="2157023" param_name="称受理工号名称">【ESB】广东电信统一通信平台</col>
                        <col colnum="24" param_id="2157024" param_name="受理工位名称">惠州本地一级管理工位</col>
                        <col colnum="25" param_id="2157025" param_name="受理机构名称">惠州分公司</col>
                        <col colnum="26" param_id="2157026" param_name="订单来源">600101_ESBWSYYT</col>
                        <col colnum="27" param_id="2157027" param_name="套餐编码" />
                        <col colnum="28" param_id="2157028" param_name="来源系统">网厅ESB来源订单</col>
                    </row>
                    <row rownum="2">
                        <col colnum="1" param_id="2157001" param_name="申请单标识">3000010101960</col>
                        <col colnum="2" param_id="2157002" param_name="申请单编码">HZ20210912950057232</col>
                        <col colnum="3" param_id="2157003" param_name="申请单状态">200000</col>
                        <col colnum="4" param_id="2157004" param_name="订单标识">3500018696706</col>
                        <col colnum="5" param_id="2157005" param_name="订单编码">752210912410694016</col>
                        <col colnum="6" param_id="2157006" param_name="订单状态">201300</col>
                        <col colnum="7" param_id="2157007" param_name="订单状态说明">开通中</col>
                        <col colnum="8" param_id="2157008" param_name="状态原因">1000</col>
                        <col colnum="9" param_id="2157009" param_name="订单类型">002</col>
                        <col colnum="10" param_id="2157010" param_name="受理工号">90000000671</col>
                        <col colnum="11" param_id="2157011" param_name="受理时间">20210912093604</col>
                        <col colnum="12" param_id="2157012" param_name="受理机构">752000000</col>
                        <col colnum="13" param_id="2157013" param_name="受理工位">752</col>
                        <col colnum="14" param_id="2157014" param_name="套餐名称">快捷宽带套餐（50元）50M</col>
                        <col colnum="15" param_id="2157015" param_name="服务标识" />
                        <col colnum="16" param_id="2157016" param_name="业务号码" />
                        <col colnum="17" param_id="2157017" param_name="产品标识">500046219</col>
                        <col colnum="18" param_id="2157018" param_name="产品名称" />
                        <col colnum="19" param_id="2157019" param_name="状态时间">未竣工</col>
                        <col colnum="20" param_id="2157020" param_name="业务编码">YH001</col>
                        <col colnum="21" param_id="2157021" param_name="业务名称">销售品订购(快捷宽带套餐（50元）50M)</col>
                        <col colnum="22" param_id="2157022" param_name="客户名称">何志聪</col>
                        <col colnum="23" param_id="2157023" param_name="称受理工号名称">【ESB】广东电信统一通信平台</col>
                        <col colnum="24" param_id="2157024" param_name="受理工位名称">惠州本地一级管理工位</col>
                        <col colnum="25" param_id="2157025" param_name="受理机构名称">惠州分公司</col>
                        <col colnum="26" param_id="2157026" param_name="订单来源">600101_ESBWSYYT</col>
                        <col colnum="27" param_id="2157027" param_name="套餐编码">DM0001-677-1-1</col>
                        <col colnum="28" param_id="2157028" param_name="来源系统">网厅ESB来源订单</col>
                    </row>
                    <row rownum="3">
                        <col colnum="1" param_id="2157001" param_name="申请单标识">3000010101960</col>
                        <col colnum="2" param_id="2157002" param_name="申请单编码">HZ20210912950057232</col>
                        <col colnum="3" param_id="2157003" param_name="申请单状态">200000</col>
                        <col colnum="4" param_id="2157004" param_name="订单标识">3500018696707</col>
                        <col colnum="5" param_id="2157005" param_name="订单编码">752210912410694017</col>
                        <col colnum="6" param_id="2157006" param_name="订单状态">201300</col>
                        <col colnum="7" param_id="2157007" param_name="订单状态说明">开通中</col>
                        <col colnum="8" param_id="2157008" param_name="状态原因">1000</col>
                        <col colnum="9" param_id="2157009" param_name="订单类型">000</col>
                        <col colnum="10" param_id="2157010" param_name="受理工号">90000000671</col>
                        <col colnum="11" param_id="2157011" param_name="受理时间">20210912093607</col>
                        <col colnum="12" param_id="2157012" param_name="受理机构">752000000</col>
                        <col colnum="13" param_id="2157013" param_name="受理工位">752</col>
                        <col colnum="14" param_id="2157014" param_name="套餐名称" />
                        <col colnum="15" param_id="2157015" param_name="服务标识">3500005312442</col>
                        <col colnum="16" param_id="2157016" param_name="业务号码">CZCZKD2294432695</col>
                        <col colnum="17" param_id="2157017" param_name="产品标识">2340</col>
                        <col colnum="18" param_id="2157018" param_name="产品名称">快捷宽带</col>
                        <col colnum="19" param_id="2157019" param_name="状态时间">未竣工</col>
                        <col colnum="20" param_id="2157020" param_name="业务编码">CZCZKD_011</col>
                        <col colnum="21" param_id="2157021" param_name="业务名称">快捷宽带变更(改速率)</col>
                        <col colnum="22" param_id="2157022" param_name="客户名称">何志聪</col>
                        <col colnum="23" param_id="2157023" param_name="称受理工号名称">【ESB】广东电信统一通信平台</col>
                        <col colnum="24" param_id="2157024" param_name="受理工位名称">惠州本地一级管理工位</col>
                        <col colnum="25" param_id="2157025" param_name="受理机构名称">惠州分公司</col>
                        <col colnum="26" param_id="2157026" param_name="订单来源">ibssderv</col>
                        <col colnum="27" param_id="2157027" param_name="套餐编码" />
                        <col colnum="28" param_id="2157028" param_name="来源系统">CRM后台-派生订单</col>
                    </row>
                    <row rownum="4">
                        <col colnum="1" param_id="2157001" param_name="申请单标识">3000010101960</col>
                        <col colnum="2" param_id="2157002" param_name="申请单编码">HZ20210912950057232</col>
                        <col colnum="3" param_id="2157003" param_name="申请单状态">200000</col>
                        <col colnum="4" param_id="2157004" param_name="订单标识">3500018696708</col>
                        <col colnum="5" param_id="2157005" param_name="订单编码">752210912410694018</col>
                        <col colnum="6" param_id="2157006" param_name="订单状态">201300</col>
                        <col colnum="7" param_id="2157007" param_name="订单状态说明">开通中</col>
                        <col colnum="8" param_id="2157008" param_name="状态原因">1000</col>
                        <col colnum="9" param_id="2157009" param_name="订单类型">000</col>
                        <col colnum="10" param_id="2157010" param_name="受理工号">90000000671</col>
                        <col colnum="11" param_id="2157011" param_name="受理时间">20210912093609</col>
                        <col colnum="12" param_id="2157012" param_name="受理机构">752000000</col>
                        <col colnum="13" param_id="2157013" param_name="受理工位">752</col>
                        <col colnum="14" param_id="2157014" param_name="套餐名称" />
                        <col colnum="15" param_id="2157015" param_name="服务标识">3500005312442</col>
                        <col colnum="16" param_id="2157016" param_name="业务号码">CZCZKD2294432695</col>
                        <col colnum="17" param_id="2157017" param_name="产品标识">2340</col>
                        <col colnum="18" param_id="2157018" param_name="产品名称">快捷宽带</col>
                        <col colnum="19" param_id="2157019" param_name="状态时间">未竣工</col>
                        <col colnum="20" param_id="2157020" param_name="业务编码">CZCZKD_021</col>
                        <col colnum="21" param_id="2157021" param_name="业务名称">快捷宽带变更(改专网)</col>
                        <col colnum="22" param_id="2157022" param_name="客户名称">何志聪</col>
                        <col colnum="23" param_id="2157023" param_name="称受理工号名称">【ESB】广东电信统一通信平台</col>
                        <col colnum="24" param_id="2157024" param_name="受理工位名称">惠州本地一级管理工位</col>
                        <col colnum="25" param_id="2157025" param_name="受理机构名称">惠州分公司</col>
                        <col colnum="26" param_id="2157026" param_name="订单来源">ibssderv</col>
                        <col colnum="27" param_id="2157027" param_name="套餐编码" />
                        <col colnum="28" param_id="2157028" param_name="来源系统">CRM后台-派生订单</col>
                    </row>
                    <row rownum="5">
                        <col colnum="1" param_id="2157001" param_name="申请单标识">3000010101443</col>
                        <col colnum="2" param_id="2157002" param_name="申请单编码">HZ20210911950057192</col>
                        <col colnum="3" param_id="2157003" param_name="申请单状态">301200</col>
                        <col colnum="4" param_id="2157004" param_name="订单标识">3500018695761</col>
                        <col colnum="5" param_id="2157005" param_name="订单编码">752210911410693935</col>
                        <col colnum="6" param_id="2157006" param_name="订单状态">301200</col>
                        <col colnum="7" param_id="2157007" param_name="订单状态说明">完工</col>
                        <col colnum="8" param_id="2157008" param_name="状态原因">1000</col>
                        <col colnum="9" param_id="2157009" param_name="订单类型">000</col>
                        <col colnum="10" param_id="2157010" param_name="受理工号">90000000671</col>
                        <col colnum="11" param_id="2157011" param_name="受理时间">20210911160332</col>
                        <col colnum="12" param_id="2157012" param_name="受理机构">1</col>
                        <col colnum="13" param_id="2157013" param_name="受理工位">200</col>
                        <col colnum="14" param_id="2157014" param_name="套餐名称" />
                        <col colnum="15" param_id="2157015" param_name="服务标识" />
                        <col colnum="16" param_id="2157016" param_name="业务号码" />
                        <col colnum="17" param_id="2157017" param_name="产品标识">0</col>
                        <col colnum="18" param_id="2157018" param_name="产品名称" />
                        <col colnum="19" param_id="2157019" param_name="状态时间">20210911160340</col>
                        <col colnum="20" param_id="2157020" param_name="业务编码">NEW_CUST</col>
                        <col colnum="21" param_id="2157021" param_name="业务名称">客户创建</col>
                        <col colnum="22" param_id="2157022" param_name="客户名称">何志聪</col>
                        <col colnum="23" param_id="2157023" param_name="称受理工号名称">【ESB】广东电信统一通信平台</col>
                        <col colnum="24" param_id="2157024" param_name="受理工位名称">广州本地一级管理工位</col>
                        <col colnum="25" param_id="2157025" param_name="受理机构名称">广东公司</col>
                        <col colnum="26" param_id="2157026" param_name="订单来源">600101_ESBGDUC</col>
                        <col colnum="27" param_id="2157027" param_name="套餐编码" />
                        <col colnum="28" param_id="2157028" param_name="来源系统">广东电信统一通信平台来源订单</col>
                    </row>
                </result>
                <result rows="4" cols="4" set_id="202">
                    <row rownum="1">
                        <col colnum="1" param_id="2157041" param_name="申请单标识">3000010101960</col>
                        <col colnum="2" param_id="2157042" param_name="主订单标识">3500018696706</col>
                        <col colnum="3" param_id="2157043" param_name="从订单标识">3500018696707</col>
                        <col colnum="4" param_id="2157044" param_name="依赖关系">1100</col>
                    </row>
                    <row rownum="2">
                        <col colnum="1" param_id="2157041" param_name="申请单标识">3000010101960</col>
                        <col colnum="2" param_id="2157042" param_name="主订单标识">3500018696696</col>
                        <col colnum="3" param_id="2157043" param_name="从订单标识">3500018696707</col>
                        <col colnum="4" param_id="2157044" param_name="依赖关系">1100</col>
                    </row>
                    <row rownum="3">
                        <col colnum="1" param_id="2157041" param_name="申请单标识">3000010101960</col>
                        <col colnum="2" param_id="2157042" param_name="主订单标识">3500018696706</col>
                        <col colnum="3" param_id="2157043" param_name="从订单标识">3500018696708</col>
                        <col colnum="4" param_id="2157044" param_name="依赖关系">1100</col>
                    </row>
                    <row rownum="4">
                        <col colnum="1" param_id="2157041" param_name="申请单标识">3000010101960</col>
                        <col colnum="2" param_id="2157042" param_name="主订单标识">3500018696707</col>
                        <col colnum="3" param_id="2157043" param_name="从订单标识">3500018696708</col>
                        <col colnum="4" param_id="2157044" param_name="依赖关系">1100</col>
                    </row>
                </result>
            </results>
        </outputdatas>
    </osb:recvData>
</mbos:callResponse>

解析后的内容

RowCrmResult
resultcode=0, 

reason=OK, 

results=[

	RowCrmResult.Result(setId=201, rowNum=5, colNum=28, rows=[
		RowCrmResult.Row(rownum=1, cols=[
			RowCrmResult.Col(colnum=1, paramId=2157001, paramName=申请单标识, content=3000010101960), 
			RowCrmResult.Col(colnum=2, paramId=2157002, paramName=申请单编码, content=HZ20210912950057232), 
			RowCrmResult.Col(colnum=3, paramId=2157003, paramName=申请单状态, content=200000), RowCrmResult.Col(colnum=4, paramId=2157004, paramName=订单标识, content=3500018696696), RowCrmResult.Col(colnum=5, paramId=2157005, paramName=订单编码, content=752210912410694015), RowCrmResult.Col(colnum=6, paramId=2157006, paramName=订单状态, content=201300), RowCrmResult.Col(colnum=7, paramId=2157007, paramName=订单状态说明, content=开通中), RowCrmResult.Col(colnum=8, paramId=2157008, paramName=状态原因, content=1000), RowCrmResult.Col(colnum=9, paramId=2157009, paramName=订单类型, content=000), RowCrmResult.Col(colnum=10, paramId=2157010, paramName=受理工号, content=90000000671), RowCrmResult.Col(colnum=11, paramId=2157011, paramName=受理时间, content=20210912093601), RowCrmResult.Col(colnum=12, paramId=2157012, paramName=受理机构, content=752000000), RowCrmResult.Col(colnum=13, paramId=2157013, paramName=受理工位, content=752), RowCrmResult.Col(colnum=14, paramId=2157014, paramName=套餐名称, content=), RowCrmResult.Col(colnum=15, paramId=2157015, paramName=服务标识, content=3500005312442), RowCrmResult.Col(colnum=16, paramId=2157016, paramName=业务号码, content=CZCZKD2294432695), RowCrmResult.Col(colnum=17, paramId=2157017, paramName=产品标识, content=2340), RowCrmResult.Col(colnum=18, paramId=2157018, paramName=产品名称, content=快捷宽带), RowCrmResult.Col(colnum=19, paramId=2157019, paramName=状态时间, content=未竣工), RowCrmResult.Col(colnum=20, paramId=2157020, paramName=业务编码, content=CZCZKD_001), RowCrmResult.Col(colnum=21, paramId=2157021, paramName=业务名称, content=快捷宽带订购), RowCrmResult.Col(colnum=22, paramId=2157022, paramName=客户名称, content=何志聪), RowCrmResult.Col(colnum=23, paramId=2157023, paramName=称受理工号名称, content=【ESB】广东电信统一通信平台), RowCrmResult.Col(colnum=24, paramId=2157024, paramName=受理工位名称, content=惠州本地一级管理工位), RowCrmResult.Col(colnum=25, paramId=2157025, paramName=受理机构名称, content=惠州分公司), RowCrmResult.Col(colnum=26, paramId=2157026, paramName=订单来源, content=600101_ESBWSYYT), RowCrmResult.Col(colnum=27, paramId=2157027, paramName=套餐编码, content=), RowCrmResult.Col(colnum=28, paramId=2157028, paramName=来源系统, content=网厅ESB来源订单)]), 
		RowCrmResult.Row(rownum=2, cols=[
			RowCrmResult.Col(colnum=1, paramId=2157001, paramName=申请单标识, content=3000010101960), 
			RowCrmResult.Col(colnum=2, paramId=2157002, paramName=申请单编码, content=HZ20210912950057232), 
			RowCrmResult.Col(colnum=3, paramId=2157003, paramName=申请单状态, content=200000), 
			RowCrmResult.Col(colnum=4, paramId=2157004, paramName=订单标识, content=3500018696706), 
			RowCrmResult.Col(colnum=5, paramId=2157005, paramName=订单编码, content=752210912410694016), 
			RowCrmResult.Col(colnum=6, paramId=2157006, paramName=订单状态, content=201300), 
			RowCrmResult.Col(colnum=7, paramId=2157007, paramName=订单状态说明, content=开通中), 
			RowCrmResult.Col(colnum=8, paramId=2157008, paramName=状态原因, content=1000), 
			RowCrmResult.Col(colnum=9, paramId=2157009, paramName=订单类型, content=002), 
			RowCrmResult.Col(colnum=10, paramId=2157010, paramName=受理工号, content=90000000671), 
			RowCrmResult.Col(colnum=11, paramId=2157011, paramName=受理时间, content=20210912093604), 
			RowCrmResult.Col(colnum=12, paramId=2157012, paramName=受理机构, content=752000000), 
			RowCrmResult.Col(colnum=13, paramId=2157013, paramName=受理工位, content=752), 
			RowCrmResult.Col(colnum=14, paramId=2157014, paramName=套餐名称, content=快捷宽带套餐（50元）50M), 
			RowCrmResult.Col(colnum=15, paramId=2157015, paramName=服务标识, content=), 
			RowCrmResult.Col(colnum=16, paramId=2157016, paramName=业务号码, content=), 
			RowCrmResult.Col(colnum=17, paramId=2157017, paramName=产品标识, content=500046219), 
			RowCrmResult.Col(colnum=18, paramId=2157018, paramName=产品名称, content=), 
			RowCrmResult.Col(colnum=19, paramId=2157019, paramName=状态时间, content=未竣工), 
			RowCrmResult.Col(colnum=20, paramId=2157020, paramName=业务编码, content=YH001), 
			RowCrmResult.Col(colnum=21, paramId=2157021, paramName=业务名称, content=销售品订购(快捷宽带套餐（50元）50M)), 
			RowCrmResult.Col(colnum=22, paramId=2157022, paramName=客户名称, content=何志聪), 
			RowCrmResult.Col(colnum=23, paramId=2157023, paramName=称受理工号名称, content=【ESB】广东电信统一通信平台), 
			RowCrmResult.Col(colnum=24, paramId=2157024, paramName=受理工位名称, content=惠州本地一级管理工位), 
			RowCrmResult.Col(colnum=25, paramId=2157025, paramName=受理机构名称, content=惠州分公司), 
			RowCrmResult.Col(colnum=26, paramId=2157026, paramName=订单来源, content=600101_ESBWSYYT), 
			RowCrmResult.Col(colnum=27, paramId=2157027, paramName=套餐编码, content=DM0001-677-1-1), 
			RowCrmResult.Col(colnum=28, paramId=2157028, paramName=来源系统, content=网厅ESB来源订单)]), 
		RowCrmResult.Row(rownum=3, cols=[RowCrmResult.Col(colnum=1, paramId=2157001, paramName=申请单标识, content=3000010101960), RowCrmResult.Col(colnum=2, paramId=2157002, paramName=申请单编码, content=HZ20210912950057232), RowCrmResult.Col(colnum=3, paramId=2157003, paramName=申请单状态, content=200000), RowCrmResult.Col(colnum=4, paramId=2157004, paramName=订单标识, content=3500018696707), RowCrmResult.Col(colnum=5, paramId=2157005, paramName=订单编码, content=752210912410694017), RowCrmResult.Col(colnum=6, paramId=2157006, paramName=订单状态, content=201300), RowCrmResult.Col(colnum=7, paramId=2157007, paramName=订单状态说明, content=开通中), RowCrmResult.Col(colnum=8, paramId=2157008, paramName=状态原因, content=1000), RowCrmResult.Col(colnum=9, paramId=2157009, paramName=订单类型, content=000), RowCrmResult.Col(colnum=10, paramId=2157010, paramName=受理工号, content=90000000671), RowCrmResult.Col(colnum=11, paramId=2157011, paramName=受理时间, content=20210912093607), RowCrmResult.Col(colnum=12, paramId=2157012, paramName=受理机构, content=752000000), RowCrmResult.Col(colnum=13, paramId=2157013, paramName=受理工位, content=752), RowCrmResult.Col(colnum=14, paramId=2157014, paramName=套餐名称, content=), RowCrmResult.Col(colnum=15, paramId=2157015, paramName=服务标识, content=3500005312442), RowCrmResult.Col(colnum=16, paramId=2157016, paramName=业务号码, content=CZCZKD2294432695), RowCrmResult.Col(colnum=17, paramId=2157017, paramName=产品标识, content=2340), RowCrmResult.Col(colnum=18, paramId=2157018, paramName=产品名称, content=快捷宽带), RowCrmResult.Col(colnum=19, paramId=2157019, paramName=状态时间, content=未竣工), RowCrmResult.Col(colnum=20, paramId=2157020, paramName=业务编码, content=CZCZKD_011), RowCrmResult.Col(colnum=21, paramId=2157021, paramName=业务名称, content=快捷宽带变更(改速率)), RowCrmResult.Col(colnum=22, paramId=2157022, paramName=客户名称, content=何志聪), RowCrmResult.Col(colnum=23, paramId=2157023, paramName=称受理工号名称, content=【ESB】广东电信统一通信平台), RowCrmResult.Col(colnum=24, paramId=2157024, paramName=受理工位名称, content=惠州本地一级管理工位), RowCrmResult.Col(colnum=25, paramId=2157025, paramName=受理机构名称, content=惠州分公司), RowCrmResult.Col(colnum=26, paramId=2157026, paramName=订单来源, content=ibssderv), RowCrmResult.Col(colnum=27, paramId=2157027, paramName=套餐编码, content=), RowCrmResult.Col(colnum=28, paramId=2157028, paramName=来源系统, content=CRM后台-派生订单)]), 
		RowCrmResult.Row(rownum=4, cols=[RowCrmResult.Col(colnum=1, paramId=2157001, paramName=申请单标识, content=3000010101960), RowCrmResult.Col(colnum=2, paramId=2157002, paramName=申请单编码, content=HZ20210912950057232), RowCrmResult.Col(colnum=3, paramId=2157003, paramName=申请单状态, content=200000), RowCrmResult.Col(colnum=4, paramId=2157004, paramName=订单标识, content=3500018696708), RowCrmResult.Col(colnum=5, paramId=2157005, paramName=订单编码, content=752210912410694018), RowCrmResult.Col(colnum=6, paramId=2157006, paramName=订单状态, content=201300), RowCrmResult.Col(colnum=7, paramId=2157007, paramName=订单状态说明, content=开通中), RowCrmResult.Col(colnum=8, paramId=2157008, paramName=状态原因, content=1000), RowCrmResult.Col(colnum=9, paramId=2157009, paramName=订单类型, content=000), RowCrmResult.Col(colnum=10, paramId=2157010, paramName=受理工号, content=90000000671), RowCrmResult.Col(colnum=11, paramId=2157011, paramName=受理时间, content=20210912093609), RowCrmResult.Col(colnum=12, paramId=2157012, paramName=受理机构, content=752000000), RowCrmResult.Col(colnum=13, paramId=2157013, paramName=受理工位, content=752), RowCrmResult.Col(colnum=14, paramId=2157014, paramName=套餐名称, content=), RowCrmResult.Col(colnum=15, paramId=2157015, paramName=服务标识, content=3500005312442), RowCrmResult.Col(colnum=16, paramId=2157016, paramName=业务号码, content=CZCZKD2294432695), RowCrmResult.Col(colnum=17, paramId=2157017, paramName=产品标识, content=2340), RowCrmResult.Col(colnum=18, paramId=2157018, paramName=产品名称, content=快捷宽带), RowCrmResult.Col(colnum=19, paramId=2157019, paramName=状态时间, content=未竣工), RowCrmResult.Col(colnum=20, paramId=2157020, paramName=业务编码, content=CZCZKD_021), RowCrmResult.Col(colnum=21, paramId=2157021, paramName=业务名称, content=快捷宽带变更(改专网)), RowCrmResult.Col(colnum=22, paramId=2157022, paramName=客户名称, content=何志聪), RowCrmResult.Col(colnum=23, paramId=2157023, paramName=称受理工号名称, content=【ESB】广东电信统一通信平台), RowCrmResult.Col(colnum=24, paramId=2157024, paramName=受理工位名称, content=惠州本地一级管理工位), RowCrmResult.Col(colnum=25, paramId=2157025, paramName=受理机构名称, content=惠州分公司), RowCrmResult.Col(colnum=26, paramId=2157026, paramName=订单来源, content=ibssderv), RowCrmResult.Col(colnum=27, paramId=2157027, paramName=套餐编码, content=), RowCrmResult.Col(colnum=28, paramId=2157028, paramName=来源系统, content=CRM后台-派生订单)]), 
		RowCrmResult.Row(rownum=5, cols=[RowCrmResult.Col(colnum=1, paramId=2157001, paramName=申请单标识, content=3000010101443), RowCrmResult.Col(colnum=2, paramId=2157002, paramName=申请单编码, content=HZ20210911950057192), RowCrmResult.Col(colnum=3, paramId=2157003, paramName=申请单状态, content=301200), RowCrmResult.Col(colnum=4, paramId=2157004, paramName=订单标识, content=3500018695761), RowCrmResult.Col(colnum=5, paramId=2157005, paramName=订单编码, content=752210911410693935), RowCrmResult.Col(colnum=6, paramId=2157006, paramName=订单状态, content=301200), RowCrmResult.Col(colnum=7, paramId=2157007, paramName=订单状态说明, content=完工), RowCrmResult.Col(colnum=8, paramId=2157008, paramName=状态原因, content=1000), RowCrmResult.Col(colnum=9, paramId=2157009, paramName=订单类型, content=000), RowCrmResult.Col(colnum=10, paramId=2157010, paramName=受理工号, content=90000000671), RowCrmResult.Col(colnum=11, paramId=2157011, paramName=受理时间, content=20210911160332), RowCrmResult.Col(colnum=12, paramId=2157012, paramName=受理机构, content=1), RowCrmResult.Col(colnum=13, paramId=2157013, paramName=受理工位, content=200), RowCrmResult.Col(colnum=14, paramId=2157014, paramName=套餐名称, content=), RowCrmResult.Col(colnum=15, paramId=2157015, paramName=服务标识, content=), RowCrmResult.Col(colnum=16, paramId=2157016, paramName=业务号码, content=), RowCrmResult.Col(colnum=17, paramId=2157017, paramName=产品标识, content=0), RowCrmResult.Col(colnum=18, paramId=2157018, paramName=产品名称, content=), RowCrmResult.Col(colnum=19, paramId=2157019, paramName=状态时间, content=20210911160340), RowCrmResult.Col(colnum=20, paramId=2157020, paramName=业务编码, content=NEW_CUST), RowCrmResult.Col(colnum=21, paramId=2157021, paramName=业务名称, content=客户创建), RowCrmResult.Col(colnum=22, paramId=2157022, paramName=客户名称, content=何志聪), RowCrmResult.Col(colnum=23, paramId=2157023, paramName=称受理工号名称, content=【ESB】广东电信统一通信平台), RowCrmResult.Col(colnum=24, paramId=2157024, paramName=受理工位名称, content=广州本地一级管理工位), RowCrmResult.Col(colnum=25, paramId=2157025, paramName=受理机构名称, content=广东公司), RowCrmResult.Col(colnum=26, paramId=2157026, paramName=订单来源, content=600101_ESBGDUC), RowCrmResult.Col(colnum=27, paramId=2157027, paramName=套餐编码, content=), RowCrmResult.Col(colnum=28, paramId=2157028, paramName=来源系统, content=广东电信统一通信平台来源订单)])]), 
	
	
	RowCrmResult.Result(setId=202, rowNum=4, colNum=4, rows=[
		RowCrmResult.Row(rownum=1, cols=[
			RowCrmResult.Col(colnum=1, paramId=2157041, paramName=申请单标识, content=3000010101960), 
			RowCrmResult.Col(colnum=2, paramId=2157042, paramName=主订单标识, content=3500018696706), 
			RowCrmResult.Col(colnum=3, paramId=2157043, paramName=从订单标识, content=3500018696707), 
			RowCrmResult.Col(colnum=4, paramId=2157044, paramName=依赖关系, content=1100)]), 
		RowCrmResult.Row(rownum=2, cols=[
			RowCrmResult.Col(colnum=1, paramId=2157041, paramName=申请单标识, content=3000010101960), 
			RowCrmResult.Col(colnum=2, paramId=2157042, paramName=主订单标识, content=3500018696696), 
			RowCrmResult.Col(colnum=3, paramId=2157043, paramName=从订单标识, content=3500018696707), 
			RowCrmResult.Col(colnum=4, paramId=2157044, paramName=依赖关系, content=1100)]), 
		RowCrmResult.Row(rownum=3, cols=[
			RowCrmResult.Col(colnum=1, paramId=2157041, paramName=申请单标识, content=3000010101960), 
			RowCrmResult.Col(colnum=2, paramId=2157042, paramName=主订单标识, content=3500018696706), RowCrmResult.Col(colnum=3, paramId=2157043, paramName=从订单标识, content=3500018696708), RowCrmResult.Col(colnum=4, paramId=2157044, paramName=依赖关系, content=1100)]), 
		RowCrmResult.Row(rownum=4, cols=[
			RowCrmResult.Col(colnum=1, paramId=2157041, paramName=申请单标识, content=3000010101960), 
			RowCrmResult.Col(colnum=2, paramId=2157042, paramName=主订单标识, content=3500018696707), RowCrmResult.Col(colnum=3, paramId=2157043, paramName=从订单标识, content=3500018696708), RowCrmResult.Col(colnum=4, paramId=2157044, paramName=依赖关系, content=1100)])])
		

])