使用python flask和jquery删除sqlite数据库中的行

from flask import Flask from flask import Flask, render_template, request import sqlite3 app = Flask(__name__) @app.route("/") @app.route('/delete', methods=['POST']) def delete(): con = sqlite3.connect('ships.db') cur = con.cursor() cur.execute('DELETE FROM `liners` WHERE liner_ip = "' + request.form['id'] + '"') cur.commit() con.close()

$( document ).ready(function() { $( 'a.delete' ).click( function( e ) { e.preventDefault(); $.ajax({ url: '/delete', data: $('form').serialize(), type: 'POST', success: function(response) { console.log(response); }, error: function(error) { console.log(error); } }); }); }); <form action="/delete" method="post" role="form"> <input type="hidden" name="id" value="{{row['liner_ip']}}"> <a href="#" class="btn btn-danger delete">DELETE</a> </form>

而不是 form ,只需创建 input 字段。当选择按钮时, ajax 可以做一个 GET 请求:

from flask import jsonify

@app.route("/")
@app.route('/delete')
def delete():
  con = sqlite3.connect('ships.db')
  cur = con.cursor()
  cur.execute('DELETE FROM `liners` WHERE liner_ip = "' +  request.args.get('id')+ '"')
  cur.commit()
  con.close()
  return flask.jsonify({'success':"True"})

然后,在 html :

<html>
  <head>
       <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
  </head>
    <body>
      <div class='wrapper'> <!--Need wrapper for anchoring button click -->
        <input type="hidden" name="id" class='input_row' value="{{row['liner_ip']}}">
        <button class='delete_row'>DELETE</button>
      </div>
    </body>
    <script>
      $(document).ready(function(){
        $('.wrapper').on('click', '.delete_row', function(){
          var val = $('.input_row').val();
          $.ajax({
            url: "/suggestions",
            type: "get",
            data: {id: val},
            success: function(response) {
              $('.input_row').val('');
            },

          });
        });
      });
    </script>
</html>