使用Python操作Informix
要使用Python操作Informix数据库，您需要安装Informix数据库驱动程序。推荐使用ibm_db或pyodbc驱动程序。这里我们以ibm_db驱动程序为例进行介绍。
1. 安装ibm_db驱动程序：
pip install ibm_db
2. 连接到数据库：
python
import ibm_db
conn_str = 'DATABASE=your_database;HOSTNAME=your_host;PORT=your_port;PROTOCOL=TCPIP;UID=your_username;PWD=your_password;'
conn = ibm_db.connect(conn_str, '', '')
if conn:
print("Database connected successfully.")
else:
print("Failed to connect database.")
3. 插入数据：
python
sql = "INSERT INTO your_table (column1, column2) VALUES (?, ?)"
stmt = ibm_db.prepare(conn, sql)
column1_value = "value1"
column2_value = "value2"
ibm_db.bind_param(stmt, 1, column1_value)
ibm_db.bind_param(stmt, 2, column2_value)
if ibm_db.execute(stmt):
print("Data inserted successfully.")
else:
print("Failed to insert data.")
ibm_db.close(stmt)
4. 查询数据：
python
sql = "SELECT * FROM your_table"
stmt = ibm_db.exec_immediate(conn, sql)
while ibm_db.fetch_row(stmt):
column1_value = ibm_db.result(stmt, 0)
column2_value = ibm_db.result(stmt, 1)
print(f"Column1: {column1_value}, Column2: {column2_value}")
ibm_db.close(stmt)
5. 修改数据：
python
sql = "UPDATE your_table SET column1 = ? WHERE column2 = ?"
stmt = ibm_db.prepare(conn, sql)
column1_value = "new_value"
column2_value = "value2"
ibm_db.bind_param(stmt, 1, column1_value)
ibm_db.bind_param(stmt, 2, column2_value)
if ibm_db.execute(stmt):
print("Data updated successfully.")
else:
print("Failed to update data.")
ibm_db.close(stmt)
6. 删除数据：
python
sql = "DELETE FROM your_table WHERE column1 = ?"
stmt = ibm_db.prepare(conn, sql)
column1_value = "value1"
ibm_db.bind_param(stmt, 1, column1_value)
if ibm_db.execute(stmt):
print("Data deleted successfully.")
else:
print("Failed to delete data.")
ibm_db.close(stmt)
以上是使用Python操作Informix数据库的基本操作示例。请根据您的实际情况进行相应的调整。
