使用delete方法接收客户端提交的delete请求

来源：互联网发布：刷vip永久软件编辑：程序博客网时间：2024/05/22 14:14

/** * Created by os on 17-6-18. *//*    使用delete方法接收客户端提交的delete请求 */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('/delete.html',function(req,res){    res.sendfile(__dirname+'/delete.html')})app.delete('/delete.html',function(req,res){    req.on('data',function(data){        var obj = JSON.parse(data.toString())        console.log(obj)        pool.getConnection(function(err,connection){            if(err){                res.send('MySQL数据库建立连接失败')            }else{                var str;                connection.query('delete from node where username =? and age = ?',[obj.username,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="delete.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('delete','delete.html',true)        xhr.onload = function(e){            if(this.status == 200){                document.getElementBiId('result').innerHTML = this.response            }        }        xhr.send(JSON.stringify(obj))    }</script>

阅读全文

0 0