EOS开发报错日志记录

1201error01

[default][2020-12-01 10:00:29,648][ERROR][com.primeton.common.connection.impl.synchronization.TraceLoggerStatementSynchronization:49] Sql[insert into 1.o_operator (USER_ID, USER_NAME, GENDER, POSTCODE, ADDRESS, PHONE, EMAIL, MEMO, OPERATOR_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)] execute error.
java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator (USER_ID, USER_NAME, GENDER, POSTCODE, ADDRESS, PHONE, EMAIL, ME...' at line 1
	at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1167)
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1773)
	at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1257)
	at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:958)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
	at com.primeton.ext.infra.connection.StatementWrapper.executeBatch(StatementWrapper.java:210)
	at com.primeton.das.entity.impl.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:49)
	at com.primeton.das.entity.impl.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:254)
	at com.primeton.das.entity.impl.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
	at com.primeton.das.entity.impl.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
	at com.primeton.das.entity.impl.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
	at com.primeton.das.entity.impl.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
	at com.primeton.das.entity.impl.hibernate.impl.SessionImpl.flush(SessionImpl.java:1021)
	at com.primeton.das.entity.impl.DASSessionImpl.insertEntity(DASSessionImpl.java:120)
	at com.eos.foundation.database.DatabaseUtil.insertEntity(DatabaseUtil.java:226)
	at com.primeton.eos.ooperatorbiz.addOOperator_biz.invokePojo0(addOOperator_biz.java:177)
	at com.primeton.eos.ooperatorbiz.addOOperator_biz.__choiceinvokePojo0(addOOperator_biz.java:409)
	at com.primeton.eos.ooperatorbiz.addOOperator_biz.__invokeBiz(addOOperator_biz.java:360)
	at com.primeton.eos.ooperatorbiz.addOOperator_biz._invoke(addOOperator_biz.java:266)
	at com.primeton.eos.ooperatorbiz.addOOperator_biz.invoke(addOOperator_biz.java:313)
	at com.primeton.engine.core.impl.process.BLProxy.invoke(BLProxy.java:223)
	at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:112)
	at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:80)
	at com.primeton.ext.engine.component.Operation.invoke(Operation.java:100)
	at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:183)
	at com.primeton.access.client.impl.skeleton.BizLogicReceiveTarget.invoke(BizLogicReceiveTarget.java:50)
	at com.primeton.access.client.impl.skeleton.ServiceEngine.receive(ServiceEngine.java:36)
	at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invokeService(DefaultServiceSkeleton.java:130)
	at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invoke(DefaultServiceSkeleton.java:32)
	at com.primeton.access.client.impl.ClientMessageInterceptor.invoke(ClientMessageInterceptor.java:57)
	at com.primeton.system.aop.impl.HandlerInvoker.invoke(HandlerInvoker.java:60)
	at com.primeton.system.aop.impl.JdkProxyUtil$JdkInvocationHandlerWrapper.invoke(JdkProxyUtil.java:53)
	at com.sun.proxy.$Proxy38.invoke(Unknown Source)
	at com.primeton.eos.OOperatorMaintain_flow.subprocess2(OOperatorMaintain_flow.java:1076)
	at com.primeton.eos.OOperatorMaintain_flow._insertSubmit(OOperatorMaintain_flow.java:1305)
	at com.primeton.eos.OOperatorMaintain_flow._view0(OOperatorMaintain_flow.java:1618)
	at com.primeton.eos.OOperatorMaintain_flow.process(OOperatorMaintain_flow.java:1678)
	at com.primeton.engine.core.impl.process.PageflowInstance.process(PageflowInstance.java:327)
	at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.doProcess(AbstractPageFlowProcessor.java:330)
	at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.process(AbstractPageFlowProcessor.java:112)
	at com.primeton.access.http.impl.ProcessorWebInterceptor.doIntercept(ProcessorWebInterceptor.java:105)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:131)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:124)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at org.gocom.components.coframe.auth.intercepter.FunctionWebInterceptor.doIntercept(FunctionWebInterceptor.java:84)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at org.gocom.components.coframe.auth.intercepter.UserLoginWebInterceptor.doIntercept(UserLoginWebInterceptor.java:84)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.security.HttpRefererWebInterceptor.doIntercept(HttpRefererWebInterceptor.java:47)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.security.HttpSecurityWebInterceptor.doIntercept(HttpSecurityWebInterceptor.java:40)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:133)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:662)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator (USER_ID, USER_NAME, GENDER, POSTCODE, ADDRESS, PHONE, EMAIL, ME...' at line 1
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1751)
	... 74 more
