5/1 dbserver.js

// 모듈을 추출합니다.

var express = require('express');

var bodyParser = require('body-parser');

var mysql=require("mysql");

var client=mysql.createConnection({

    user:"root",

    password:"1234",

    database:"company"

});

// 웹 서버를 생성합니다.

var app = express();

app.use(express.static('public'));

app.use(bodyParser.urlencoded({ extended: false }));

app.get('/products', function (request, response) {

    client.query("select * from products",function(error,data){

        response.send(data);

    });

    

});

app.get('/products/:id', function (request, response) {

    // 변수를 선언합니다.

    var id = Number(request.params.id);

    client.query("select * from products where id=?",[id],function(error,data){response.send(data)});

});

app.post('/products', function (request, response) {

    // 변수를 선언합니다.

    var name = request.body.name;

    var modelnumber = request.body.modelnumber;

    var series = request.body.series;

    

    client.query("insert into products(name,modelnumber,series) values(?,?,?)",[name,modelnumber,series],

    function(error,data){response.send(data);});   

    

});

app.put('/products/:id', function (request, response) {

    // 변수를 선언합니다.

    var id = Number(request.params.id);

    var name = request.body.name;

    var modelnumber = request.body.modelnumber;

    var series = request.body.series;

    var query="update products set";

    

    if (name){

        query+=" name='"+name+"',";

    }

    if(modelnumber){

        query+=" modelnumber='"+modelnumber+"',";

    }

    if(series){

        query+=" series='"+series+"'";

    }

    query+=" where id="+id;

    

    client.query(query,function(error,data){

        if(error){

            response.send("수정작업이 실패하였습니다.");

        }else{

            response.send(data);

        }

    });

    

});

app.delete('/products/:id', function (request, response) {

    // 변수를 선언합니다.

    var id = Number(request.params.id);

    client.query("dele from products where id=?",[id],function(error,data){

        response.send(data);

    });

});

// 웹 서버를 실행합니다.

app.listen(52273, function () {

    console.log('Server Running at http://127.0.0.1:52273');

});