const express = require('express')
const fs = require('fs')
const ejs = require('ejs')
const mysql = require('mysql2')
const bodyParser = require('body-parser')
const client = mysql.createConnection({
user: 'root',
password: '', //본인의 db root 계정 비밀번호
database: 'coding' //본인의 db
})
const app = express()
app.use(bodyParser.urlencoded({
extended: false
}))
app.listen(3000, function () {
console.log('Server is running at : http://127.0.0.1:3000')
})
app.get('/', function (req, res) {
fs.readFile('list.ejs', 'utf8', function (err, data) {
client.query('select * from MusicList', function (err, results) {
if (err) {
res.send(err)
} else {
res.send(ejs.render(data, {
data: results
}))
}
})
})
})
app.get('/delete/:id', function (req, res) {
client.query('delete from MusicList where id=?', [req.params.id], function () {
res.redirect('/')
})
})
app.get('/insert', function (req, res) {
fs.readFile('insert.html', 'utf8', function (err, data) {
res.send(data)
})
})
app.post('/insert', function (req, res) {
const body = req.body
client.query('insert into MusicList (name, artist, genre) values (?, ?, ?);', [
body.name,
body.artist,
body.genre
], function() {
res.redirect('/')
})
})
app.get('/edit/:id', function (req, res) {
fs.readFile('edit.ejs', 'utf8', function (err, data) {
client.query('select * from MusicList where id = ?', [req.params.id], function (err, result) {
res.send(ejs.render(data, {
data: result[0]
}))
})
})
})
app.post('/edit/:id', function (req, res) {
const body = req.body
client.query('update MusicList SET name=?, artist=?, genre=? where id=?',[
body.name, body.artist, body.genre, req.params.id
], function () {
res.redirect('/')
})
})
조회 : 67
