#诊断逻辑代码
importsysimportosimporttimeimportoperatorimportcx_Oracleimportnumpy as npimportpandas as pdimporttensorflow as tf
conn=cx_Oracle.connect('doctor/admin@localhost:1521/tszr')
cursor=conn.cursor()#one-hot编码
defonehot(labels):
n_sample=len(labels)
n_class= max(labels) + 1onehot_labels=np.zeros((n_sample, n_class))
onehot_labels[np.arange(n_sample), labels]= 1
returnonehot_labels#获取数据集
defgetdata(surgery ,surgeryChest):
sql= "select feature1,feature2,feature3,feature4,feature5,trainLable from menzhen where surgery='%s' and surgeryChest='%s'" %\
(surgery, surgeryChest)
cursor.execute(sql)
rows=cursor.fetchall()
dataset=[]
lables=[]for row inrows:
temp=[]
temp.append(row[0])
temp.append(row[1])
temp.append(row[2])
temp.append(row[3])
temp.append(row[4])
dataset.append(temp)if (row[5] == 3):
lables.append(0)elif (row[5] == 6):
lables.append(1)else:
lables.append(2)
dataset=np.array(dataset)
lables=np.array(lables)
dataset=dataset.astype(np.float32)
labless=onehot(lables)returndataset, lablessdefgetAnswer(a1, a2, a3, a4, a5):
answers=[]
answers.append(int(a1))
answers.append(int(a2))
answers.append(int(a3))
answers.append(int(a4))
answers.append(int(a5))
str_answers=[]if (int(a1) == 1):
str_answers.append("正常")elif (int(a1) == 2):
str_answers.append("轻度")elif (int(a1) == 3):
str_answers.append("偏重")else:
str_answers.append("严重")if (int(a2) == 1):
str_answers.append("正常")elif (int(a2) == 2):
str_answers.append("轻度")elif (int(a2) == 3):
str_answers.append("偏重")else:
str_answers.append("严重")if (int(a3) == 1):
str_answers.append("正常")elif (int(a3) == 2):
str_answers.append("轻度")elif (int(a3) == 3):
str_answers.append("偏重")else:
str_answers.append(&#