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