Oracle数据库连接

使用Oracle需要数据库与python版本一致，python调用Oracle需要配置环境变量

import cx_Oracle

from auto_interface.testting import rpb_all_param

# os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8'

class Oracle_conn():

classmethod可以在类调用时不用实例化直接使用内部函数

@classmethod

def select(self, sql, orcle_adress=rpb_all_param.Param.orcle_adress):

conn = cx_Oracle.connect(orcle_adress)

print(sql)

c = conn.cursor()

c.execute(sql)

ftechone会输出结果的第一条，循环输出可顺序输出全部

value = c.fetchone()

c.close()

conn.close()

if value is None:

return ''

print('8888888888888888')

print(value[0])

return value[0]

@classmethod

def update(self, sql, orcle_adress=rpb_all_param.Param.orcle_adress):

print(sql)

conn = cx_Oracle.connect(orcle_adress)

c = conn.cursor()

c.execute(sql)

获取影响行数

if c.rowcount < 1:

print('参数有误，需核对')

# print(c.rowcount)

c.close()

conn.commit()

conn.close()

if __name__ == "__main__":

Oracle_conn().update(sql)