Python + Flask 项目开发实践系列《三》

<div class="row" align="right">
        主要内容：<input type='text' id='contents' name='contents'>
        <button class="btn btn-warning" id="select">查询</button>
        <button class="btn btn-primary" id="adds">添加</button>
        <button class="btn btn-danger" id="delete">删除</button>
    </div>

$(function () {
        $("#delete").click(function () {
            var chk_value =[];
            $('input[name="testid"]:checked').each(function(){
                chk_value.push($(this).val());
            });
            // alert(chk_value.length==0 ?'你还没有选择任何内容！':chk_value);
            if(chk_value.length != 0){
                var mymessage=confirm("确定删除吗？")
                if(mymessage==true){
                    // alert(chk_value)
                    $.ajax({
                        url:'/delete/'+chk_value,
                        type:'POST',
                        timeout:1000,
                        cache:false,
                        success:function () {
                            alert("删除成功!!!");
                            window.location.reload();
                            // window.location.href='info.html';
                        },
                        error:function () {
                            alert("删除失败!!!");
                        }
                    })
                }else{
                    return false;
                }
            }else{
                alert("你还没有选择任何要删除的内容！")
            }
        })
    })

@app.route('/delelte/<id>',methods=['POST'])
def delete(id):
    list1=[int(x) for x in str(id).split(",")]
    # print list1
    if len(tuple(list1)) == 1:
        delsql = "delete from flask_info where id ="+str(list1[0])  +";"
    else:
        delsql = "delete form flask_info where id in " + str(tuple(list1)) + ";"
    execute_sql(delsql)
    return "OK"

def execute_sql(sql1):
    db = sqlite3.connect('test_flask.db')
    cur = db.cursor()
    print(sql1)
    cur.execute(sql1)
    cur.close()
    db.commit()
    db.close()