|
- SQL执行失败,com.mysql.jdbc.JDBC4PreparedStatement@15f8465:<font color="#ff0000"> INSERT INTO</font> promote_data_marketing_specialist (pd_ms_id,pd_ms_campus,pd_ms_date,pd_ms_effectivity,pd_ms_intention,pd_ms_name,pd_ms_real_number,pd_ms_sign,pd_ms_signup,pd_ms_signup_intention,pd_ms_time,pd_ms_to_floow_up,pd_ms_un_signup_intention,pd_ms_visit,pd_ms_week_attendance,pd_ms_week_payment,pd_ms_week_sign,pd_ms_wrong_number) VALUES (2,'test2','2017-04-06',1,null,'李四',null,15,1,null,null,1,null,20,null,null,null,0)
- com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:<font color="#ff0000"> Duplicate entry '2' for key 'PRIMARY'</font>
复制代码
------------------------------------------------------------------------------------------------
以上是eclipse错误代码,我在参考了记账本的时候 发现新增可以插入,但是修改的时候sql语句怎么是insert into 不应该是update么。下面是我参考的记账本源码,完全按照edit事件写的
- Model.prototype.modelParamsReceive = function(event){
- // 对话框接收参数后,新增或编辑
- var accountData = this.comp("accountData");
- accountData.clear();
- this.operator = event.params.operator;
- if (this.operator == "new") {
- accountData.newData({
- "defaultValues" : [ {
- "fID" : justep.UUID.createUUID(),
- "fCreateTime" : new Date(),
- "fDate" : new Date(),
- "fType" : "支出",
- "fClass" : this.getDefaultClass("支出")
- } ]
- });
- }<font color="#ff0000"> else if (this.operator == "edit") {
- accountData.loadData([ event.params.rowData ]);
- accountData.first();
- }</font>
- };
复制代码
|
|