2021-05-22

app.post('/doupdate', function (req, res) {
	var form = new formidable.IncomingForm();
	form.parse(req, function (err, fields, files) {
		console.dir('获取到的表单数据======================' + fields)
		var sql = 'update users set name=?,age=?,classid=? where id' + fields.id;

		var editArr = [];
		for (var k in fields) {
			editArr.push(fields[k]);
		}
		var sql = mysql.format(sql, editArr);
		console.log('更新的sql===================' + sql);
		connection.query(sql, function (error, results, fields) {
			if (results.affectedRows > 0) {
				res.redirect('/index')
				res.end()
			} else {
				console.log('修改失败');
				res.end()
			}
		})
	})
})

app.get('/update', function (req, res) {
	url = req.url;

	id = urll.parse(url, true).query.id
	console.log('===========================要编辑的id' + id);
	var selectArr = [id]
	var sql = 'select * from users where id=' + id;
	console.log('mysql============' + sql);
	connection.query(sql, function (err, results, fields) {
		console.log('数据库查询结果+++++++++++++' + results);
		if (results.length > 0) {
			res.render('edit', {
				data: results
			})
			res.end()
		}
	})
})