var express = require("express");
var request = require("request");
var mysql = require('mysql');
var connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: 'root',
database: 'zhouheiya',
port: 3307
});
connection.connect();
var app = new express();
app.get("/query", function (req, res) {
res.header("Access-Control-Allow-Origin", "*");
res.header("Access-Control-Allow-Methods", "PUT,POST,GET,DELETE,OPTIONS");
var name = req.query.name;
if (name == "" || name == null || name == undefined) {
connection.query({
sql: 'SELECT * FROM zhouheiyastoreinfo WHERE orgcode like \'0-7%\'',
timeout: 40000
}, function (err, result, fields) {
if (err) {
console.log('[SELECT ERROR] - ', err.message);
return;
}
console.log('---SELECT---');
var arr = [];
for(var i=0;i<result.length;i++){
var x=result[i].x;
var y=result[i].y;
var arrs = [x,y,0.1];
arr.push(arrs);
}
res.send(arr);
});
} else {
connection.query({
sql: 'SELECT * FROM heiya WHERE `name` LIKE ?',
timeout: 40000,
values: '%' + [name] + '%'
}, function (err, result, fields) {
if (err) {
console.log('[SELECT ERROR] - ', err.message);
return;
}
console.log('---SELECT---');
res.send(result);
});
}
})
app.listen(3000);
网友评论