MySql:通过Node.js实现增删查改

1.安装mysql组件

npm install mysql

或者在package.json中添加

"dependencies": {
    "mysql": ""
  }

而后键入

npm install

2、创建连接测试脚本databaseConnect.js

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : '服务器地址',
  user     : '管理员账户',
  password : '管理员密码'
});

connection.connect();

connection.query('SELECT 1 + 1 AS solution', function(err, rows, fields) {
  if (err) throw err;
  console.log('The solution is: ', rows[0].solution);
});

connection.end();

3、测试脚本

node databaseConnect.js

4、向数据库添加数据

  var usr = {
    memberName: req.body.memberName,
    memberSchoolNumber: req.body.memberSchoolNumber,
    memberClassName: req.body.memberClassName,
    memberTel: req.body.memberTel,
    memberQQ: req.body.memberQQ,
    memberSex: req.body.memberSex,
    memberTeam: req.body.memberTeam,
    memberMessage: req.body.memberMessage,
  };
  connection.query('insert into tblMemberRegisInfo set ?', usr, function (err, result) {
    if (err) throw err;
    console.log('inserted complete');
    console.log(result);
    console.log('\n');
  });

5、查询数据库数据

 //显示查询数据
  connection.query('select * from tblMemberRegisInfo', function (err, rows, fields) {
    if (err) throw err;
    console.log('selected after deleted');
    for (var i = 0, usr; usr = rows[i++];) {
      console.log('user name=' + usr.memberName);
    }
    console.log('\n');
  });
最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容