1、安装mysql并添加依赖
$ npm install --save mysql
/routes/index.js
var express = require('express');
var router = express.Router();
var mysql = require('mysql');
var pool = mysql.createPool({
connectionLimit: 10,
host: 'localhost',
user: 'root',
password: '',
database: 'xkdb'
});
router.get('/', function (req, res, next) {
res.render('index', {title: 'Express'});
});
router.get('/json/db', function (req, res, next) {
pool.getConnection(function (err, connection) {
if (err) throw err;
var sqlStr='SELECT * FROM category';
connection.query(sqlStr, function (err, rows,fields) {
if (err) throw err;
res.render('json', {layout: null, results: JSON.stringify(rows),fields:JSON.stringify(fields)});
connection.release();
});
});
});
module.exports = router;
/views/json.handlebars
{{{results}}}