Python使用pymysql

2020-03-04  本文已影响0人  LeslieLiang
from . import config
import pymysql

class Mysql:
    def __init__(self):
        self.conn()

    def conn(self):
        self.conn = pymysql.connect(
            host = config.DB.get('HOST'),
            user = config.DB.get('USER'),
            password = config.DB.get('PASSWORD'),
            database = config.DB.get('DATABASE'),
            charset = config.DB.get('CHARSET'),
        )
        self.cursor = self.conn.cursor(cursor = pymysql.cursors.DictCursor)

    def close(self):
        self.cursor.close()
        self.conn.close()
上一篇 下一篇

猜你喜欢

热点阅读