express使用

express使用

• npm init
  首先创建一个项目，之后初始化为npm类型的项目，要生成node的基本项目，需要使用npm init 进行初始化
• npm install express --save
  下一步使用npm安装express，由于express仅仅只是存在在当前项目中，所以安装不用使用-g进行全局安装，但是需要增加–save的参数，这个表示会把这些信息添加到package.json的依赖中
• 使用淘宝 NPM 镜像
  npm install -g cnpm --registry=https://registry.npm.taobao.org
• 安装插件
  cnpm install body-parser --save
  cnpm install cookie-parser --save
  cnpm install multer --save

express实例 1

express_demo.js

var express = require('express');
var app = express();
var bodyParser = require('body-parser');
var cookieParser = require('cookie-parser');
var fs = require("fs");
var util = require('util');

 创建 application/x-www-form-urlencoded 编码解析
//var urlencodedParser = bodyParser.raw({ extended: false })

app.use(cookieParser());
app.use(express.static('Content'));
app.use(bodyParser());

//  主页输出 "Hello World"
app.get('/', function (req, res) {
    console.log("主页 GET 请求");
    console.log("Cookies: ", req.cookies);
    //res.send('Hello GET');
    // 输出 JSON 格式
    response = {
        first_name: req.query.first_name,
        last_name: req.query.last_name
    };
    console.log(response);
    res.send(JSON.stringify(response));
})
//  POST 请求
app.post('/', function (req, res) {
    console.log("主页 POST 请求");
    //res.send('Hello POST');
    // 输出 JSON 格式
    //请求json格式：  {"first_name":"pkm","last_name":"test1"}  类型 application/json
    response = {
        first_name: req.body.first_name,
        last_name: req.body.last_name
    };
    console.log("准备写入文件");
    fs.writeFile('input.txt', util.inspect(req), function (err) {
        if (err) {
            return console.error(err);
        }
        console.log("数据写入成功！");

    });
    console.log(res);
    res.end(JSON.stringify(response));
})
var server = app.listen(8888, function () {
    var host = server.address().address
    var port = server.address().port
    console.log("应用实例，访问地址为 http://%s:%s", host, port)
}) 

运行

node express_demo.js
http://localhost:8888/?first_name=a&last_name=b

示例：RESTFul API使用

service_rest.js

var express = require('express');
var app = express();
var fs = require("fs");

//添加的新用户数据
var user = {
    "user4": {
        "name": "mohit",
        "password": "password4",
        "profession": "teacher",
        "id": 4
    }
}

app.get('/listUsers', function (req, res) {
    fs.readFile(__dirname + "/" + "users.json", 'utf8', function (err, data) {
        console.log(data);
        res.end(data);
    });
})

app.get('/addUser', function (req, res) {
    // 读取已存在的数据
    fs.readFile(__dirname + "/" + "users.json", 'utf8', function (err, data) {
        //console.log(data);
        var dataJson = JSON.parse(data.trim());
        console.log(data.length);
        dataJson["user4"] = user["user4"];
        console.log(dataJson);
        res.end(JSON.stringify(dataJson));
    });
})
//http://localhost:8888/getUser/3
app.get('/getUser/:id', function (req, res) {
    // 首先我们读取已存在的用户
    fs.readFile(__dirname + "/" + "users.json", 'utf8', function (err, data) {
        data = JSON.parse(data.trim());
        var user = data["user" + req.params.id]
        console.log(user);
        res.end(JSON.stringify(user));
    });
})
//http://localhost:8888/deleteUser/3
app.get('/deleteUser/:id', function (req, res) {
    // First read existing users.
    fs.readFile(__dirname + "/" + "users.json", 'utf8', function (err, data) {
        data = JSON.parse(data.trim());
        delete data["user" + req.params.id];
        console.log(data);
        res.end(JSON.stringify(data));
    });
})
var server = app.listen(8888, function () {
    var host = server.address().address
    var port = server.address().port
    console.log("应用实例，访问地址为 http://%s:%s", host, port)
}) 

users.json

