#复诊
importsysimportosimporttimeimportoperatorimportcx_Oracleimportnumpy as npimportpandas as pdimporttensorflow as tf
uid= 6sql= "select username,sex,age,province,area,bumen,ke,result,chufang,jianyi,yiyuaan,yisheng,jianchaxiang,zhenduanriqi from zhenduanjilutable where userid=%d" %uid
cursor.execute(sql)
rows=cursor.fetchall()
zhenduanjilu=[]for row inrows:
temp=[]
temp.append(row[0])
temp.append(row[1])
temp.append(row[2])
temp.append(row[3])
temp.append(row[4])
temp.append(row[5])
temp.append(row[6])
temp.append(row[7])
temp.append(row[8])
temp.append(row[9])
temp.append(row[10])
temp.append(row[11])
temp.append(row[12])
temp.append(row[13])
zhenduanjilu.append(temp)print("===================打印诊断历史记录=====================")for i inrange(len(zhenduanjilu)):print("-------------->>第:"+str(i+1)+"次诊断<
num= int(input("请输入需要复诊的对应第几次诊断记录编号:"))print("===================开始复诊流程=====================")
num-= 1username=zhenduanjilu[num][0]
sex=zhenduanjilu[num][1]
age=zhenduanjilu[num][2]
province=zhenduanjilu[num][3]
area=zhenduanjilu[num][4]
bumen=zhenduanjilu[num][5]
ke=zhenduanjilu[num][6]
sql= "select keid from hy_keid where ke='%s'" %ke
cursor.execute(sql)
rows=cursor.fetchall()
keid=[]for row inrows:
keid.append(row[0])
sql= "select QUESTION from HY_QUESTID where QUID=%d" %keid[0]
cursor.execute(sql)
rows=cursor.fetchall()
question=[]for row inrows:
question.append(row[0])
question= question[0].split(",")#print(question)
answer =[]for i,j inzip(question,np.arange(len(question))):print("问题"+str(j+1)+":是否"+i+":")print("A、正常 B、较轻 C、