使用Oracle,有几个很方便的东西是绕不过去的:nextval, currval,sysdate
1. nextval
示例如下,其中也示例了如何插入datatime
query_params={'A_ID':0}sql_string = "INSERT INTO TB_A(C_ID,A_ID,CREATE_DATE) " \
" values(SQ_C.nextval,:A_ID,sysdate)"
cursor.prepare(sql_string)
cursor.execute(None,query_params)
2. currval
currval必须在nextval之后使用,在oracle中也是一样的,以下语句接上面的语句
sql_string = "SELECT SQ_C.currval from dual"
cursor.execute(sql_string)
row = cursor.fetchone()
c_id = row[0]
print 'c_id',c_id