吴裕雄人工智能 java、javascript、HTML5、python、oracle ——智能医疗系统WEB端智能分诊代码简洁版实现

<%--

    Document   : getInfo

    Created on : 2018-10-7, 21:36:37

    Author     : acer

--%>

<%@page import="java.util.Iterator"%>

<%@page import="java.util.List"%>

<%@page import="db.ActionDB"%>

<%@page import="db.DBConnection"%>

<%@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>

    <body>

    <center><h2>智能分诊</h2></center>

    <hr>

    <form id='test_form' action='getInfoTwo.jsp' method='' omsubmit='return checkForm()'>

        选择你现在省份：<select name="province" size="1" id="province">

            <option value="北京市">北京市</option>

            <option value="重庆市">重庆市</option>

            <option value="香港特别行政区">香港特别行政区</option>

            <option value="安徽省">安徽省</option>

            <option value="河南省">河南省</option>

            <option value="湖北省">湖北省</option>

            <option value="陕西省">陕西省</option>

            <option value="青海省">青海省</option>

            <option value="台湾省">台湾省</option>

            <option value="黑龙江省">黑龙江省</option>

            <option value="山东省">山东省</option>

            <option value="海南省">海南省</option>

            <option value="贵州省">贵州省</option>

            <option value="吉林省">吉林省</option>

            <option value="福建省">福建省</option>

            <option value="上海市">上海市</option>

            <option value="浙江省">浙江省</option>

            <option value="四川省">四川省</option>

            <option value="云南省">云南省</option>

            <option value="新疆维吾尔自治区">新疆维吾尔自治区</option>

            <option value="河北省">河北省</option>

            <option value="江苏省">江苏省</option>

            <option value="江西省">江西省</option>

            <option value="广东省">广东省</option>

            <option value="辽宁省">辽宁省</option>

            <option value="湖南省">湖南省</option>

            <option value="甘肃省">甘肃省</option>

            <option value="内蒙古自治区">内蒙古自治区</option>

            <option value="广西壮族自治区">广西壮族自治区</option>

            <option value="西藏自治区">西藏自治区</option>

            <option value="澳门特别行政区">澳门特别行政区</option>

            <option value="天津市">天津市</option>

            <option value="山西省">山西省</option>

            <option value="宁夏回族自治区">宁夏回族自治区</option>

        </select>

        <input type="submit" name="Submit" value="下一步" />

    </form>

</body>

</html>

<%--

    Document   : getInfoTwo

    Created on : 2018-10-11, 13:22:00

    Author     : acer

--%>

<%@page import="java.util.Iterator"%>

<%@page import="java.util.List"%>

<%@page import="db.ActionDB"%>

<%@page import="db.DBConnection"%>

<%@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>

    <center><h2>智能分诊</h2></center>

    <hr>

    <body>

        <form action="fenzhen.jsp" method="post">

            <table width="874" cellspacing="0" cellpadding="0">

                <tr>

                    <td><div align="right">请输入你的症状：</div></td>

                    <td>      <textarea name="zhengzhuang" id="zhengzhuang"></textarea>    </td>

                </tr>

                <tr>

                    <td rowspan="2"><div align="right">请选择你目前所在地（省份/地区）：</div></td>

                    <td>省份/地区：</td>

                    <td>

                        <%

                            String province = request.getParameter("province");

                            if (province != null) {

                                DBConnection conn = new DBConnection();

                                ActionDB action = new ActionDB(conn.getConnection());

                                List<String> administ = action.findAdminist(province);

                                Iterator<String> iter = administ.iterator();

                                int length = administ.size();

                                String[] str_administ = new String[length];

                                for (int i = 0; i < str_administ.length; i++) {

                                    str_administ[i] = iter.next();

                                }

                        %>

                        省份：<input type='text' name='province' value='<%=province%>'/><br>

                        地区：<select name="administ" size="1" id="administ">

                            <%for (int i = 0; i < str_administ.length; i++) {%>

                            <option value="<%=str_administ[i]%>"><%=str_administ[i]%></option>

                            <%}%>

                        </select>

                        <%

                            }

                        %>

                    </td>

                </tr>

                <tr>

                    <td colspan="2">    <div align="center">

                            <input type="submit" name="Submit" value="确认" />

                            <input name="reset" type="reset" id="reset" value="重置" />

                        </div></td>

                </tr>

            </table>

        </form>

    </body>

