为什么我在数据存入这部分总出错哪位大神能帮帮忙

drz · 发表于 2017-1-9 09:52:07

这是设计里面显示的错误：
一月 09, 2017 9:36:36 上午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet WeX5_Baas_Servlet threw exception
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'fID' cannot be null
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
at com.mysql.jdbc.Util.getInstance(Util.java:383)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1193)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at com.justep.baas.data.DataUtils.saveData(Unknown Source)
at com.justep.baas.data.DataUtils.saveData(Unknown Source)
at com.justep.baas.action.CRUD.save(Unknown Source)
at sxwm.New_action__do.saveNeworder(New_action__do.java:267)
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.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)

drz · 发表于 2017-1-9 09:54:12

file:///C:/Users/Administrator/Desktop/YYPDF%E6%88%AA%E5%9B%BE20171995114.png

这是js里面的数据存入代码

drz · 发表于 2017-1-9 09:56:12

这是js里面的数据存入代码

Model.prototype.button4Click = function(event){
      var self=this;
      var orderData = this.comp("orderData");
var cartData = this.comp("cartData");
var userData = this.comp("userData");
var statusData = this.comp("statusData");

   orderData.newData({
"defaultValues ": [ {
"fID" : justep.UUID.createUUID(),
"fCreatTime" : userData.val("fCreatTime"),
"fUserID" : userData.val("fID"),
"fYName" : userData.val("fName"),
"fYCount" : userData.val("fCount"),
"fPhone" : userData.val("fPhone"),
"fName" : cartData.val("fName"),
"fPrice" : cartData.val("fPrice"),
"fCount" : cartData.val("fCount"),
"fSum" : statusData.val("calcCartSumMoneyText")
} ]
});
orderData.saveData({
onSuccess:function(event){
justep.Util.hint("下单成功，谢谢您的订餐！");
cartData.clear();
}
});
orderData.refreshData();
};

drz · 发表于 2017-1-9 09:59:35

这是浏览器显示的错误

GET http://localhost:35729/livereload.js?_=1483925760971 net::ERR_CONNECTION_REFUSED
send @ core.min.js:65
h.extend.ajax @ core.min.js:65
h.(anonymous function) @ core.min.js:65
h.extend.getScript @ core.min.js:65
(anonymous function) @ core.min.js:65
core.min.js:65
POST http://localhost:8080/baas/sxwm/new_action/saveNeworder 500 (Internal Server Error)
send @ core.min.js:65
h.extend.ajax @ core.min.js:65
r.sendRequest @ core.min.js:65
r.extend.doSaveData @ common.min.js:7
justep.ModelComponent.extend.saveData @ common.min.js:7
Model.button4Click @ cdActivity.js:67
r.extend.fire @ core.min.js:65
r.extend.fireEvent @ core.min.js:65
n.callParent @ core.min.js:65
Component.extend.fireEvent @ common.min.js:7
n.BindComponent.extend._doClick @ comp.min.js:144
h.isFunction.i @ core.min.js:65
h.event.dispatch @ core.min.js:65
g.handle @ core.min.js:65

drz · 发表于 2017-1-9 10:00:48

新手找了两天实在找不出问题希望懂的大神可以告诉我一下感谢

liangyongfei · 发表于 2017-1-9 14:25:51

drz 发表于 2017-1-9 10:00
新手找了两天实在找不出问题希望懂的大神可以告诉我一下感谢

后台报错是：
: Column 'fID' cannot be null

请问下，报错的操作action中，你是否限制了fID 不保存呢？？
报错信息来看fID 字段不存在

请问你的orderData定义的字段！是否存在fID 字段（注意大小写！必须一致）
idColumn 属性是他吗？

drz · 发表于 2017-1-10 02:14:11

liangyongfei 发表于 2017-1-9 14:25
后台报错是：
: Column 'fID' cannot be null

存在fID的。idColumn的属性就是fID 我也不知道这个id哪里出了问题，找不出来。还有其他可能出错的原因吗

liangyongfei · 发表于 2017-1-10 10:40:42

drz 发表于 2017-1-10 02:14
存在fID的。idColumn的属性就是fID 我也不知道这个id哪里出了问题，找不出来。还有其他可能出错的原因吗 ...

自己debugger调试看下吧！确定是orderData 进行保存的时候报错的吗？？+
保存前先使用orderData.getID() 调试看下id列是否有值？？

后端的baasServer saveAction 中 permissions 参数中没有设置只保存某些字段吧

		自动登录	找回密码
密码			注册

[处理中3] 为什么我在数据存入这部分总出错 哪位大神能帮帮忙

[处理中3] 为什么我在数据存入这部分总出错哪位大神能帮帮忙