计算机毕业设计-基于SSH的医院在线挂号系统源代码和论文

医院挂号系统主要用于实现医院的挂号，前台基本功能包括：用户注册、用户登录、医院查询、挂号、取消挂号、修改个人信息、退出等。

后台基本功能包括：系统管理员登录、医院管理、科室管理、公告管理、退出系统等。

计算机毕业设计基于SSH的医院在线挂号系统源结构如下：

（1）前台功能：

用户注册：注册功能；

用户登录：登录功能；

医院查询：选择医院、科室查询该医院下的医生信息

挂号:选择医生后点击挂号，填写信息完成挂号

管理中心:点击管理中心可以修改个人信息、取消挂号

（2）系统管理员：

登录模块：实现管理员登录功能；

医院管理模块：实现医院的增加、删除功能；

科室管理模块：实现科室的增加、删除功能；

公告管理模块：实现公告的增加、删除功能；

退出系统模块：实现用户的退出功能；

基于SSH的医院在线挂号系统设计与实现摘要：

互联网技术迅速的发展给我们的生活带来很大的方便，同时也让许多行业迅速的发展起来。互联网技术已走向科技发展的巅峰期，我们要做的就是合理的使用互联网技术让我们的各个行业得到更快速的发展。

计算机毕业设计基于SSH的医院在线挂号系统设计与实现答辩ppt：

计算机毕业设计基于SSH的医院在线挂号系统设计与实现数据库：

