#coding:utf-8
importsysimportcx_Oracleimportnumpy as npimportpandas as pdimporttensorflow as tfdefmain(argv):
conn=cx_Oracle.connect('doctor/admin@localhost:1521/tszr')
cursor=conn.cursor()
sql= "select distinct surgery from menzhen"cursor.execute(sql)
rows=cursor.fetchall()
dipart=[]for row inrows:
dipart.append(row[0])############################################
sql = "select distinct surgery,surgerychest from menzhen"cursor.execute(sql)
rows=cursor.fetchall()
dipartmentSubj=[]for row inrows:
one=[]
one.append(row[0])
one.append(row[1])
dipartmentSubj.append(one)###########################################################
sql = "select illSubject,question from questb"cursor.execute(sql)
rows=cursor.fetchall()
subjectQues&