node.js安装express以及连接数据库

一.添加express 项目框架
1.安装nodejs
2.  npm install -g exprsss
    cnpm install -g express-generator
3.express -e hello
4.cnpm install
5.cnpm start

二.数据库增删改查
1.连接数据库固定操作
var mysql      = require('mysql');
var connection = mysql.createConnection({
    host     : 'localhost',
    user     : 'root',
    password : '123456',
    database : 'nodetest1' //数据库名字(下面可以放很多张表) 注意连接名字叫nodesql
});
connection.connect();
2.添加语法
var addSql = "insert into websites(id,name,url,alex,country) values (0,?,?,?,?)"; //string
var addSqlParams = ['腾讯','www.qq.com','12312123','CN']; //array
connection.query(string,arr,(err,result)=>{

})

3.删除语法
var delSql = "delete from websites where id=2";
connection.query(delSql,function (err,result) {
    if(err){
        console.log('err'+err.message);
        return;
    }
    console.log('--------------update--------------');
    console.log('update ready:',result.affectedRows);
    console.log('----------------------------------');

})
4.修改语法
var modSql = "UPDATE  websites SET name = ?,url = ? WHERE Id = ?";
var modSqlParams = ['百度','www.baidu2.com','1'];
connection.query(modSql,modSqlParams,function (err,result) {
    if(err){
        console.log('err'+err.message);
        return;
    }
    console.log('--------------update--------------');
    console.log('update ready:',result.affectedRows);
    console.log('----------------------------------');

})

5.查询语法
var readSql = "select * from websites";
connection.query(readSql,function (err,result) {
    if(err){
        console.log('err'+err.message);
        return;
    }
    console.log('--------------update--------------');
    console.log('read all:',result);
    console.log('----------------------------------');

})