</html>

/*

 * To change this license header, choose License Headers in Project Properties.

 * To change this template file, choose Tools | Templates

 * and open the template in the editor.

 */

package db;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class DBConnection {

    private static String DBDRIVER = "oracle.jdbc.OracleDriver";    //驱动标识符

    private static String DBURL = "jdbc:oracle:thin:@localhost:1521:tszr"; //链接字符串

    private static String DBUSER = "doctor";         //数据库的用户名

    private static String DBPASSWORD = "admin";     //数据库的密码

    private Connection conn = null;

    public DBConnection() throws Exception {

        Class.forName(DBDRIVER);

        this.conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);

    }

    public Connection getConnection() {

        return this.conn;

    }

    public void close() throws Exception {

        if (this.conn != null) {

            try {

                this.conn.close();

            } catch (SQLException e) {

                throw e;

            }

        }

    }

}

/*

 * To change this license header, choose License Headers in Project Properties.

 * To change this template file, choose Tools | Templates

 * and open the template in the editor.

 */

package db;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.util.ArrayList;

import java.util.List;

public class ActionDB {

    private Connection conn = null;

    private PreparedStatement pstmt = null;

    public ActionDB() {

    }

    public ActionDB(Connection conn) {

        this.conn = conn;

    }

    public List<String> findAdminist(String province) throws Exception {

        List<String> allList = new ArrayList<String>();

        String sql = "select administrative from hostitaladrrest where province=?";

        this.pstmt = this.conn.prepareStatement(sql);

        this.pstmt.setString(1, province);

        ResultSet rs = this.pstmt.executeQuery();

        while (rs.next()) {

            allList.add(rs.getString(1));

        }

        this.pstmt.close();

        return allList;

    }

}

<%--

    Document   : fenzhen

    Created on : 2018-10-8, 6:09:42

    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 zhengzhuang = request.getParameter("zhengzhuang");

        String province = request.getParameter("province");

        String administ = request.getParameter("administ");

        String[] userInfo = new String[]{"python", "F:\\HostitalProject\\src\\java\\pyFile\\getInfo.py", zhengzhuang, province, administ};

        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" border="1">

        <tr>

            <td width="383"><div align="right">你的症状：</div></td>

            <td width="489">      <textarea name="zhengzhuang" id="zhengzhuang" value="<%=zhengzhuang%>"><%=zhengzhuang%></textarea>    </td>

        </tr>

        <tr>

            <td rowspan="2"><div align="right">目前所在地（省份/地区）：</div></td>

            <td>省份：

                <input name="province" type="text" id="province" value="<%=province%>"/>    </td>

        </tr>

        <tr>

            <td>地区：<input name="administ" type="text" id="province" value="<%=administ%>"/>      </td>

        </tr>

        <tr>

            <td colspan="2"><div align="center">系统分诊信息</div></td>

        </tr>

        <tr>

            <td colspan="2">

                <%

                    for (int i = 0; i < str_back.length; i++) {

                %>

                <h3><%=str_back[i]%></h3>

                <%

                    }

                %>

            </td>

        </tr>

    </table>

    <h2><a href="log.html">返回登录页</a></h2>

</body>

</html>

# coding:utf-8

import sys

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 getPAH(province, administrative):

    sql = "select hostitalname from hostitalAdrrest where province='%s' and administrative='%s'" % (

    province, administrative)

    cursor.execute(sql)

    rows = cursor.fetchall()

    hostitalName = []

    for row in rows:

        hostitalName.append(row[0])

    for i in range(len(hostitalName)):

        print(hostitalName[i])

