enclosing function for Oracle database operation via cx_oracle in Python

Haha, it seems that my SQL Automation release, immediately full support oracle,mysql,postgresql,mssql ...

http://blog.csdn.net/swiftshow/article/details/7383481

deforacle_exec (sqlstr):"Execute Oracle Command"Conn=Cx_oracle.connect (Db_username, DB_USERPWD, db_connectstr) cursor=conn.cursor ()Try: Cursor.execute (SQLSTR) conn.commit ()returnTrueexcept: Conn.rollback ()Print "Exec SQL failed:%s"%sqlstrreturnFalsefinally: Cursor.close () conn.close ()defOracle_query (sqlstr, debug =0):"Execute Oracle Query, and return DataList"DataList=[] Conn=Cx_oracle.connect (Db_username, DB_USERPWD, db_connectstr) cursor=conn.cursor ()Try: Cursor.execute (SQLSTR) while1: Rs=Cursor.fetchone ()ifrs = =None: BreakDatalist.append (RS)ifDebug:fieldnames= []             forFieldinchcursor.description:fieldnames.append (field[0])PrintFieldNamesPrintDataListPrint "Query success!"                except:        Print "Exec SQL failed:%s"%sqlstrfinally: Cursor.close () conn.close ()returnDataList

enclosing function for Oracle database operation via cx_oracle in Python