JsUtil:=======================预计销售额type=======================O JsUtil:===========2222222sql2++++++++++++++++++++++ select item_expensesstyle,sum(m1) as item_m1,sum(m2) as item_m2,sum(m3) as item_m3,sum(m4) as item_m4,'11df-da58-bc5eca1a-89ca-f3fcc4bc58f3' as domainid from (select item_expensesstyle, (case when item_startdate between '2012-04-01' and '2012-04-30' then item_tmexpenses else 0 end) as M1, (case when item_startdate between '2012-05-01' and '2012-05-31' then item_tmexpenses else 0 end) as M2, (case when item_startdate between '2012-06-01' and '2012-06-30' then item_tmexpenses else 0 end) as M3,0 as M4 from tlk_tm_budget_expense where item_status='未生效' and item_region='HD') t group by item_expensesstyle JsUtil:#####!!!!#########[Document:亨氏龙凤OA管理系统/市场费用管理/tm_budget_expense pwpStates月度PWP authorqianlina estimatenum promotioncomment_PART priceofpromotion0.0 provisionofyear0.0 priceofcontract0.0 periodFY13M1 provisionofmonth0.0 pwptypeO status未生效 issign startdate2012-04-01 00:00:00.0 skuno tel iscontractcustomerno10200312 rebatestyle regionHD authorno11e1-a3ad-2d87f5b5-816f-b5a935c60df8 discount0.0 enddate2012-06-30 00:00:00.0 productlevel 11DF-D79F-BD761A9C-AC6E-27F410949A54null customer无锡市利比利商贸有限公司 address promotioncomment121212 dept11e0-59aa-f8577bd3-825c-ffa150364fae channelDIS-DISFS-SDIS salestarget0.0 tmexpenses111.0 expensesstyleO province comment111 city pwpnosh-1122 promotioncategory rebate0.0 channel_PART , Document:亨氏龙凤OA管理系统/市场费用管理/tm_budget_expense pwpStates月度PWP authoradmin estimatenum promotioncomment_PART priceofpromotion0.0 provisionofyear0.0 priceofcontract0.0 periodFY12M1 pwptypeO provisionofmonth0.0 status未生效 issign startdate2012-04-01 00:00:00.0 skuno tel iscontractcustomerno10200312 rebatestyle authorno11df-da62-43646fc3-a9bb-e73cc8edb980 regionHD discount0.0 enddate2012-04-01 00:00:00.0 11DF-D79F-BD761A9C-AC6E-27F410949A54null productlevel customer无锡市利比利商贸有限公司 address promotioncomment111 dept11e0-0e89-c407f961-8855-ef98937b319a channelDIS-DISFS-SDIS salestarget0.0 tmexpenses1111.0 province上海市 expensesstyleO comment pwpnoSH-111 city promotioncategory rebate0.0 channel_PART , Document:亨氏龙凤OA管理系统/市场费用管理/tm_budget_expense authorqianlina pwpStates月度PWP estimatenum promotioncomment_PART priceofpromotion0.0 priceofcontract0.0 periodfy13m1 provisionofyear0.0 status未生效 provisionofmonth0.0 pwptypeO issign startdate2012-04-01 00:00:00.0 skuno tel iscontractcustomerno10200312 rebatestyle authorno11e1-a3ad-2d87f5b5-816f-b5a935c60df8 regionHD discount0.0 enddate2012-06-30 00:00:00.0 productlevel 11DF-D79F-BD761A9C-AC6E-27F410949A54null customer无锡市利比利商贸有限公司 address promotioncomment12 dept11e0-59aa-f8577bd3-825c-ffa150364fae channelDIS-DISFS-SDIS salestarget0.0 tmexpenses100.0 province expensesstyleO comment city pwpnoSH-1121 promotioncategory rebate0.0 channel_PART , Document:亨氏龙凤OA管理系统/市场费用管理/tm_budget_expense authorqianlina pwpStates月度PWP estimatenum promotioncomment_PART priceofpromotion0.0 priceofcontract0.0 provisionofyear0.0 periodFY13M1 status未生效 provisionofmonth0.0 pwptypeO issign startdate2012-04-01 00:00:00.0 skuno tel iscontractcustomerno10200312 rebatestyle authorno11e1-a3ad-2d87f5b5-816f-b5a935c60df8 regionHD discount0.0 enddate2012-06-30 00:00:00.0 productlevel 11DF-D79F-BD761A9C-AC6E-27F410949A54null customer无锡市利比利商贸有限公司 address promotioncomment11 dept11e0-59aa-f8577bd3-825c-ffa150364fae channelDIS-DISFS-SDIS salestarget0.0 tmexpenses100.0 expensesstyleO province comment pwpnosh-133 city promotioncategory rebate0.0 channel_PART , Document:亨氏龙凤OA管理系统/市场费用管理/tm_budget_expense authoradmin pwpStates月度PWP estimatenum promotioncomment_PART priceofpromotion0.0 periodFY13M1 priceofcontract0.0 provisionofyear0.0 status未生效 provisionofmonth0.0 pwptypeO issign startdate2012-04-01 00:00:00.0 skuno tel iscontractcustomerno10200312 rebatestyle regionHD authorno11df-da62-43646fc3-a9bb-e73cc8edb980 discount0.0 enddate2012-06-30 00:00:00.0 11DF-D79F-BD761A9C-AC6E-27F410949A54null productlevel customer无锡市利比利商贸有限公司 address promotioncomment1212 dept11e0-0e89-c407f961-8855-ef98937b319a channelDIS-DISFS-SDIS salestarget0.0 tmexpenses200.0 province expensesstyleO comment pwpnoSH-66 city promotioncategory rebate0.0 channel_PART ] org.mozilla.javascript.WrappedException: Wrapped java.sql.SQLException: '-' 附近有语法错误。 (11df-e0c6-c63ce4a2-9adb-d5d4b08a29f1).提交afterActionScript#14) at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1757) at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:170) at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243) at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66) at org.mozilla.javascript.gen.c3509._c0(FormName:亨氏龙凤OA管理系统/市场费用管理/tm_budget Activity Action(11df-e0c6-c63ce4a2-9adb-d5d4b08a29f1).提交afterActionScript:14) at org.mozilla.javascript.gen.c3509.call(FormName:亨氏龙凤OA管理系统/市场费用管理/tm_budget Activity Action(11df-e0c6-c63ce4a2-9adb-d5d4b08a29f1).提交afterActionScript) at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393) at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834) at org.mozilla.javascript.gen.c3509.call(FormName:亨氏龙凤OA管理系统/市场费用管理/tm_budget Activity Action(11df-e0c6-c63ce4a2-9adb-d5d4b08a29f1).提交afterActionScript) at org.mozilla.javascript.gen.c3509.exec(FormName:亨氏龙凤OA管理系统/市场费用管理/tm_budget Activity Action(11df-e0c6-c63ce4a2-9adb-d5d4b08a29f1).提交afterActionScript) at cn.myapps.core.macro.runner.JavaScriptRunner.run(JavaScriptRunner.java:117) at org.apache.jsp.portal.share.dynaform.activity.after_jsp._jspService(after_jsp.java:478) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292) at com.opensymphony.webwork.dispatcher.ServletDispatcherResult.doExecute(ServletDispatcherResult.java:114) at cn.myapps.base.web.ServletResult.OBPMServletDispatcherResult.doExecute(OBPMServletDispatcherResult.java:32) at com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebWorkResultSupport.java:101) at com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:312) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:207) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:113) at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:233) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:111) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292) at com.opensymphony.webwork.dispatcher.ServletDispatcherResult.doExecute(ServletDispatcherResult.java:114) at cn.myapps.base.web.ServletResult.OBPMServletDispatcherResult.doExecute(OBPMServletDispatcherResult.java:32) at com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebWorkResultSupport.java:101) at com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:312) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:207) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:137) at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:81) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:115) at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:81) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.webwork.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:171) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:151) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:100) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:113) at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:233) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:111) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292) at cn.myapps.util.OBPMDispatcher.forward(OBPMDispatcher.java:52) at org.apache.jsp.portal.share.dynaform.activity.action_jsp._jspService(action_jsp.java:407) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292) at com.opensymphony.webwork.dispatcher.ServletDispatcherResult.doExecute(ServletDispatcherResult.java:114) at cn.myapps.base.web.ServletResult.OBPMServletDispatcherResult.doExecute(OBPMServletDispatcherResult.java:32) at com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebWorkResultSupport.java:101) at com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:312) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:207) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:137) at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:81) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:115) at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:81) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.webwork.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:171) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:151) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:100) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:113) at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:233) at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:198) at cn.myapps.base.web.filter.OBPMFilterDispatcher.doFilter(OBPMFilterDispatcher.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:78) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at cn.myapps.base.web.filter.AjaxMultiLanguageFilter.doFilter(AjaxMultiLanguageFilter.java:42) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at cn.myapps.base.web.filter.PersistenceFilter.doFilter(PersistenceFilter.java:30) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at cn.myapps.base.web.filter.SecurityFilter.doFilter(SecurityFilter.java:115) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jasig.cas.client.util.AssertionThreadLocalFilter.doFilter(AssertionThreadLocalFilter.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jasig.cas.client.util.HttpServletRequestWrapperFilter.doFilter(HttpServletRequestWrapperFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jasig.cas.client.validation.AbstractTicketValidationFilter.doFilter(AbstractTicketValidationFilter.java:197) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at cn.myapps.core.sso.cas.filter.OBPMAuthenticationFilter.doFilter(OBPMAuthenticationFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at cn.myapps.base.web.filter.EncodingFilter.doFilter(EncodingFilter.java:27) 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:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:722) Caused by: java.sql.SQLException: '-' 附近有语法错误。 at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:505) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) at cn.myapps.core.dynaform.document.dao.AbstractDocStaticTblDAO.updateDocument(AbstractDocStaticTblDAO.java:602) at cn.myapps.core.dynaform.document.ejb.DocumentProcessBean.doUpdate(DocumentProcessBean.java:1389) at cn.myapps.core.dynaform.document.ejb.DocumentProcessBean.doUpdate(DocumentProcessBean.java:1345) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155) ... 175 more