1689 ssm社区老人危机干预系统myeclipse开发mysql数据库springMVC模式java编程计算机网页设计源码

package com.action; import java.sql.ResultSet; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import com.bean.*; import com.dao.*; import com.util.DBO; @Controller @RequestMapping(value="/syl") public class sylAction { /** * 自动注入业务逻辑层，注入方式使用了注解自动注入 */ @Resource sylDao syldao; @RequestMapping(value="/addPage") public String addPage(syl syl,HttpServletRequest request){ Map<String,Object> map= new HashMap<String,Object>(); System.out.println("addPageok"); return "syl/syladd"; } @RequestMapping(value="/add") public String add(syl syl,HttpServletRequest request){ Map<String,Object> map= new HashMap<String,Object>(); //String name=(String)request.getParameter("name"); map.put("sylid", syl.getSylid());//使用量编号 map.put("lr", syl.getLr());//老人 map.put("bysyl", syl.getBysyl());//本月使用量 map.put("yf", syl.getYf());//月份 map.put("djsj", syl.getDjsj());//登记时间 map.put("djr", syl.getDjr());//登记人 String sylid=(String)syl.getSylid();//使用量编号 String lr=(String)syl.getLr();//老人 String bysyl=(String)syl.getBysyl();//本月使用量 String yf=(String)syl.getYf();//月份 String djsj=(String)syl.getDjsj();//登记时间 String djr=(String)syl.getDjr();//登记人 String yj=(String)syl.getYj();//预警 DBO db=new DBO(); String sql=""; ResultSet rs=null; int num=0; int yjz=0; try{ sql="select count(1) as num from syl where lr='"+lr+"' and yf='"+yf+"'"; rs=db.query(sql); if(rs.next()){ num=rs.getInt("num"); } if(num==0){ sql="select * from yjz"; rs=db.query(sql); if(rs.next()){ num=rs.getInt("yjz"); } if(Integer.parseInt(bysyl)>yjz){ map.put("yj", "是");//预警 }else{ map.put("yj", syl.getYj());//预警 } sql="update sqlr set sb=sb+"+bysyl+" where sqlrid='"+lr+"'"; db.update(sql); syldao.save(map); request.setAttribute("msg", "<script>alert('添加成功');</script>"); System.out.println("addok"); }else{ request.setAttribute("msg", "<script>alert('添加失败、数据重复');</script>"); } }catch(Exception e){ e.printStackTrace(); }finally{ db.close(); } return "syl/syladd"; } /**取消预警 * */ @RequestMapping(value="/quxiao") public String quxiao(Integer id,HttpServletRequest request,Map<String,Object> map){ // Map<String,Object> map= new HashMap<String,Object>(); String a=(String)request.getParameter("keyid"); DBO db=new DBO(); String sql=""; ResultSet rs=null; try{ sql="update syl set yj='否' where sylid='"+a+"'"; db.update(sql); }catch(Exception e){ e.printStackTrace(); }finally{ db.close(); } request.setAttribute("msg", "<script>alert('取消成功');</script>"); return list(null,map,request); } /**删除 * */ @RequestMapping(value="/del") public String del(Integer id,HttpServletRequest request,Map<String,Object> map){ // Map<String,Object> map= new HashMap<String,Object>(); String a=(String)request.getParameter("keyid"); id=Integer.parseInt(a); request.setAttribute("msg", "<script>alert('删除成功');</script>"); syldao.del(id); return selectall(null,map,request); } /** * 修改syl信息 */ @RequestMapping(value="/update") public String update(syl syl,HttpServletRequest request,Map<String,Object> map1){ Map<String,Object> map= new HashMap<String,Object>(); map.put("sylid", syl.getSylid());//使用量编号 map.put("lr", syl.getLr());//老人 map.put("bysyl", syl.getBysyl());//本月使用量 map.put("yf", syl.getYf());//月份 map.put("djsj", syl.getDjsj());//登记时间 map.put("djr", syl.getDjr());//登记人 map.put("yj", syl.getYj());//预警 String sylid=(String)syl.getSylid();//使用量编号 String lr=(String)syl.getLr();//老人 String bysyl=(String)syl.getBysyl();//本月使用量 String yf=(String)syl.getYf();//月份 String djsj=(String)syl.getDjsj();//登记时间 String djr=(String)syl.getDjr();//登记人 String yj=(String)syl.getYj();//预警 request.setAttribute("msg", "<script>alert('修改成功');</script>"); syldao.update(map); return selectall(null,map1,request); } /** * 查询syl信息 */ @RequestMapping(value="/modify") public String modify(Integer id,Map<String,Object> map,HttpServletRequest request){ String keyid=(String)request.getParameter("keyid"); List<Map<String,Object>> list= new ArrayList<Map<String,Object>>(); list=syldao.select(Integer.parseInt(keyid)); request.setAttribute("sylid", list.get(0).get("sylid"));//使用量编号 request.setAttribute("lr", list.get(0).get("lr"));//老人 request.setAttribute("bysyl", list.get(0).get("bysyl"));//本月使用量 request.setAttribute("yf", list.get(0).get("yf"));//月份 request.setAttribute("djsj", list.get(0).get("djsj"));//登记时间 request.setAttribute("djr", list.get(0).get("djr"));//登记人 request.setAttribute("yj", list.get(0).get("yj"));//预警 return "syl/sylmodify"; } @RequestMapping(value="/detail") public String detail(Integer id,Map<String,Object> map,HttpServletRequest request){ String keyid=(String)request.getParameter("keyid"); List<Map<String,Object>> list= new ArrayList<Map<String,Object>>(); list=syldao.select(Integer.parseInt(keyid)); request.setAttribute("sylid", list.get(0).get("sylid"));//使用量编号 request.setAttribute("lr", list.get(0).get("lr"));//老人 request.setAttribute("bysyl", list.get(0).get("bysyl"));//本月使用量 request.setAttribute("yf", list.get(0).get("yf"));//月份 request.setAttribute("djsj", list.get(0).get("djsj"));//登记时间 request.setAttribute("djr", list.get(0).get("djr"));//登记人 request.setAttribute("yj", list.get(0).get("yj"));//预警 return "syl/syldetail"; } /** * 查询syl信息 */ @RequestMapping(value="/selectall") public String selectall(Integer id,Map<String,Object> map,HttpServletRequest request){ List<Map<String,Object>> list= new ArrayList<Map<String,Object>>(); Map<String,Object> map1= new HashMap<String,Object>(); String sylid=(String)request.getParameter("sylid");//使用量编号 if(sylid!=null&&!sylid.equals("")){ map1.put("sylid",sylid);//使用量编号 } String lr=(String)request.getParameter("lr");//老人 if(lr!=null&&!lr.equals("")){ map1.put("lr",lr);//老人 } String bysyl=(String)request.getParameter("bysyl");//本月使用量 if(bysyl!=null&&!bysyl.equals("")){ map1.put("bysyl",bysyl);//本月使用量 } String yf=(String)request.getParameter("yf");//月份 if(yf!=null&&!yf.equals("")){ map1.put("yf",yf);//月份 } String djsj=(String)request.getParameter("djsj");//登记时间 if(djsj!=null&&!djsj.equals("")){ map1.put("djsj",djsj);//登记时间 } String djr=(String)request.getParameter("djr");//登记人 if(djr!=null&&!djr.equals("")){ map1.put("djr",djr);//登记人 } String yj=(String)request.getParameter("yj");//预警 if(yj!=null&&!yj.equals("")){ map1.put("yj",yj);//预警 } list=syldao.selectAll(map1); System.out.println("listsize="+list.size()); map.put("mylist", list); return "syl/syllist"; } /** * 查询syl信息 */ @RequestMapping(value="/list") public String list(Integer id,Map<String,Object> map,HttpServletRequest request){ List<Map<String,Object>> list= new ArrayList<Map<String,Object>>(); Map<String,Object> map1= new HashMap<String,Object>(); String sylid=(String)request.getParameter("sylid");//使用量