Node.js + Mysql 연결하기

npm install express mysql2

npm install fs cors multer 

//config/mysql.js

var mysql = require("mysql2");
var db_info = {
    host: "",
    port: "3306",
    user: "",
    password: "",
    database: "",
};

module.exports = {
    init: function () {
        return mysql.createConnection(db_info);
    },
    connect: function (conn) {
        conn.connect(function (err) {
            if (err) console.error("mysql connection error : " + err);
            else console.log("mysql is connected successfully!");
        });
    },
};

const express = require('express');
const multer = require("multer");
const cors = require("cors");
const fs = require("fs");
const bodyParser = require("body-parser");
const db = require("./config/mysql.js");

const app = express();
const conn = db.init();

const upload = multer({
    storage: multer.diskStorage({
        destination: function (req, file, callback) {
            console.log(file),
                fs.existsSync("./uploads/") ||
                fs.mkdirSync("./uploads/", { recursive: !0 }),
                callback(null, "./uploads/");
        },
        filename: function (req, file, callback) {
            callback(null, file.originalname);
        },
    }),
});

module.exports = {
    init: function () {
        return mysql.createConnection(db_info);
    },
    connect: function (conn) {
        conn.connect(function (err) {
            if (err) console.error("mysql connection error : " + err);
            else console.log("mysql is connected successfully!");
        });
    },
};

app.use(express.urlencoded({ extended: true }));
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: false }));
app.use(cors());


app.set("port", process.env.PORT || 8080); // 포트 설정

app.set('view engine', 'ejs');
app.set('views', __dirname + '/views');//이거 수정
app.engine('ejs', require('ejs').__express);//경로지정

app.get('/list', async (req, res) => {
    var sql = "select * from board;";
    conn.query(sql, function (err, result) {
        if (err) console.log("query is not excuted: " + err);
        else res.send(result);
    });
})