4.2.MySQL로 Read 기능 구현 2

egoing · egoing · commit a734904249cd · 2018-06-14T01:24:40.000+09:00
diff --git a/lib/template.js b/lib/template.js
@@ -15,11 +15,11 @@ module.exports = {
     </body>
     </html>
     `;
-  },list:function(filelist){
+  },list:function(topics){
     var list = '<ul>';
     var i = 0;
-    while(i < filelist.length){
-      list = list + `<li><a href="/?id=${filelist[i]}">${filelist[i]}</a></li>`;
+    while(i < topics.length){
+      list = list + `<li><a href="/?id=${topics[i].id}">${topics[i].title}</a></li>`;
       i = i + 1;
     }
     list = list+'</ul>';
diff --git a/main.js b/main.js
@@ -21,21 +21,16 @@ var app = http.createServer(function(request,response){
     var pathname = url.parse(_url, true).pathname;
     if(pathname === '/'){
       if(queryData.id === undefined){
-        /* fs.readdir('./data', function(error, filelist){
+        db.query(`SELECT * FROM topic`, function(error,topics){
           var title = 'Welcome';
           var description = 'Hello, Node.js';
-          var list = template.list(filelist);
+          var list = template.list(topics);
           var html = template.HTML(title, list,
             `<h2>${title}</h2>${description}`,
             `<a href="/create">create</a>`
           );
           response.writeHead(200);
           response.end(html);
-        }); */
-        db.query(`SELECT * FROM topic`, function(error,topics){
-          console.log(topics);
-          response.writeHead(200);
-          response.end('Success');
         });
       } else {
         fs.readdir('./data', function(error, filelist){
