python医疗系统设计_吴裕雄 python 人工智能——智能医疗系统后台用户复诊模块简约版代码展示...

#复诊

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、