ajax+jquary+mysql学生信息管理系统问题记录

网页跳转带值传递

使用js带值进行跳转，目标网页接收这个值(例如此处需要传递的id为3045)

 location.href = "student.html?user_id=" + user_id;

var user_id = $.query.get("user_id");	//user_id=3045

ajax的get请求与controller

$.ajax({
                    type: 'get',
                    url: '/users/editPasswords/' + user_id,
                    dataType: 'json',
                    success: function(data) {
                        console.log(data);
                    },
                    error: function(data) {
                        console.log("false");
                    }
                });

exports.editPasswords = (req, res) => {
    let info = req.params.user_id;
    let sql = "select * from t_user where user_id=?";
    db.base(sql, info, (result) => {
        res.json(result[0]);	//这里使用result[0]而不是result，否则会返回404
    });
};