download:Python自动化测试开发实战 一门能就业的测试课
python 3.4.3
cx_Oracle12345678910111213141516171819202122232425#!/usr/bin/env pythonimport timestart = time.clock()import cx_Oracle
tns = cx_Oracle.makedsn('127.0.0.1', '1534', 'dsn')db = cx_Oracle.connect('username', 'password', tns)def sqlSelect(sql, db):cur=db.cursor()cur.execute(sql)result=cur.fetchall()cur.close()return resultsql_1 = " "
sql_2 = " "sql_3 = " "sql_list = [sql_1, sql_2, sql_3]
for sql in sql_list:result = sqlSelect(sql, db)print(result[0][0])end = time.clock()
print("\nRunning time: %f s" % (end - start))
精彩评论