server/app.js at main · react-aws-exercise/server · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
var express = require('express');
var app = express();

//----------------------------------
// 편집영역
//----------------------------------

app.get('/select', function (req, res, next) {
    console.log('select');
    const mysql = require('mysql');  // mysql 모듈 로드
    const conn = {  // mysql 접속 설정
        host: '54.199.43.5',
        port: '13306',
        user: 'tiger',
        password: '1234',
        database: 'db01'
    };
    let connection = mysql.createConnection(conn); // DB 커넥션 생성
    connection.connect();   // DB 접속
    console.log('db connect');
    let sql = "select * from test;";

    connection.query(sql, function (err, results, fields) {
        if (err) {
            console.log(err);
        }
        console.log(results);
        res.send(results)
    });
});

app.post('/insert', function (req, res, next) {
    console.log('insert');
    const mysql = require('mysql');  // mysql 모듈 로드
    const conn = {  // mysql 접속 설정
        host: '54.199.43.5',
        port: '13306',
        user: 'tiger',
        password: '1234',
        database: 'db01'
    };
    let connection = mysql.createConnection(conn); // DB 커넥션 생성
    connection.connect();   // DB 접속
    console.log('db connect');
    console.log(req.query);
    let sql = "insert into test value (" + req.query.id + ")";

    connection.query(sql, function (err, results, fields) {
        if (err) {
            console.log(err);
        }
        console.log(results);
        res.send(results)
    });
});

app.post('/update', function (req, res, next) {
    console.log('update');
    const mysql = require('mysql');  // mysql 모듈 로드
    const conn = {  // mysql 접속 설정
        host: '54.199.43.5',
        port: '13306',
        user: 'tiger',
        password: '1234',
        database: 'db01'
    };
    let connection = mysql.createConnection(conn); // DB 커넥션 생성
    connection.connect();   // DB 접속
    console.log('db connect');
    console.log(req.query);
    let sql = "UPDATE test SET id = " + req.query.id2 + " WHERE id = " + req.query.id1;

    connection.query(sql, function (err, results, fields) {
        if (err) {
            console.log(err);
        }
        console.log(results);
        res.send(results)
    });
});

app.post('/delete', function (req, res, next) {
    console.log('delete');
    const mysql = require('mysql');  // mysql 모듈 로드
    const conn = {  // mysql 접속 설정
        host: '54.199.43.5',
        port: '13306',
        user: 'tiger',
        password: '1234',
        database: 'db01'
    };
    let connection = mysql.createConnection(conn); // DB 커넥션 생성
    connection.connect();   // DB 접속
    console.log('db connect');
    console.log(req.query.id3);
    let sql = "delete from test where id = " + req.query.id3;

    connection.query(sql, function (err, results, fields) {
        if (err) {
            console.log(err);
        }
        console.log(results);
        res.send(results)
    });
});
// app.use('/', require('./routes/index'));
// app.use('/users', require('./routes/users'));

var port = process.env.PORT || '5000';
app.listen(port, () => { console.log('nodemon restart') });

module.exports = app;