页面代码:
<!DOCTYPE html><html lang="utf-8"><meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <head> ?<title>Put data to db</title> </head> <body> ?<form id="form1"> ???用户名:<input type="text" id="username" name="name" value=""><br/> ???密码 ?:<input type="password" id="userpswd" name="pswd" value=""><br/> ???<input type="button" value="提交" onclick="submitData();"/> ?</form> </body></html><script type="text/javascript"><!--function submitData(){ ???var obj={ ???????name:document.getElementById("username").value, ???????password:document.getElementById("userpswd").value ???}; ???var xhr=new XMLHttpRequest(); ???xhr.open(‘put‘,‘index.html‘,true); ???xhr.onload=function(e){ ???????if(this.status==200){ ???????????alert(this.response); ???????} ???}; ???xhr.send(JSON.stringify(obj));}//--></script>
后台代码:
‘use strict‘;var express=require(‘express‘);var http=require(‘http‘);var fs=require(‘fs‘);var querystring=require(‘querystring‘);var app=express();var mysql=require(‘mysql‘);var pool=mysql.createPool({ ???host:‘127.0.0.1‘, ???port:‘3306‘, ???database:‘test‘, ???user:‘root‘, ???password:‘12345678‘,});app.get(‘/index.html‘,function(req,rsp){ ???//rsp.writeHead(200,{‘Content-Type‘:‘text/html‘}); ???????//fs.createReadStream(‘index.html‘).pipe(rsp); ???rsp.sendFile(__dirname+‘/index.html‘);// 与上两句意义相同});app.put(‘/index.html‘,function(req,res){ ???req.on(‘data‘,function(data){ ???????var obj=JSON.parse(data.toString());// 取得Ajax提交的参数 ???????console.log(obj); ???????pool.getConnection(function(err,connection){ ???????????if(err){ ???????????????res.send(‘Can not connect to MySql DB‘); ???????????????console.log(err); ???????????}else{ ???????????????var str; ???????????????connection.query(‘insert into emp set ?‘,{name:obj.name,password:obj.password},function(err,result){ ???????????????????if(err){ ???????????????????????str=‘Insert failed‘; ???????????????????}else{ ???????????????????????str="Insert succeed"; ???????????????????} ???????????????????connection.release(); ???????????????????res.send(str); ???????????????}) ???????????} ???????}); ???});});app.listen(8080,"127.0.0.1");
【nodejs】使用put方式向后端提交数据
原文地址:https://www.cnblogs.com/xiandedanteng/p/8776266.html