server.js

const express = require('express');
const app = express();
const mysql = require('mysql2');
app.use(express.json());

const connection = mysql.createConnection({
  host: 'localhost', 
  user: 'cye', 
  password: 'pwpw12211234*', 
  database: 'study' 
});

connection.connect((err) => {
  if (err) {
    console.error('오류:', err);
  } else {
    console.log('성공');
  }
});

app.post('/posts', (req, res) => {
  const query = 'select id, title, content, date_format(datee, \'%Y-%m-%d %H:%i\') as datee from phone';
  connection.query(query, (err, results) => {
    if (err) {
      console.error(err);
      res.send('에러남');
    }
    res.json(results);
  });
});

app.post('/write', (req, res) => {
  const {title, content} = req.body;
  const query = 'insert into phone (title, content) values (?, ?)';
  
  connection.query(query, [title, content], (err, results) => {
    if (err) {
      console.error(err);
      res.status(500).json({ error: '에러' });
    } 
    res.status(201).send('create');
  });
});

app.post('/delete', (req, res) => {
    const {id} = req.body;
  const query = 'delete from phone where id = ?';
  
  connection.query(query, [id], (err, results) => {
    if (err) {
      console.error(err);
      res.status(500).json({ error: '에러' });
    } 
    res.status(201).send('delete');
  });
});

app.post('/update', (req, res) => {
    const {title, content, id} = req.body;
  const query = 'update phone set title = ?, content = ?';
  
  connection.query(query, [title, content, id], (err, results) => {
    if (err) {
      console.error(err);
      res.status(500).json({ error: '에러' });
    } 
    res.status(201).send('update');
  });
});

const port = 3000;
app.listen(port, () => {
  console.log(`서버 시작 ${port}`);
});