flask实现mysql连接池_flask 使用数据库连接池

使用原生sql语句

目录

初级阶段

制定一个函数

import pymysql

from flask import Flask

app = Flask(__name__)

def fetchall(sql):

conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123', db='t1')

cursor = conn.cursor()

cursor.execute(sql)

result = cursor.fetchall()

cursor.close()

conn.close()

return result

@app.route('/login')

def login():

result = fetchall('select * from user')

return 'login'

@app.route('/index')

def index():

result = fetchall('select * from user')

return 'xxx'

@app.route('/order')

def order():

result = fetchall('select * from user')

return 'xxx'

if __name__ == '__main__':

app.run()

在修改

使用的是同一个连接

import pymysql

from flask import Flask

app = Flask(__name__)

CONN = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123', db='t1')

def fetchall(sql):

cursor = CONN.cursor()

cursor.execute(sql)

result = cursor.fetchall()

cursor.close()

return result

@app.route('/login')

def login():

result = fetchall('select * from user')

return 'login'

@app.route('/index')

def index():

result = fetchall('select * from user')

return 'xxx'

@app.route('/order')

def order():

result = fetchall('select * from user')

return 'xxx'

if