基于Spring MVC + Spring + MyBatis的【医院就诊挂号系统】

喜欢ヅ旅行 2022-09-09 06:08 161阅读 0赞

> 资源下载：[https://download.csdn.net/download/weixin\_44893902/21727306][https_download.csdn.net_download_weixin_44893902_21727306]

## 一、语言和环境 ##

**1.实现语言：** JAVA语言。  
**2.环境要求：** MyEclipse/Eclipse + Tomcat + MySQL。  
**3.使用技术：** Spring MVC + Spring + MyBatis 或 JSP + Servlet + JavaBean + JDBC。

## 二、实现效果 ##

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5piO6YeR5ZCM5a2m_size_20_color_FFFFFF_t_70_g_se_x_16]  
实现能够对患者姓名，医师类别、科室的模糊查询，用户点击核销以后状态变为已就诊。  
![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5piO6YeR5ZCM5a2m_size_20_color_FFFFFF_t_70_g_se_x_16 1]  
点击挂号实现基本信息的添加  
![在这里插入图片描述][1409f759802e462c864742d45e75f0b0.png]

## 三、实现代码 ##

### 数据库： ###

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代码： ###

目录结构  
![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5piO6YeR5ZCM5a2m_size_13_color_FFFFFF_t_70_g_se_x_16]

#### JAR包： ####

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5piO6YeR5ZCM5a2m_size_18_color_FFFFFF_t_70_g_se_x_16]![在这里插入图片描述][656c8d2ab8e84d338900570442060103.png]

#### 代码： ####

##### =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 ######

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
    <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 ######

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    
    	<typeAliases>
    		<package name="com.mhys.crm.entity"/>
    	</typeAliases>
    
    </configuration>

##### > spring #####

###### applicationContext-dao.xml ######

<?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 ######

###### spring-mvc.xml ######

<?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"%>
    <!DOCTYPE html>
    <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"%>
    <!DOCTYPE html>
    <html>
    <head>
    <meta charset="UTF-8">
    <title>医院就诊挂号系统</title>
    <style type="text/css"> form{ padding: 20px; } #warp{ margin:0 auto; width: 60% } </style>
    </head>
    <body>
    	<h1 align="center">医院就诊挂号系统</h1>
    	<div id="warp">
    		<form action="list.do">
    		患者姓名：<input type="text" name="name">     
    		医师类别：
    				<select name="type">
    					<option value="" >=不限=</option>
    					<option value="专家医师" >专家医师</option>
    					<option value="普通医师" >普通医师</option>
    					<option value="副主任医师" >副主任医师</option>
    				</select>     
    		科室：<input type="text" name="dep">     
    		<input type="submit" value="查询">   
    		<input type="button" value="挂号" onclick="add()">
    	</form>
    	<table style="margin-bottom: 30px;" width="100%" border="1px" cellpadding="11" cellspacing="0">
    		<tr>
    			<th>编号</th>
    			<th>姓名</th>
    			<th>性别</th>
    			<th>年龄</th>
    			<th>电话</th>
    			<th>科室</th>
    			<th>医师类别</th>
    			<th>价格</th>
    			<th>挂号时间</th>
    			<th>状态</th>
    			<th>操作</th>
    		</tr>
    		<c:forEach var="list" items="${selctAll }">
    			<tr>
    				<td>${list.id }</td>
    				<td>${list.name }</td>
    				<td>${list.sex }</td>
    				<td>${list.age }</td>
    				<td>${list.phone }</td>
    				<td>${list.department }</td>
    				<td>${list.type }</td>
    				<td>${list.price }</td>
    				<td><fmt:formatDate value="${list.registerTime }" pattern="yyyy-MM-dd"/></td>
    				<td>
    					<c:if test="${list.state==0}">
    	 			    	未就诊
    	 			    </c:if>
    					<c:if test="${list.state==1}">
    	 			    	已就诊
    	 			    </c:if>
    				</td>
    				<td>
    					<c:if test="${list.state==0}">
    	 			    	<a href="javascript:if(confirm('确实要核销该挂号信息吗?'))location='upd.do?id=${list.id }'">核销</a>
    	 			    </c:if>
    					<%-- <c:if test="${list.state==1}">
    	 			    	已就诊
    	 			    </c:if> --%>
    				</td>
    			</tr>
    		</c:forEach>
    	</table>
    	</div>
    	<script type="text/javascript"> function add() { location.href="adds.do"; } </script>
    </body>
    </html>

###### index.jsp ######

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
    <!DOCTYPE html>
    <%
    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_download.csdn.net_download_weixin_44893902_21727306]: https://download.csdn.net/download/weixin_44893902/21727306
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5piO6YeR5ZCM5a2m_size_20_color_FFFFFF_t_70_g_se_x_16]: /images/20220829/c2b7a99bbc9b4ed9914bfbc399010fe0.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5piO6YeR5ZCM5a2m_size_20_color_FFFFFF_t_70_g_se_x_16 1]: /images/20220829/efd98367ce3e4ee5a7913d0771611556.png
[1409f759802e462c864742d45e75f0b0.png]: /images/20220829/087ca59facd04e76a1f353e29f561952.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5piO6YeR5ZCM5a2m_size_13_color_FFFFFF_t_70_g_se_x_16]: /images/20220829/47b0ff68cb0b4675b58ef452d44ed3d2.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5piO6YeR5ZCM5a2m_size_18_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/b7af343e5f8640ad8137dc733f20a477.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA5piO6YeR5ZCM5a2m,size_18,color_FFFFFF,t_70,g_se,x_16
[656c8d2ab8e84d338900570442060103.png]: /images/20220829/b1a788043ec84494a01e3b281b889f24.png