建立html页面,并配上一张杜甫的图片。
<!DOCTYPE html>
<html>
<body>
<form action="http://127.0.0.1:8080/process_get" method="GET">
<br> 标题:<input type="text" name="title">
<input type="submit" value="Submit">
</form>
<img src="杜甫.jpg">
<script>
</script>
</body>
</html>
node.js后端代码
var myRequest = require('request')
var myCheerio = require('cheerio')
var mysql = require('mysql')
var fs = require('fs')
var express = require('express')
let options = {
host : "127.0.0.1",
port : "3306",
user : "root",
password : "root",
database : "tangpoem"
}
let con=mysql.createConnection(options);
con.connect((err)=>{
if(err){
console.log(err);
}
})
var app = express();
//app.use(express.static('public'));
app.get('/唐诗查询.html', function(req, res) {
res.sendFile(__dirname + "/" + "唐诗查询.html");
})
// app.get('/查询结果.html', function(req, res) {
// res.sendFile(__dirname + "/" + "查询结果.html");
// })
app.get('/process_get', function(req, res) {
res.writeHead(200, { 'Content-Type': 'text/html;charset=utf-8' }); //设置res编码为utf-8
//sql字符串和参数
var fetchSql = "select title,content from poem where title like '%" +
req.query.title + "%'";
con.query(fetchSql, function(err, result, fields) {
console.log(result);
res.end(JSON.stringify(result));
});
})
var server = app.listen(8080, function() {
console.log("访问地址为 http://127.0.0.1:8080/唐诗查询.html")
})
以上为飞花令神器