nodejs 连接数据库 并在数据库上进行增删改查操作

第一步：
安装

npm install mysql

第二步:连接数据库

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'me',
  password : 'secret',
  database : 'my_db'
});
 
connection.connect();
 
connection.query('SELECT 1 + 1 AS solution', function (error, results, fields) {
  if (error) throw error;
  console.log('The solution is: ', results[0].solution);
});
 
connection.end();

查询：

//查询
// connection.query('SELECT * from users', function (error, results, fields) {
//     if (error) throw error;
//     console.log('The solution is: ', results);
// });
//查询一个
// connection.query('SELECT * from users WHERE id=?', ['2'], function (error, results, fields) {
//     if (error) throw error;
//     console.log('The solution is: ', results);
// });

添加：

//添加
// var post = {
//     slug: 'aaa',
//     email: 'ss@qq.oo',
//     password: 'wanglei22',
//     nickname: '汪磊22',
//     avatar: '/static/uploads/avatar.jpg',
//     bio: null,
//     status: 'activated'
// };
// var query = connection.query('INSERT INTO users SET ?', post, function (error, results, fields) {
//     if (error) throw error;
//     console.log(results.affectedRows)
// });

修改：

//修改
var updatSQL = 'UPDATE users SET ? WHERE id =?'
connection.query(updatSQL, [{slug: 'lis3', password: '4567774'}, 2], function (error, results, fields) {
    if (error) throw error;
    // ...
});

删除：

//删除
connection.query('DELETE FROM users WHERE id =?', ['2'], function (error, results, fields) {
    if (error) throw error;
    console.log('The solution is: ', results);
});