数据保存成功回调的方法也进了，就是数据库里没有数据

zhang6332

数据保存成功回调的方法也进了，就是数据库里没有数据写入怎末回事啊？alert('saveData2')这个弹窗都出来了，有没有遇到过的？求助，谢谢！！！

zhang6332

第三张图的debugger都生效了，说明已经进来了回调方法啊？sqliteUtil这个文件时WeX5中自带的，tx.executeSql(sql, param, function(tx, res) {

zhang6332

tx.executeSql(sql, param, function(tx, res) {
                                                        doSqlsSuccess();
                                                }这是js原生的操作数据库执行sql语句的方法还是Wex5特有的方法啊？怎末实现的？有原码吗，或者简单介绍下原理也行？我以前没有用过js直接操作数据库，以前都是发送请求给后台去操作数据库，也不知道js可以不可以？上网搜网上说可以，希望能够解答我的疑惑，谢谢！

liangyongfei

你先打包案例测试下
/UI2/demo/sqlite/simpleData/index.w
是否正常？
最终执行的sql语句是
getDataSaveSqls  里面的代码

data.saveData 执行保存。触发onCustomerRefresh 事件
你的数据行状态是什么？？
能不能保存是行状态决定的
http://docs.wex5.com/wex5-ui-question-list-2184/

zhang6332

liangyongfei 发表于 2018-6-26 09:52
你先打包案例测试下
/UI2/demo/sqlite/simpleData/index.w
是否正常？

我是直接点击下一步在button的点击事件里给baasdata赋值的，根本不存在’行对象的状态‘这个东西，怎末解决啊？

liangyongfei

zhang6332 发表于 2018-6-26 16:06
我是直接点击下一步在button的点击事件里给baasdata赋值的，根本不存在’行对象的状态‘这个东西，怎末解 ...

调用 .newData 方法 默认行状态就是  new

可以调用
data.getRowState(data.getCurrenRow())   行状态如果正确

调用data.saveData 时就可以保存成功 的啊！

你appLoader 运行案例 /UI2/demo/sqlite/simpleData/index.w
尝试一下是否正常？

zhang6332

liangyongfei 发表于 2018-6-26 16:09
调用 .newData 方法 默认行状态就是  new

可以调用

mainData.setValue(列名，value)；之后还要调用mainData.saveData才能保存到数据库吗???

zhang6332

liangyongfei 发表于 2018-6-26 16:09
调用 .newData 方法 默认行状态就是  new

可以调用

我加了saveData就会报这样的错误信息出来，怎么解决啊？我现在就想向数据库里多加一条数据，怎么就这么难呢？问了两星期了都没人给解决下，不要让我看资料，资料都看完了没用，能不能远程下啊？




2018-07-03 16:30:57 Action[em/emutils/saveYH_AQJCJL]执行失败，For input string: ""
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
        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: java.lang.NumberFormatException: For input string: ""
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
        at java.lang.Integer.parseInt(Integer.java:592)
        at java.lang.Integer.<init>(Integer.java:867)
        at com.justep.baas.data.Transform.jsonToValue(Unknown Source)
        at com.justep.baas.data.Transform.jsonToColumnValue(Unknown Source)
        at com.justep.baas.data.Transform.jsonToRow(Unknown Source)
        at com.justep.baas.data.Transform.jsonToTable(Unknown Source)
        at com.justep.baas.action.CRUD.save(Unknown Source)
        at em.Emutils__do.saveYH_AQJCJL(Emutils__do.java:1259)
        ... 20 more
七月 03, 2018 4:30:57 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet WeX5_Baas_Servlet threw exception
java.lang.NumberFormatException: For input string: ""
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
        at java.lang.Integer.parseInt(Integer.java:592)
        at java.lang.Integer.<init>(Integer.java:867)
        at com.justep.baas.data.Transform.jsonToValue(Unknown Source)
        at com.justep.baas.data.Transform.jsonToColumnValue(Unknown Source)
        at com.justep.baas.data.Transform.jsonToRow(Unknown Source)
        at com.justep.baas.data.Transform.jsonToTable(Unknown Source)
        at com.justep.baas.action.CRUD.save(Unknown Source)
        at em.Emutils__do.saveYH_AQJCJL(Emutils__do.java:1259)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
        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)

com.justep.baas.action.ActionException: Action[em/emutils/saveYH_AQJCJL]执行失败，For input string: ""
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
        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: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        ... 16 more
Caused by: java.lang.NumberFormatException: For input string: ""
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
        at java.lang.Integer.parseInt(Integer.java:592)
        at java.lang.Integer.<init>(Integer.java:867)
        at com.justep.baas.data.Transform.jsonToValue(Unknown Source)
        at com.justep.baas.data.Transform.jsonToColumnValue(Unknown Source)
        at com.justep.baas.data.Transform.jsonToRow(Unknown Source)
        at com.justep.baas.data.Transform.jsonToTable(Unknown Source)
        at com.justep.baas.action.CRUD.save(Unknown Source)
        at em.Emutils__do.saveYH_AQJCJL(Emutils__do.java:1259)
        ... 20 more

zhang6332

liangyongfei 发表于 2018-6-26 16:09
调用 .newData 方法 默认行状态就是  new

可以调用

我加了saveData就会报这样的错误信息出来，怎么解决啊？我现在就想向数据库里多加一条数据，怎么就这么难呢？问了两星期了都没人给解决下，不要让我看资料，资料都看完了没用，能不能远程下啊？
2018-07-03 16:30:57 Action[em/emutils/saveYH_AQJCJL]执行失败，For input string: ""
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
        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: java.lang.NumberFormatException: For input string: ""
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
        at java.lang.Integer.parseInt(Integer.java:592)
        at java.lang.Integer.<init>(Integer.java:867)
        at com.justep.baas.data.Transform.jsonToValue(Unknown Source)
        at com.justep.baas.data.Transform.jsonToColumnValue(Unknown Source)
        at com.justep.baas.data.Transform.jsonToRow(Unknown Source)
        at com.justep.baas.data.Transform.jsonToTable(Unknown Source)
        at com.justep.baas.action.CRUD.save(Unknown Source)
        at em.Emutils__do.saveYH_AQJCJL(Emutils__do.java:1259)
        ... 20 more
七月 03, 2018 4:30:57 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet WeX5_Baas_Servlet threw exception
java.lang.NumberFormatException: For input string: ""
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
        at java.lang.Integer.parseInt(Integer.java:592)
        at java.lang.Integer.<init>(Integer.java:867)
        at com.justep.baas.data.Transform.jsonToValue(Unknown Source)
        at com.justep.baas.data.Transform.jsonToColumnValue(Unknown Source)
        at com.justep.baas.data.Transform.jsonToRow(Unknown Source)
        at com.justep.baas.data.Transform.jsonToTable(Unknown Source)
        at com.justep.baas.action.CRUD.save(Unknown Source)
        at em.Emutils__do.saveYH_AQJCJL(Emutils__do.java:1259)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
        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)

com.justep.baas.action.ActionException: Action[em/emutils/saveYH_AQJCJL]执行失败，For input string: ""
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
        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: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        ... 16 more
Caused by: java.lang.NumberFormatException: For input string: ""
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
        at java.lang.Integer.parseInt(Integer.java:592)
        at java.lang.Integer.<init>(Integer.java:867)
        at com.justep.baas.data.Transform.jsonToValue(Unknown Source)
        at com.justep.baas.data.Transform.jsonToColumnValue(Unknown Source)
        at com.justep.baas.data.Transform.jsonToRow(Unknown Source)
        at com.justep.baas.data.Transform.jsonToTable(Unknown Source)
        at com.justep.baas.action.CRUD.save(Unknown Source)
        at em.Emutils__do.saveYH_AQJCJL(Emutils__do.java:1259)
        ... 20 more

liangyongfei

zhang6332 发表于 2018-7-3 16:36
我加了saveData就会报这样的错误信息出来，怎么解决啊？我现在就想向数据库里多加一条数据，怎么就这么难 ...

是不是数字类型的字段，你输入了字符串导致的？？
你检查下哪个字段是数字类型的？是否赋值了非数字的字符串？？

比如改成0  再保存  行不？？