import sys
import os
import time
import operator
import cx_Oracle
import numpy as np
import pandas as pd
import tensorflow as tf
conn=cx_Oracle.connect('doctor/admin@localhost:1521/tszr')
cursor = conn.cursor()
def printHistory(userid):
sql = "select username,sex,age,province,area,bumen,ke,result,chufang,jianyi,yiyuaan,yisheng,jianchaxiang,zhenduanriqi from zhenduanjilutable where userid='%d'" % userid
cursor.execute(sql)
rows = cursor.fetchall()
zhenduanjilu = []
for row in rows:
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 in range(len(zhenduanjilu)):
print("-------------->>第:"+str(i+1)+"次诊断<<-------------------")
print(" 姓名:"+zhenduanjilu[i][0])
print(" 性别:"+zhenduanjilu[i][1])
print(" 年龄:"+str(zhenduanjilu[i][2]))
print(" 省份:"+zhenduanjilu[i][3])
print(" 市区:"+zhenduanjilu[i][4])
print(" 门诊部门:"+zhenduanjilu[i][5])
print(" 门诊科目:"+zhenduanjilu[i][6])
print(" 诊断结果:"+zhenduanjilu[i][7])
print(" 医疗处方:"+zhenduanjilu[i][8])
print(" 养生建议:"+zhenduanjilu[i][9])
print(" 推荐医院:"+zhenduanjilu[i][10])
print(" 推荐医生:"+zhenduanjilu[i][11])
print(" 建议检查项:"+zhenduanjilu[i][12])
print(" 诊断日期:"+str(zhenduanjilu[i][13]))
# printHistory(6)
<%--
Document : ALSelectHistory
Created on : 2018-10-9, 21:28:13
Author : acer
--%>
<%@page import="java.util.Iterator"%>
<%@page import="java.util.ArrayList"%>
<%@page import="java.util.List"%>
<%@page import="java.io.InputStreamReader"%>
<%@page import="java.io.BufferedReader"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>智能复诊页title>
head>
<% request.setCharacterEncoding("UTF-8"); %>
<body>
<center><h2>智能复诊h2>center>
<hr>
<%
String userid = request.getParameter("userid");
String username = request.getParameter("username");
String province = request.getParameter("province");
String administ = request.getParameter("administ");
String[] userInfo = new String[]{"python", "F:\\HostitalProject\\src\\java\\pyFile\\printzhenduanjilu.py", userid};
Process pr = Runtime.getRuntime().exec(userInfo);
BufferedReader in = new BufferedReader(new InputStreamReader(pr.getInputStream()));
List<String> allList = new ArrayList<>();
String line;
while ((line = in.readLine()) != null) {
allList.add(line);
}
Iterator<String> iter = allList.iterator();
int length = allList.size();
String[] str_back = new String[length];
for (int i = 0; i < str_back.length; i++) {
str_back[i] = iter.next();
}
%>
<table width="874" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center">编号:<%=userid%> 就诊历史记录div>td>
tr>
<%
for (int i = 0; i < str_back.length; i++) {
%>
<tr>
<td><%=str_back[i]%>td>
tr>
<%
}
%>
table>
<form action="ALgetquestion.jsp" method="post">
<h2>请输入上面你需要复诊记录的编号:<input type="text" name="hisid" value=""/>h2>
<input type="hidden" name="userid" value="<%=userid%>"/>
<input type="hidden" name="username" value="<%=username%>"/>
<input type="hidden" name="province" value="<%=province%>"/>
<input type="hidden" name="administ" value="<%=administ%>"/>
<input type="submit" name="Submit" value="下一步" />
form>
body>
html>
<%--
Document : ALquestion
Created on : 2019-5-13, 15:40:45
Author : Administrator
--%>
<%@page import="java.util.Iterator"%>
<%@page import="java.util.ArrayList"%>
<%@page import="java.util.List"%>
<%@page import="java.io.InputStreamReader"%>
<%@page import="java.io.BufferedReader"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>复诊页title>
head>
<% request.setCharacterEncoding("UTF-8");%>
<body>
<center><h2>智能复诊h2>center>
<hr>
<%
String userid = request.getParameter("userid");
String username = request.getParameter("username");
String province = request.getParameter("province");
String administ = request.getParameter("administ");
String hisid = request.getParameter("hisid");
String[] userInfo = new String[]{"python", "F:\\HostitalProject\\src\\java\\pyFile\\getidcishu.py", userid,hisid};
Process pr = Runtime.getRuntime().exec(userInfo);
BufferedReader in = new BufferedReader(new InputStreamReader(pr.getInputStream()));
List<String> allList = new ArrayList<>();
String line;
while ((line = in.readLine()) != null) {
allList.add(line);
}
Iterator<String> iter = allList.iterator();
int length = allList.size();
String[] str_back = new String[length];
for (int i = 0; i < str_back.length; i++) {
str_back[i] = iter.next();
}
%>
<form action="ALgetquestion.jsp" method="post">
<input type="hidden" name="userid" value="<%=str_back[0]%>"/>
<input type="hidden" name="username" value="<%=str_back[1]%>"/>
<input type="hidden" name="sex" value="<%=str_back[2]%>"/>
<input type="hidden" name="age" value="<%=str_back[3]%>"/>
<input type="hidden" name="province" value="<%=str_back[4]%>"/>
<input type="hidden" name="area" value="<%=str_back[5]%>"/>
<input type="hidden" name="bumen" value="<%=str_back[6]%>"/>
<input type="hidden" name="ke" value="<%=str_back[7]%>"/>
<input type="submit" name="Submit" value="下一步" />
form>
body>
html>