Flask+mysql+postman实现对数据库的增删改查

Python代码

# coding=utf-8
from flask import Flask
import pymysql
from flask import request
import json

app = Flask(__name__)


@app.route('/add', methods=['get', 'post'])
def add():
    if request.method == 'GET':
        name1 = request.values.get('name')
        age1 = request.values.get('age')
    elif request.method == 'POST':
        try:
            name1 = request.form['name']
            age1 = request.form['age']
        except KeyError:
            ret = {
   'code': 10001, 'message': '参数不能为空！'}
            return json.dumps(ret, ensure_ascii=False)
    if name1 and age1:
        # 打开数据库连接
        db = pymysql.connect(host="localhost", user="root", password="123456", database="test")
        # 使用cursor（）方法创建一个游标对象cursor
        cursor = db.cursor()
        # sql插入语句 拼接注意字符串要加引号
        sql = "insert into person(name,age) values ('" + name1 + "' ," + age1 + ")"
        print(sql)
        try:
            cursor.execute(sql)
            # 提交
            db.commit()
            return '添加成功'
        except Exception as e:
            # 错误回滚
            db.rollback()
            return '添加失败'
        fi