以通用类的形式写出python执行10条oracle查询sql语句通用代码
时间: 2024-02-01 19:15:50 浏览: 27
以下是一个示例通用类,可以执行Oracle查询SQL语句:
```python
import cx_Oracle
class OracleQuery:
def __init__(self, host, port, user, password, sid):
self.host = host
self.port = port
self.user = user
self.password = password
self.sid = sid
self.connection = None
def connect(self):
dsn_tns = cx_Oracle.makedsn(self.host, self.port, self.sid)
self.connection = cx_Oracle.connect(self.user, self.password, dsn_tns)
def query(self, sql):
cursor = self.connection.cursor()
cursor.execute(sql)
result = cursor.fetchall()
cursor.close()
return result
```
使用示例:
```python
oracle = OracleQuery('localhost', 1521, 'username', 'password', 'SID')
oracle.connect()
# 查询语句1
result1 = oracle.query('SELECT * FROM table1')
# 查询语句2
result2 = oracle.query('SELECT * FROM table2 WHERE column1 = "value"')
# 查询语句3
result3 = oracle.query('SELECT column1, column2 FROM table3 WHERE column3 > 10')
```
注意:需要安装`cx_Oracle`模块。