python中使用cx_oracle插入数据

Python

import cx_Oracle
import os

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

APP_ID =35
username = 'zyl'
con = cx_Oracle.connect(
    "username",
    "password",
    "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (LOAD_BALANCE = yes)(FAILOVER = ON) (CONNECT_DATA = (SERVICE_NAME = servicename) ) )")
print(con.version)
cur = con.cursor()
# sql语句
statement = "INSERT INTO APPDB.T_TABLE(APP_ID, TYPE, USERNAME, INCLUDE, ENABLED) VALUES (:2, :3, :4, :5, :6)"
# 生产数据元组
data = (APP_ID, 1, username, 1, 1)
# 执行insert语句
cur.execute(statement, data)
# 提交事务
con.commit()
cur.close()
con.close()

参考：

• INSERT (CRUD) USING CX_ORACLE
• Using Bind Variables