사전 설치 작업
npm install express mysql --save --save-exact
Server.js
var express = require('express');
var app = express();
const Router = require('./routes/path');
app.use('/path', Router)
app.set('port', process.env.PORT || 3000);
app.listen(app.get('port'), function () {
console.log('Express server listening on port ' + app.get('port'));
});
routes/path.js
const db = require('../config/database');
const express = require('express');
const router = express.Router();
router.get('/', function(req, res){
// res.send('Error');
db.query('select * from ()', function (err, rows) {
if(err){
throw err;
}
console.log(rows);
res.json(rows);
});
});
module.exports = router;
config/database.js
const mysql = require('mysql');
const connection = mysql.createPool({
host : 'localhost',
user : 'root',
password : '****',
port : 3306,
database : 'any',
waitForConnections:false
});
module.exports = connection