python--sqlite数据库连接+执行查询语句

import sqlite3
import os

PATH = os.path.dirname(os.path.dirname(__file__))


class Sqlite(object):
    def __init__(self):
        self.conn = sqlite3.connect(os.path.join(PATH, 'db/userData.db'), check_same_thread=False)
        self.curs = self.conn.cursor()

    def close_db(self):
        self.curs.close()
        self.conn.close()

    def select_sql(self, sql_, *data):
        try:
            self.curs.execute(sql_, *data)
            result = self.curs.fetchall()
            print("select_sql", 1, sql_)
            if result:
                return list(result)
            return None
        except Exception as error:
            print("select_sql", 0, error)

    def upDate_sql(self, sql_, *data):
        try:
            self.curs.execute(sql_, *data)
            self.conn.commit()
            print("upData_sql", 1, sql_)
        except Exception as error:
            print("upData_sql", 0, error)
            self.conn.rollback()

    def insert_sql(self, sql_, *data):
        try:
            self.curs.execute(sql_, *data)
            self.conn.commit()
            print("insert_sql", 1, sql_)
        except Exception as error:
            print("insert_sql", 0, error)
            self.conn.rollback()

    def del_sql(self, sql_, *data):
        try:
            self.curs.execute(sql_, *data)
            self.conn.commit()
            print("del_sql", 1, sql_)
        except Exception as error:
            print("del_sql", 0, error)
            self.conn.rollback()

    def create_table(self, sql_):
        try:
            self.curs.execute(sql_)
            self.conn.commit()
            print("create_table:", 1, sql_)
        except Exception as error:
            print("create_table:", 0, error)
            self.conn.rollback()


run_sql = Sqlite()

if __name__ == '__main__':
    pass
    # sql = """
    # CREATE TABLE login_bi(
    # id INTEGER PRIMARY KEY AUTOINCREMENT,
    # cookie TEXT,
    # times TEXT,
    # username TEXT,
    # starts integer)
    # """
    # print(run_sql.create_table(sql))

    # token = "2"
    # times = "2"
    # userName = 'admin'
    # passWord = 'admin'

    # sql = """
    # insert into login('token','times','username','password') values (?,?,?,?)
    # """
    # datas = ('token', 'times', 'userName', 'passWord')
    # run_sql.insert_sql(sql, datas)
    # #
    # print(run_sql.del_sql("delete from login where token='123456'"))
    # print(run_sql.select_sql("select * from login"))