javaWebssh文玩竞价管理系统myeclipse开发mysql数据库MVC模式java编程计算机网页设计源码

package com.action; import java.util.ArrayList; import java.util.List; import org.apache.struts2.ServletActionContext; import com.opensymphony.xwork2.ActionSupport; import com.bean.shangpin; import com.dao.shangpinDao; /* 对商品功能进行维护 */ @SuppressWarnings("serial") public class shangpinAction extends ActionSupport { private static final long serialVersionUID = 1L; private shangpinDao dao=null; private shangpin shangpin=new shangpin();////对商品进行管理bean private List<shangpin> shangpins=new ArrayList<shangpin>();//对商品进行管理获得结果集返回list private String key=""; private int pageNum=1; private int pageCount=0; public shangpin getShangpin() { return shangpin; } public void setDao(shangpinDao dao) { this.dao = dao; } public void setShangpin(shangpin shangpin) { this.shangpin = shangpin; } public List<shangpin> getShangpins() { return shangpins; } public String execute() {//默认商品功能 添加 暂时留空 return ""; } public String addPage(){ //商品添加页面 try{ }catch(Exception e){ System.out.println(e.toString()); } return "shangpinaddPage"; } public String add() {//对表shangpin进行添加操作 try{ dao.addshangpin(shangpin); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('添加成功');</script>"); return "shangpinadd"; } public String list() {//对商品进行管理 对表shangpin进行查询 try{ String sql=" from shangpin where 1=1"; String qx=""; String yhm=""; if(ServletActionContext.getRequest().getSession().getAttribute("yhm")!=null){ qx=ServletActionContext.getRequest().getSession().getAttribute("qx").toString(); yhm=ServletActionContext.getRequest().getSession().getAttribute("yhm").toString(); } if(qx.equals("管理员")){ }else{ sql+=" and yh='"+yhm+"'"; } shangpins=dao.getshangpins(sql); }catch(Exception e){ System.out.println(e.toString()); } return "shangpinlist"; } public String listp() {//对商品进行管理 对表shangpin进行查询 try{ shangpins=dao.getshangpins(" from shangpin where 1=1"); }catch(Exception e){ System.out.println(e.toString()); } return "shangpinlistp"; } public String del() {//对商品进行删除 对表shangpin进行删除 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); shangpin tempbean=dao.getshangpin("from shangpin where spid="+keyid); try{ dao.delshangpin(tempbean); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('删除成功');</script>"); return list(); } public String modPage(){ ////对商品修改页面 对表shangpin进行修改 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); try{ shangpin=dao.getshangpin("from shangpin where spid="+keyid); ServletActionContext.getRequest().setAttribute("fl",shangpin.getFl()); ServletActionContext.getRequest().setAttribute("sj",shangpin.getSj()); ServletActionContext.getRequest().setAttribute("spid",shangpin.getSpid()); }catch(Exception e){ System.out.println(e.toString()); } return "shangpinmodPage"; } public String mod(){ ////对商品进行修改操作 对表shangpin进行修改 try{ dao.modifyshangpin(shangpin); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('修改成功');</script>");//location.href='bookmanage'; return list(); } public String detail(){ ////对商品修改页面 对表shangpin进行修改 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); try{ shangpin=dao.getshangpin("from shangpin where spid="+keyid); ServletActionContext.getRequest().setAttribute("fl",shangpin.getFl()); ServletActionContext.getRequest().setAttribute("sj",shangpin.getSj()); ServletActionContext.getRequest().setAttribute("spid",String.valueOf(shangpin.getSpid())); }catch(Exception e){ System.out.println(e.toString()); } return "shangpindetail"; } public String getKey() { return key; } public void setKey(String key) { this.key = key; } public int getPageNum() { return pageNum; } public void setPageNum(int pageNum) { this.pageNum = pageNum; } public int getPageCount() { return pageCount; } }