SSM社区医院卫生所病人患者随访信息管理javaweb网站系统设计与实现

目录

 

1 效果展示 

2 数据实体

3 功能说明

4 部分代码


1 效果展示 

 

2 数据实体

3 功能说明

 

包含医生 和管理员两种角色,对随访信息,科室,病房,病人患者等信息进行管理

4 部分代码

package com.action;

import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.directwebremoting.WebContext;
import org.directwebremoting.WebContextFactory;

import com.dao.DB;
import com.orm.Yisheng;

public class yisheng_servlet extends HttpServlet
{ 
	public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
	{
		String type=req.getParameter("type");
		
		if(type.endsWith("yishengAdd"))
		{
			yishengAdd(req, res);
		}
		if(type.endsWith("yishengMana"))
		{
			yishengMana(req, res);
		}
		if(type.endsWith("yishengDel"))
		{
			yishengDel(req, res);
		}
		if(type.endsWith("yishengEdit"))
		{
			yishengEdit(req, res);
		}
	
		if(type.endsWith("yishengSearch"))
		{
			yishengSearch(req, res);
		}
		if(type.endsWith("yishengSearch_bianhao"))
		{
			yishengSearch_bianhao(req, res);
		}
		if(type.endsWith("yishengQuanxian"))
		{
			yishengQuanxian(req, res);
		}
	}
	
	
	
	
	public void yishengAdd(HttpServletRequest req,HttpServletResponse res)
	{
		String bianhao=req.getParameter("bianhao");
		String name=req.getParameter("name");
		String sex=req.getParameter("sex");
		String age=req.getParameter("age");
		String tel=req.getParameter("tel");
		String address=req.getParameter("address");
		String zhiwei=req.getParameter("zhiwei");
		String card=req.getParameter("card");
		String keshi=req.getParameter("keshi");
		int ruzhinianfei=Integer.parseInt(req.getParameter("ruzhinianfei"));
		
		String sql="insert into t_yisheng values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
		Object[] params={null,bianhao,name,sex,age,tel,address,zhiwei,card,ruzhinianfei,0,"","","no",keshi};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "yisheng?type=yishengMana");
		
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}	
	public void yishengEdit(HttpServletRequest req,HttpServletResponse res)
	{
		String bianhao=req.getParameter("bianhao");
		String name=req.getParameter("name");
		String sex=req.getParameter("sex");
		String age=req.getParameter("age");
		String tel=req.getParameter("tel");
		String address=req.getParameter("address");
		String zhiwei=req.getParameter("zhiwei");
		String card=req.getParameter("card");
		String keshi=req.getParameter("keshi");
		String my=req.getParameter("my");
		int ruzhinianfei=Integer.parseInt(req.getParameter("ruzhinianfei"));
		
		String sql="update t_yisheng set keshi='"+keshi+"', bianhao='"+bianhao+"',card='"+card+"',ruzhinianfei='"+ruzhinianfei+"', name='"+name+"',sex='"+sex+"',age='"+age+"',tel='"+tel+"',address='"+address+"',zhiwei='"+zhiwei+"' where id="+Integer.parseInt(req.getParameter("id"));
		Object[] params={};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		if(my==null){
			req.setAttribute("message", "操作成功");
			req.setAttribute("path", "yisheng?type=yishengMana");
		} else {
				req.getSession().removeAttribute("yisheng");
			 Yisheng yisheng=new Yisheng();
			 yisheng.setId(Integer.parseInt(req.getParameter("id")));
			 yisheng.setBianhao(bianhao);
			 yisheng.setKeshi(keshi);
			 yisheng.setName(name);
			 yisheng.setSex(sex);
			 yisheng.setAge(age);
			 yisheng.setTel(tel);
			 yisheng.setAddress(address);
			 yisheng.setZhiwei(zhiwei);
			 yisheng.setQuanxian(1);
			 yisheng.setLoginName((String)req.getSession().getAttribute("loginName"));
			 yisheng.setLoginPw((String)req.getSession().getAttribute("loginPw"));
			 yisheng.setCard(card);
			 
			 req.getSession().setAttribute("yisheng",yisheng);
//			 WebContext ctx = WebContextFactory.get(); 
//			 HttpSession session=ctx.getSession();
//			 session.setAttribute("yisheng", yisheng);
			 
			req.setAttribute("message", "操作成功");
			req.setAttribute("path", "admin/yisheng/yishengEditMy.jsp");
		}
		
		
		
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}



	public void yishengDel(HttpServletRequest req,HttpServletResponse res)
	{
		int id=Integer.parseInt(req.getParameter("id"));
		
		String sql="update t_yisheng set del=? where id=?";
		Object[] params={"yes",id};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "yisheng?type=yishengMana");
		
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}
	public void yishengMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		String id=req.getParameter("yishengId");
		String page1=req.getParameter("page");
		if(page1==null){
			page1="1";
		}
		//分页设置
		int EVERYPAGENUM=10;//每页条数
		int page=Integer.parseInt(page1);   //传递过来的当前页
		int cou = 1;//得到信息总数	
		int pagecount=1;  //总页数
		String sql1="select count(*) as cou from t_yisheng where del='no'";
		if(id!=null)sql1+=" and id="+id;
		
		Object[] params1={};
		DB mydb1=new DB();
		try
		{
			mydb1.doPstm(sql1, params1);
			ResultSet rs=mydb1.getRs();
			while(rs.next())
			{
			cou= rs.getInt("cou");
			}
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb1.closed();
		
		
		
		if (cou % EVERYPAGENUM == 0) {
			pagecount= cou / EVERYPAGENUM;
        } else {
        	pagecount=cou / EVERYPAGENUM + 1;
        }	
		
		
		
		
		
		
		req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);	
		req.setAttribute("page", page);
		req.setAttribute("cou", cou);
		req.setAttribute("pagecount", pagecount);
		
		
		
		List yishengList=new ArrayList();
		String sql="select * from t_yisheng where del='no'";
		if(id!=null)sql+=" and id="+id;
		sql1+=" order by bianhao desc";
		Object[] params={};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
				 for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
	                rs.next();
	            }
	            for (int t = 0; t < EVERYPAGENUM; t++) {
	                if (rs.next()) {

				Yisheng yisheng=new Yisheng();
				yisheng.setId(rs.getInt("id"));
				yisheng.setBianhao(rs.getString("bianhao"));
				yisheng.setName(rs.getString("name"));
				yisheng.setSex(rs.getString("sex"));
				yisheng.setAge(rs.getString("age"));
				yisheng.setTel(rs.getString("tel"));
				yisheng.setAddress(rs.getString("address"));
				yisheng.setZhiwei(rs.getString("zhiwei"));
				yisheng.setCard(rs.getString("card"));
				yisheng.setRuzhinianfei(rs.getInt("ruzhinianfei"));
				yisheng.setGongling(new Date().getYear()+1900-rs.getInt("ruzhinianfei"));
				yisheng.setQuanxian(rs.getInt("quanxian"));
				yisheng.setLoginName(rs.getString("loginName"));
				yisheng.setLoginPw(rs.getString("loginPw"));
				yisheng.setKeshi(rs.getString("keshi"));
						yishengList.add(yisheng);
						                } else {
	                    break; //减少空循环的时间
	                }
	            }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		
		req.setAttribute("yishengList", yishengList);
		req.getRequestDispatcher("admin/yisheng/yishengMana.jsp").forward(req, res);
	}
	
	

	
	public void yishengSearch(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		String name=req.getParameter("name");
		String page1=req.getParameter("page");
		if(page1==null){
			page1="1";
		}
		//分页设置
		int EVERYPAGENUM=10;//每页条数
		int page=Integer.parseInt(page1);   //传递过来的当前页
		int cou = 1;//得到信息总数	
		int pagecount=1;  //总页数
		String sql1="select count(*) as cou from t_yisheng where del='no' and name like '%"+name.trim()+"%'";
		Object[] params1={};
		DB mydb1=new DB();
		try
		{
			mydb1.doPstm(sql1, params1);
			ResultSet rs=mydb1.getRs();
			while(rs.next())
			{
			cou= rs.getInt("cou");
			}
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb1.closed();
		
		
		
		if (cou % EVERYPAGENUM == 0) {
			pagecount= cou / EVERYPAGENUM;
        } else {
        	pagecount=cou / EVERYPAGENUM + 1;
        }	
		
		
		
		
		
		
		req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);	
		req.setAttribute("page", page);
		req.setAttribute("cou", cou);
		req.setAttribute("pagecount", pagecount);
		
		
		
		List yishengList=new ArrayList();
		String sql="select * from t_yisheng where del='no' and name like '%"+name.trim()+"%'";
		Object[] params={};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			 for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
	                rs.next();
	            }
	            for (int t = 0; t < EVERYPAGENUM; t++) {
	                if (rs.next()) {
	Yisheng yisheng=new Yisheng();
				yisheng.setId(rs.getInt("id"));
				yisheng.setBianhao(rs.getString("bianhao"));
				yisheng.setName(rs.getString("name"));
				yisheng.setSex(rs.getString("sex"));
				yisheng.setAge(rs.getString("age"));
				yisheng.setTel(rs.getString("tel"));
				yisheng.setAddress(rs.getString("address"));
				yisheng.setZhiwei(rs.getString("zhiwei"));
				yisheng.setRuzhinianfei(rs.getInt("ruzhinianfei"));
				yisheng.setCard(rs.getString("card"));
				yisheng.setGongling(new Date().getYear()+1900-rs.getInt("ruzhinianfei"));
				yisheng.setQuanxian(rs.getInt("quanxian"));
				yisheng.setLoginName(rs.getString("loginName"));
				yisheng.setLoginPw(rs.getString("loginPw"));
				yisheng.setKeshi(rs.getString("keshi"));
				yishengList.add(yisheng);
		   } else {
	                    break; //减少空循环的时间
	                }
	            }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		
		req.setAttribute("yishengList", yishengList);
		req.getRequestDispatcher("admin/yisheng/yishengMana.jsp").forward(req, res);
	}
	
	public void yishengSearch_bianhao(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		String bianhao=req.getParameter("bianhao");
		String page1=req.getParameter("page");
		if(page1==null){
			page1="1";
		}
		//分页设置
		int EVERYPAGENUM=10;//每页条数
		int page=Integer.parseInt(page1);   //传递过来的当前页
		int cou = 1;//得到信息总数	
		int pagecount=1;  //总页数
		String sql1="select count(*) as cou from t_yisheng where del='no' and bianhao like '%"+bianhao.trim()+"%'";
		Object[] params1={};
		DB mydb1=new DB();
		try
		{
			mydb1.doPstm(sql1, params1);
			ResultSet rs=mydb1.getRs();
			while(rs.next())
			{
			cou= rs.getInt("cou");
			}
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb1.closed();
		
		
		
		if (cou % EVERYPAGENUM == 0) {
			pagecount= cou / EVERYPAGENUM;
        } else {
        	pagecount=cou / EVERYPAGENUM + 1;
        }	
		
		
		
		
		
		
		req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);	
		req.setAttribute("page", page);
		req.setAttribute("cou", cou);
		req.setAttribute("pagecount", pagecount);
		
			List yishengList=new ArrayList();
		String sql="select * from t_yisheng where del='no' and bianhao like '%"+bianhao.trim()+"%'";
		Object[] params={};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			 for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
	                rs.next();
	            }
	            for (int t = 0; t < EVERYPAGENUM; t++) {
	                if (rs.next()) {
				Yisheng yisheng=new Yisheng();
				yisheng.setId(rs.getInt("id"));
				yisheng.setBianhao(rs.getString("bianhao"));
				yisheng.setName(rs.getString("name"));
				yisheng.setSex(rs.getString("sex"));
				yisheng.setAge(rs.getString("age"));
				yisheng.setTel(rs.getString("tel"));
				yisheng.setAddress(rs.getString("address"));
				yisheng.setZhiwei(rs.getString("zhiwei"));
				yisheng.setRuzhinianfei(rs.getInt("ruzhinianfei"));
				yisheng.setCard(rs.getString("card"));
				yisheng.setGongling(new Date().getYear()+1900-rs.getInt("ruzhinianfei"));
				yisheng.setQuanxian(rs.getInt("quanxian"));
				yisheng.setLoginName(rs.getString("loginName"));
				yisheng.setLoginPw(rs.getString("loginPw"));
				yisheng.setKeshi(rs.getString("keshi"));
				yishengList.add(yisheng);
		  } else {
	                    break; //减少空循环的时间
	                }
	            }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		
		req.setAttribute("yishengList", yishengList);
		req.getRequestDispatcher("admin/yisheng/yishengMana.jsp").forward(req, res);
	}
	
	public void yishengQuanxian(HttpServletRequest req,HttpServletResponse res)
	{
		int id=Integer.parseInt(req.getParameter("id"));
		int quanxian=Integer.parseInt(req.getParameter("quanxian"));
		String loginName=req.getParameter("loginName");
		String loginPw=req.getParameter("loginPw");
		
		String sql="update t_yisheng set quanxian=?,loginName=?,loginPw=? where id="+id;
		Object[] params={quanxian,loginName,loginPw};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "yisheng?type=yishengMana");
		
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}
	
	
	public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response) 
	{
		RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
		try 
		{
		    dispatch.forward(request, response);
		    return;
		} 
		catch (ServletException e) 
		{
                    e.printStackTrace();
		} 
		catch (IOException e) 
		{
			
		    e.printStackTrace();
		}
	}
	public void init(ServletConfig config) throws ServletException 
	{
		super.init(config);
	}
	
	public void destroy() 
	{
		
	}
}
  • 0
    点赞
  • 4
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

计算机程序设计开发

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值