完整的医院就诊挂号系统基于Spring MVC + Spring + MyBatis实现

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' );

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

     }

}

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

}

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

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 + "]" ;

     }

}

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

     }

}

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

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

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

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

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

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

<%@ 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" >&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

         医师类别：

                 < select name = "type" >

                     < option value = "" >=不限=</ option >

                     < option value = "专家医师" >专家医师</ option >

                     < option value = "普通医师" >普通医师</ option >

                     < option value = "副主任医师" >副主任医师</ option >

                 </ select >&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

         科室：< input type = "text" name = "dep" >&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

         < input type = "submit" value = "查询" >&nbsp;&nbsp;&nbsp;

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

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