Python中通過cx_oracle操作ORACLE資料庫的封閉函數

標籤：

哈哈，看來我的SQL自動化發布，馬上就全面支援ORACLE,MYSQL,POSTGRESQL,MSSQL啦。。。

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

def Oracle_Exec(SqlStr):    "Execute oracle command"    conn = cx_Oracle.connect(DB_UserName, DB_UserPwd, DB_ConnectStr)        cursor = conn.cursor()    try:        cursor.execute(SqlStr)        conn.commit()        return True        except:        conn.rollback()        print "Exec sql failed: %s" % SqlStr        return False    finally:                cursor.close()        conn.close()        def Oracle_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)            while 1:                 rs = cursor.fetchone()            if rs == None:                break            datalist.append(rs)        if debug:            fieldnames = []            for field in cursor.description:                fieldnames.append(field[0])            print fieldnames            print datalist            print "Query success!"                except:        print "Exec sql failed: %s" % SqlStr             finally:                cursor.close()        conn.close()        return datalist     

 

Python中通過cx_oracle操作ORACLE資料庫的封閉函數