node.js学习5-mysql

1、数据库直连

首先我们需要先npm install mysql，接着在js文件中实现数据库的连接:

//index.js

var mysql = require("mysql");
var connection = mysql.createConnection({
  host: 'localhost',
  port: 3306,
  user: 'root',
  password: '5qbtsGKz%qa9',
  //这里必须保证本地的数据库中已经建了库'nodesys'
  database: 'nodesys'
})
connection.connect();
var myname = "张三";
var age = "12"
//这里的数据库nodesys中已经建了表'login_users'
connection.query("select * from login_users where name=? and age=?", [myname,age],(error,results,fields) => {
if(error)
   console.log(error)
console.log(results);
console.log(fileds);
})
connection.end();

本地数据库的表：

在终端中运行 node index.js

2、连接池连接

var mysql = require("mysql");
var pool = mysql.createPool({
  host: 'localhost',
  port: 3306,
  user: 'root',
  password: '5qbtsGKz%qa9',
  database: 'nodesys'
})

pool.getConnection(function(err,connection){
  connection.query("select * from login_users", function(error, results, fields){
    console.log(results);
    console.log(fields);
    connection.release();
  })
})