NodeJs method example for connecting to mysql based on connection pool, nodejsmysql

NodeJs method example for connecting to mysql based on connection pool, nodejsmysql

This article describes how to connect nodeJs to mysql based on the connection pool. We will share this with you for your reference. The details are as follows:

Mysql. js

// Connect to the database var mysql = require ('mysql'); var pool = mysql. createPool ({host: 'localhost', user: 'root', password: 'gfdfsdf34r34r', database: 'caiji '}); module. exports = function (SQL, callback) {pool. getConnection (function (conn_err, conn) {if (conn_err) {callback (err, null, null);} else {conn. query (SQL, function (query_err, rows, fields) {conn. release (); callback (query_err, rows, fields );});}});};

Call

Var query = require ("./mysql. js"); query (SQL, function (err, rows, fields) {console. log (rows );});

I hope this article will help you design nodejs programs.