nodejs脚手架express-generator

1.安装生成器

npm install express-generator -g

2. 创建名称为APP的应用：

express my-project

3.安装依赖包

cd my-project

npm install

4、启动应用

npm start

5、在浏览器中使用 localhost:3000访问

　　默认的端口就是3000

　　更改端口：

　　　　路径：app/bin/www

　　　　var port = normalizePort(process.env.PORT || '3000');

6、设置请求跨域头

// app.js

app.all('*', function(req, res, next) {

  res.header("Access-Control-Allow-Origin", "http://localhost:3000");

  res.header("Access-Control-Allow-Origin", "http://localhost:8080");

  res.header("Access-Control-Allow-Origin", "http://127.0.0.1:8080");

  // res.header("Access-Control-Allow-Origin", "*");

  res.header("Access-Control-Allow-Headers", "X-Requested-With,Content-Type");

  res.header("Access-Control-Allow-Methods","PUT,POST,GET,DELETE,OPTIONS");

  next();

});

注：该模板默认用的是 .jade 文件作为模板渲染若要使用 ejs 可按照一下方法配置

1、安装 ejs

npm install ejs -S

2、在app.js中添加一下代码

var ejs = require('ejs');

app.engine('.html', ejs.__express);

app.set('view engine', 'html');

3、将view文件夹中的模板替换成 .html 文件即可（每次配置一个路由需要重新启动一下服务器）

参考文档：

https://www.jianshu.com/p/b555ba6f4067

mysql数据库配置

1、安装mysql

npm install mysql -S

2、建立对应的文件

//mysql.js

// MySQL数据库联接配置封裝

var mysql = {

    host: '127.0.0.1',

    user: 'root',

    password: 'tll456456',

    database: 'test',

    port: 3306

};

module.exports = mysql;

//handel.js

/*

    数据增删改查模块封装

    req.query 解析GET请求中的参数 包含在路由中每个查询字符串参数属性的对象，如果没有则为{}

    req.params 包含映射到指定的路线“参数”属性的对象,如果有route/user/：name，那么“name”属性可作为req.params.name

    req.body通常用来解析POST请求中的数据

     +req.query.id 可以将id转为整数

 */

// 引入mysql

var mysql = require('mysql');

// 引入mysql连接配置

var mysqlconfig = require('../config/mysql');

// 引入连接池配置

var poolextend = require('./poolextend');

// 引入SQL模块

var sql = require('./sql');

// 引入json模块

var json = require('./json');

// 使用连接池，提升性能

var pool = mysql.createPool(poolextend({}, mysqlconfig));

var userData = {

    add: function(req, res, next) {

        pool.getConnection(function(err, connection) {

            var param = req.query || req.params;

            connection.query(sql.insert, [param.id, param.name, param.age], function(err, result) {

                if (result) {

                    result = 'add'

                }

                // 以json形式，把操作结果返回给前台页面

                json(res, result);

                // 释放连接

                connection.release();

            });

        });

    },

    delete: function(req, res, next) {

        pool.getConnection(function(err, connection) {

            var id = +req.query.id;

            connection.query(sql.delete, id, function(err, result) {

                if (result.affectedRows > 0) {

                    result = 'delete';

                } else {

                    result = undefined;

                }

                json(res, result);

                connection.release();

            });

        });

    },

    update: function(req, res, next) {

        var param = req.body;

        if (param.name == null || param.age == null || param.id == null) {

            json(res, undefined);

            return;

        }

        pool.getConnection(function(err, connection) {

            connection.query(sql.update, [param.name, param.age, +param.id], function(err, result) {

                if (result.affectedRows > 0) {

                    result = 'update'

                } else {

                    result = undefined;

                }

                json(res, result);

                connection.release();

            });

        });

    },

    queryById: function(req, res, next) {

        var id = +req.query.id;

        pool.getConnection(function(err, connection) {

            connection.query(sql.queryById, id, function(err, result) {

                if (result != '') {

                    var _result = result;

                    result = {

                        result: 'select',

                        data: _result

                    }

                } else {

                    result = undefined;

                }

                json(res, result);

                connection.release();

            });

        });

    },

    queryAll: function(req, res, next) {

        pool.getConnection(function(err, connection) {

            connection.query(sql.queryAll, function(err, result) {

                if (result != '') {

                    var _result = result;

                    result = {

                        result: 'selectall',

                        data: _result

                    }

                } else {

                    result = undefined;

                }

                json(res, result);

                connection.release();

            });

        });

    }

};

