python-连接sqlite数据库封装\参数化封装

import sqlite3

class ReadSqlite():
    conn = sqlite3.connect("sledbExtra.db")
    cur = conn.cursor()

    def __init__(self):
        self.cur.execute("create table if not exists BASI_PROJ_INFO([PROJ_ID] INTEGER, [PROJ_NAME] NVARCHAR(20))")
        print("table created successfully!")

    def addRecord(self):
        self.cur.execute("insert into BASI_PROJ_INFO(PROJ_ID, PROJ_NAME) values (16, 'Pakistan')")
        self.conn.commit()
        print("record inserted successfully!")

    def getRecord(self):
        self.cur.execute("select * from basi_proj_info;")
        for row in self.cur:
            print("PROJ_ID = ", row[0])
            print("PROJ_NAME = ", row[1])


    # def updateRecord(self):
    # def deleteRecord(self):


    def Dbclose(self):
        self.conn.commit()
        self.conn.close()

db=ReadSqlite()
#db.addRecord()
db.getRecord()

===================参数化封装=====================================

import sqlite3


class ReadSqlite():
    conn = ""
    cur = ""
    def __init__(self, dbName):
        self.conn = sqlite3.connect(dbName)
        self.cur = self.conn.cursor()

    def addRecord(self):
        self.cur.execute("insert into BASI_PROJ_INFO(PROJ_ID, PROJ_NAME) values (16, 'Pakistan')")
        self.conn.commit()
        print("record inserted successfully!")

    def getRecord(self):
        self.cur.execute("select * from basi_proj_info;")
        for row in self.cur:
            print("PROJ_ID = ", row[0])
            print("PROJ_NAME = ", row[1])
    # def updateRecord(self):
    # def deleteRecord(self):

    def Dbclose(self):
        self.conn.commit()
        self.conn.close()


dh = ReadSqlite("sledbExtra.db")
# dh.addRecord()
dh.getRecord()
dh.Dbclose()