[default][2020-12-01 10:00:29,651][ERROR][com.primeton.das.entity.impl.hibernate.util.JDBCExceptionReporter:77] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator (USER_ID, USER_NAME, GENDER, POSTCODE, ADDRESS, PHONE, EMAIL, ME...' at line 1
[default][2020-12-01 10:00:29,652][ERROR][com.primeton.das.entity.impl.hibernate.event.def.AbstractFlushingEventListener:301] Could not synchronize database state with session. Could not execute JDBC batch update
[FlowName=com.primeton.eos.ooperatorbiz.addOOperator.biz][activity name=insertEntity][activity id=invokePojo0][exception=ErrCode: 24000040
Message: 新增一条记录失败. 事务回滚.]
[default][2020-12-01 10:00:29,654][ERROR][com.primeton.access.client.impl.skeleton.ServiceEngine:38] 
ErrCode: 24000040
Message: 新增一条记录失败. 事务回滚.
	at com.eos.foundation.database.DatabaseUtil.insertEntity(DatabaseUtil.java:232)
	at com.primeton.eos.ooperatorbiz.addOOperator_biz.invokePojo0(addOOperator_biz.java:177)
	at com.primeton.eos.ooperatorbiz.addOOperator_biz.__choiceinvokePojo0(addOOperator_biz.java:409)
	at com.primeton.eos.ooperatorbiz.addOOperator_biz.__invokeBiz(addOOperator_biz.java:360)
	at com.primeton.eos.ooperatorbiz.addOOperator_biz._invoke(addOOperator_biz.java:266)
	at com.primeton.eos.ooperatorbiz.addOOperator_biz.invoke(addOOperator_biz.java:313)
	at com.primeton.engine.core.impl.process.BLProxy.invoke(BLProxy.java:223)
	at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:112)
	at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:80)
	at com.primeton.ext.engine.component.Operation.invoke(Operation.java:100)
	at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:183)
	at com.primeton.access.client.impl.skeleton.BizLogicReceiveTarget.invoke(BizLogicReceiveTarget.java:50)
	at com.primeton.access.client.impl.skeleton.ServiceEngine.receive(ServiceEngine.java:36)
	at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invokeService(DefaultServiceSkeleton.java:130)
	at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invoke(DefaultServiceSkeleton.java:32)
	at com.primeton.access.client.impl.ClientMessageInterceptor.invoke(ClientMessageInterceptor.java:57)
	at com.primeton.system.aop.impl.HandlerInvoker.invoke(HandlerInvoker.java:60)
	at com.primeton.system.aop.impl.JdkProxyUtil$JdkInvocationHandlerWrapper.invoke(JdkProxyUtil.java:53)
	at com.sun.proxy.$Proxy38.invoke(Unknown Source)
	at com.primeton.eos.OOperatorMaintain_flow.subprocess2(OOperatorMaintain_flow.java:1076)
	at com.primeton.eos.OOperatorMaintain_flow._insertSubmit(OOperatorMaintain_flow.java:1305)
	at com.primeton.eos.OOperatorMaintain_flow._view0(OOperatorMaintain_flow.java:1618)
	at com.primeton.eos.OOperatorMaintain_flow.process(OOperatorMaintain_flow.java:1678)
	at com.primeton.engine.core.impl.process.PageflowInstance.process(PageflowInstance.java:327)
	at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.doProcess(AbstractPageFlowProcessor.java:330)
	at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.process(AbstractPageFlowProcessor.java:112)
	at com.primeton.access.http.impl.ProcessorWebInterceptor.doIntercept(ProcessorWebInterceptor.java:105)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:131)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:124)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at org.gocom.components.coframe.auth.intercepter.FunctionWebInterceptor.doIntercept(FunctionWebInterceptor.java:84)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at org.gocom.components.coframe.auth.intercepter.UserLoginWebInterceptor.doIntercept(UserLoginWebInterceptor.java:84)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.security.HttpRefererWebInterceptor.doIntercept(HttpRefererWebInterceptor.java:47)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.security.HttpSecurityWebInterceptor.doIntercept(HttpSecurityWebInterceptor.java:40)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:133)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:662)
