安装mysql 数据库
npm install mysql --save
配置连接 单一连接
const mysql = require('mysql');
const conn = mysql.creatConnection({
host:'localhost',
user:'数据库用户名',
password:'数据库的密码',
database:'数据库的名字'
})
执行查询操作
conn.query(sql, (err, result)=>{
if (err) throw err;
})
单一连接模块封装
const mysql = require('mysql');
const pool = mysql.createConnection({
host:'localhost',
user:'数据库用户名',
password:'数据库密码',
database:'数据库名字',
})
module.exports = function(sql) {
return new Promise((resolve, reject) => {
conn.query(sql, (err, result) => {
if (err) reject(err);
resolve(result);
})
})
}
配置连接池
const mysql = require('mysql');
const pool = mysql.createPool({
host:'localhost',
user:'数据库用户名',
password:'数据库密码',
database:'数据库名字',
connectionLimit:10
})
建立连接
pool.query(sql, (error, results)=> {
if (error) throw error;
});
pool.getConnection((err, connection) => {
if (err) throw err;
connection.query(sql, (err, results, fields) => {
connection.release();
if (error) throw error;
})
})
连接池模块封装
const mysql = require('mysql');
const pool = mysql.createPool({
host:'localhost',
user:'数据库用户名',
password:'数据库密码',
database:'数据库名字',
connectionLimit: 10
})
module.exports = function(sql){
return new Promise((resolve, reject) => {
pool.getConnection((err, results) => {
if (err) reject(err);
connection.query(sql, (err, result) => {
connection.release();
if (err) reject(err);
resolve(result);
})
})
})
}