var mysql = {
    host: "127.0.0.1",//這是數(shù)據(jù)庫(kù)的地址
    user: "root",//需要用戶的名字
    password: "root23",//用戶密碼 ，如果你沒(méi)有密碼，直接雙引號(hào)就是
    database: "info",//數(shù)據(jù)庫(kù)名字
    port:3306//數(shù)據(jù)庫(kù)使用的端口號(hào)
}
module.exports = mysql;//用module.exports暴露出這個(gè)接口

const express = require('express');
const router = express.Router();
//導(dǎo)入MySQL 模塊
const mysql = require('mysql');
//導(dǎo)入配置文件
const db = require('../config/configdb');

router.get('test',(req,res)=>{
    //創(chuàng)建數(shù)據(jù)庫(kù)連接對(duì)象
    let conn = mysql.createConnection(db);
    //查詢bookinfo中所有數(shù)據(jù)
    conn.query('select * from student',(err,results,fieldes)=>{
        //fieldes表示具體的字段
        if(err){
            throw err;
        }
        res.send(results);
    })
    //關(guān)閉數(shù)據(jù)庫(kù)鏈接
    conn.end((err)=>{
        console.log(err);
})
module.exports = router;

var dbRouter = require('./routes/option')
app.use('/db',dbRouter);

var mysql = require('mysql'); 

var pool = mysql.createPool(options);

//創(chuàng)建數(shù)據(jù)庫(kù)連接池
const pool = mysql.createPool({
    connectionLimit:20,
    host:'localhost',
    port:3306,
    user:'root',
    password:'123456',
    database:'info'
})
//導(dǎo)出數(shù)據(jù)庫(kù)連接池對(duì)象
module.exports = pool;

pool.getConnection((err, conn) => {
    if (err) {
        console.log(err)
    } else {
        let sql = 'select * from bookinfo';
        conn.query(sql, (err, results) => {
            if (err) {
                console.log(err)
            } else {
                res.send(results);
                conn.release();
            }
        })
    }
})

conn.release();

const express = require('express');
const pool = require('../config/dbmysql');

const router = express.Router();
/*
* http://localhost:3000/dbmysql/books
* */
router.get('/books',(req,res)=>{
    //從數(shù)據(jù)庫(kù)連接池中獲取數(shù)據(jù)庫(kù)連接對(duì)象
    pool.getConnection((err,conn)=>{
        if(err){
            console.log(err)
        }else {
            let sql = 'select * from bookinfo';
            conn.query(sql,(err,results)=>{
                if (err) {
                    console.log(err)
                }else {
                    res.send(results);
                    conn.release();
                }
            })
        }
    })
})
module.exports = router;