分类: Python/Ruby
2012-01-17 10:03:10
很简单的,地球人都懂,不解释了。O(∩_∩)O哈哈~
======================================================================================
另外附一段Python脚本。通过SQL查询,比较查询出的名字是否存在于dict的判断。
# conn = cx_Oracle.connect(user+"/xx@11.11.1.11:11/abc")
# cursor = conn.cursor()
# cursor.execute("select name from namelist where name_type='B' and name_id = '"+str(row[0])+"'")
# for name in cursor:
# fcase.write("|name=" + name[0])
# for name in name_list.keys():
# if name_list[name][0] == row[0]:
# fcase.write("|name=" + name_list[name][1])
# else:
# continue
# conn.close()