mysql简单封装
配置文件congig,py
MYSQL_HOST = "127.0.0.1"
MYSQL_PORT = 3306
MYSQL_USER = "user"
MYSQL_PASSWD = "123456"
MYSQL_DB = "db_mysql"
MYSQL_CHARSET = "UTF8"
mysql封装
from config import *
import pymysql
class PyMysql():
def __init__(self):
self.conn = pymysql.connect(
host=MYSQL_HOST,
port=MYSQL_PORT,
user=MYSQL_USER,
passwd=MYSQL_PASSWD,
db=MYSQL_DB,
charset=MYSQL_CHARSET,
)
self.cur = self.conn.cursor(cursor=pymysql.cursors.DictCursor)
def __del__(self):
self.cur.close()
self.conn.close()
def select_db(self, sql):
"""
查询
:param sql: sql语句
:return:
"""
self.conn.ping(reconnect=True)
self.cur.execute(sql)
data = self.cur.fetchall()
return data
def execute_db(self,sql):
"""
更新、新增、删除
:param sql: sql语句
:return:
"""
try:
self.conn.ping(reconnect=True)
self.cur.execute(sql)
self.conn.commit()
except Exception as e:
print('操作错误:{}'.format(e))
self.conn.rollback()
if __name__ == '__main__':
db = PyMysql()