Caused by: ErrCode: 14101017
Message: SQL语法错误(Could not execute JDBC batch update)
	at com.primeton.das.entity.impl.exception.DASExceptionHelper.convert(DASExceptionHelper.java:150)
	at com.primeton.das.entity.impl.DASSessionImpl.insertEntity(DASSessionImpl.java:123)
	at com.eos.foundation.database.DatabaseUtil.insertEntity(DatabaseUtil.java:226)
	... 61 more
Caused by: com.primeton.das.entity.impl.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
	at com.primeton.das.entity.impl.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
	at com.primeton.das.entity.impl.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at com.primeton.das.entity.impl.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:264)
	at com.primeton.das.entity.impl.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
	at com.primeton.das.entity.impl.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
	at com.primeton.das.entity.impl.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
	at com.primeton.das.entity.impl.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
	at com.primeton.das.entity.impl.hibernate.impl.SessionImpl.flush(SessionImpl.java:1021)
	at com.primeton.das.entity.impl.DASSessionImpl.insertEntity(DASSessionImpl.java:120)
	... 62 more
Caused by: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator (USER_ID, USER_NAME, GENDER, POSTCODE, ADDRESS, PHONE, EMAIL, ME...' at line 1
	at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1167)
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1773)
	at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1257)
	at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:958)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
	at com.primeton.ext.infra.connection.StatementWrapper.executeBatch(StatementWrapper.java:210)
	at com.primeton.das.entity.impl.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:49)
	at com.primeton.das.entity.impl.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:254)
	... 68 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator (USER_ID, USER_NAME, GENDER, POSTCODE, ADDRESS, PHONE, EMAIL, ME...' at line 1
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1751)
	... 74 more
[FlowName=com.primeton.eos.OOperatorMaintain.flow][activity name=addOOperator][activity id=subprocess2][exception=ErrCode: 24000040
Message: 新增一条记录失败. 事务回滚.]
[default][2020-12-01 10:00:29,656][ERROR][com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor:371] error [com.primeton.eos.OOperatorMaintain.flow?_flowKey=9ddca8f3-1c59-4d69-8185-f2fe3f5ceca9.null]
ErrCode: 24000040
Message: 新增一条记录失败. 事务回滚.
	at com.eos.foundation.database.DatabaseUtil.insertEntity(DatabaseUtil.java:232)
	at com.primeton.eos.ooperatorbiz.addOOperator_biz.invokePojo0(addOOperator_biz.java:177)
	at com.primeton.eos.ooperatorbiz.addOOperator_biz.__choiceinvokePojo0(addOOperator_biz.java:409)
	at com.primeton.eos.ooperatorbiz.addOOperator_biz.__invokeBiz(addOOperator_biz.java:360)
	at com.primeton.eos.ooperatorbiz.addOOperator_biz._invoke(addOOperator_biz.java:266)
	at com.primeton.eos.ooperatorbiz.addOOperator_biz.invoke(addOOperator_biz.java:313)
	at com.primeton.engine.core.impl.process.BLProxy.invoke(BLProxy.java:223)
	at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:112)
	at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:80)
	at com.primeton.ext.engine.component.Operation.invoke(Operation.java:100)
	at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:183)
	at com.primeton.access.client.impl.skeleton.BizLogicReceiveTarget.invoke(BizLogicReceiveTarget.java:50)
	at com.primeton.access.client.impl.skeleton.ServiceEngine.receive(ServiceEngine.java:36)
	at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invokeService(DefaultServiceSkeleton.java:130)
	at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invoke(DefaultServiceSkeleton.java:32)
	at com.primeton.access.client.impl.ClientMessageInterceptor.invoke(ClientMessageInterceptor.java:57)
	at com.primeton.system.aop.impl.HandlerInvoker.invoke(HandlerInvoker.java:60)
	at com.primeton.system.aop.impl.JdkProxyUtil$JdkInvocationHandlerWrapper.invoke(JdkProxyUtil.java:53)
	at com.sun.proxy.$Proxy38.invoke(Unknown Source)
	at com.primeton.eos.OOperatorMaintain_flow.subprocess2(OOperatorMaintain_flow.java:1076)
	at com.primeton.eos.OOperatorMaintain_flow._insertSubmit(OOperatorMaintain_flow.java:1305)
	at com.primeton.eos.OOperatorMaintain_flow._view0(OOperatorMaintain_flow.java:1618)
	at com.primeton.eos.OOperatorMaintain_flow.process(OOperatorMaintain_flow.java:1678)
	at com.primeton.engine.core.impl.process.PageflowInstance.process(PageflowInstance.java:327)
	at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.doProcess(AbstractPageFlowProcessor.java:330)
	at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.process(AbstractPageFlowProcessor.java:112)
	at com.primeton.access.http.impl.ProcessorWebInterceptor.doIntercept(ProcessorWebInterceptor.java:105)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:131)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:124)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at org.gocom.components.coframe.auth.intercepter.FunctionWebInterceptor.doIntercept(FunctionWebInterceptor.java:84)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at org.gocom.components.coframe.auth.intercepter.UserLoginWebInterceptor.doIntercept(UserLoginWebInterceptor.java:84)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.security.HttpRefererWebInterceptor.doIntercept(HttpRefererWebInterceptor.java:47)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.security.HttpSecurityWebInterceptor.doIntercept(HttpSecurityWebInterceptor.java:40)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:133)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:662)
