String.prototype.parseUrl = function(){
	var result = this;
	var index = result.indexOf("?") + 1;
	var result = result.slice(index);
	var result = result.split("&");
	var obj = {}
	result.forEach(function(item){
		var arr = item.split("=");
		obj[arr[0]] = arr[1]
	})
	return obj;
}
var express = require("express");
var server = express();
var expressStatic = require("express-static");
var mysql = require("mysql");
var port = 81;
var url = require("url")
var sql = mysql.createConnection({
	host:"localhost",
	user:"root",
	password:"admin",
	database:"mysql",
})
sql.connect();




server.get("/getData",function(request,response){
	console.log("接收到前端请求,路由:"+" getData");
	var id = request.url.parseUrl().id;
	if(!id){	
		sql.query(`select * from yuangong`,(error,data)=>{
			if(error){
				console.log(error);
				response.end("error")
			}
			else{
				console.log("查询成功,接口：getData")
				response.end(JSON.stringify(data))
			}
		})
	}
	else{
		sql.query(`select * from yuangong where id="${id}"`,(error,data)=>{
			if(!error){
				response.end(JSON.stringify(data))
			}
			else{
				response.end("error")
			}
	   })
   }
})
server.get("/deleteData",function(request,response){
	var id = request.url.parseUrl().id;
	sql.query(`delete from yuangong where id="${id}"`,(error,data)=>{
		if(error){
			console.log(error);
			response.end("error")
		}
		else{
			if(data.affectedRows){
				console.log("删除成功,接口：deleteData");
				response.end("success")
			}
			else{
				console.log("未找到该数据");
				response.end("error")
			}
		}
	})
})
server.get("/insertData",function(request,response){
	var data = url.parse(request.url,true).query
	sql.query(`insert into yuangong (id,name,sex,age,yx) values ("${data.id}","${data.name}","${data.sex}"，"${data.age}"，"${data.yx}")`,function(error,data){
		if(!error){
			sql.query(`select * from yuangong`,function(error,data){
				response.end(JSON.stringify(data))
				console.log(data)
			})
		}
		else{
			console.log("插入失败")
			response.end("error")
		}
	})
})

server.use(expressStatic(`${__dirname}/static`));
server.listen(port);
console.log(`server is running at ${port}`)