module.exports = userData;

//json.js

//封装接送模块

var json = function(res, result) {

    if (typeof result === 'undefined') {

        res.json({

            code: '1',

            msg: '操作失败'

        });

    } else if (result === 'add') {

        res.json({

            code: '200',

            msg: '添加成功'

        });

    } else if (result === 'delete') {

        res.json({

            code: '200',

            msg: '删除成功'

        });

    } else if (result === 'update') {

        res.json({

            code: '200',

            msg: '更改成功'

        });

    } else if (result.result != 'undefined' && result.result === 'select') {

        res.json({

            code: '200',

            msg: '查找成功',

            data: result.data

        });

    } else if (result.result != 'undefined' && result.result === 'selectall') {

        res.json({

            code: '200',

            msg: '全部查找成功',

            data: result.data

        });

    } else {

        res.json(result);

    }

};

module.exports = json;

//poolextent.js

// 连接池扩展封装

var poolextend = function(target, source, flag) {

    for (var key in source) {

        if (source.hasOwnProperty(key)) {

            flag ? (target[key] = source[key]) : (target[key] === void 0 && (target[key] = source[key]));

        }

    }

    return target;

}

module.exports = poolextend;

//sql.js

// SQL语句封裝

var user = {

    insert:'INSERT INTO user(id, name, age) VALUES(?,?,?)',

    update:'UPDATE user SET name=?, age=? WHERE id=?',

    delete: 'DELETE FROM user WHERE id=?',

    queryById: 'SELECT * FROM user WHERE id=?',

    queryAll: 'SELECT * FROM user'

};

module.exports = user;

//router/index.js

var express = require('express');

var router = express.Router();

var user = require('../modules/handle');

/* GET users listing. */

router.get('/', function(req, res, next) {

  res.render('index', { title: 'SQL for MySQL' });

});

router.get('/addUser', function(req, res, next) {

    user.add(req, res, next);

});

router.get('/queryAll', function(req, res, next) {

    user.queryAll(req, res, next);

});

router.get('/query', function(req, res, next) {

    user.queryById(req, res, next);

});

router.get('/deleteUser', function(req, res, next) {

    user.delete(req, res, next);

});

router.get('/update', function(req, res, next) {

    res.render('update');

});

router.post('/updateUser', function(req, res, next) {

    user.update(req, res, next);

});

module.exports = router;

//index.jade

extends layout

block content

  h1= title

  p

  a(class={active: currentUrl === '/'} href='/queryAll')     数据查询

  p

  a(class={active: currentUrl === '/'} href='/query?id=1')     定向查询

  p

  a(class={active: currentUrl === '/'} href='/addUser?id=0&name=xyz&age=18')    数据插入

  p

  a(class={active: currentUrl === '/'} href='/update')   数据更新

  p

  a(class={active: currentUrl === '/'} href='/deleteUser?id=0')    数据删除

  p

//layout.jade

doctype html

html

  head

    title= title

    link(rel='stylesheet', href='/stylesheets/style.css')

  body

    block content

//update.jade

extends layout

block content

    h1 更新用户资料

    form(method='post', action='updateUser')

        div.form-row

            label

                span ID:

                input(type='text',name='id')

        div.form-row

            label

                span name:

                input(type='text',name='name')

        div.form-row

            label

                span age:

                input(type='text',name='age')

        div.form-row

            input(type='submit')

巴特西