Caused by: ErrCode: 14101017
Message: SQL语法错误(Could not execute JDBC batch update)
	at com.primeton.das.entity.impl.exception.DASExceptionHelper.convert(DASExceptionHelper.java:150)
	at com.primeton.das.entity.impl.DASSessionImpl.insertEntity(DASSessionImpl.java:123)
	at com.eos.foundation.database.DatabaseUtil.insertEntity(DatabaseUtil.java:226)
	... 61 more
Caused by: com.primeton.das.entity.impl.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
	at com.primeton.das.entity.impl.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
	at com.primeton.das.entity.impl.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at com.primeton.das.entity.impl.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:264)
	at com.primeton.das.entity.impl.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
	at com.primeton.das.entity.impl.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
	at com.primeton.das.entity.impl.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
	at com.primeton.das.entity.impl.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
	at com.primeton.das.entity.impl.hibernate.impl.SessionImpl.flush(SessionImpl.java:1021)
	at com.primeton.das.entity.impl.DASSessionImpl.insertEntity(DASSessionImpl.java:120)
	... 62 more
Caused by: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator (USER_ID, USER_NAME, GENDER, POSTCODE, ADDRESS, PHONE, EMAIL, ME...' at line 1
	at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1167)
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1773)
	at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1257)
	at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:958)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
	at com.primeton.ext.infra.connection.StatementWrapper.executeBatch(StatementWrapper.java:210)
	at com.primeton.das.entity.impl.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:49)
	at com.primeton.das.entity.impl.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:254)
	... 68 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator (USER_ID, USER_NAME, GENDER, POSTCODE, ADDRESS, PHONE, EMAIL, ME...' at line 1
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1751)
	... 74 more
[BPS Process Server][2020-12-01 10:00:36,408][INFO] Timer trig first:180000 3000

1201error02

报错节点
02 主从表功能一步完成
右键点击左侧"资源管理器"视图中,已创建的(project)项目中的(com.primeton.eos)构件包节点,选择[功能向导/主从表维护向导]菜单,如下图所示。
在这里插入图片描述
选择数据实体,还是选择刚才那个OOperator实体,我们会发现这个时候可以选择从表实体了,如下图所示。
在这里插入图片描述
我们进行查询条件的设置,如下图所示。
在这里插入图片描述
小技巧:queryform配置查询条件 EOS Studio提供了一个queryform的查询表单向导,如果查询的实体建立了n->1的关联关系,我们是可以选择关联实体的字段做为查询条件的,例如在上图中,我们可以设置"oOrg."开头的属性做为查询条件。通过这个方式我们轻松的实现了简单的join查询。
填好了查询条件字段后,单击<下一步>按钮,我们进入结果集的设置界面,我们可以通过下图中的 按钮来添加关联实体的属性"oOrg.orgName",这样结果集中就会显示操作员所在机构了。
在这里插入图片描述
后续的步骤中我们只需要点击<下一步>按钮即可。直到最后选择生成文件的目录,为了不和原来程序冲突,我们选择的包是"com.primeton.eos1",页面资源目录是"operator1",如下图所示。
在这里插入图片描述
我们通过http://127.0.0.1:8080/eos-default/com.primeton.eos1.OOperatorMaintain.flow查看运行结果。
查询界面如下:
在这里插入图片描述
录入界面如下:
在这里插入图片描述
到这里我们就了解了原来快速开发:单表增删改查、实现关联表操作、实现从表操作实现的功能特性全部可以通过功能向导来实现。让大家辛辛苦苦做了这么多步骤,原来向导都能够实现,虽然大家忙了一阵,但是可以通过前面的步骤了解到EOS编程的基本思路,也希望你能通过学习体验到编程的快乐。

