Java医院就诊挂号系统_spring


一、语言和环境

1. 实现语言： JAVA语言。

2. 环境要求： MyEclipse/Eclipse + Tomcat + MySQL。

3. 使用技术： Spring MVC + Spring + MyBatis 或 JSP + Servlet + JavaBean + JDBC。

二、实现效果

Java医院就诊挂号系统_mysql_02

实现能够对患者姓名，医师类别、科室的模糊查询，用户点击核销以后状态变为已就诊。
Java医院就诊挂号系统_java_03

点击挂号实现基本信息的添加
Java医院就诊挂号系统_atom_04

三、实现代码

数据库：

SET FOREIGN_KEY_CHECKS=0;


-- ----------------------------
-- Table structure for tb_patient
-- ----------------------------
DROP TABLE IF EXISTS `tb_patient`;
CREATE TABLE `tb_patient` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `sex` varchar(10) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `department` varchar(50) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `price` decimal(9,2) DEFAULT NULL,
  `state` int(11) DEFAULT NULL,
  `register_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;


-- ----------------------------
-- Records of tb_patient
-- ----------------------------
INSERT INTO `tb_patient` VALUES ('1', '张蕾', '女', '12', '13895463212', '儿科', '专家医师', '25.00', '1', '2021-07-18 12:23:00');
INSERT INTO `tb_patient` VALUES ('2', '刘德明', '男', '28', '13345623215', '骨科', '普通医师', '8.00', '0', '2021-07-18 12:23:00');
INSERT INTO `tb_patient` VALUES ('3', '李将军', '男', '38', '13578064788', '内科', '专家医师', '25.00', '1', '2021-07-17 12:23:00');
INSERT INTO `tb_patient` VALUES ('4', '张佩佩', '女', '44', '18214217246', '外科', '副主任医师', '17.00', '0', '2021-07-16 12:23:00');
INSERT INTO `tb_patient` VALUES ('5', '程聪明', '男', '29', '13652645964', '骨科', '副主任医师', '17.00', '0', '2021-08-08 16:21:52');


项目Java代码：

目录结构
Java医院就诊挂号系统_atom_05

JAR包：

Java医院就诊挂号系统_atom_06Java医院就诊挂号系统_javabean_07

代码：

=src
> com.mhys.crm.controller
HospitalContrller.java
package com.mhys.crm.controller;


import java.util.List;


import javax.annotation.Resource;


import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;


import com.mhys.crm.dao.TbPatientMapper;
import com.mhys.crm.entity.TbPatient;


@Controller
public class HospitalContrller {
  @Resource
  private TbPatientMapper tbPatientMapper;


  @RequestMapping("/select")
  public String getList(Model model) {
    List<TbPatient> selctAll = tbPatientMapper.selectAlls();
    System.out.println(selctAll);
    model.addAttribute("selctAll", selctAll);
    return "info";
  }


  @RequestMapping("/list")
  public String getAll(Model model, String name, String type, String dep) {
    List<TbPatient> selctAll = tbPatientMapper.selectAll(name, type, dep);
    System.out.println(name+"==="+type+"==="+dep);
    model.addAttribute("selctAll", selctAll);
    return "info";
  }


  @RequestMapping("/upd")
  public String upDev(Model model,int id) {
    int update = tbPatientMapper.update(id);
    return "redirect:/select.do";
  }


  @RequestMapping("/adds")
  public String adds(Model model) {
    return "addInfo";
  }


  @RequestMapping("/insert")
  public String toaddDev(Model model,TbPatient tb) {
    tbPatientMapper.insert(tb);
      return "redirect:/select.do";
  }


}
> com.mhys.crm.dao
TbPatientMapper.java
package com.mhys.crm.dao;


import com.mhys.crm.entity.TbPatient;
import java.util.List;


import org.apache.ibatis.annotations.Param;


public interface TbPatientMapper {
    int deleteByPrimaryKey(Integer id);


    int insert(TbPatient record);


    TbPatient selectByPrimaryKey(Integer id);


    List<TbPatient> selectAlls();


    int updateByPrimaryKey(TbPatient record);


    int update(Integer id);


    List<TbPatient> selectAll(@Param("name")String name,@Param("type")String type,@Param("dep")String dap);
}

TbPatientMapper.xml

 version="1.0" encoding="UTF-8" ?>

<mapper namespace="com.mhys.crm.dao.TbPatientMapper" >
  <resultMap id="BaseResultMap" type="com.mhys.crm.entity.TbPatient" >
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="sex" property="sex" jdbcType="VARCHAR" />
    <result column="age" property="age" jdbcType="INTEGER" />
    <result column="phone" property="phone" jdbcType="VARCHAR" />
    <result column="department" property="department" jdbcType="VARCHAR" />
    <result column="type" property="type" jdbcType="VARCHAR" />
    <result column="price" property="price" jdbcType="DECIMAL" />
    <result column="state" property="state" jdbcType="INTEGER" />
    <result column="register_time" property="registerTime" jdbcType="TIMESTAMP" />
  resultMap>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
    delete from tb_patient
    where id = #{id,jdbcType=INTEGER}
  delete>
  <insert id="insert" parameterType="com.mhys.crm.entity.TbPatient" >
    insert into tb_patient (id, name, sex, 
      age, phone, department, 
      type, price, state, 
      register_time)
    values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, #{sex,jdbcType=VARCHAR}, 
      #{age,jdbcType=INTEGER}, #{phone,jdbcType=VARCHAR}, #{department,jdbcType=VARCHAR}, 
      #{type,jdbcType=VARCHAR}, #{price,jdbcType=DECIMAL}, #{state,jdbcType=INTEGER}, 
      #{registerTime,jdbcType=TIMESTAMP})
  insert>
  <update id="updateByPrimaryKey" parameterType="com.mhys.crm.entity.TbPatient" >
    update tb_patient
    set name = #{name,jdbcType=VARCHAR},
      sex = #{sex,jdbcType=VARCHAR},
      age = #{age,jdbcType=INTEGER},
      phone = #{phone,jdbcType=VARCHAR},
      department = #{department,jdbcType=VARCHAR},
      type = #{type,jdbcType=VARCHAR},
      price = #{price,jdbcType=DECIMAL},
      state = #{state,jdbcType=INTEGER},
      register_time = #{registerTime,jdbcType=TIMESTAMP}
    where id = #{id,jdbcType=INTEGER}
  update>


  <select id="selectAlls" resultMap="BaseResultMap" >
    select id, name, sex, age, phone, department, type, price, state, register_time
    from tb_patient
  select>


  <select id="selectAll" resultMap="BaseResultMap" >
    select id, name, sex, age, phone, department, type, price, state, register_time
    from tb_patient
    <where>
    <if test="name!=null and name!=''">
      and name = #{name}
    if>
  <if test="type!=null and type!=''">
      and type = #{type}
    if>
    <if test="dep!=null and dep!=''">
      and department = #{dep}
    if>
    where>
  select>


  <update id="update" parameterType="com.mhys.crm.entity.TbPatient" >
    update tb_patient set state=1 where id = #{id,jdbcType=INTEGER}
  update>


mapper>
> com.mhys.crm.entity
TbPatient.java
package com.mhys.crm.entity;


import java.math.BigDecimal;
import java.util.Date;


public class TbPatient {
    private Integer id;


    private String name;


    private String sex;


    private Integer age;


    private String phone;


    private String department;


    private String type;


    private BigDecimal price;


    private Integer state;


    private Date registerTime;


    public Integer getId() {
        return id;
    }


    public void setId(Integer id) {
        this.id = id;
    }


    public String getName() {
        return name;
    }


    public void setName(String name) {
        this.name = name == null ? null : name.trim();
    }


    public String getSex() {
        return sex;
    }


    public void setSex(String sex) {
        this.sex = sex == null ? null : sex.trim();
    }


    public Integer getAge() {
        return age;
    }


    public void setAge(Integer age) {
        this.age = age;
    }


    public String getPhone() {
        return phone;
    }


    public void setPhone(String phone) {
        this.phone = phone == null ? null : phone.trim();
    }


    public String getDepartment() {
        return department;
    }


    public void setDepartment(String department) {
        this.department = department == null ? null : department.trim();
    }


    public String getType() {
        return type;
    }


    public void setType(String type) {
        this.type = type == null ? null : type.trim();
    }


    public BigDecimal getPrice() {
        return price;
    }


    public void setPrice(BigDecimal price) {
        this.price = price;
    }


    public Integer getState() {
        return state;
    }


    public void setState(Integer state) {
        this.state = state;
    }


    public Date getRegisterTime() {
        return registerTime;
    }


    public void setRegisterTime(Date registerTime) {
        this.registerTime = registerTime;
    }


  @Override
  public String toString() {
    return "TbPatient [id=" + id + ", name=" + name + ", sex=" + sex + ", age=" + age + ", phone=" + phone
        + ", department=" + department + ", type=" + type + ", price=" + price + ", state=" + state
        + ", registerTime=" + registerTime + "]";
  }




}
> com.mhys.crm.service.impl
HospitalService.java
package com.mhys.crm.service.impl;


import java.util.List;


import javax.annotation.Resource;


import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;


import com.mhys.crm.dao.TbPatientMapper;
import com.mhys.crm.entity.TbPatient;


public class HospitalService {
  @Resource
  private TbPatientMapper tbPatientMapper;


  @RequestMapping("/select")
  public String getList(Model model) {
    List<TbPatient> selctAll = tbPatientMapper.selectAlls();
    System.out.println(selctAll);
    model.addAttribute("selctAll", selctAll);
    return "info";
  }


  @RequestMapping("/list")
  public String getAll(Model model, String name, String type, String dep) {
    List<TbPatient> selctAll = tbPatientMapper.selectAll(name, type, dep);
    System.out.println(name+"==="+type+"==="+dep);
    model.addAttribute("selctAll", selctAll);
    return "info";
  }


  @RequestMapping("/upd")
  public String upDev(Model model,int id) {
    int update = tbPatientMapper.update(id);
    return "redirect:/select.do";
  }


  @RequestMapping("/adds")
  public String adds(Model model) {
    return "addInfo";
  }


  @RequestMapping("/insert")
  public String toaddDev(Model model,TbPatient tb) {
    tbPatientMapper.insert(tb);
      return "redirect:/select.do";
  }
}
=resource
> mybatis
SqlMapConfig.xml
 version="1.0" encoding="UTF-8" ?>

"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>


  <typeAliases>
    <package name="com.mhys.crm.entity"/>
  typeAliases>


configuration>
> spring
applicationContext-dao.xml
 version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
  xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"
  xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
  http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
  http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
  http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">


  <context:property-placeholder location="classpath:database.properties">context:property-placeholder>
  <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
    <property name="driverClassName" value="${jdbc.driver}">property>
    <property name="Url" value="${jdbc.url}">property>
    <property name="username" value="${jdbc.username}">property>
    <property name="password" value="${jdbc.password}">property>
  bean>
  
  <bean class="org.mybatis.spring.SqlSessionFactoryBean">
    
    <property name="configLocation" value="classpath:mybatis/SqlMapConfig.xml" />
    
    <property name="dataSource" ref="dataSource" />
  bean>
  
  <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    
    <property name="basePackage"  value="com.mhys.crm.dao" />
  bean>
  
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
      <property name="dataSource" ref="dataSource">property>
    bean>
    
    <tx:annotation-driven transaction-manager="transactionManager" />


beans>

applicationContext-service.xml

 version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
  xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"
  xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
  http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
  http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
  http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">
    
  <context:component-scan base-package="com" />
  <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource">property>
  bean>
  <tx:annotation-driven transaction-manager="transactionManager" />
beans>

spring-mvc.xml

 version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
  xmlns:context="http://www.springframework.org/schema/context"
  xmlns:mvc="http://www.springframework.org/schema/mvc"
  xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
    
  <context:component-scan base-package="com.mhys.crm.controller" />
  <mvc:annotation-driven />
  <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    <property name="prefix" value="/WEB-INF/jsp/" />
    <property name="suffix" value=".jsp" />
  bean>
beans>
> database.properties
jdbc.url=jdbc:mysql://localhost:3306/hospital_db?useUnicode=true&characterEncoding=UTF-8&useSSL=false
jdbc.username=root
jdbc.password=123456
jdbc.driver=com.mysql.jdbc.Driver
=JSP页面
> /WEB-INF/jsp/
addInfo.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>

<html>
  <head>
    <meta charset="utf-8">
    <title>挂号title>
  head>
  <body>
    <form action="insert.do" method="post">
      <table border="" cellspacing="" cellpadding="">


        <tr>
          <td>姓名td>
          <td><input type="text" name="name" value="" />td>
        tr>
        <tr>
          <td>性别td>
          <td><input type="text" name="sex" value=""/>td>
        tr>
        <tr>
          <td>年龄td>
          <td><input type="text" name="age" value=""/>td>
        tr>
        <tr>
          <td>电话td>
          <td><input type="text" name="phone" value=""/>td>
        tr>
        <tr>
          <td>医师类别td>
          <td><input type="text" name="department" value=""/>td>
        tr>
        <tr>
          <td>价格td>
          <td><input type="text" name="price" value=""/>td>
        tr>
        <tr>
          <td>挂号时间td>
          <td><input type="text" name="registerTime" value=""/>td>
        tr>


      table>
      <input type="submit" value="确定" />
    form>
  body>
html>

info.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>



charset="UTF-8">
医院就诊挂号系统



  align="center">医院就诊挂号系统
  
id="warp">
    
action="list.do">
    患者姓名：type="text" name="name">     
    医师类别：
             
    科室：type="text" name="dep">     
    type="submit" value="查询">   
    type="button" value="挂号" onclick="add()">
  

  style="margin-bottom: 30px;"width="100%"border="1px"cellpadding="11"cellspacing="0">













var="list" items="${selctAll }">
      













        
      编号      姓名      性别      年龄      电话      科室      医师类别      价格      挂号时间      状态      操作    
    
        ${list.id }        ${list.name }        ${list.sex }        ${list.age }        ${list.phone }        ${list.department }        ${list.type }        ${list.price }        value="${list.registerTime }" pattern="yyyy-MM-dd"/>        
          test="${list.state==0}">
               未就诊
             
          test="${list.state==1}">
               已就诊
             
        		        
          test="${list.state==0}">
               href="javascript:if(confirm('确实要核销该挂号信息吗?'))location='upd.do?id=${list.id }'">核销
             
          <%-- test="${list.state==1}">
               已就诊
              --%>

index.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path;
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>XXX系统title>
head>
<body>
<script>
  window.location.href="<%=basePath%>/select.do";
script>
body>
html>

源码下载

链接：https://pan.baidu.com/s/1Spl38NORVbpYs7MhY19goA

提取码：jisk

<END>