Page code:
<!DOCTYPE HTML><HTMLLang= "Utf-8"><Metahttp-equiv= "Content-type"content= "text/html; charset=utf-8"/> <Head> <title>Put data to DB</title> </Head> <Body> <formID= "Form1">User name:<inputtype= "text"ID= "username"name= "Name"value=""><BR/>Password:<inputtype= "Password"ID= "USERPSWD"name= "PSWD"value=""><BR/> <inputtype= "button"value= "Submit"onclick= "SubmitData ();"/> </form> </Body></HTML><Scripttype= "Text/javascript"><!--functionSubmitData () {varobj={name:document.getElementById ("username"). Value, Password:document.getElementById ("userpswd"). Value}; varXHR=NewXMLHttpRequest (); Xhr.open ('put','index.html',true); Xhr.onload=function(e) {if( This. Status== $) {alert ( This. Response); } }; Xhr.send (json.stringify (obj));// -</Script>
Background code:
' Use strict ';varExpress=require (' Express ');varHttp=require (' http ');varFs=require (' FS ');varQuerystring=require (' QueryString ');varapp=Express ();varMysql=require (' MySQL ');varPool=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 ');//the same as the last two sentences}); App.put ('/index.html ',function(req,res) {Req.on (' Data ',function(data) {varObj=json.parse (Data.tostring ());//get parameters for Ajax submissionsconsole.log (obj); Pool.getconnection (function(err,connection) {if(Err) {Res.send (' Can not connect to MYSQL DB '); Console.log (ERR); }Else{ varstr; 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" submits data to the back end using put