小技巧:编程关键技巧 EOS提供了一个可视化的流程编程,改变了传统的编程模式。在编程过程中一定要记住下面的要点。 逻辑程序:流程体现逻辑,尽可能理清程序逻辑,定义出参数和变量,你就可以通过"自定义"库快速实现功能。 JSP页面:界面的代码占用了大量的开发时间,所以在设计时需要统一规划好"显示属性",然后借用"组合控件"向导以及"功能向导"可以将大量的程序框架生成出来,然后只要在程序框架上进行调整就可以加快程序开发进度。
报错日志

[BPS Process Server][2020-12-01 16:41:35,947][INFO] Timer trig first:180000 3000
[default][2020-12-01 16:44:04,098][ERROR][com.primeton.common.connection.impl.synchronization.TraceLoggerStatementSynchronization:49] Sql[select count(*) eos_row_count from ( select this_.OPERATOR_ID as OPERATOR1_84_2_, this_.USER_ID as USER2_84_2_, this_.USER_NAME as USER3_84_2_, this_.BIRTHDAY as BIRTHDAY84_2_, this_.GENDER as GENDER84_2_, this_.POSTCODE as POSTCODE84_2_, this_.ADDRESS as ADDRESS84_2_, this_.PHONE as PHONE84_2_, this_.EMAIL as EMAIL84_2_, this_.MEMO as MEMO84_2_, this_.oOrg as oOrg84_2_, oorg2_.ORG_ID as ORG1_85_0_, oorg2_.ORG_NAME as ORG2_85_0_, oorg2_.ORG_CODE as ORG3_85_0_, oorg2_.ORG_ADDRESS as ORG4_85_0_, oorg2_.ORG_SEQ as ORG5_85_0_, oorg2_.PARENT_ORG_ID as PARENT6_85_0_, oorg3_.ORG_ID as ORG1_85_1_, oorg3_.ORG_NAME as ORG2_85_1_, oorg3_.ORG_CODE as ORG3_85_1_, oorg3_.ORG_ADDRESS as ORG4_85_1_, oorg3_.ORG_SEQ as ORG5_85_1_, oorg3_.PARENT_ORG_ID as PARENT6_85_1_ from 1.o_operator this_ left outer join o_org oorg2_ on this_.oOrg=oorg2_.ORG_ID left outer join o_org oorg3_ on oorg2_.PARENT_ORG_ID=oorg3_.ORG_ID) table_] execute error.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator this_ left outer join o_org oorg2_ on this_.oOrg=oorg2_.ORG_ID l...' at line 1
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	at com.primeton.ext.infra.connection.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:110)
	at com.primeton.das.entity.impl.DASSessionImpl.countBySubQuery(DASSessionImpl.java:479)
	at com.primeton.das.entity.impl.DASSessionImpl.count(DASSessionImpl.java:558)
	at com.eos.foundation.database.DatabaseUtil.count(DatabaseUtil.java:987)
	at com.eos.foundation.database.Pagination.doQuery(Pagination.java:485)
	at com.eos.foundation.database.Pagination.doQueryPageCond(Pagination.java:515)
	at com.eos.foundation.database.DatabaseExt.queryEntitiesByCriteriaEntityWithPage(DatabaseExt.java:441)
	at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.invokePojo0(queryOOperators_biz.java:210)
	at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.__choiceinvokePojo0(queryOOperators_biz.java:424)
	at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.__invokeBiz(queryOOperators_biz.java:370)
	at com.primeton.eos1.ooperatorbiz.queryOOperators_biz._invoke(queryOOperators_biz.java:256)
	at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.invoke(queryOOperators_biz.java:321)
	at com.primeton.engine.core.impl.process.BLProxy.invoke(BLProxy.java:223)
	at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:112)
	at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:80)
	at com.primeton.ext.engine.component.Operation.invoke(Operation.java:100)
	at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:183)
	at com.primeton.access.client.impl.skeleton.BizLogicReceiveTarget.invoke(BizLogicReceiveTarget.java:50)
	at com.primeton.access.client.impl.skeleton.ServiceEngine.receive(ServiceEngine.java:36)
	at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invokeService(DefaultServiceSkeleton.java:130)
	at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invoke(DefaultServiceSkeleton.java:32)
	at com.primeton.access.client.impl.ClientMessageInterceptor.invoke(ClientMessageInterceptor.java:57)
	at com.primeton.system.aop.impl.HandlerInvoker.invoke(HandlerInvoker.java:60)
	at com.primeton.system.aop.impl.JdkProxyUtil$JdkInvocationHandlerWrapper.invoke(JdkProxyUtil.java:53)
	at com.sun.proxy.$Proxy38.invoke(Unknown Source)
	at com.primeton.eos1.OOperatorMaintain_flow.subprocess0(OOperatorMaintain_flow.java:324)
	at com.primeton.eos1.OOperatorMaintain_flow._pageQuery(OOperatorMaintain_flow.java:454)
	at com.primeton.eos1.OOperatorMaintain_flow.process(OOperatorMaintain_flow.java:1635)
	at com.primeton.engine.core.impl.process.PageflowInstance.process(PageflowInstance.java:325)
	at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.doProcess(AbstractPageFlowProcessor.java:330)
	at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.process(AbstractPageFlowProcessor.java:112)
	at com.primeton.access.http.impl.ProcessorWebInterceptor.doIntercept(ProcessorWebInterceptor.java:105)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:131)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:124)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at org.gocom.components.coframe.auth.intercepter.FunctionWebInterceptor.doIntercept(FunctionWebInterceptor.java:84)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at org.gocom.components.coframe.auth.intercepter.UserLoginWebInterceptor.doIntercept(UserLoginWebInterceptor.java:84)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.security.HttpRefererWebInterceptor.doIntercept(HttpRefererWebInterceptor.java:47)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.security.HttpSecurityWebInterceptor.doIntercept(HttpSecurityWebInterceptor.java:40)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:133)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:662)