def getSeeProject(subject):

    sql = "select CHACKPRO from chackProject where FAMILY='%s'" % (subject)

    cursor.execute(sql)

    rows = cursor.fetchall()

    seeproject = []

    for row in rows:

        seeproject.append(rows[0])

    return seeproject[0][0]

def getDoctors(sujects):

    sql = "select addraction,name,summary from doctors where family='%s'" % (sujects)

    cursor.execute(sql)

    rows = cursor.fetchall()

    doctorInfo = []

    for row in rows:

        doctorInfo.append(row[0])

        doctorInfo.append(row[1])

        doctorInfo.append(row[2])

    print("主治专家姓名：" + doctorInfo[1])

    print("主治专家简介：" + doctorInfo[2])

    print("主治专家所在医院：" + doctorInfo[0])

    return doctorInfo

def getInfo(argv, province, administ):

    sql = "select distinct surgery from menzhen"

    cursor.execute(sql)

    rows = cursor.fetchall()

    dipart = []

    for row in rows:

        dipart.append(row[0])

    ############################################

    sql = "select distinct surgery,surgerychest from menzhen"

    cursor.execute(sql)

    rows = cursor.fetchall()

    dipartmentSubj = []

    for row in rows:

        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 = []

    for row in rows:

        one = []

        one.append(row[0])

        one.append(row[1])

        subjectQues.append(one)

    #############################################################

    if (len(argv) == 1):

        print('很抱歉系统没有匹配到你症状所对应的门诊部门...')

    else:

        sym = ""

        for i in range(1, len(argv)):

            sym += argv[i]

        symptom = []

        symptom.extend(sym)

        subCount = []

        flat = False

        for j in range(len(subjectQues)):

            temp = []

            que = []

            que.extend(subjectQues[j][1])

            count = 0

            for i in range(len(symptom)):

                if (symptom[i] != "," or symptom[i] != " "):

                    for k in range(len(que)):

                        if (symptom[i] == que[k]):

                            count = count + 1

                            flat = True

            temp.append(subjectQues[j][0])

            temp.append(count)

            subCount.append(temp)

        ############################################################

        if (flat):

            for i in range(len(subCount)):

                for j in range(len(dipartmentSubj)):

                    if (subCount[i][0] == dipartmentSubj[j][1]):

                        subCount[i].append(dipartmentSubj[j][0])

            symMaxCount = sorted(subCount, key=(lambda x: x[1]), reverse=True)

            print("根据你输入的问题，经过大数据分析建议你选择以下的门诊部和对应的科：")

            print("门诊部门：" + symMaxCount[0][2])

            print("对应的科：" + symMaxCount[0][0])

            print("根据你的情况，系统推荐重点检查身体以下几项健康指标：")

            seeproject = getSeeProject(symMaxCount[0][0])

            print("推荐检查：", seeproject)

            print("===============================================================================================")

            print("根据你的情况，系统向你推荐以下在这一治疗领域专家：")

            doctorInfo = getDoctors(symMaxCount[0][0])

            print("===============================================================================================")

            print("根据你所处的位置，系统找到以下与你距离最近的医院：")

            getPAH(province, administ)

        else:

            print('很抱歉系统没有匹配到你症状所对应的门诊部门...')

# getInfo("发烧 感冒 流鼻涕","广东省","广州市")

import sys

def action(infon):

    getInfo(infon[0],infon[1],infon[2])

if __name__ == '__main__':

    infon = []

    for i in range(1,len(sys.argv)):

        infon.append(sys.argv[i])

    action(infon)

巴特西

吴裕雄人工智能 java、javascript、HTML5、python、oracle ——智能医疗系统WEB端智能分诊代码简洁版实现

最新文章

热门文章

巴特西

吴裕雄 人工智能 java、javascript、HTML5、python、oracle ——智能医疗系统WEB端智能分诊代码简洁版实现

最新文章

热门文章

吴裕雄人工智能 java、javascript、HTML5、python、oracle ——智能医疗系统WEB端智能分诊代码简洁版实现