{
	"user1": {
		"name": "mahesh",
		"password": "password1",
		"profession": "teacher",
		"id": 1
	},
	"user2": {
		"name": "suresh",
		"password": "password2",
		"profession": "librarian",
		"id": 2
	},
	"user3": {
		"name": "ramesh",
		"password": "password3",
		"profession": "clerk",
		"id": 3
	}
}

示例：Mysql操作

init sql

CREATE TABLE `websites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` char(20) NOT NULL DEFAULT '' COMMENT '站点名称',
  `url` varchar(255) NOT NULL DEFAULT '',
  `alexa` int(11) NOT NULL DEFAULT '0' COMMENT 'Alexa 排名',
  `country` char(10) NOT NULL DEFAULT '' COMMENT '国家',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

INSERT INTO `websites` VALUES ('1', 'Google', 'https://www.google.cm/', '1', 'USA'), ('2', '淘宝', 'https://www.taobao.com/', '13', 'CN'), ('3', '菜鸟教程', 'http://www.runoob.com/', '4689', 'CN'), ('4', '微博', 'http://weibo.com/', '20', 'CN'), ('5', 'Facebook', 'https://www.facebook.com/', '3', 'USA');

service_mysql.js

/**
安装Mysql模块
cnpm install mysql
*/
var http = require("http");
var mysql = require("mysql");

function serverOk(req,resp) {
    resp.writeHead(200,{"Content-type":"text/plain"});
    test2();
    resp.write("hello node module!");
    resp.end();
}
module.exports = {
    startServer: function(port) {
        http.createServer(serverOk).listen(port);
    }
}; 
function GetConnection() {
    var connection = mysql.createConnection({
        host: '192.168.5.72',
        user: 'root',
        password: 'xskj2018',
        database: 'test'
    });
    return connection;
}
function test2() {
    var connection = GetConnection();
    connection.connect();
    var sql = 'SELECT * FROM websites';
    //查
    connection.query(sql, function (err, result) {
        if (err) {
            console.log('[SELECT ERROR] - ', err.message);
            return;
        }
        console.log('--------------------------SELECT----------------------------');
        console.log(result);
        console.log('------------------------------------------------------------\n\n');
    });
    connection.end();
}
function test3() {
    var connection = GetConnection();
    connection.connect();
    var addSql = 'INSERT INTO websites(name,url,alexa,country) VALUES(?,?,?,?)';
    var addSqlParams = ['测试网站', 'http://www.test.com', '1222', 'CN'];
    //增
    connection.query(addSql, addSqlParams, function (err, result) {
        if (err) {
            console.log('[INSERT ERROR] - ', err.message);
            return;
        }
        console.log('--------------------------INSERT----------------------------');
        console.log('INSERT ID:',result.insertId);        
        console.log('INSERT ID:', result);
        console.log('-----------------------------------------------------------------\n\n');
    });
    connection.end();
}
function test4() {
    var connection = GetConnection();
    connection.connect();
    var modSql = 'UPDATE websites SET name = ?,url = ? WHERE Id = ?';
    var modSqlParams = ['测试网站6', 'http://www.test6.com', 6];
    //改
    connection.query(modSql, modSqlParams, function (err, result) {
        if (err) {
            console.log('[UPDATE ERROR] - ', err.message);
            return;
        }
        console.log('--------------------------UPDATE----------------------------');
        console.log('UPDATE affectedRows', result.affectedRows);
        console.log('-----------------------------------------------------------------\n\n');
    });
    connection.end();
}
function test5() {
    var connection = GetConnection();
    connection.connect();
    var delSql = 'DELETE FROM websites where id=?';
    var delSqlParams = [6];
    //删
    connection.query(delSql, delSqlParams, function (err, result) {
        if (err) {
            console.log('[DELETE ERROR] - ', err.message);
            return;
        }
        console.log('--------------------------DELETE----------------------------');
        console.log('DELETE affectedRows', result.affectedRows);
        console.log('-----------------------------------------------------------------\n\n');
    });
    connection.end();
}

module1.js

var Server = require("./service_mysql")
console.log(Server);//输出确定仅仅导出startServer
Server.startServer(8099);