[FlowName=com.primeton.eos1.ooperatorbiz.queryOOperators.biz][activity name=queryEntitiesByCriteriaEntityWithPage][activity id=invokePojo0][exception=ErrCode: 14101000
Message: 未知异常(You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator this_ left outer join o_org oorg2_ on this_.oOrg=oorg2_.ORG_ID l...' at line 1)]
[default][2020-12-01 16:44:04,120][ERROR][com.primeton.access.client.impl.skeleton.ServiceEngine:38] 
ErrCode: 14101000
Message: 未知异常(You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator this_ left outer join o_org oorg2_ on this_.oOrg=oorg2_.ORG_ID l...' at line 1)
	at com.primeton.das.entity.impl.exception.DASExceptionHelper.convert(DASExceptionHelper.java:169)
	at com.primeton.das.entity.impl.DASSessionImpl.countBySubQuery(DASSessionImpl.java:497)
	at com.primeton.das.entity.impl.DASSessionImpl.count(DASSessionImpl.java:558)
	at com.eos.foundation.database.DatabaseUtil.count(DatabaseUtil.java:987)
	at com.eos.foundation.database.Pagination.doQuery(Pagination.java:485)
	at com.eos.foundation.database.Pagination.doQueryPageCond(Pagination.java:515)
	at com.eos.foundation.database.DatabaseExt.queryEntitiesByCriteriaEntityWithPage(DatabaseExt.java:441)
	at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.invokePojo0(queryOOperators_biz.java:210)
	at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.__choiceinvokePojo0(queryOOperators_biz.java:424)
	at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.__invokeBiz(queryOOperators_biz.java:370)
	at com.primeton.eos1.ooperatorbiz.queryOOperators_biz._invoke(queryOOperators_biz.java:256)
	at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.invoke(queryOOperators_biz.java:321)
	at com.primeton.engine.core.impl.process.BLProxy.invoke(BLProxy.java:223)
	at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:112)
	at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:80)
	at com.primeton.ext.engine.component.Operation.invoke(Operation.java:100)
	at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:183)
	at com.primeton.access.client.impl.skeleton.BizLogicReceiveTarget.invoke(BizLogicReceiveTarget.java:50)
	at com.primeton.access.client.impl.skeleton.ServiceEngine.receive(ServiceEngine.java:36)
	at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invokeService(DefaultServiceSkeleton.java:130)
	at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invoke(DefaultServiceSkeleton.java:32)
	at com.primeton.access.client.impl.ClientMessageInterceptor.invoke(ClientMessageInterceptor.java:57)
	at com.primeton.system.aop.impl.HandlerInvoker.invoke(HandlerInvoker.java:60)
	at com.primeton.system.aop.impl.JdkProxyUtil$JdkInvocationHandlerWrapper.invoke(JdkProxyUtil.java:53)
	at com.sun.proxy.$Proxy38.invoke(Unknown Source)
	at com.primeton.eos1.OOperatorMaintain_flow.subprocess0(OOperatorMaintain_flow.java:324)
	at com.primeton.eos1.OOperatorMaintain_flow._pageQuery(OOperatorMaintain_flow.java:454)
	at com.primeton.eos1.OOperatorMaintain_flow.process(OOperatorMaintain_flow.java:1635)
	at com.primeton.engine.core.impl.process.PageflowInstance.process(PageflowInstance.java:325)
	at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.doProcess(AbstractPageFlowProcessor.java:330)
	at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.process(AbstractPageFlowProcessor.java:112)
	at com.primeton.access.http.impl.ProcessorWebInterceptor.doIntercept(ProcessorWebInterceptor.java:105)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:131)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:124)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at org.gocom.components.coframe.auth.intercepter.FunctionWebInterceptor.doIntercept(FunctionWebInterceptor.java:84)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at org.gocom.components.coframe.auth.intercepter.UserLoginWebInterceptor.doIntercept(UserLoginWebInterceptor.java:84)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.security.HttpRefererWebInterceptor.doIntercept(HttpRefererWebInterceptor.java:47)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.security.HttpSecurityWebInterceptor.doIntercept(HttpSecurityWebInterceptor.java:40)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:133)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:662)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator this_ left outer join o_org oorg2_ on this_.oOrg=oorg2_.ORG_ID l...' at line 1
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	at com.primeton.ext.infra.connection.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:110)
	at com.primeton.das.entity.impl.DASSessionImpl.countBySubQuery(DASSessionImpl.java:479)
	... 65 more
