|
|
| 版本: |
BeX5V3.1 |
小版本号: |
|
|
|
| 数据库: |
MySQL |
服务器操作系统: |
Windows |
应用服务器: |
Tomcat |
| 客户端操作系统: |
Windows 7 |
浏览器: |
Chrome |
|
|
//主表
public static Table printSellAction1(String id){
String sql = "SELECT s.fDate AS fDate,s.fSale AS fSale,s.fPayed AS fPayed,s.fRemark AS fRemark,c.fName AS fName" +
"FROM sm_sell s,cr_customerinfo c WHERE $clientFilter(s) AND s.fCustomerID = c.fID";
if(Utils.isNotEmptyString(id)&& !id.equals("null") ){
sql += String.format(" AND s.fID = '%s' ", id);
}
HashMap<String,String> sqlMap = new HashMap<String,String>();
sqlMap.put(SQL.DEFAULT_DB_NAME, sql);
sqlMap.put(DatabaseProduct.MYSQL.name(),sql);
return SQL.select(sqlMap,null,"/SMS/sell/data");
}
//从表
public static Table printSellListAction1(String id){
String sql = "SELECT s.fPrice,s.fNum,s.fPay,s.fCardPay,b.fName,b.fSpec,d.fName AS cardName" +
" FROM sm_selllist s,ba_items b,sm_customercard c,ba_items d WHERE $clientFilter(s) AND " +
"b.fID = s.fItemsID AND s.fCustomerCardID = c.fID AND c.fItemsID = d.fID";
if(Utils.isNotEmptyString(id)&& !id.equals("null") ){
sql += String.format(" AND s.fSellID = '%s' ", id);
}
HashMap<String,String> sqlMap = new HashMap<String,String>();
sqlMap.put(SQL.DEFAULT_DB_NAME, sql);
sqlMap.put(DatabaseProduct.MYSQL.name(),sql);
return SQL.select(sqlMap,null,"/SMS/sell/data");
}
报错如下：
二月 26, 2016 9:02:12 上午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet main-servlet threw exception
org.dom4j.DocumentException: Error on line 1 of document : 前言中不允许有内容。 Nested exception: 前言中不允许有内容。
at org.dom4j.io.SAXReader.read(SAXReader.java:482)
at org.dom4j.io.SAXReader.read(SAXReader.java:365)
at com.justep.ui.system.service.report.ReportJSONHelper.getElementFromCacheFile(Unknown Source)
at com.justep.ui.system.service.report.ReportJSONHelper.execute(Unknown Source)
at com.justep.ui.system.service.report.ReportHelper.call(Unknown Source)
at com.justep.ui.system.service.report.ReportHelper.service(Unknown Source)
at ReportBrowse.doPost(ReportBrowse.java:21)
at com.justep.ui.impl.JProcessorImpl.execute(Unknown Source)
at com.justep.ui.JavaServer.runJava(Unknown Source)
at com.justep.ui.JavaServer.doJ(Unknown Source)
at com.justep.ui.JavaServer.service(Native Method)
at com.justep.ui.servlet.MainServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Nested exception:
org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; 前言中不允许有内容。
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:198)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:177)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:441)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:368)
at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1436)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(XMLDocumentScannerImpl.java:999)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:117)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:648)
at org.dom4j.io.SAXReader.read(SAXReader.java:465)
at org.dom4j.io.SAXReader.read(SAXReader.java:365)
at com.justep.ui.system.service.report.ReportJSONHelper.getElementFromCacheFile(Unknown Source)
at com.justep.ui.system.service.report.ReportJSONHelper.execute(Unknown Source)
at com.justep.ui.system.service.report.ReportHelper.call(Unknown Source)
at com.justep.ui.system.service.report.ReportHelper.service(Unknown Source)
at ReportBrowse.doPost(ReportBrowse.java:21)
at com.justep.ui.impl.JProcessorImpl.execute(Unknown Source)
at com.justep.ui.JavaServer.runJava(Unknown Source)
at com.justep.ui.JavaServer.doJ(Unknown Source)
at com.justep.ui.JavaServer.service(Native Method)
at com.justep.ui.servlet.MainServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
|
|
IP卡
狗仔卡
发表于 2016-2-26 09:19:31
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
发表于 2016-2-26 11:14:08
楼主
