nodejs连接MySQL数据库,更新删除数据都没问题,插入数据数据库没有,刷新也没有,不知道哪里出了问题
前端代码如下
js代码
var Duban = {
//增加一条督办数据
insertData( param ){
return 'insert into departlist (departName,things,from,leader,depart,charge,date,remarks,cancel) VALUES ("'+param.departName+'","'+param.things+'","'+param.from+'","'+param.leader+'","'+param.depart+'","'+param.charge+'","'+param.data+'","'+param.remarks+'"," ")';
},
//删除一条数据
delData( param ){
return "delete from departlist where id = '"+param.id+"'";
},
/* 更新一条督办 */
upData( param ){
return "update departlist set remarks = '"+param.remarks+"' where id = '"+param.id+"'";
}
}
exports = module.exports = Duban;
数据表