/*
Navicat MySQL Data Transfer
计算机毕业设计基于SSH的医院在线挂号系统设计与实现数据库
Source Server         : localhost_3307
Source Server Version : 50022
Source Host           : localhost:3307
Source Database       : db_guahao

Target Server Type    : MYSQL
Target Server Version : 50022
File Encoding         : 65001
计算机毕业设计基于SSH的医院在线挂号系统设计与实现数据库
Date: 2013-12-05 12:16:02
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `t_admin`
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin` (
  `userId` int(11) NOT NULL,
  `userName` varchar(50) default NULL,
  `userPw` varchar(50) default NULL,
  PRIMARY KEY  (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_admin
-- ----------------------------
INSERT INTO `t_admin` VALUES ('1', 'a', 'a');

-- ----------------------------
-- Table structure for `t_gonggao`
-- ----------------------------
DROP TABLE IF EXISTS `t_gonggao`;
CREATE TABLE `t_gonggao` (
  `id` int(11) NOT NULL,
  `biaoti` varchar(255) default NULL,
  `neirong` varchar(255) default NULL,
  `shijian` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_gonggao
-- ----------------------------
INSERT INTO `t_gonggao` VALUES ('1', '测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告', '测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告测试公告', '2013-11-29 18:13');
INSERT INTO `t_gonggao` VALUES ('2', 'mmmmmmmmmmmmmmmmmmmmmmmmmmmm', 'mmmmmmmmmmmmmmmmmmmmmmmmmmm', '2013-12-02 08:14');

-- ----------------------------
-- Table structure for `t_guahao`
-- ----------------------------
DROP TABLE IF EXISTS `t_guahao`;
CREATE TABLE `t_guahao` (
  `id` int(11) NOT NULL default '0',
  `zhuanjiaId` int(11) default NULL,
  `userId` int(11) default NULL,
  `riqi` varchar(255) default NULL,
  `jibing` varchar(255) default NULL,
  `xingming` varchar(255) default NULL,
  `lianxi` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_guahao
-- ----------------------------

-- ----------------------------
-- Table structure for `t_keshi`
-- ----------------------------
DROP TABLE IF EXISTS `t_keshi`;
CREATE TABLE `t_keshi` (
  `keshi_id` int(11) NOT NULL,
  `keshi_anme` varchar(50) default NULL,
  `del` varchar(50) default NULL,
  PRIMARY KEY  (`keshi_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_keshi
-- ----------------------------
INSERT INTO `t_keshi` VALUES ('2', '内科', 'no');
INSERT INTO `t_keshi` VALUES ('3', '外科', 'no');
INSERT INTO `t_keshi` VALUES ('4', '胸科', 'no');
INSERT INTO `t_keshi` VALUES ('5', '骨科', 'no');

-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `user_id` int(11) NOT NULL,
  `user_name` varchar(50) default NULL,
  `user_pw` varchar(50) default NULL,
  `user_realname` varchar(50) default NULL,
  `user_address` varchar(50) default NULL,
  `user_tel` varchar(50) default NULL,
  `user_email` varchar(50) default NULL,
  `user_del` varchar(50) default NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('1', 'liusan', '000000', '刘三', '北京路1', '13444444444', 'liusan@163.com', 'no');

-- ----------------------------
-- Table structure for `t_yiyuan`
-- ----------------------------
DROP TABLE IF EXISTS `t_yiyuan`;
CREATE TABLE `t_yiyuan` (
  `id` int(11) NOT NULL,
  `mingcheng` varchar(50) default NULL,
  `dizhi` varchar(50) default NULL,
  `dianhua` varchar(255) default NULL,
  `del` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_yiyuan
-- ----------------------------
INSERT INTO `t_yiyuan` VALUES ('2', '北京大学第三医院 ', '海淀区花园北路49号', '010-82266699', 'no');
INSERT INTO `t_yiyuan` VALUES ('3', '阜外心血管病医院', '西城区北礼士路167号', '010-88398866', 'no');
INSERT INTO `t_yiyuan` VALUES ('4', '北京大学人民医院', '西城区西直门南大街', '010-66583666', 'no');

-- ----------------------------
-- Table structure for `t_zhuanjia`
-- ----------------------------
DROP TABLE IF EXISTS `t_zhuanjia`;
CREATE TABLE `t_zhuanjia` (
  `id` int(11) NOT NULL default '0',
  `yiyuanId` int(11) default NULL,
  `keshiId` int(11) default NULL,
  `xingming` varchar(255) default NULL,
  `xingbie` varchar(11) default NULL,
  `nianling` int(11) default NULL,
  `shanchang` varchar(255) default NULL,
  `leixing` varchar(255) default NULL,
  `fujian` varchar(255) default NULL,
  `del` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_zhuanjia
-- ----------------------------
INSERT INTO `t_zhuanjia` VALUES ('2', '2', '2', '王晓光', '男', '40', '各类心脑血管各类疾病病', '专家门诊', '/upload/1362249942828.jpg', 'no');
INSERT INTO `t_zhuanjia` VALUES ('3', '2', '2', '张大海', '男', '40', '各类心血管外科各种疾病', '专家门诊', '/upload/1362250001253.jpg', 'no');
INSERT INTO `t_zhuanjia` VALUES ('4', '2', '2', '刘莉莉', '男', '52', '各类口腔科疾病药到病除', '普通门诊', '/upload/1362250044364.jpg', 'no');

计算机毕业设计基于SSH的医院在线挂号系统设计与实现项目截图：

计算机毕业设计基于SSH的医院在线挂号系统设计与实现项目部分源代码guahaoAction.java：

package com.action;

import java.util.Date;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import org.apache.struts2.ServletActionContext;

import com.dao.TGuahaoDAO;
import com.dao.TZhuanjiaDAO;
import com.model.TGuahao;
import com.model.TUser;
import com.model.TZhuanjia;
import com.opensymphony.xwork2.ActionSupport;

public class guahaoAction extends ActionSupport
{
    private Integer id;
    private Integer zhuanjiaId;
    private Integer userId;
    private String riqi;

    private String jibing;
    private String xingming;
    private String lianxi;
    
    private String message;
    private String path;
    
    private TGuahaoDAO guahaoDAO;
    private TZhuanjiaDAO zhuanjiaDAO;
    
    public String guahaoAdd()
    {
        HttpServletRequest request=ServletActionContext.getRequest();
        HttpSession session=request.getSession();
        TUser user=(TUser)session.getAttribute("user");
        
        
        TGuahao guahao=new TGuahao();
        
        guahao.setZhuanjiaId(zhuanjiaId);
        guahao.setUserId(user.getUserId());
        guahao.setRiqi(riqi);
        guahao.setJibing(jibing);
        
        guahao.setXingming(xingming);
        guahao.setLianxi(lianxi);
        
        guahaoDAO.save(guahao);
        
        
        this.setMessage("成功挂号");
        this.setPath("index.action");
        return "succeed";
    }
    
    
    public String guahaoDel()
    {   
        HttpServletRequest request=ServletActionContext.getRequest();
        
        TGuahao guahao=guahaoDAO.findById(id);
        guahaoDAO.delete(guahao);
        
        request.setAttribute("msg", "成功取消挂号");
        return "msg";
    }
    
    

    public String guahaoMana_user()
    {
        HttpServletRequest request=ServletActionContext.getRequest();
        HttpSession session=request.getSession();
        TUser user=(TUser)session.getAttribute("user");
        
        String sql="from TGuahao where userId="+user.getUserId();
        List guahaoList =guahaoDAO.getHibernateTemplate().find(sql);
        for(int i=0;i<guahaoList.size();i++)
        {
            TGuahao guahao=(TGuahao)guahaoList.get(i);
            guahao.setZhuanjia(zhuanjiaDAO.findById(guahao.getZhuanjiaId()));
        }
        
        request.setAttribute("guahaoList", guahaoList);
        return ActionSupport.SUCCESS;
    }
    
    
    
    public String guahaoMana_zhuanjia()
    {
        HttpServletRequest request=ServletActionContext.getRequest();
        HttpSession session=request.getSession();
        TZhuanjia zhuanjia=(TZhuanjia)session.getAttribute("zhuanjia");
        
        String sql="from TGuahao where zhuanjiaId="+zhuanjia.getId();
        List guahaoList =guahaoDAO.getHibernateTemplate().find(sql);
        for(int i=0;i<guahaoList.size();i++)
        {
            TGuahao guahao=(TGuahao)guahaoList.get(i);
            guahao.setZhuanjia(zhuanjiaDAO.findById(guahao.getZhuanjiaId()));
        }
        
        request.setAttribute("guahaoList", guahaoList);
        return ActionSupport.SUCCESS;
    }
    
    
    public TGuahaoDAO getGuahaoDAO()
    {
        return guahaoDAO;
    }


    public void setGuahaoDAO(TGuahaoDAO guahaoDAO)
    {
        this.guahaoDAO = guahaoDAO;
    }


    public TZhuanjiaDAO getZhuanjiaDAO()
    {
        return zhuanjiaDAO;
    }


    public String getMessage()
    {
        return message;
    }


    public void setMessage(String message)
    {
        this.message = message;
    }


    public String getPath()
    {
        return path;
    }


    public void setPath(String path)
    {
        this.path = path;
    }


    public void setZhuanjiaDAO(TZhuanjiaDAO zhuanjiaDAO)
    {
        this.zhuanjiaDAO = zhuanjiaDAO;
    }


    public Integer getId()
    {
        return id;
    }


    public void setId(Integer id)
    {
        this.id = id;
    }


    public String getJibing()
    {
        return jibing;
    }


    public void setJibing(String jibing)
    {
        this.jibing = jibing;
    }


    public String getLianxi()
    {
        return lianxi;
    }


    public void setLianxi(String lianxi)
    {
        this.lianxi = lianxi;
    }


    

    public String getRiqi()
    {
        return riqi;
    }


    public void setRiqi(String riqi)
    {
        this.riqi = riqi;
    }


    public Integer getUserId()
    {
        return userId;
    }


    public void setUserId(Integer userId)
    {
        this.userId = userId;
    }


    public String getXingming()
    {
        return xingming;
    }


    public void setXingming(String xingming)
    {
        this.xingming = xingming;
    }


    public Integer getZhuanjiaId()
    {
        return zhuanjiaId;
    }


    public void setZhuanjiaId(Integer zhuanjiaId)
    {
        this.zhuanjiaId = zhuanjiaId;
    }

}

计算机毕业设计基于SSH的医院在线挂号系统设计与实现项目部分源代码TZhuanjiaDAO.java：

package com.dao;

import java.util.List;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.LockMode;
import org.springframework.context.ApplicationContext;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.model.TZhuanjia;

/**
 * Data access object (DAO) for domain model class TZhuanjia.
 * 
 * @see com.model.TZhuanjia
 * @author MyEclipse Persistence Tools
 */