[FlowName=com.primeton.eos1.OOperatorMaintain.flow][activity name=queryOOperators][activity id=subprocess0][exception=ErrCode: 14101000
Message: 未知异常(You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator this_ left outer join o_org oorg2_ on this_.oOrg=oorg2_.ORG_ID l...' at line 1)]
[default][2020-12-01 16:44:04,122][ERROR][com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor:371] error [com.primeton.eos1.OOperatorMaintain.flow?_flowKey=bcf9ec3c-e84d-42b8-abc4-d244fb0710cd.null]
ErrCode: 14101000
Message: 未知异常(You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator this_ left outer join o_org oorg2_ on this_.oOrg=oorg2_.ORG_ID l...' at line 1)
	at com.primeton.das.entity.impl.exception.DASExceptionHelper.convert(DASExceptionHelper.java:169)
	at com.primeton.das.entity.impl.DASSessionImpl.countBySubQuery(DASSessionImpl.java:497)
	at com.primeton.das.entity.impl.DASSessionImpl.count(DASSessionImpl.java:558)
	at com.eos.foundation.database.DatabaseUtil.count(DatabaseUtil.java:987)
	at com.eos.foundation.database.Pagination.doQuery(Pagination.java:485)
	at com.eos.foundation.database.Pagination.doQueryPageCond(Pagination.java:515)
	at com.eos.foundation.database.DatabaseExt.queryEntitiesByCriteriaEntityWithPage(DatabaseExt.java:441)
	at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.invokePojo0(queryOOperators_biz.java:210)
	at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.__choiceinvokePojo0(queryOOperators_biz.java:424)
	at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.__invokeBiz(queryOOperators_biz.java:370)
	at com.primeton.eos1.ooperatorbiz.queryOOperators_biz._invoke(queryOOperators_biz.java:256)
	at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.invoke(queryOOperators_biz.java:321)
	at com.primeton.engine.core.impl.process.BLProxy.invoke(BLProxy.java:223)
	at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:112)
	at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:80)
	at com.primeton.ext.engine.component.Operation.invoke(Operation.java:100)
	at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:183)
	at com.primeton.access.client.impl.skeleton.BizLogicReceiveTarget.invoke(BizLogicReceiveTarget.java:50)
	at com.primeton.access.client.impl.skeleton.ServiceEngine.receive(ServiceEngine.java:36)
	at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invokeService(DefaultServiceSkeleton.java:130)
	at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invoke(DefaultServiceSkeleton.java:32)
	at com.primeton.access.client.impl.ClientMessageInterceptor.invoke(ClientMessageInterceptor.java:57)
	at com.primeton.system.aop.impl.HandlerInvoker.invoke(HandlerInvoker.java:60)
	at com.primeton.system.aop.impl.JdkProxyUtil$JdkInvocationHandlerWrapper.invoke(JdkProxyUtil.java:53)
	at com.sun.proxy.$Proxy38.invoke(Unknown Source)
	at com.primeton.eos1.OOperatorMaintain_flow.subprocess0(OOperatorMaintain_flow.java:324)
	at com.primeton.eos1.OOperatorMaintain_flow._pageQuery(OOperatorMaintain_flow.java:454)
	at com.primeton.eos1.OOperatorMaintain_flow.process(OOperatorMaintain_flow.java:1635)
	at com.primeton.engine.core.impl.process.PageflowInstance.process(PageflowInstance.java:325)
	at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.doProcess(AbstractPageFlowProcessor.java:330)
	at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.process(AbstractPageFlowProcessor.java:112)
	at com.primeton.access.http.impl.ProcessorWebInterceptor.doIntercept(ProcessorWebInterceptor.java:105)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:131)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:124)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at org.gocom.components.coframe.auth.intercepter.FunctionWebInterceptor.doIntercept(FunctionWebInterceptor.java:84)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at org.gocom.components.coframe.auth.intercepter.UserLoginWebInterceptor.doIntercept(UserLoginWebInterceptor.java:84)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.security.HttpRefererWebInterceptor.doIntercept(HttpRefererWebInterceptor.java:47)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.security.HttpSecurityWebInterceptor.doIntercept(HttpSecurityWebInterceptor.java:40)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:133)
	at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
	at com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:662)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator this_ left outer join o_org oorg2_ on this_.oOrg=oorg2_.ORG_ID l...' at line 1
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	at com.primeton.ext.infra.connection.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:110)
	at com.primeton.das.entity.impl.DASSessionImpl.countBySubQuery(DASSessionImpl.java:479)
	... 65 more

