Java医院就诊挂号系统（附源码）

顶级架构师 2021-12-16

推荐关注

顶级架构师后台回复 1024 有特别礼包

来源：blog.csdn.net/weixin_44893902/article/details/119986708

上一篇：男女洗澡前后区别，太形象了！

大家好，我是顶级架构师。

一、语言和环境

1. 实现语言： JAVA语言。

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

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

二、实现效果

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

点击挂号实现基本信息的添加

三、实现代码

数据库：

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

目录结构

JAR包：

代码：

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

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

搜索公众号GitHub猿后台回复“赚钱”，获取一份惊喜礼包。

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("/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

  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

<?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=falsejdbc.username=rootjdbc.password=123456jdbc.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>

源码获取

扫码下方二维码，后台回复【挂号系统】即可获取

公众号后台回复架构或者 架构整洁 有惊喜礼包！顶级架构师交流群

「顶级架构师」建立了读者架构师交流群，大家可以添加小编微信进行加群。欢迎有想法、乐于分享的朋友们一起交流学习。

扫描添加好友邀你进架构师群，加我时注明【姓名+公司+职位】

版权申明：内容来源网络，版权归原作者所有。如有侵权烦请告知，我们会立即删除并表示歉意。谢谢。

猜你还想看

史上讲解最好的 Docker 教程
 分布式事务最经典的七种解决方案
 阿里技术专家：一文教你高效画出技术架构图
 Loki日志系统详解

: ， . Video Mini Program Like ，轻点两下取消赞 Wow ，轻点两下取消在看

《鱿鱼游戏2》今天下午四点开播，网友无心上班了，导演悄悄剧透

刘恺威近况曝光，父亲刘丹证实已分手，目前失业在家，没有资源

紧急通告！三高的“克星”终于被找到了！！不是吃素和控糖,而是多喝它....

话费充值活动来了：95元充值100元电话费！

跟着南通住建局学“朝令夕改”

Java医院就诊挂号系统（附源码）

一、语言和环境

二、实现效果

三、实现代码

数据库：

项目Java代码：

JAR包：

代码：

=src

> com.mhys.crm.controller

HospitalContrller.java

> com.mhys.crm.dao

TbPatientMapper.java

搜索公众号GitHub猿后台回复“赚钱”，获取一份惊喜礼包。

> com.mhys.crm.entity

TbPatient.java

> com.mhys.crm.service.impl

HospitalService.java

=resource

> mybatis

SqlMapConfig.xml

> spring

applicationContext-dao.xml

> database.properties

=JSP页面

> /WEB-INF/jsp/

addInfo.jsp

您可能也对以下帖子感兴趣

《鱿鱼游戏2》今天下午四点开播，网友无心上班了，导演悄悄剧透

刘恺威近况曝光，父亲刘丹证实已分手，目前失业在家，没有资源

紧急通告！三高的“克星”终于被找到了！！不是吃素和控糖,而是多喝它....

话费充值活动来了：95元充值100元电话费！

跟着南通住建局学“朝令夕改”

生成图片，分享到微信朋友圈

Java医院就诊挂号系统（附源码）

一、语言和环境

二、实现效果

三、实现代码

数据库：

项目Java代码：

JAR包：

代码：

=src

> com.mhys.crm.controller

HospitalContrller.java

> com.mhys.crm.dao

TbPatientMapper.java

搜索公众号GitHub猿后台回复“赚钱”，获取一份惊喜礼包。

> com.mhys.crm.entity

TbPatient.java

> com.mhys.crm.service.impl

HospitalService.java

=resource

> mybatis

SqlMapConfig.xml

> spring

applicationContext-dao.xml

> database.properties

=JSP页面

> /WEB-INF/jsp/

addInfo.jsp

您可能也对以下帖子感兴趣