flask 操作mysql的两种方式-sql操作
一、用常规的sql语句操作
# coding=utf-8
# model.py
import MySQLdb
def get_conn():
conn = MySQLdb.connect("localhost", "root", "root@123", "jike")
return conn
class User(object):
def __init__(self, user_id, user_name):
self.user_id = user_id
self.user_name = user_name
def save(self):
conn = get_conn()
cursor = conn.cursor()
sql = "insert into user (user_id, user_name) VALUES (%s, %s)"
cursor.execute(sql, (self.user_id, self.user_name))
conn.commit()
cursor.close()
conn.close()
@staticmethod
def query_all():
conn = get_conn()
cursor = conn.cursor()
sql = "select * from user"
cursor.execute(sql)
rows = cursor.fet