Node.js와 MySQL 연결

노드 최초 설정은 생략

cmd에서 mySQL2 모듈 설치 npm install -S mysql2

index.js -> 서버 시작

const express = require('express');

const userRouter = require('./userRouter');

const app = express();

const port = 3000;

app.use(express.json());

app.use(`/user`, userRouter);

app.get('/', (req, res) => {

    res.json({

        success: true,

       

    });

});

app.listen(port, () => {

    console.log(`server is listening at localhost:${port}`);

});

 

 

userDB.js -> DB접속 정보

const mysql = require('mysql2');

const pool = mysql.createPool //접속 정보

({

    host: '****************',

    user: '*************',

    database: '*************',

    password: '**************',

    port: '*************',

    waitForConnections: true,

    connectionLimit: 10,

    queueLimit: 0

})

const getUser = async ()=>

{

    const promisePool = pool.promise();

    const [rows] = await promisePool.query('select * from user;');

    console.log(rows);

    return rows;

};

module.exports =

{

    getUser

};

 

 

userRouter.js -> 정보 가져오기

const express = require('express');

const userDB = require('./userDB');

const router = express.Router();

router.get('/getUser', async (req, res)=>

{

    let res_get_users =

    {

        status_code : 500,

        user : []

    };

    try

    {

        const rows = await userDB.getUser();

        res_get_users.status_code = 200;

        if(rows.length > 0)

        {

            rows.forEach((user)=>

            {

                res_get_users.user.push

                ({

                    email : user.email,

                    password : user.password,

                    name : user.name,

                });

            });

        }

        else

        {

            console.log('사용자 없음');

        }

    }

    catch(error)

    {

        console.log(error.message);

    }

    finally

    {

        var result = '';

        for(var i = 0; i < res_get_users.user.length; i++)

        {

            result += "========================================<br>";

            result += " email : "+res_get_users.user[i].email+" <br>";

            result += " password : "+res_get_users.user[i].password+" <br>";

            result += " name : "+res_get_users.user[i].name+" <br>";

            result += "========================================<br>";

           

            result += "<br>";

        }

        res.send(result);

    }

});

module.exports = router;

 

 

npm run start 서버 실행

 

크롬에서 URL(localhost:3000 접속 결과)

 

크롬에서 URL(localhost:3000/User/getUser 접속 결과)