以通用类的形式写出python执行10条oracle查询sql语句通用代码,添加异常处理
时间: 2024-02-01 14:15:53 浏览: 23
下面是一个Python程序,可以执行10条Oracle查询SQL语句,其中包括异常处理:
```python
import cx_Oracle
# Oracle 数据库连接信息
db_host = 'localhost'
db_port = 1521
db_sid = 'ORCL'
db_username = 'scott'
db_password = 'tiger'
# Oracle 连接字符串
dsn = cx_Oracle.makedsn(db_host, db_port, db_sid)
conn = cx_Oracle.connect(db_username, db_password, dsn)
# 10条查询SQL语句
sql_list = [
"SELECT * FROM emp",
"SELECT * FROM dept",
"SELECT * FROM salgrade",
"SELECT * FROM bonus",
"SELECT * FROM job",
"SELECT * FROM loc",
"SELECT * FROM mgr",
"SELECT * FROM sal",
"SELECT * FROM tab",
"SELECT * FROM user_tab_cols"
]
# 执行查询并打印结果
for sql in sql_list:
try:
cursor = conn.cursor()
cursor.execute(sql)
rows = cursor.fetchall()
for row in rows:
print(row)
except cx_Oracle.Error as error:
print(f"查询 {sql} 出错,错误信息:{error}")
finally:
cursor.close()
# 关闭数据库连接
conn.close()
```
以上代码连接本地 Oracle 数据库,执行了10条查询SQL语句,并打印结果。如果有任何查询出错,它将捕获 `cx_Oracle.Error` 异常并打印错误信息。