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() {}
}

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

1 效果展示

2 数据实体

3 功能说明

4 部分代码

相关文章

基于SSM的网上拍卖网站购物系统的设计与实现

PHP实现的博客网站-个人相册微博-php图片分享网站基于lamp/wamp/MySQL/PhpStorm

ASP.NET失物招领网站包含（寻物启事+感谢信+通知公告）c#开发

javaweb校园互助悬赏跑腿中介平台SSM网站J2EE

基于WEB的课程培训报名在线网站平台PHP开发mysql数据库

SSM大学生公益义工主题管理-义工服务-志愿者报名审核javaweb网站j2ee项目

基于SSM开发的javaweb模式二手手机回收利用j2ee网站管理系统

基于SSM开发的JavaWEB企业股权融资平台j2ee网站（包含财务顾问资讯-融资项目发布-意向投递-投资人管理等功能）

基于SSM的大学生心理咨询网站(javaweb-php-asp.netC#-j2ee)包含测试心理知识咨询回复留言数据统计分析建议

基于SSM的在线贷款借款信贷贷款网站交易平台(javaweb-php-asp.netC#-j2ee)

基于SSMidea开发景区景点旅游网站(javaweb-php-asp.netC#-j2ee)包含城市推荐线路预约预定自驾游个性化推荐技术数据统计分析

基于idea-SSM的企业资讯管理系统-企业网站-企业公司新闻网站-产品管理-行业动态(javaweb-php-asp.netC#-j2ee)

基于idea-SSM兼职网站校园兼职任务发布网站(bootstrap-jquery-vue-javaweb-php-asp.netC#-j2ee)

针对某五金电子厂的企业网站进行模拟SQL注入来谈企业网站安全的攻击与防范-网站安全漏洞剖析实例 (适应于idea-SSMjavaweb-php-asp.netC#-j2ee)

idea开发SSM框架的高校大学学生社团管理网站bootstrap自适应响应式前端(javaweb-php-asp.netC#-j2ee)包含公告管理-社团活动管理-社团申请管理-社团审核-活动报名

基于idea-SSM的问卷投票调查网站(javaweb-php-asp.netC#-j2ee)包含题目管理-答案统计-数据分析-会员管理

基于idea-SSM的信访局网站系统(javaweb-php-asp.netC#-j2ee-springboot)包含投诉新闻公告反馈等功能

基于springboot的宠物周边服务预约网站(javaweb-php-asp.netC#-j2ee-SSM-idea)包含宠物领养信息管理-喂养知识-宠物新闻-宠物周边医院疫苗等服务

idea开发SSM框架游戏账号租号发布网站 (javaweb-php-asp.netC#-j2ee-springboot)功能有推荐算法功能

idea开发SSM框架乐器租赁网站管理系统 (javaweb-php-asp.netC#-j2ee-springboot)