基于javaweb+mysql的jsp+servlet慢病报销管理信息系统(java+mysql+jdbc+servlet+jsp)

基于javaweb+mysql的jsp+servlet慢病报销管理信息系统(java+mysql+jdbc+servlet+jsp)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb+mysql的JSP+Servlet慢病报销管理信息系统(java+mysql+jdbc+servlet+jsp)

一、项目简述 功能： 慢病管理，医疗机构管理，家庭管理，费用交纳，费用报销，报表统计等等功能。

二、项目运行

环境配置：

Jdk1.8 + Tomcat8.5 + mysql + Eclispe（IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持）

项目技术：

Jdbc+ Servlert + Jsp + css + JavaScript + JQuery + Ajax + Fileupload等等

* @throws ServletException* @throws IOException*/public void chperList(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {req.setCharacterEncoding("utf-8");String address = req.getParameter("address");String rccardnum = req.getParameter("rccardnum");String name = req.getParameter("name");String pageNo = req.getParameter("pageNo");int p = pageNo == null ? 1 : Integer.parseInt(pageNo);ChperDao chper = new ChperDao();Page chperpage = chper.queryAll(p, Constant.ROW, address, rccardnum, name);int prePage = chperpage.prePage();int lastPage = chperpage.lastPage();boolean last = chperpage.isLast();List<Integer> linkLumbers = chperpage.linkLumbers();List datas = chperpage.getDatas();req.setAttribute("chperpage", chperpage);req.setAttribute("datas", datas);req.setAttribute("prePage", prePage);req.setAttribute("lastPage", lastPage);req.setAttribute("linkLumbers", linkLumbers);req.setAttribute("last", last);req.getRequestDispatcher("/page/chper/chper_list.jsp").forward(req, resp);}/*** 去添加参合人员档案* * @param req* @param resp* @throws ServletException* @throws IOException*/public void toAdd(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String familycode = req.getParameter("familycode");req.setAttribute("familycode", familycode);req.getRequestDispatcher("/page/chper/chper_add.jsp").forward(req, resp);}/*** 预更新* * @param req* @param resp* @throws ServletException* @throws IOException*/public void toUpdate(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

/*** 用农合证号+身份证号+年度的方式查询参合登记表* Servlet implementation class ReimbursementServlet*/@WebServlet("/ReimbursementServlet")public class ReimbursementServlet extends BaseServlet {private static final long serialVersionUID = 1L;/*** 系统在参合登记表中判断该身份证号是否参合;* @param req* @param resp* @throws IOException*/public void selIsPer(HttpServletRequest req,HttpServletResponse resp) throws IOException{Map<String,Object> map=new HashMap<String, Object>();String idnumber = req.getParameter("idnumber");//通过身份证号查询参合人员是否参合ChperDao chperDao = new ChperDao();Chper chper = chperDao.queryByIdnumber(idnumber, null);map.put("chper", chper);//查询当前慢性病信息IllnumDao cd=new IllnumDao();List<Illnum> lc = cd.quertByIdnumber(idnumber);System.out.println("根据身份证号码可以查询到慢性病吗？"+lc.size());map.put("lc", lc);System.out.println(new Gson().toJson(map));resp.getWriter().print(new Gson().toJson(map));}public void save(HttpServletRequest req,HttpServletResponse resp)throws IOException{String name = req.getParameter("name");String rccardnum = req.getParameter("rccardnum");String illcode = req.getParameter("illcode");double momey =Double.parseDouble(req.getParameter("momey")) ;System.out.println("接到值吗？"+name+","+rccardnum+","+illcode+","+momey);Map<String,Object> map=new HashMap<String, Object>();//获取当前年

//响应resp.getWriter().write("power");return;}else{//重定向到登录页面resp.sendRedirect("/medical1/WebRoot/page/user/user_login.jsp");}}}@Overridepublic void init(FilterConfig arg0) throws ServletException {}}package www.gxuwz.medical.web.servlet;public class MenuServlet extends BaseServlet {MenuDao md=null;public void selMenus(HttpServletRequest req,HttpServletResponse resp) throws ServletException, IOException{md=new MenuDao();String sql="select * from t_menu";List<Menu> lm = md.selMenu(sql);req.setAttribute("menus", lm);

}package www.gxuwz.medical.web.servlet;/*** Servlet implementation class ChperServlet*/@WebServlet("/ChperServlet")public class ChperServlet extends BaseServlet {private static final long serialVersionUID = 1L;/*** 显示所有参合人员档案信息* * @param req* @param resp* @throws ServletException* @throws IOException*/public void chperList(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {req.setCharacterEncoding("utf-8");String address = req.getParameter("address");String rccardnum = req.getParameter("rccardnum");String name = req.getParameter("name");String pageNo = req.getParameter("pageNo");int p = pageNo == null ? 1 : Integer.parseInt(pageNo);ChperDao chper = new ChperDao();Page chperpage = chper.queryAll(p, Constant.ROW, address, rccardnum, name);int prePage = chperpage.prePage();int lastPage = chperpage.lastPage();boolean last = chperpage.isLast();List<Integer> linkLumbers = chperpage.linkLumbers();List datas = chperpage.getDatas();req.setAttribute("chperpage", chperpage);

* @throws ServletException* @throws IOException*/public void addPolicy(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {int years=Integer.parseInt(req.getParameter("years"));double upperlimit=Double.parseDouble(req.getParameter("upperlimit"));double proportion=Double.parseDouble(req.getParameter("proportion"));Policy policy=new Policy(years,upperlimit,proportion);policy.add();req.getRequestDispatcher("PolicyServlet?method=policyList").forward(req, resp);}/*** 预更新慢性政策* * @param req* @param resp* @throws ServletException* @throws IOException*/public void toUpdate(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {int years=Integer.parseInt(req.getParameter("years")) ;PolicyDao policyDao=new PolicyDao();Policy policy = policyDao.queryByYears(years);req.setAttribute("policy", policy);req.getRequestDispatcher("/page/policy/policy_edit.jsp").forward(req, resp);}/*** 更新慢性政策* * @param req* @param resp* @throws ServletException* @throws IOException*/public void updatePolicy(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {int years=Integer.parseInt(req.getParameter("years"));double upperlimit=Double.parseDouble(req.getParameter("upperlimit"));double proportion=Double.parseDouble(req.getParameter("proportion"));Policy policy=new Policy(years,upperlimit,proportion);policy.update();req.getRequestDispatcher("PolicyServlet?method=policyList").forward(req, resp);}}package www.gxuwz.medical.web.servlet;

//通过身份证号查询参合人员是否参合ChperDao chperDao = new ChperDao();Chper chper = chperDao.queryByIdnumber(idnumber, null);map.put("chper", chper);//查询当前慢性病信息IllnumDao cd=new IllnumDao();List<Illnum> lc = cd.quertByIdnumber(idnumber);System.out.println("根据身份证号码可以查询到慢性病吗？"+lc.size());map.put("lc", lc);System.out.println(new Gson().toJson(map));resp.getWriter().print(new Gson().toJson(map));}public void save(HttpServletRequest req,HttpServletResponse resp)throws IOException{String name = req.getParameter("name");String rccardnum = req.getParameter("rccardnum");String illcode = req.getParameter("illcode");double momey =Double.parseDouble(req.getParameter("momey")) ;System.out.println("接到值吗？"+name+","+rccardnum+","+illcode+","+momey);Map<String,Object> map=new HashMap<String, Object>();//获取当前年Calendar c=Calendar.getInstance();int i = c.get(Calendar.YEAR);//系统查询当前年度慢性病封顶线及报销比例; PolicyDao pd=new PolicyDao();Policy policy = pd.queryByYears(i);policy.getUpperlimit();//系统获取当年封顶线double upperlimit=policy.getUpperlimit();//获取疾病名称ChronicdisDao cd=new ChronicdisDao();Chronicdis chronicdis = cd.quertByIllcode(illcode);//系统预计算本次报销金额;double pre= momey*policy.getProportion();//系统计算当前年度慢性病已报销总金额; ReimbursementDao rd=new ReimbursementDao();

req.getRequestDispatcher("PolicyServlet?method=policyList").forward(req, resp);}/*** 预更新慢性政策* * @param req* @param resp* @throws ServletException* @throws IOException*/public void toUpdate(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {int years=Integer.parseInt(req.getParameter("years")) ;PolicyDao policyDao=new PolicyDao();Policy policy = policyDao.queryByYears(years);req.setAttribute("policy", policy);req.getRequestDispatcher("/page/policy/policy_edit.jsp").forward(req, resp);}/*** 更新慢性政策* * @param req* @param resp* @throws ServletException* @throws IOException*/public void updatePolicy(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {int years=Integer.parseInt(req.getParameter("years"));double upperlimit=Double.parseDouble(req.getParameter("upperlimit"));double proportion=Double.parseDouble(req.getParameter("proportion"));Policy policy=new Policy(years,upperlimit,proportion);policy.update();req.getRequestDispatcher("PolicyServlet?method=policyList").forward(req, resp);}}package www.gxuwz.medical.web.servlet;

*/public void updateFamily(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String familycode = req.getParameter("familycode");String countycode = req.getParameter("countycode");String towncode = req.getParameter("towncode");String villagecode = req.getParameter("villagecode");String groupcode = req.getParameter("groupcode");String familyattr = req.getParameter("familyattr");String householder = req.getParameter("householder");int familynum = Integer.parseInt(req.getParameter("familynum"));int farmingnum = Integer.parseInt(req.getParameter("farmingnum"));String address = req.getParameter("address");String creationtime = req.getParameter("creationtime");String registrar = req.getParameter("registrar");String relation = req.getParameter("relation");String idnumber = req.getParameter("idnumber");// 姓名=householderString sex = req.getParameter("sex");String ishealthy = req.getParameter("ishealthy");String nation = req.getParameter("nation");String culture = req.getParameter("culture");String brithday = req.getParameter("brithday");String perattr = req.getParameter("perattr");String isvillage = req.getParameter("isvillage");String vocation = req.getParameter("vocation");String company = req.getParameter("company");String tetl = req.getParameter("tetl");String ismarried = req.getParameter("ismarried");Person person = new Person(idnumber, householder, sex, ishealthy, nation, culture, brithday, perattr, isvillage,vocation, company, tetl, ismarried, relation, address);Family chper = new Family(familycode, countycode, towncode, villagecode, groupcode, familyattr, householder,familynum, farmingnum, address, creationtime, registrar, person);chper.update();req.getRequestDispatcher("FamilyServlet?method=familyList").forward(req, resp);}}package www.gxuwz.medical.web.servlet;

String countycode = req.getParameter("countycode");String towncode = req.getParameter("towncode");String villagecode = req.getParameter("villagecode");String groupcode = req.getParameter("groupcode");String familyattr = req.getParameter("familyattr");String householder = req.getParameter("householder");int familynum = Integer.parseInt(req.getParameter("familynum"));int farmingnum = Integer.parseInt(req.getParameter("farmingnum"));String address = req.getParameter("address");String creationtime = req.getParameter("creationtime");String registrar = req.getParameter("registrar");String relation = req.getParameter("relation");String idnumber = req.getParameter("idnumber");// 姓名=householderString sex = req.getParameter("sex");String ishealthy = req.getParameter("ishealthy");String nation = req.getParameter("nation");String culture = req.getParameter("culture");String brithday = req.getParameter("brithday");String perattr = req.getParameter("perattr");String isvillage = req.getParameter("isvillage");String vocation = req.getParameter("vocation");String company = req.getParameter("company");String tetl = req.getParameter("tetl");String ismarried = req.getParameter("ismarried");Person person = new Person(idnumber, householder, sex, ishealthy, nation, culture, brithday, perattr, isvillage,vocation, company, tetl, ismarried, relation, address);Family chper = new Family(null, countycode, towncode, villagecode, groupcode, familyattr, householder,familynum, farmingnum, address, creationtime, registrar, person);chper.add();req.getRequestDispatcher("FamilyServlet?method=familyList").forward(req, resp);}/*** 预修改* * @param req* @param resp* @throws ServletException

int p = pageNo == null ? 1 : Integer.parseInt(pageNo);ChpayDao chpay = new ChpayDao();Page chpaypage = chpay.queryAll(p, Constant.ROW);int prePage = chpaypage.prePage();int lastPage = chpaypage.lastPage();boolean last = chpaypage.isLast();List<Integer> linkLumbers = chpaypage.linkLumbers();List datas = chpaypage.getDatas();req.setAttribute("chpaypage", chpaypage);req.setAttribute("datas", datas);req.setAttribute("prePage", prePage);req.setAttribute("lastPage", lastPage);req.setAttribute("linkLumbers", linkLumbers);req.setAttribute("last", last);req.getRequestDispatcher("/page/chpay/chpay_list.jsp").forward(req, resp);}/*** 查询本镇下面所有同名的户主* * @param req* @param resp* @throws ServletException* @throws IOException*/public void chpayPay(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String householder = req.getParameter("householder");// 存储数据Map<String, Object> map = new HashMap<String, Object>();// 获取当前年份Calendar instance = Calendar.getInstance();int i = instance.get(Calendar.YEAR);// 系统检查是否设置当年缴费标准。PolicyDao policyDao = new PolicyDao();Policy queryByYears = policyDao.queryByYears(i);boolean hasyear;boolean isovertime;if (queryByYears != null) {hasyear = true;} else {

* @param resp* @throws ServletException* @throws IOException*/public void addChper(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String rccardnum = req.getParameter("rccardnum");String medicalnum = req.getParameter("medicalnum");String name = req.getParameter("name");String relation = req.getParameter("relation");String idnumber = req.getParameter("idnumber");String sex = req.getParameter("sex");String ishealthy = req.getParameter("ishealthy");String nation = req.getParameter("nation");String culture = req.getParameter("culture");int age = Integer.parseInt(req.getParameter("age"));String brithday = req.getParameter("brithday");String perattr = req.getParameter("perattr");String isvillage = req.getParameter("isvillage");String vocation = req.getParameter("vocation");String company = req.getParameter("company");String tetl = req.getParameter("tetl");String ismarried = req.getParameter("ismarried");String address = null;String familycode = req.getParameter("familycode");String countycode = req.getParameter("countycode");String towncode = req.getParameter("towncode");String villagecode = req.getParameter("villagecode");String groupcode = req.getParameter("groupcode");String details = req.getParameter("details");AreaDao ad = new AreaDao();if (groupcode == null && details == null) {address = ad.queryAreaByCode(countycode).getAreaname() + ad.queryAreaByCode(towncode).getAreaname()+ ad.queryAreaByCode(villagecode).getAreaname();} else if (details == null) {address = ad.queryAreaByCode(countycode).getAreaname() + ad.queryAreaByCode(towncode).getAreaname()+ ad.queryAreaByCode(villagecode).getAreaname() + ad.queryAreaByCode(groupcode).getAreaname();} else {address = ad.queryAreaByCode(countycode).getAreaname() + ad.queryAreaByCode(towncode).getAreaname()+ ad.queryAreaByCode(villagecode).getAreaname() + ad.queryAreaByCode(groupcode).getAreaname()+ details;}

String areacode = req.getParameter("areacode");AreaDao areaDao = new AreaDao();Area area = areaDao.queryAreaByCode(areacode);Area areap = areaDao.queryAreaByCode(area.getAreapid());AreaTree areaTree = new AreaTree("0");List<TreeNode> childNodeList = areaTree.getChildNodeList();// 跳转req.setAttribute("childNodeList", childNodeList);req.setAttribute("area", area);req.setAttribute("areap", areap);req.getRequestDispatcher("page/area/area_edit.jsp").forward(req, resp);}public void addArea(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {// 处理业务String choese = req.getParameter("choese");int level = Integer.parseInt(choese.split("-")[0]);String areapid = choese.split("-")[1];String areaname = req.getParameter("areaname");Area area = new Area(areapid, areaname, level);area.add();// 跳转req.getRequestDispatcher("areaData?method=areaList").forward(req, resp);}}package www.gxuwz.medical.web.servlet;

* @throws IOException*/public void chperList(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {req.setCharacterEncoding("utf-8");String address = req.getParameter("address");String rccardnum = req.getParameter("rccardnum");String name = req.getParameter("name");String pageNo = req.getParameter("pageNo");int p = pageNo == null ? 1 : Integer.parseInt(pageNo);ChperDao chper = new ChperDao();Page chperpage = chper.queryAll(p, Constant.ROW, address, rccardnum, name);int prePage = chperpage.prePage();int lastPage = chperpage.lastPage();boolean last = chperpage.isLast();List<Integer> linkLumbers = chperpage.linkLumbers();List datas = chperpage.getDatas();req.setAttribute("chperpage", chperpage);req.setAttribute("datas", datas);req.setAttribute("prePage", prePage);req.setAttribute("lastPage", lastPage);req.setAttribute("linkLumbers", linkLumbers);req.setAttribute("last", last);req.getRequestDispatcher("/page/chper/chper_list.jsp").forward(req, resp);}/*** 去添加参合人员档案* * @param req* @param resp* @throws ServletException* @throws IOException*/public void toAdd(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String familycode = req.getParameter("familycode");req.setAttribute("familycode", familycode);req.getRequestDispatcher("/page/chper/chper_add.jsp").forward(req, resp);}/*** 预更新* * @param req* @param resp* @throws ServletException* @throws IOException*/

req.getRequestDispatcher("IllnumServlet?method=illnumList").forward(req, resp);}public void updateIllnum(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String illcode = req.getParameter("illcode");String illcardnum = req.getParameter("illcardnum");String endtime = req.getParameter("endtime");Illnum i = new Illnum(illcardnum, null, null, illcode, null, endtime);i.update();req.getRequestDispatcher("IllnumServlet?method=illnumList").forward(req, resp);}}package www.gxuwz.medical.web.servlet;public class InsServlet extends BaseServlet {public void updateMedical(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {String inscode = req.getParameter("inscode");String insname = req.getParameter("insname");String areacode = req.getParameter("areapid");int subcode = Integer.parseInt(req.getParameter("subcode"));int levelcode = Integer.parseInt(req.getParameter("levelcode"));int fixedpoindcode = Integer.parseInt(req.getParameter("fixedpoindcode"));int pfixedpoindcode = Integer.parseInt(req.getParameter("pfixedpoindcode"));int ecocode = Integer.parseInt(req.getParameter("ecocode"));String instypecode = req.getParameter("instypecode");String sponsorunit = req.getParameter("sponsorunit");

* @throws IOException*/public void delChronicdis(HttpServletRequest req,HttpServletResponse resp) throws ServletException, IOException{String illcode=req.getParameter("illcode");Chronicdis chronicdis=new Chronicdis(illcode);chronicdis.del();req.getRequestDispatcher("ChronicdisServlet?method=chronicdisList").forward(req, resp);}/***预更新* @param req* @param resp* @throws ServletException* @throws IOException*/public void toUpdate(HttpServletRequest req,HttpServletResponse resp) throws ServletException, IOException{String illcode=req.getParameter("illcode");ChronicdisDao chronicdis=new ChronicdisDao();Chronicdis quertByIllcode = chronicdis.quertByIllcode(illcode);req.setAttribute("quertByIllcode", quertByIllcode);req.getRequestDispatcher("/page/chronicdis/chronicdis_edit.jsp").forward(req, resp);}public void addChronicdis(HttpServletRequest req,HttpServletResponse resp) throws ServletException, IOException{String illcode=req.getParameter("illcode");String illname=req.getParameter("illname");String pycode=req.getParameter("pycode");Chronicdis chronicdis=new Chronicdis(illcode,illname,pycode);chronicdis.add();req.getRequestDispatcher("ChronicdisServlet?method=chronicdisList").forward(req, resp);}public void updateChronicdis(HttpServletRequest req,HttpServletResponse resp) throws ServletException, IOException{String illcode=req.getParameter("illcode");String illname=req.getParameter("illname");String pycode=req.getParameter("pycode");Chronicdis chronicdis=new Chronicdis(illcode,illname,pycode);chronicdis.update();req.getRequestDispatcher("ChronicdisServlet?method=chronicdisList").forward(req, resp);}

resp.getWriter().print(new Gson().toJson(hashMap));} else {flag = 1;hashMap.put("flag", flag);Chpay chpay = new Chpay(null, rccardnum, payamount, null, null, registrar, null);chpay.add();resp.getWriter().print(new Gson().toJson(hashMap));}}}package www.gxuwz.medical.web.servlet;/*** Servlet implementation class ChperServlet*/@WebServlet("/ChperServlet")public class ChperServlet extends BaseServlet {private static final long serialVersionUID = 1L;/*** 显示所有参合人员档案信息* * @param req* @param resp* @throws ServletException* @throws IOException*/

String areacode = req.getParameter("areacode");// 跳转Area area = new Area(areacode);area.del();req.getRequestDispatcher("areaData?method=areaList").forward(req, resp);}public void toAdd(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {AreaTree areaTree = new AreaTree("0");List<TreeNode> childNodeList = areaTree.getChildNodeList();req.setAttribute("childNodeList", childNodeList);req.getRequestDispatcher("page/area/area_add.jsp").forward(req, resp);}public void areaQuery(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {String search = req.getParameter("search");AreaDao areaDao = new AreaDao();List<Area> arealist = areaDao.search(search);resp.setContentType("html/text;charset=utf-8");resp.getWriter().println(new Gson().toJson(arealist));}/*** editArea 更新* * @param req* @param resp* @throws ServletException* @throws IOException*/public void editArea(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {// 处理业务String areapid =null;String reArea= req.getParameter("areapid");if(reArea==""){areapid="0";}else{areapid=reArea;}String areaname = req.getParameter("areaname");String areacode = req.getParameter("areacode");

ChperDao chperDao = new ChperDao();Chper chper = chperDao.queryByIdnumber(idnumber, null);map.put("chper", chper);//查询当前慢性病信息IllnumDao cd=new IllnumDao();List<Illnum> lc = cd.quertByIdnumber(idnumber);System.out.println("根据身份证号码可以查询到慢性病吗？"+lc.size());map.put("lc", lc);System.out.println(new Gson().toJson(map));resp.getWriter().print(new Gson().toJson(map));}public void save(HttpServletRequest req,HttpServletResponse resp)throws IOException{String name = req.getParameter("name");String rccardnum = req.getParameter("rccardnum");String illcode = req.getParameter("illcode");double momey =Double.parseDouble(req.getParameter("momey")) ;System.out.println("接到值吗？"+name+","+rccardnum+","+illcode+","+momey);Map<String,Object> map=new HashMap<String, Object>();//获取当前年Calendar c=Calendar.getInstance();int i = c.get(Calendar.YEAR);//系统查询当前年度慢性病封顶线及报销比例; PolicyDao pd=new PolicyDao();Policy policy = pd.queryByYears(i);policy.getUpperlimit();//系统获取当年封顶线double upperlimit=policy.getUpperlimit();//获取疾病名称ChronicdisDao cd=new ChronicdisDao();Chronicdis chronicdis = cd.quertByIllcode(illcode);//系统预计算本次报销金额;double pre= momey*policy.getProportion();//系统计算当前年度慢性病已报销总金额; ReimbursementDao rd=new ReimbursementDao();double sum=rd.querySum(rccardnum);//本次报销double benci;//判断是否超出封顶线boolean isupper=false;if(pre>(upperlimit-sum)){//超出封顶线,封顶线-报销总额

public void showAreaTree(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {// 处理业务AreaDao areaDao = new AreaDao();List<Area> allArea = areaDao.allArea();// 跳转resp.setContentType("text/html;charset=utf-8");resp.getWriter().println(new Gson().toJson(allArea));}/*** 联动获取地区信息* @param req* @param resp* @throws ServletException* @throws IOException*/public void arealinkage(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {// 处理业务AreaDao areaDao = new AreaDao();String areapid=req.getParameter("areapid");List<Area> allArea = areaDao.areaByPid(areapid);// 跳转resp.setContentType("text/html;charset=utf-8");resp.getWriter().println(new Gson().toJson(allArea));}public void updAdd(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {// 处理业务String areacode = req.getParameter("areacode");AreaDao areaDao = new AreaDao();Area area = areaDao.queryAreaByCode(areacode);Area areap = areaDao.queryAreaByCode(area.getAreapid());AreaTree areaTree = new AreaTree("0");List<TreeNode> childNodeList = areaTree.getChildNodeList();// 跳转req.setAttribute("childNodeList", childNodeList);req.setAttribute("area", area);req.setAttribute("areap", areap);req.getRequestDispatcher("page/area/area_edit.jsp").forward(req, resp);}

String sql="select * from t_user where userid=? and pwd =?";User u = ud.userLogin(sql,userid, pwd);HttpSession hs = req.getSession();if (u != null) {hs.setAttribute("loginSuccess", u);resp.sendRedirect("page/user/main.jsp");} else {hs.setAttribute("flag", "loginFailed");resp.sendRedirect("page/user/user_login.jsp");}}/*** 用户退出登录* * @param req* @param resp*/public void userOut(HttpServletRequest req, HttpServletResponse resp) {HttpSession session = req.getSession();session.invalidate();try {resp.sendRedirect("page/user/user_login.jsp");} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}}/***显示所有用户信息* @param req* @param resp* @throws ServletException* @throws IOException*/public void userManager(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String sql="select * from t_user"; List<User> lu = ud.userList(sql);req.setAttribute("userList",lu);req.getRequestDispatcher("page/user/user_manager.jsp").forward(req, resp);}/** * 添加用户

public void arealinkage(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {// 处理业务AreaDao areaDao = new AreaDao();String areapid=req.getParameter("areapid");List<Area> allArea = areaDao.areaByPid(areapid);// 跳转resp.setContentType("text/html;charset=utf-8");resp.getWriter().println(new Gson().toJson(allArea));}public void updAdd(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {// 处理业务String areacode = req.getParameter("areacode");AreaDao areaDao = new AreaDao();Area area = areaDao.queryAreaByCode(areacode);Area areap = areaDao.queryAreaByCode(area.getAreapid());AreaTree areaTree = new AreaTree("0");List<TreeNode> childNodeList = areaTree.getChildNodeList();// 跳转req.setAttribute("childNodeList", childNodeList);req.setAttribute("area", area);req.setAttribute("areap", areap);req.getRequestDispatcher("page/area/area_edit.jsp").forward(req, resp);}public void addArea(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {// 处理业务String choese = req.getParameter("choese");int level = Integer.parseInt(choese.split("-")[0]);String areapid = choese.split("-")[1];String areaname = req.getParameter("areaname");Area area = new Area(areapid, areaname, level);area.add();// 跳转req.getRequestDispatcher("areaData?method=areaList").forward(req, resp);}}package www.gxuwz.medical.web.servlet;

/*** Servlet implementation class ChperServlet*/@WebServlet("/ChperServlet")public class ChperServlet extends BaseServlet {private static final long serialVersionUID = 1L;/*** 显示所有参合人员档案信息* * @param req* @param resp* @throws ServletException* @throws IOException*/public void chperList(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {req.setCharacterEncoding("utf-8");String address = req.getParameter("address");String rccardnum = req.getParameter("rccardnum");String name = req.getParameter("name");String pageNo = req.getParameter("pageNo");int p = pageNo == null ? 1 : Integer.parseInt(pageNo);ChperDao chper = new ChperDao();Page chperpage = chper.queryAll(p, Constant.ROW, address, rccardnum, name);int prePage = chperpage.prePage();int lastPage = chperpage.lastPage();boolean last = chperpage.isLast();List<Integer> linkLumbers = chperpage.linkLumbers();List datas = chperpage.getDatas();req.setAttribute("chperpage", chperpage);req.setAttribute("datas", datas);req.setAttribute("prePage", prePage);req.setAttribute("lastPage", lastPage);req.setAttribute("linkLumbers", linkLumbers);req.setAttribute("last", last);req.getRequestDispatcher("/page/chper/chper_list.jsp").forward(req, resp);}

//if (j > 180) {//isovertime = true;//} else {isovertime = false;//}map.put("isovertime", isovertime);// 获取用户所在乡镇// 系统弹出对话框显示本乡镇下所有同名户主。FamilyDao f = new FamilyDao();List<Family> queryAllbyName = f.queryAllbyName(householder);map.put("info", queryAllbyName);System.out.println(new Gson().toJson(map));resp.getWriter().println(new Gson().toJson(map));}/*** 显示户主所在家庭所有未完全缴费的参合人员* * @param req* @param resp* @throws ServletException* @throws IOException*/public void selPerson(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String familycode = req.getParameter("familycode");// 获取当前年Calendar calendar = Calendar.getInstance();int i = calendar.get(Calendar.YEAR);ChperDao chperDao = new ChperDao();PersonDao pd = new PersonDao();ChpayDao cd = new ChpayDao();PolicyDao policyDao = new PolicyDao();Policy policy = policyDao.queryByYears(i);List<Chper> lc = new ArrayList<Chper>();List<Person> lp = pd.queryByFamilycode(familycode, null);//通过家庭编号和名字查询家庭成员double upperlimit = policy.getUpperlimit();//得到当年缴费标准for (Person person : lp) {Chper chper = chperDao.queryByIdnumber(person.getIdnumber(), null);//通过个人身份证号得到农合证号信息if (chper != null) {//通过农合信息号查询boolean flag = cd.queryByid(chper.getRccardnum());//Chpay chpay = null;if (flag == false) {Chper idnumber = chperDao.queryByIdnumber(null, chper.getRccardnum());lc.add(idnumber);} else {chpay = cd.queryByCode(chper.getRccardnum(), upperlimit);

// TODO Auto-generated catch blocke.printStackTrace();}req.getRequestDispatcher("IllnumServlet?method=illnumList").forward(req, resp);}/*** 显示所有慢性病证* * @param req* @param resp* @throws ServletException* @throws IOException*/public void illnumList(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String m = req.getParameter("m");String search = req.getParameter("search");String pageNo = req.getParameter("pageNo");int p = pageNo == null ? 1 : Integer.parseInt(pageNo);IllnumDao illnum = new IllnumDao();Page illnumpage = illnum.queryAll(p, Constant.ROW, search);int prePage = illnumpage.prePage();int lastPage = illnumpage.lastPage();boolean last = illnumpage.isLast();List<Integer> linkLumbers = illnumpage.linkLumbers();List datas = illnumpage.getDatas();req.setAttribute("illnumpage", illnumpage);req.setAttribute("datas", datas);req.setAttribute("prePage", prePage);req.setAttribute("lastPage", lastPage);req.setAttribute("linkLumbers", linkLumbers);req.setAttribute("last", last);req.getRequestDispatcher("/page/illnum/illnum_list.jsp").forward(req, resp);}/*** 删除慢性病证* * @param req* @param resp* @throws ServletException* @throws IOException*/public void delIllnum(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String illcardnum = req.getParameter("illcardnum");Illnum i = new Illnum(illcardnum);i.del();req.getRequestDispatcher("IllnumServlet?method=illnumList").forward(req, resp);}

public void toAdd(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {EconomicType etype = new EconomicType();FixedPoind fpoind = new FixedPoind();InsLevel level = new InsLevel();InsType insType = new InsType();Subjection sub = new Subjection();AreaDao areaDao=new AreaDao();List<EconomicType> etypeinfo = etype.query();List<FixedPoind> fpoindinfo = fpoind.query();List<InsLevel> levelinfo = level.query();List<InsType> insTypeinfo = insType.query();List<Subjection> subinfo = sub.query();List<Area> allArea = areaDao.allArea();req.setAttribute("etypeinfo", etypeinfo);req.setAttribute("fpoindinfo", fpoindinfo);req.setAttribute("levelinfo", levelinfo);req.setAttribute("insTypeinfo", insTypeinfo);req.setAttribute("subinfo", subinfo);req.setAttribute("allArea", allArea);req.getRequestDispatcher("/page/medical/medical_add.jsp").forward(req, resp);;}}package www.gxuwz.medical.web.servlet;