const express = require('express');
const mysql = require('mysql'); 


var connection = mysql.createConnection({ 
    host:'localhost',
    user:'아이디',
    password:'비밀번호',
    database:'데이타베이스명',
connectionLimit: 500,
    waitForConnections: true,
timezone: 'UTC',
dialectOptions: {
  charset: 'utf8mb4',
  dateStrings: true,
  typeCast: true
},
timestamps: true

});

var app = express(); 


connection.connect(function(err){ 
if(!err) { 
    console.log("DB ok \n\n");   
} else { 
    console.log("DB err  \n\n");   
} 
});

app.get("/",function(request,response){

var sql  = "SELECT * ";
        sql += "  from test  ";
connection.query(sql, function(err, rows, fields) { 
  if (!err){ 
if(rows.length > 0){
                response.send(rows); 
      console.log(' ', rows); 
    }else {
console.log('데이타 없습니다.'); 
}
  } 
  else 
console.log('오류..'); 
  }); 
});


app.listen(2000, () => {
  console.log('데이타 모니터링 /  JSON port : 2000!');
});