1202error01

下面操作文档的HTML代码,其中,引入的JS(nui.js)路径【src=“common/nui/nui.js” 】

<!DOCTYPE html />
 
<html>
<head>
    <title>Hello NUI!</title>
    <!-NUI->
    <script src="common/nui/nui.js" type="text/javascript"></script>
</head>
<body>
    <input id="helloBtn" class="nui-button" text="Hello" onclick="onHelloClick"/>
    <script type="text/javascript">
        function onHelloClick(e){ 
            var button = e.sender; 
            nui.alert("Hello NUI!"); 
        }
    </script>
</body>
</html>

在工作空间导入的现成页面可以正常展示,引入的JS路径【<%@include file="/nui/common.jsp"%> 】和【

<link id="css_skin" rel="stylesheet" type="text/css"
	  href="<%=contextPath%>/coframe/tools/skins/skin1/style.css" />

】完整代码如下:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@page pageEncoding="UTF-8"%>
<%@include file="/nui/common.jsp"%>
<link id="css_skin" rel="stylesheet" type="text/css"
	  href="<%=contextPath%>/coframe/tools/skins/skin1/style.css" />
<html>
<!-- 
  - Author(s): JFree
  - Date: 2013-03-19 17:01:14
  - Description:
-->
<head>
    <title>Hello, world!</title>
    
</head>
<body >
    <input id="helloBtn" class="nui-button" text="Hello" onclick="onHelloClick"/>
    <script type="text/javascript">
        function onHelloClick(e) {
            var button = e.sender;
            nui.alert("Hello NUI!");
        }
    </script>
</body>
</html>

其中【/nui/common.jsp】引入了操作文档的JS文件(nui.js)代码如下:

<%
	String contextPath=request.getContextPath();
%>

<script type="text/javascript" src="<%=contextPath%>/common/nui/nui.js"></script>
<script>
	$(function(){
		nui.context='<%=contextPath %>'
	})
</script>

上面代码中 request.getContextPath();是获取站点根路径,就是webContent(MyEclipse中是webRoot),但是在此路径下不存在【/common/nui/nui.js】文件,网络关于此函数【request.getContextPath();】介绍: 点击此处查看360文档.
或: 点击此处查看博客园文档.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值