整理思路
1.导入from pymysql import *
(下载pymsql,终端中输入pip3 install pymysql)
2.建立类,和函数根据已经创建过的数据库和优化后coding
class JD(object):
def __init__(self):
# 创建Connection连接
self.conn = connect(
host='localhost',
port=3306,
database='jing_dong',
user='root',
password='mysql',
charset='utf8')
# 获得Cursor对象
self.csl = self.conn.cursor()
def __del__(self):
# 关闭
self.csl.close()
self.conn.close()
def execute_sql(self,sql):
self.csl.execute(sql)