var express =
require(
'express')
var fs =
require(
'fs')
var app = express()
var mysql =
require(
'mysql')
var pool = mysql.createPool({
host :
'localhost',
port :
3306,
database :
'test',
user :
'root',
password:
'root'
})
app.get(
'/index1.html',
function(req,res){
res.sendfile(__dirname+
'/index1.html')
})
app.put(
'/index1.html',
function(req,res){
req.on(
'data',
function(data){
var obj =
JSON.parse(data.toString())
console.log(obj)
pool.getConnection(
function(err,conneciton)
{
if(err)
{
res.send(
'与MySQL建立连接失败')
}
else
{
var str
conneciton.query(
'insert into node set ?',{username:obj.username,age:obj.age},
function(err,result){
if(err){
str =
'MySQL数据库插入数据失败'
}
else{
str =
'MySQL数据库插入数据成功'
}
connection.release()
res.send(str)
})
}
})
})
})
app.listen(
8889,
'127.0.0.1')
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>使用PUT方法提交数据
</title>
</head>
<body>
山丘
<form action="index1.html" >
<input id="username" type="text" name="username" placeholder="请输入姓名"><br>
<input id="age" type="text" name="age" placeholder="请输入年龄"><br>
<input type="submit" value="提交" onclick="submitData();">
</form>
<div id='result'></div>
</body>
</html>
<script>
function submitData(){
var obj = {
username :document.getElementById('username').value,
age : document.getElementById('age').value
}
var xhr = new XMLHttpRequest()
xhr.open('put','index1.html',true)
xhr.onload = function(e){
if(this.status == 200){
document.getElementBiId('result').innerHTML = this.response
}
alert('檀木')
}
xhr.send(JSON.stringify(obj))
}
</script>