public class TZhuanjiaDAO extends HibernateDaoSupport
{
    private static final Log log = LogFactory.getLog(TZhuanjiaDAO.class);

    protected void initDao()
    {
        // do nothing
    }

    public void save(TZhuanjia transientInstance)
    {
        log.debug("saving TZhuanjia instance");
        try
        {
            getHibernateTemplate().save(transientInstance);
            log.debug("save successful");
        } catch (RuntimeException re)
        {
            log.error("save failed", re);
            throw re;
        }
    }

    public void delete(TZhuanjia persistentInstance)
    {
        log.debug("deleting TZhuanjia instance");
        try
        {
            getHibernateTemplate().delete(persistentInstance);
            log.debug("delete successful");
        } catch (RuntimeException re)
        {
            log.error("delete failed", re);
            throw re;
        }
    }

    public TZhuanjia findById(java.lang.Integer id)
    {
        log.debug("getting TZhuanjia instance with id: " + id);
        try
        {
            TZhuanjia instance = (TZhuanjia) getHibernateTemplate().get(
                    "com.model.TZhuanjia", id);
            return instance;
        } catch (RuntimeException re)
        {
            log.error("get failed", re);
            throw re;
        }
    }

    public List findByExample(TZhuanjia instance)
    {
        log.debug("finding TZhuanjia instance by example");
        try
        {
            List results = getHibernateTemplate().findByExample(instance);
            log.debug("find by example successful, result size: "
                    + results.size());
            return results;
        } catch (RuntimeException re)
        {
            log.error("find by example failed", re);
            throw re;
        }
    }

