[react] mysql 연동하기

 

server/config/db.js

const mysql = require('mysql');
const db = mysql.createPool({
    host: 'localhost',
    user: 'martjangbogo',
    password: '123123123',
    database: 'martjangbogo_cs',
})

module.exports = db;

 

server/server.js

const express = require('express');
const app = express();
const PORT = process.env.PORT || 4000;
const db = require('./config/db.js')
const cors = require('cors');
const { router } = require('json-server');

app.use(cors({ credentials: true, origin: "http://localhost:4000" }));

app.get('/join', (req, res) => {
    res.header("Access-Control-Allow-Origin", "*");
    res.header("Access-Control-Allow-Headers", "*");
    
    db.query('select * from ceo_cs where category = "회원가입_승인요청";', (err, data) => {
        if(!err) {
            console.log(data);
            res.send(data);
        } else {
            console.log(err);
        }
    })
})


app.listen(PORT, () => {
    console.log(`Server on : http://localhost:${PORT}`);
});

 

 

서버에 데이터 요청

    useEffect(() => {
        axios.get('http://localhost:4000/join')
            .then((res) => {
                setResData(res.data)
            })
            .catch((err) => {
                console.log(err);
            })
    }, []);