ssm 设备采购管理系统开发mysql数据库web结构java编程计算机网页源码eclipse项目源码

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="/shebei") public class shebeiAction { /** * 自动注入业务逻辑层，注入方式使用了注解自动注入 */ @Resource shebeiDao shebeidao; @RequestMapping(value="/addPage") public String addPage(shebei shebei,HttpServletRequest request){ Map<String,Object> map= new HashMap<String,Object>(); System.out.println("addPageok"); return "shebei/shebeiadd"; } @RequestMapping(value="/add") public String add(shebei shebei,HttpServletRequest request){ Map<String,Object> map= new HashMap<String,Object>(); //String name=(String)request.getParameter("name"); map.put("sbid", shebei.getSbid());//设备编号 map.put("sbmc", shebei.getSbmc());//设备名称 map.put("fl", shebei.getFl());//分类 map.put("js", shebei.getJs());//介绍 map.put("jg", shebei.getJg());//价格 map.put("tp", shebei.getTp());//图片 map.put("gys", shebei.getGys());//供应商 map.put("scsj", shebei.getScsj());//上传时间 map.put("sl", shebei.getSl());//数量 map.put("ll", shebei.getLl());//浏览 map.put("ck", shebei.getCk());//仓库 String sbid=(String)shebei.getSbid();//设备编号 String sbmc=(String)shebei.getSbmc();//设备名称 String fl=(String)shebei.getFl();//分类 String js=(String)shebei.getJs();//介绍 String jg=(String)shebei.getJg();//价格 String tp=(String)shebei.getTp();//图片 String gys=(String)shebei.getGys();//供应商 String scsj=(String)shebei.getScsj();//上传时间 String sl=(String)shebei.getSl();//数量 String ll=(String)shebei.getLl();//浏览 String ck=(String)shebei.getCk();//仓库 DBO db=new DBO(); String sql=""; int num=0; ResultSet rs=null; try{ sql="select count(1) as num from shebei where sbmc='"+sbmc+"'"; rs=db.query(sql); if(rs.next()){ num=rs.getInt("num"); } if(num>0){ request.setAttribute("msg", "<script>alert('添加失败');</script>"); }else{ shebeidao.save(map); request.setAttribute("msg", "<script>alert('添加成功');</script>"); } }catch(Exception e){ e.printStackTrace(); }finally{ db.close(); } System.out.println("addok"); return "shebei/shebeiadd"; } /**删除 * */ @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>"); shebeidao.del(id); return selectall(null,map,request); } /** * 修改shebei信息 */ @RequestMapping(value="/update") public String update(shebei shebei,HttpServletRequest request,Map<String,Object> map1){ Map<String,Object> map= new HashMap<String,Object>(); map.put("sbid", shebei.getSbid());//设备编号 map.put("sbmc", shebei.getSbmc());//设备名称 map.put("fl", shebei.getFl());//分类 map.put("js", shebei.getJs());//介绍 map.put("jg", shebei.getJg());//价格 map.put("tp", shebei.getTp());//图片 map.put("gys", shebei.getGys());//供应商 map.put("scsj", shebei.getScsj());//上传时间 map.put("sl", shebei.getSl());//数量 map.put("ll", shebei.getLl());//浏览 map.put("ck", shebei.getCk());//仓库 String sbid=(String)shebei.getSbid();//设备编号 String sbmc=(String)shebei.getSbmc();//设备名称 String fl=(String)shebei.getFl();//分类 String js=(String)shebei.getJs();//介绍 String jg=(String)shebei.getJg();//价格 String tp=(String)shebei.getTp();//图片 String gys=(String)shebei.getGys();//供应商 String scsj=(String)shebei.getScsj();//上传时间 String sl=(String)shebei.getSl();//数量 String ll=(String)shebei.getLl();//浏览 String ck=(String)shebei.getCk();//仓库 request.setAttribute("msg", "<script>alert('修改成功');</script>"); shebeidao.update(map); return selectall(null,map1,request); } /** * 查询shebei信息 */ @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=shebeidao.select(Integer.parseInt(keyid)); request.setAttribute("sbid", list.get(0).get("sbid"));//设备编号 request.setAttribute("sbmc", list.get(0).get("sbmc"));//设备名称 request.setAttribute("fl", list.get(0).get("fl"));//分类 request.setAttribute("js", list.get(0).get("js"));//介绍 request.setAttribute("jg", list.get(0).get("jg"));//价格 request.setAttribute("tp", list.get(0).get("tp"));//图片 request.setAttribute("gys", list.get(0).get("gys"));//供应商 request.setAttribute("scsj", list.get(0).get("scsj"));//上传时间 request.setAttribute("sl", list.get(0).get("sl"));//数量 request.setAttribute("ll", list.get(0).get("ll"));//浏览 request.setAttribute("ck", list.get(0).get("ck"));//仓库 return "shebei/shebeimodify"; } @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=shebeidao.select(Integer.parseInt(keyid)); request.setAttribute("sbid", list.get(0).get("sbid"));//设备编号 request.setAttribute("sbmc", list.get(0).get("sbmc"));//设备名称 request.setAttribute("fl", list.get(0).get("fl"));//分类 request.setAttribute("js", list.get(0).get("js"));//介绍 request.setAttribute("jg", list.get(0).get("jg"));//价格 request.setAttribute("tp", list.get(0).get("tp"));//图片 request.setAttribute("gys", list.get(0).get("gys"));//供应商 request.setAttribute("scsj", list.get(0).get("scsj"));//上传时间 request.setAttribute("sl", list.get(0).get("sl"));//数量 request.setAttribute("ll", list.get(0).get("ll"));//浏览 request.setAttribute("ck", list.get(0).get("ck"));//仓库 return "shebei/shebeidetail"; } /** * 查询shebei信息 */ @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 sbid=(String)request.getParameter("sbid");//设备编号 if(sbid!=null&&!sbid.equals("")){ map1.put("sbid",sbid);//设备编号 } String sbmc=(String)request.getParameter("sbmc");//设备名称 if(sbmc!=null&&!sbmc.equals("")){ map1.put("sbmc",sbmc);//设备名称 } String fl=(String)request.getParameter("fl");//分类 if(fl!=null&&!fl.equals("")){ map1.put("fl",fl);//分类 } String js=(String)request.getParameter("js");//介绍 if(js!=null&&!js.equals("")){ map1.put("js",js);//介绍 } String jg=(String)request.getParameter("jg");//价格 if(jg!=null&&!jg.equals("")){ map1.put("jg",jg);//价格 } String tp=(String)request.getParameter("tp");//图片 if(tp!=null&&!tp.equals("")){ map1.put("tp",tp);//图片 } String gys=(String)request.getParameter("gys");//供应商 if(request.getSession().getAttribute("yhm")!=null){ String qx=""; qx=(String)request.getSession().getAttribute("qx"); if(qx.equals("供应商")){ map1.put("gys",request.getSession().getAttribute("yhm"));//供应商 } }