    public List findByProperty(String propertyName, Object value)
    {
        log.debug("finding TZhuanjia instance with property: " + propertyName
                + ", value: " + value);
        try
        {
            String queryString = "from TZhuanjia as model where model."
                    + propertyName + "= ?";
            return getHibernateTemplate().find(queryString, value);
        } catch (RuntimeException re)
        {
            log.error("find by property name failed", re);
            throw re;
        }
    }

    public List findAll()
    {
        log.debug("finding all TZhuanjia instances");
        try
        {
            String queryString = "from TZhuanjia";
            return getHibernateTemplate().find(queryString);
        } catch (RuntimeException re)
        {
            log.error("find all failed", re);
            throw re;
        }
    }

    public TZhuanjia merge(TZhuanjia detachedInstance)
    {
        log.debug("merging TZhuanjia instance");
        try
        {
            TZhuanjia result = (TZhuanjia) getHibernateTemplate().merge(
                    detachedInstance);
            log.debug("merge successful");
            return result;
        } catch (RuntimeException re)
        {
            log.error("merge failed", re);
            throw re;
        }
    }

    public void attachDirty(TZhuanjia instance)
    {
        log.debug("attaching dirty TZhuanjia instance");
        try
        {
            getHibernateTemplate().saveOrUpdate(instance);
            log.debug("attach successful");
        } catch (RuntimeException re)
        {
            log.error("attach failed", re);
            throw re;
        }
    }

    public void attachClean(TZhuanjia instance)
    {
        log.debug("attaching clean TZhuanjia instance");
        try
        {
            getHibernateTemplate().lock(instance, LockMode.NONE);
            log.debug("attach successful");
        } catch (RuntimeException re)
        {
            log.error("attach failed", re);
            throw re;
        }
    }

    public static TZhuanjiaDAO getFromApplicationContext(ApplicationContext ctx)
    {
        return (TZhuanjiaDAO) ctx.getBean("TZhuanjiaDAO");
    }
}

计算机毕业设计基于SSH的医院在线挂号系统源代码和论文有项目辅导视频：

整体论文和项目代码如下：