수업소개
저자 목록을 보여주는 기능을 구현해보겠습니다.
강의
소스코드
main.js
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
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
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);
});
});
}
