var express = require("express");
var server = express();
var expressStatic = require("express-static");
var mysql = require("mysql");
var port = 81;
var url = require("url");
var ejs = require("ejs");
var sql = mysql.createConnection({
	host:"localhost",
	user:"root",
	password:"admin",
	database:"zff",
	timezone:"08:00"
})
sql.connect();


server.get("/newsList",function(request,response){
	sql.query(`select id,title from news`,function(error,data){
		if(!error){
			ejs.renderFile("static/newsList.html",{list:data},function(error,data){
				// console.log(data)
				if(!error){
					response.end(data)
				}
				else{
					response.end("error")
					console.log("解析失败")
				}
			})
		}
		else{
			response.end("error")
			console.log("解析失败")
		}
	})
	
})
server.get("/news",function(request,response){
	//解析参数
	var id = url.parse(request.url,true).query.id;

	sql.query(`select * from news where id="${id}"`,function(error,data){
		if(!error){
			ejs.renderFile("static/news.html",{data:data[0]},function(error,data){
		
				if(!error){
					response.end(data)
				}
				else{
					console.log(error)
				}
			})
		}
		else{
			response.end("error")
			console.log(error)
		}
	})	

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