수업소개
저자 목록을 보여주는 기능을 구현해보겠습니다.
강의
소스코드
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 | 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 { response.writeHead(404); response.end('Not found'); }});app.listen(3000); |
lib/template.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 | module.exports = { HTML:function(title, list, body, control){ return ` <!doctype html> <html> <head> <title>WEB1 - ${title}</title> <meta charset="utf-8"> </head> <body> <h1><a href="/">WEB</a></h1> <a href="/author">author</a> ${list} ${control} ${body} </body> </html> `; },list:function(topics){ var list = '<ul>'; var i = 0; while(i < topics.length){ list = list + `<li><a href="/?id=${topics[i].id}">${topics[i].title}</a></li>`; i = i + 1; } list = list+'</ul>'; return list; },authorSelect:function(authors, author_id){ var tag = ''; var i = 0; while(i < authors.length){ var selected = ''; if(authors[i].id === author_id) { selected = ' selected'; } tag += `<option value="${authors[i].id}"${selected}>${authors[i].name}</option>`; i++; } return ` <select name="author"> ${tag} </select> ` },authorTable:function(authors){ var tag = '<table>'; var i = 0; while(i < authors.length){ tag += ` <tr> <td>${authors[i].name}</td> <td>${authors[i].profile}</td> <td>update</td> <td>delete</td> </tr> ` i++; } tag += '</table>'; return tag; }} |
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 | var db = require('./db');var template = require('./template.js');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> `, `<a href="/create">create</a>` ); response.writeHead(200); response.end(html); }); });} |
