강의1
소스코드
강의2
소스코드
main.js
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 | var http = require('http');var url = require('url');var topic = require('./lib/topic');var author = require('./lib/author');var app = http.createServer(function(request,response){ var _url = request.url; var queryData = url.parse(_url, true).query; var pathname = url.parse(_url, true).pathname; if(pathname === '/'){ if(queryData.id === undefined){ topic.home(request, response); } else { topic.page(request, response); } } else if(pathname === '/create'){ topic.create(request, response); } else if(pathname === '/create_process'){ topic.create_process(request, response); } else if(pathname === '/update'){ topic.update(request, response); } else if(pathname === '/update_process'){ topic.update_process(request, response); } else if(pathname === '/delete_process'){ topic.delete_process(request, response); } else if(pathname === '/author'){ author.home(request, response); } else if(pathname === '/author/create_process'){ author.create_process(request, response); } else if(pathname === '/author/update'){ author.update(request, response); } else if(pathname === '/author/update_process'){ author.update_process(request, response); } else { response.writeHead(404); response.end('Not found'); }});app.listen(3000); |
lib/author.js
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 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 | var db = require('./db');var template = require('./template.js');var qs = require('querystring');var url = require('url');exports.home = function(request, response){ db.query(`SELECT * FROM topic`, function(error,topics){ db.query(`SELECT * FROM author`, function(error2,authors){ var title = 'author'; var list = template.list(topics); var html = template.HTML(title, list, ` ${template.authorTable(authors)} <style> table{ border-collapse: collapse; } td{ border:1px solid black; } </style> <form action="/author/create_process" method="post"> <p> <input type="text" name="name" placeholder="name"> </p> <p> <textarea name="profile" placeholder="description"></textarea> </p> <p> <input type="submit" value="create"> </p> </form> `, `` ); response.writeHead(200); response.end(html); }); });}exports.create_process = function(request, response){ var body = ''; request.on('data', function(data){ body = body + data; }); request.on('end', function(){ var post = qs.parse(body); db.query(` INSERT INTO author (name, profile) VALUES(?, ?)`, [post.name, post.profile], function(error, result){ if(error){ throw error; } response.writeHead(302, {Location: `/author`}); response.end(); } ) });}exports.update = function(request, response){ db.query(`SELECT * FROM topic`, function(error,topics){ db.query(`SELECT * FROM author`, function(error2,authors){ var _url = request.url; var queryData = url.parse(_url, true).query; db.query(`SELECT * FROM author WHERE id=?`,[queryData.id], function(error3,author){ var title = 'author'; var list = template.list(topics); var html = template.HTML(title, list, ` ${template.authorTable(authors)} <style> table{ border-collapse: collapse; } td{ border:1px solid black; } </style> <form action="/author/update_process" method="post"> <p> <input type="hidden" name="id" value="${queryData.id}"> </p> <p> <input type="text" name="name" value="${author[0].name}" placeholder="name"> </p> <p> <textarea name="profile" placeholder="description">${author[0].profile}</textarea> </p> <p> <input type="submit" value="update"> </p> </form> `, `` ); response.writeHead(200); response.end(html); }); }); });}exports.update_process = function(request, response){ var body = ''; request.on('data', function(data){ body = body + data; }); request.on('end', function(){ var post = qs.parse(body); db.query(` UPDATE author SET name=?, profile=? WHERE id=?`, [post.name, post.profile, post.id], function(error, result){ if(error){ throw error; } response.writeHead(302, {Location: `/author`}); response.end(); } ) });} |
