728x90
const express = require('express');
const morgan = require('morgan');
const mysql = require('mssql');
const http = require('http');
const path = require('path');
// ****MSSQL 연결********************************************************
const pool = {
user: '사용자명',
password: '비밀번호',
server: '127.0.0.1',
database: '데이터베이스명',
stream: true,
options: {
encrypt: false,
datebase: process.env.DB_DEV_DATEBASE,
trustServerCertificate: true,
}
}
mysql.connect(pool, function(err){
if(err){
return console.error('error : ', err);
}
console.log('MSSQL 연결 완료')
})
/* 조회*/
router.get('/', (req, res) => {
var q = "SELECT 칼럼1, 칼럼2 FROM 테이블명 where 칼럼명 = 변수값";
var request = new mysql.Request();
request.stream = true;
request.query(q,(err, recordset) => {
if(err){
console.log('query error :', err)
}
else{
console.log("select success");
}
});
var result = [];
request.on('error', function(err){
console.log(err);
})
.on('row', (row) => { //한행씩 조회
result.push(row);
})
.on('done', () => {
console.log(result);
res.json(result); //값전송
});
});
댓글