项目场景:
需要将其他项目中开发的webservice服务响应数据将在至自己的系统中,由于数据不是自己的,所以需要处理webservice服务中的DataSet数据。
问题描述:
java中是不具有DataSet数据,不能直接处理C#中DataSet数据
服务传输数据形式如下。
<?xml version="1.0" encoding="utf-8"?>
<DataSet xmlns="http://tempuri.org/">
<xs:schema id="SinglePointMonthReport_Body" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="SinglePointMonthReport_Body" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Table1">
<xs:complexType>
<xs:sequence>
<xs:element name="POINT_ID" type="xs:string" minOccurs="0" />
<xs:element name="REC_TIME" type="xs:dateTime" minOccurs="0" />
<xs:element name="LD" type="xs:decimal" minOccurs="0" />
<xs:element name="LN" type="xs:decimal" minOccurs="0" />
<xs:element name="LDN" type="xs:decimal" minOccurs="0" />
<xs:element name="SD" type="xs:decimal" minOccurs="0" />
<xs:element name="VALID_HOUR" type="xs:decimal" minOccurs="0" />
<xs:element name="RUNNING_HOUR" type="xs:decimal" minOccurs="0" />
<xs:element name="FILTER_INFO" type="xs:string" minOccurs="0" />
<xs:element name="WS_AVG" type="xs:decimal" minOccurs="0" />
<xs:element name="RC_AVG" type="xs:decimal" minOccurs="0" />
<xs:element name="AVGFLOW" type="xs:decimal" minOccurs="0" />
<xs:element name="SAMPLING_RATE" type="xs:decimal" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
<SinglePointMonthReport_Body xmlns="">
<Table1 diffgr:id="Table11" msdata:rowOrder="0">
<POINT_ID></POINT_ID>
<REC_TIME></REC_TIME>
<LD></LD>
<LN></LN>
<LDN></LDN>
<SD></SD>
<VALID_HOUR></VALID_HOUR>
<RUNNING_HOUR></RUNNING_HOUR>
<SAMPLING_RATE></SAMPLING_RATE>
</Table1>
</SinglePointMonthReport_Body>
</diffgr:diffgram>
</DataSet>
解决方案:
将DataSet中包裹数据的标签,按照字符串的方式截取出来。然后再按照处理xml字符串的方式,处理数据,就可以将数据生成实体类对象集合。
代码如下。
public class XMLUtil {
private static HashMap<String, String> xmlFiled = new HashMap<String, String>(){{
put("diffgr:id", "id");
put("msdata:rowOrder", "rowOrder");
put("diffgr:hasChanges", "hasChanges");
}};
/**
* 截取需要转化生成实体类的xml字符串进行转化
* @param xmlStr 需要转化的xml字符串
* @param clazz 生成的实体类的class
* @return
*/
public static <T> T xmlStrToObject(String xmlStr, Class<T> clazz){
for (Map.Entry<String, String> entry : xmlFiled.entrySet()) {
xmlStr=xmlStr.replaceAll(entry.getKey(), entry.getValue());
}
T initPointInfo= (T) XMLUtil.convertXmlStrToObject(clazz, xmlStr);
return initPointInfo;
}
/**
* 将String类型的xml转换成对象
*
* @param clazz
* @param xmlStr
* @return
*/
private static Object convertXmlStrToObject(Class clazz, String xmlStr) {
Object xmlObject = null;
try {
JAXBContext context = JAXBContext.newInstance(clazz);
Unmarshaller unmarshaller = context.createUnmarshaller();
StringReader sr = new StringReader(xmlStr);
xmlObject = unmarshaller.unmarshal(sr);
} catch (JAXBException e) {
e.printStackTrace();
}
return xmlObject;
}
@Data
@NoArgsConstructor
@AllArgsConstructor
@XmlAccessorType(XmlAccessType.FIELD)
@XmlRootElement(name = "SinglePointMonthReport_Body")
public class Point_day implements Serializable {
@XmlElement(name = "Table1")
private List<Point_realTime> point_realTime;
}
@Data
@NoArgsConstructor
@AllArgsConstructor
//根元素
//访问类型,通过字段
@XmlAccessorType(XmlAccessType.FIELD)
@XmlRootElement(name = "Table1")
public class Point_mess implements Serializable {
@XmlElement(name = "ID")
private String ID;
@XmlElement(name = "POINT_CODE")
private String POINT_CODE;
@XmlElement(name = "POINT_NAME")
private String POINT_NAME;
}