关于数据保存

tlkj

执行KSQL出错, KSQL: INSERT INTO t_person t_person(t_person, t_person.csrq, t_person.ddz_id, t_person.del_flag, t_person.gh, t_person.hw_fjh, t_person.hw_zxh, t_person.ry_id, t_person.rylb, t_person.shbm, t_person.tel, t_person.timestamp, t_person.user_id, t_person.xb, t_person.xm, t_person.ygkh, t_person.zt) VALUES (:t_person, :csrq, :ddz_id, :del_flag, :gh, :hw_fjh, :hw_zxh, :ry_id, :rylb, :shbm, :tel, :timestamp, :user_id, :xb, :xm, :ygkh, :zt),保存数据失败！
编码：JUSTEP150210
隐藏详细
java.lang.reflect.InvocationTargetException
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:606)
at com.justep.system.action.Engine.invokeActions(Native Method)
at com.justep.system.action.Engine.invokeActions(Unknown Source)
at com.justep.business.server.BusinessServer.doAction(Unknown Source)
at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at com.justep.x.bs.BusinessServerServlet.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 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)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO t_person t_person(t_person, t_person.csrq, t_person.ddz_id, t_person.del_flag, t_person.gh, t_person.hw_fjh, t_person.hw_zxh, t_person.ry_id, t_person.rylb, t_person.shbm, t_person.tel, t_person.timestamp, t_person.user_id, t_person.xb, t_person.xm, t_person.ygkh, t_person.zt) VALUES (:t_person, :csrq, :ddz_id, :del_flag, :gh, :hw_fjh, :hw_zxh, :ry_id, :rylb, :shbm, :tel, :timestamp, :user_id, :xb, :xm, :ygkh, :zt)
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.impl.TableImpl.insert(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.BizData.save(Unknown Source)
at BizProcedure.save(BizProcedure.java:143)
... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO t_person (t_person.fid, t_person.CSRQ, t_person.DDZ_ID, t_person.DEL_FLAG, t_person.GH, t_person.HW_FJH, t_person.HW_ZXH, t_person.RY_ID, t_person.RYLB, t_person.SHBM, t_person.TEL, t_person.TIMESTAMP, t_person.USER_ID, t_person.XB, t_person.XM, t_person.YGKH, t_person.ZT) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), binds: [D70C9B3B02E649BBBD270D5C9C4FD9BD, 2016-02-25, null, null, 110, null, null, null, null, 第一作业区, 134262422222, null, null, 男, 猴赛雷, 13414, null]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 36 more
Caused by: java.sql.SQLException: 当 IDENTITY_INSERT 设置为 OFF 时，不能为表 't_person' 中的标识列插入显式值。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
... 37 more
关闭

jishuang

ava.sql.SQLException: 当 IDENTITY_INSERT 设置为 OFF 时，不能为表 't_person' 中的标识列插入显式值。

这个是数据库的标准错误，可以到网上查找相关的错误信息

tlkj

如图所示这里面是通过labelRadioGroup组件，然后有重新写了一个data通过name value的这种形式显示的，我数据库中存储的是数字，那么这个我应该怎么来保存到数据库呢？1：男，0：女 存到数据需要存这个数字

jishuang

this.comp("radiogroupxid").val()就可以获取到value的值啊

tlkj

根本取不到值啊。。。。

jishuang

labelRadioGroup具体的设置发一下

tlkj

jishuang 发表于 2016-2-17 17:35
labelRadioGroup具体的设置发一下

如图所示

jishuang

如果要显示name存的是value
设置的时候把bind-itemsetValue设置为ref('value')
把bind-itemsetLabel设置为ref('name')

获取选择的值，也可以通过data中的getValue方法获取
this.comp('ryData').getValue("xb")