Java医院就诊挂号系统

程序员的成长之路

共 10192字，需浏览 21分钟

2022-05-31 20:48

程序员的成长之路

互联网/程序员/技术/资料共享

阅读本文大概需要 13 分钟。

来自：https://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 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 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 selectAlls();
    int updateByPrimaryKey(TbPatient record);
    int update(Integer id);
    List selectAll(@Param("name")String name,@Param("type")String type,@Param("dep")String dap);}

TbPatientMapper.xml

                                                  delete from tb_patient    where id = #{id,jdbcType=INTEGER}        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})        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 tb_patient set state=1 where id = #{id,jdbcType=INTEGER}

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

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

> spring

applicationContext-dao.xml

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

applicationContext-service.xml

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

spring-mvc.xml

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

> 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"%>          挂号              
                                                                                                                                                                                                                                                            
      姓名 
性别 
年龄 
电话 
医师类别 
价格 
挂号时间

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"%>"UTF-8">医院就诊挂号系统  "center">医院就诊挂号系统  "warp">    "list.do">    患者姓名：type="text" name="name">         医师类别：                 科室：type="text" name="dep">         type="submit" value="查询">       type="button" value="挂号" onclick="add()">  
  "margin-bottom: 30px;" width="100%" border="1px" cellpadding="11" cellspacing="0">                                                                              "list" items="${selctAll }">                                                                                                          编号 姓名 性别 年龄 电话 科室 医师类别 价格 挂号时间 状态 操作
${list.id } ${list.name } ${list.sex } ${list.age } ${list.phone } ${list.department } ${list.type } ${list.price } "${list.registerTime }" pattern="yyyy-MM-dd"/>           if test="${list.state==0}">               未就诊             if>          if test="${list.state==1}">               已就诊             if>                  if test="${list.state==0}">               "javascript:if(confirm('确实要核销该挂号信息吗?'))location='upd.do?id=${list.id }'">核销             if>          <%-- if test="${list.state==1}">               已就诊             if> --%>

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

index.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path;%>XXX系统

`源码下载`

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

提取码：jisk

推荐阅读：

SpringBoot太重，Vert.x真香！

Spring AOP 常见注解和执行顺序

互联网初中高级大厂面试题(9个G)

内容包含Java基础、JavaWeb、MySQL性能优化、JVM、锁、百万并发、消息队列、高性能缓存、反射、Spring全家桶原理、微服务、Zookeeper......等技术栈！

⬇戳阅读原文领取！朕已阅

浏览
                    39点赞
    
评论
    收藏
    
分享
        手机扫一扫分享
分享
    
        举报

评论

图片

表情

视频

Java医院就诊挂号系统
java团长
0

Java开源系统共享：医院就诊挂号
Java后端编程
0

Java开源系统共享：医院就诊挂号
JAVA公众号
0

Java医院预约挂号系统
java团长
0

一次挂号管三天！淮安这些医院实施→
　　为持续改善就医感受、提升患者就医体验，根据省统一部署，我市在全市二级以上公立医疗机构实施普通门诊“一次挂号管三天”惠民实事政策。　　“一次挂号管三天”是指在普通门诊（不包括多学科诊疗门诊、特需门诊、跨科室跨专业就诊）患者就诊当日因检查、检验不能完成或不能取报告的，在三日内（包含就诊当日），携检查

nTPV医院POS系统
nTPV 是一个适合医院使用的POS销售点系统和商业管理系统。  更多屏幕截图请看 http://n

Care2X医院管理系统
Care2X 是一个适合于综合医院的开源信息管理系统（HIS）这个开源系统包括四个组件：HIS，即医院信息管理系统（HospitalInformationSystem）PM，实践操作管理CDS，数据中

nTPV医院POS系统
nTPV是一个适合医院使用的POS销售点系统和商业管理系统。更多屏幕截图请看http://ntpv.org/index.php?option=com_content&task=view&

Care2X医院管理系统
Care2X  是一个适合于综合医院的开源信息管理系统（HIS）  这个开源系统包括四个组件： HI

Java在线考试系统
java团长
0

点赞

评论
    收藏
    
分享
        手机扫一扫分享
分享
    
        举报