1.在已经搭建好的nodejs+express+ejs框架中创建config目录,在目录中创建db.js里面写入如下代码:
var mysql = require('mysql');
/** 配置mysql的参数 */
var pool = mysql.createPool({
host:'localhost',
user:'root',
password:'root',
database:'test'
});
/** 数据库链接 */
function query(sql,callback){
pool.getConnection(function(err,connection){
connection.query(sql,function(err,rows){
callback(err,rows);
//释放链接
connection.release();
});
});
}
exports.query = query;
2.在routes目录中创建users.js里面写入如下代码:
var express = require('express');
var router = express.Router();
var db = require('../config/db');
/* 查询数据库数据 */
router.get('/', function(req, res) {
var sql = 'select * from users';
db.query(sql,function(err,rows){
if(err){
res.render('user/userList', {title: '我的测试', datas: []});
}else {
res.render('user/userList', {title: '我的测试', datas: rows});
}
});
});
/**
* 新增页面跳转
*/
router.get('/add', function (req, res) {
res.render('user/addUser');
});
router.post('/add', function (req, res) {
var name = req.body.name;
var age = req.body.age;
var sql =