Java医院就诊挂号系统
java团长
共 20769字,需浏览 42分钟
· 2021-09-07
版权声明:本文为博主原创文章,遵循 CC 4.0 BY 版权协议,转载请附上原文出处链接和本声明。
本文链接:
https://blog.csdn.net/weixin_44893902/article/details/119986708
一、语言和环境
二、实现效果
三、实现代码
数据库:
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;
@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>
<!-- 配置SqlSessionFactory -->
<bean class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 设置MyBatis核心配置文件 -->
<property name="configLocation" value="classpath:mybatis/SqlMapConfig.xml" />
<!-- 设置数据源 -->
<property name="dataSource" ref="dataSource" />
</bean>
<!-- 配置Mapper扫描 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!-- 设置Mapper扫描包 -->
<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>
<!-- 开启注解方式管理AOP事务 -->
<tx:annotation-driven transaction-manager="transactionManager" />
</beans>
applicationContext-service.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">
<!-- 配置Service扫描 -->
<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">
<!-- 配置Controller扫描 -->
<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://pan.baidu.com/s/1tUxW8LRC-AerI5O5gE7gLw
提取码: x56u
如果觉得我的分享不错,欢迎大家随手点赞、在看。
评论
豆瓣9.7,这部Java神作第3版重磅上市!
文末赠书Java 程序员们开年就有重磅好消息,《Effective Java 中文版(原书第 3 版)》要上市啦!该书的第1版出版于 2001 年,当时就在业界流传开来,受到广泛赞誉。时至今日,已热销近20年,本书第 3 版已是 Java 程序员的必读神书,被誉为“Java 四大名著之一”,甚至连
编码之外
0
测试新人,如何快速上手一个陌生的系统!
大家好,我是狂师!作为刚入行不久的测试新人,面对一个陌生的系统时,可能会感到有些手足无措。面对一个全新的系统系统,如何快速上手并展开有效的测试工作是一个重要的挑战。本文将探讨测试新人如何通过一系列步骤和策略,快速熟悉并掌握新系统的测试要点,从而提高测试效率和质量。本文旨在为测试新手提供一份指导,帮助
测试开发技术
0
教你基于 Jenkins 搭建一套 CI/CD 系统
原文链接:https://mp.weixin.qq.com/s/KVc4IFky1z7kZn-7bz79DQ一、CI/CD环境介绍本次要实现如下效果,开发人员完成功能开发并提交代码到gitlab仓库,jenkins自动完成拉取代码、编译构建、代码扫描(sonarqube)、打
码农编程进阶笔记
0
大量 Java 开源项目停更...
点击关注公众号,Java 干货及时推送↓推荐阅读:投了 100 多份简历后…出品 | OSC开源社区(ID:oschina2013)Sonatype 发布了最新的一份《软件供应链状况》报告,深入探讨了如何在充满选择的世界中定义更好的软件,并探讨人工智能 (AI) 对软件开发的深远
Java技术栈
0
Java 神作,必读!
Java 程序员们开年就有重磅好消息,《Effective Java 中文版(原书第 3 版)》要上市啦!该书的第1版出版于 2001 年,当时就在业界流传开来,受到广泛赞誉。时至今日,已热销近20年,本书第 3 版已是 Java 程序员的必读神书,被誉为“Java 四大名著之一”,甚至连 Java
小哈学Java
0
Linux系统性能优化:七个实战经验
来源公众号:twt社区IT社区原文链接:https://mp.weixin.qq.com/s/Rey0gSnnj-zoAEwE6J-GjwLinux系统的性能是指操作系统完成任务的有效性、稳定性和响应速度。Linux系统管理员可能经常会遇到系统不稳定、响应速度慢等问题,例如在Linux上搭建了一个w
开源Linux
1
Java与lua互相调用简单教程
来源:网络👉 欢迎加入小哈的星球 ,你将获得: 专属的项目实战 / Java 学习路线 / 一对一提问 / 学习打卡 / 赠书福利全栈前后端分离博客项目 2.0 版本完结啦, 演示链接:http://116.62.199.48/ ,新项目
小哈学Java
0
【送书福利】《Java面试八股文:高频面试题与求职攻略一本通》
先来唠唠最近粉丝面试回来跟我聊天,基本上都提到一个点,在面试过程中八股文占比很高(八股文70%、项目20%、10%算法)除了一些搞算法突出的厂除外。其实现在很多厂八股都是逐渐深入的方式来问,所以大家在学习的过程中,针对一些重点的内容,最好深入去学习,不然还是比较难应对这种追问式的问题。最近刚好从一位
Java后端技术
0