使用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)