npm install mysql2
PORT =
DB_HOST =
DB_USER =
DB_PASSWORD =
DB_DATABASE =
//config/db.js
//db 연결
const mysql = require('mysql2')
const connection = mysql.createConnection({
host : process.env.DB_HOST,
user : process.env.DB_USER,
password : process.env.DB_PASSWORD,
database : process.env.DB_DATABASE
})
connection.connect(); //연결실행
module.exports = connection;
// router/index.js
const connection = require('../config/db.js');
router.get(
'/test', (req,res,next) =>{
connection.query('SELECT * from user', (error, rows) => {
if (error) throw error;
console.log('User info is: ', rows);
res.send(rows);
});
}
)
res.send()
: 다양한 유형의 응답 전송res.redirect()
: 브라우저 리다이렉터res.render()
: views 렌저링res.json()
: json 응답 전송res.end()
: 응답 프로세스 종료