mysqljson.js
1.07 KB
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
var express = require("express");
var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : 'autoset',
database : 'test'
});
var app = express();
connection.connect(function(err){
if(!err) {
console.log("Database is connected ... \n\n");
} else {
console.log("Error connecting database ... \n\n");
}
});
app.get("/",function(request,response){
connection.query('SELECT * from seoul', function(err, rows, fields) {
connection.end();
if (!err){
var data="<html><head><title>mysql test</title></head>"
data+="<h1>구</h1>"
data+="<h1>동</h1>"
data+="<h1>x좌표</h1>"
data+="<h1>Y좌표</h1>"
for (var i in rows){
data += "<tr>"
data += "<td>"+rows[i].type +"</td>"
data += "<td>"+rows[i].address+"</td>";
data += "<td>"+rows[i].lnt+"</td>";
data += "<td>"+rows[i].lat+"</td>";
data += "</tr>"
}
data+="</table></html>"
response.send(data);
}
else
console.log('Error while performing Query.');
});
});
app.listen(3000);