python+cx_Oracle实现操作sql方法

备注：初学python，简单的写写小脚本，发个文章，欢迎指正；

import cx_Oracle

class DBoracle(object):


    def __init__(self,username,password,url):
        """
        实例属性
        :param username: 用户名
        :param password: 密码
        :param url: 实例名
        """
        self.username = username
        self.password = password
        self.url = url
        self.db = None

    def connect(self):
        self.db = cx_Oracle.connect(self.username,self.password,self.url)
        cursor = self.db.cursor()
        return cursor




    #查询数据
    def select(self,sql):
        cr = self.connect()
        cr.execute(sql)
        rs = cr.fetchall()
        list = []
        for i in rs:
            list.append(i[0])
        print(list)

    #新增数据
    def insert(self,sql,sql2):
        cr = self.connect()
        cr.execute(sql)
        self.db.commit()
        self.select(sql2)

    #删除数据
    def delete(self,sql,sql2):
        cr = self.connect()
        cr.execute(sql)
        a = input('是否执行删除操作，输入任意字确认，为空则不删除:')
        if len(a) > 0:
            self.db.commit()
            print('=====数据已删除，执行查询=====')
            self.select(sql2)
            return
        else:
            self.db.rollback()
            print('=====操作已回滚=====')
            self.select(sql2)


    def closeAll(self):
        self.db.close()
        self.connect().close()



ocl = DBoracle('ocean_arch', 'sea3000', '192.168.176.25:1521/sea')
s1 = 'insert into test_table (ID) values (\'12\')'
s2 = 'select * from test_table'


d1 = "delete from test_table where id = 9527"

ocl.select(s2)
ocl.closeAll()