Andios

사전 설치 작업

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