node.js - express无法向mysql写入数据？

问题描述

问 题

jade代码：

$.ajax({
                    url: 'index/index1post',
                    data: {
                        lv: $('#u1').val(),
                        username: $('#u2').val(),
                        userpwd: $('#u3').val()
                    },
                    type: 'POST',
                    timeout: 36000,
                    dataType: 'text',
                    success: function (data, textStatus) {
                    }

index.js代码：

var express = require('express');
var router = express.Router();
var mysql = require('mysql');
var config = require('../config');
var pool = mysql.createPool(config.mysql);
router.get('/', function(req, res, next) {
  res.render('index');
});
router.post('/index1post',function (req,res,next) {
    var lv = req.body.lv;
    var username = req.body.username;
    var userpwd = req.body.userpwd;
    pool.getConnection(function (err,connection) {
        var $sql = 'INSERT INTO user(id, lv, username, userpwd) VALUES(0, ?, ?, ?)';
        connection.query($sql,[lv, username, userpwd],function (err,result) {
        });
        connection.release();
    });
});
module.exports = router;

一直报错：

POST /index/index1post 404 115.733 ms - 1223  

补充app.js

var express = require('express');
var path = require('path');
var favicon = require('serve-favicon');
var logger = require('morgan');
var cookieParser = require('cookie-parser');
var bodyParser = require('body-parser');
var multer  = require('multer');
var storage = multer.diskStorage({
    destination: function (req, file, cb) {
        cb(null, './uploads')
    },
    filename: function (req, file, cb) {
        //var fileFormat = (file.originalname).split(".");
        cb(null, file.originalname)
    }
});
var upload = multer({ storage: storage });


var index = require('./routes/index');
var users = require('./routes/users');
var login = require('./routes/login');
var input1 = require('./routes/input1');
var input2 = require('./routes/input2');
var input3 = require('./routes/input3');
var input4 = require('./routes/input4');
var input5 = require('./routes/input5');
var input6 = require('./routes/input6');
var detail = require('./routes/detail');
var detail2 = require('./routes/detail2');
var equip = require('./routes/equip');
var user = require('./routes/user');


var app = express();
app.post('/upload', upload.single('avatar'),function (req,res,next) {
    var path = req.file.originalname;
    console.log(path);
    res.render('input1',{path1:path});
});
// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'jade');

// uncomment after placing your favicon in /public
//app.use(favicon(path.join(__dirname, 'public', 'favicon.ico')));
app.use(logger('dev'));
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));

app.use('/', index);
app.use('/users', users);
app.use('/login', login);
app.use('/input1',input1);
app.use('/input2',input2);
app.use('/input3',input3);
app.use('/input4',input4);
app.use('/input5',input5);
app.use('/input6',input6);
app.use('/detail',detail);
app.use('/detail2',detail2);
app.use('/equip',equip);
app.use('/user',user);





// catch 404 and forward to error handler
app.use(function(req, res, next) {
  var err = new Error('Not Found');
  err.status = 404;
  next(err);
});

// error handler
app.use(function(err, req, res, next) {
  // set locals, only providing error in development
  res.locals.message = err.message;
  res.locals.error = req.app.get('env') === 'development' ? err : {};

  // render the error page
  res.status(err.status || 500);
  res.render('error');
});
module.exports = upload;

module.exports = app;

解决方案

你的module.exports = router;出去，是怎么被use的？代码贴出来看看，感觉是上下文有问题的， 父路由不对

这篇关于node.js - express无法向mysql写入数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！