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 (){
            $('#adds').click(function () {
                $('#pageid').hide();//隐藏分页标签
                $('#mainbody').html(table1);
                $( "#add" ).click(function() {
                    var pms_name=$('#pms_name').val();
                    var content = $('#content').val();
                    var status = $('#status').val();
                    var mark = $('#mark').val();
                    // document.getElementById("apiadd").disabled = false;
                    $("#add").attr('disabled',true);
                    // alert(demands)
                    data={data: JSON.stringify({"pms_name":pms_name, "content":content, "status":status, "mark":mark})};
                    // alert(data);
                    $.ajax({
                        type: "post",
                        dataType : 'json',
                        async: false,
                        url: "/adds",
                        data: data,
                        success: function(){
                            alert("添加成功！！！");
                            location.href="info.html";
                        },
                        error: function (){
                            alert("添加失败！！！");
                        }
                    })
                });
            })
})

@app.route('/adds',methods=['post'])
def addApi():
    datas = json.loads(request.form.get('data'))
    print(datas)
    createtime = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())
    sql = "insert into flask_info (pms_name,content,status,mark,create_time) VALUES "
    data = "('" + datas['pms_name'] + "','" + datas["content"] + "','" + datas["status"] + "','" + datas["mark"] + "','" + str(createtime) + "'"
    end = data + ")"
    sql = sql + end
    execute_sql(sql)
    return "200"

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