<?xml version="1.0" encoding="UTF-8"?>
<ABC>
<Property Name="Description" PreFormatted="1">对公风险系统(新)的TRACE_INFO表
全量抽取。</Property>
<Property Name="Value">SELECT SERIALNO, LAWSUITSTATUS, LAWCASETYPE, LAWCASENAME, LAWCASEORG, CLAIM, RIGHTSTYPE, DECLAREDATE, LAWSUITTYPE, CASEBRIEF, CURRENCY, RTRIM(TO_CHAR(AIMSUM,'fm9999999999999999999999999990.9999999999'),'.') AS AIMSUM, RTRIM(TO_CHAR(PRINCIPAL,'fm9999999999999999999999999990.9999999999'),'.') AS PRINCIPAL, RTRIM(TO_CHAR(INDEBTINTEREST,'fm9999999999999999999999999990.9999999999'),'.') AS INDEBTINTEREST, RTRIM(TO_CHAR(OUTDEBTINTEREST,'fm9999999999999999999999999990.9999999999'),'.') AS OUTDEBTINTEREST, RTRIM(TO_CHAR(LEGALCOST,'fm9999999999999999999999999990.9999999999'),'.') AS LEGALCOST, RTRIM(TO_CHAR(ENFORCEDCOST,'fm9999999999999999999999999990.9999999999'),'.') AS ENFORCEDCOST, RTRIM(TO_CHAR(OTHERCOST,'fm9999999999999999999999999990.9999999999'),'.') AS OTHERCOST, AIMMATERIALS, EFFIENTWRITBRIEF, SAVEORNOT, DUNBORROWERDATE, DUNGUARANTORDATE, COURTSTATUS, CASEPHASE, CASESTATUS, COGNIZANCERESULT, OLDCASESTATUS, OLDCASEPHASE, APPLYDATE, OLDCOGNIZANCERESULT, APPROVEDATE, PIGEONHOLEDATE, MANAGEUSERID, MANAGEORGID, OPERATEUSERID, OPERATEORGID, INPUTUSERID, INPUTORGID, INPUTDATE, UPDATEDATE, REMARK, PAYSTANDARD, OLDCOURTSTATUS, RTRIM(TO_CHAR(RECLAIMSUM,'fm9999999999999999999999999990.9999999999'),'.') AS RECLAIMSUM, RTRIM(TO_CHAR(LOANSUM,'fm9999999999999999999999999990.9999999999'),'.') AS LOANSUM, RTRIM(TO_CHAR(CONCESSIONSUM,'fm9999999999999999999999999990.9999999999'),'.') AS CONCESSIONSUM, RTRIM(TO_CHAR(BADDEBTSUM,'fm9999999999999999999999999990.9999999999'),'.') AS BADDEBTSUM, ENDCASEREASON FROM #TableName#</Property>
</ABC>
IE里面可以准确读出这些字段。但是用JAVA的SAX就不能处理。就是想知道这有什么函数可以处理这样的数据吗?
或者只有这种类型的xml
直接读成string用api操作
这样类似的可行:public static void main(String[]args) throws Exception{
final String s = "<?xml version=\"1.0\" encoding=\"UTF-8\"?><ABC>"+
"<Property Name=\"Description\" PreFormatted=\"1\">对公风险系统(新)的TRACE_INFO表全量抽取。</Property>"+
"<Property Name=\"Value\">SELECT SERIALNO, LAWSUITSTATUS, LAWCASETYPE, LAWCASENAME, LAWCASEORG, CLAIM, RIGHTSTYPE, DECLAREDATE, LAWSUITTYPE, CASEBRIEF, CURRENCY, RTRIM(TO_CHAR(AIMSUM,'fm9999999999999999999999999990.9999999999'),'.') AS AIMSUM, RTRIM(TO_CHAR(PRINCIPAL,'fm9999999999999999999999999990.9999999999'),'.') AS PRINCIPAL, RTRIM(TO_CHAR(INDEBTINTEREST,'fm9999999999999999999999999990.9999999999'),'.') AS INDEBTINTEREST, RTRIM(TO_CHAR(OUTDEBTINTEREST,'fm9999999999999999999999999990.9999999999'),'.') AS OUTDEBTINTEREST, RTRIM(TO_CHAR(LEGALCOST,'fm9999999999999999999999999990.9999999999'),'.') AS LEGALCOST, RTRIM(TO_CHAR(ENFORCEDCOST,'fm9999999999999999999999999990.9999999999'),'.') AS ENFORCEDCOST, RTRIM(TO_CHAR(OTHERCOST,'fm9999999999999999999999999990.9999999999'),'.') AS OTHERCOST, AIMMATERIALS, EFFIENTWRITBRIEF, SAVEORNOT, DUNBORROWERDATE, DUNGUARANTORDATE, COURTSTATUS, CASEPHASE, CASESTATUS, COGNIZANCERESULT, OLDCASESTATUS, OLDCASEPHASE, APPLYDATE, OLDCOGNIZANCERESULT, APPROVEDATE, PIGEONHOLEDATE, MANAGEUSERID, MANAGEORGID, OPERATEUSERID, OPERATEORGID, INPUTUSERID, INPUTORGID, INPUTDATE, UPDATEDATE, REMARK, PAYSTANDARD, OLDCOURTSTATUS, RTRIM(TO_CHAR(RECLAIMSUM,'fm9999999999999999999999999990.9999999999'),'.') AS RECLAIMSUM, RTRIM(TO_CHAR(LOANSUM,'fm9999999999999999999999999990.9999999999'),'.') AS LOANSUM, RTRIM(TO_CHAR(CONCESSIONSUM,'fm9999999999999999999999999990.9999999999'),'.') AS CONCESSIONSUM, RTRIM(TO_CHAR(BADDEBTSUM,'fm9999999999999999999999999990.9999999999'),'.') AS BADDEBTSUM, ENDCASEREASON FROM #TableName#</Property></ABC>";
SAXParserFactory saxparserfactory = SAXParserFactory.newInstance();
SAXParser saxparser = saxparserfactory.newSAXParser();
saxparser.parse(new java.io.ByteArrayInputStream(s.getBytes()), new SAXHandler());
}
class SAXHandler extends DefaultHandler {
private StringBuffer str = null;
public void characters (char ch[], int start, int length) {
str.append(ch, start, length);
}
public void startElement(String uri, String localName, String qName,
Attributes attr) throws SAXException {
str = new StringBuffer();
}
public void endElement(String uri, String localName, String qName) throws SAXException {
System.out.println(str.toString());
}
}