nodejs中app.js连接数据库

var createError = require(‘http-errors’);
var express = require(‘express’);
var path = require(‘path’);
var cookieParser = require(‘cookie-parser’);
var bodyParser = require(‘body-parser’);
var logger = require(‘morgan’);

var indexRouter = require(’./routes/index’);
var usersRouter = require(’./routes/users’);
var mysql = require(“mysql”);

var app = express();
app.use(function(req,res,next){
req.db=mysql.createPool({
host:“localhost”,
user:“root”,
password:"",
database:“happy-new-year”
})
next()
})

// view engine setup
app.set(‘views’, path.join(__dirname, ‘views’));
app.set(‘view engine’, ‘ejs’);

app.use(logger(‘dev’));
app.use(express.json());
app.use(express.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(express.urlencoded({ extended: false }));
app.use(bodyParser.json());
app.use(express.static(path.join(__dirname, ‘public’)));

app.use(’/’, indexRouter);
app.use(’/users’, usersRouter);

// catch 404 and forward to error handler
app.use(function(req, res, next) {
next(createError(404));
});

// 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 = app;

var createError = require(‘http-errors’);
var express = require(‘express’);
var path = require(‘path’);
var cookieParser = require(‘cookie-parser’);
var bodyParser = require(‘body-parser’);
var logger = require(‘morgan’);

var indexRouter = require(’./routes/index’);
var usersRouter = require(’./routes/users’);
var mysql = require(“mysql”);

var app = express();
app.use(function(req,res,next){
req.db=mysql.createPool({
host:“localhost”,
user:“root”,
password:"",
database:“happy-new-year”
})
next()
})

// view engine setup
app.set(‘views’, path.join(__dirname, ‘views’));
app.set(‘view engine’, ‘ejs’);

app.use(logger(‘dev’));
app.use(express.json());
app.use(express.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(express.urlencoded({ extended: false }));
app.use(bodyParser.json());
app.use(express.static(path.join(__dirname, ‘public’)));

app.use(’/’, indexRouter);
app.use(’/users’, usersRouter);

// catch 404 and forward to error handler
app.use(function(req, res, next) {
next(createError(404));
});

// 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 = app;