使用前台数据修改数据库里面的数据总是失败
前端代码:
$.ajax({
url: 'guanli1/guanli1post3',
data: {
id2: $('.id').val(),
name: $('#a9').val(),
sex: $('#a10').val(),
depart: $('#a11').val(),
s1: $('#a12').val(),
s2: $('#a13').val(),
s3: $('#a14').val(),
s4: $('#a15').val(),
s5: $('#a16').val()
},
type: 'POST',
timeout: 36000,
dataType: 'text',
success: function (data, textStatus) {
}
js代码:
router.post('/guanli1post3',function (req,res,next) {
var id2 = req.body.id2;
var name = req.body.name;
var sex = req.body.sex;
var depart = req.body.depart;
var s1 = req.body.s1;
var s2 = req.body.s2;
var s3 = req.body.s3;
var s4 = req.body.s4;
var s5 = req.body.s5;
pool.getConnection(function (err,connection) {
var $sql2 = 'UPDATE person SET name='+name+',sex='+sex+
',depart='+depart+',s1='+s1 +',s2='+s2+',s3='+s3+
',s4='+s4+',s5='+s5+'where id='+id2;
connection.query($sql2,[id2, name, sex, depart, s1, s2, s3, s4, s5]
,function (err,result) {
});
});
});
执行以后数据库的数据没有变化 求教!
我传递的参数应该都是正确的。