javaWebssh运动会管理系统myeclipse开发mysql数据库MVC模式java编程计算机网页设计源码

package com.action; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import org.apache.struts2.ServletActionContext; import com.opensymphony.xwork2.ActionSupport; import com.util.DBO; import com.bean.baoming; import com.dao.baomingDao; /* 对报名功能进行维护 */ @SuppressWarnings("serial") public class baomingAction extends ActionSupport { private static final long serialVersionUID = 1L; private baomingDao dao=null; private baoming baoming=new baoming();////对报名进行管理bean private List<baoming> baomings=new ArrayList<baoming>();//对报名进行管理获得结果集返回list private String key=""; private int pageNum=1; private int pageCount=0; public baoming getBaoming() { return baoming; } public void setDao(baomingDao dao) { this.dao = dao; } public void setBaoming(baoming baoming) { this.baoming = baoming; } public List<baoming> getBaomings() { return baomings; } public String execute() {//默认报名功能 添加 暂时留空 return ""; } public String addPage(){ //报名添加页面 try{ }catch(Exception e){ System.out.println(e.toString()); } return "baomingaddPage"; } public String add() {//对表baoming进行添加操作 int num=0; ResultSet rs=null; DBO db=new DBO(); int a=0; try{ String sql="select count(1) as num from baoming where ydy='"+baoming.getYdy()+"' and bsxm='"+baoming.getBsxm()+"'"; rs=db.query(sql); if(rs.next()){ num=rs.getInt("num"); } if(num>0){ ServletActionContext.getRequest().setAttribute("msg", "<script>alert('报名失败、报名重复');</script>"); }else{ sql="select count(1) as num from baoming where ydy='"+baoming.getYdy()+"' and zt in ('报名','同意') "; rs=db.query(sql); if(rs.next()){ a=rs.getInt("num"); } System.out.println("a=="+a); if(a>=3){ ServletActionContext.getRequest().setAttribute("msg", "<script>alert('报名失败、每人最多报三项');</script>"); }else{ dao.addbaoming(baoming); ServletActionContext.getRequest().setAttribute("msg", "<script>alert('添加成功');</script>"); } } }catch(Exception e){ System.out.println(e.toString()); } return "baomingadd"; } public String list() {//对报名进行管理 对表baoming进行页面查询 int size=10;//分页个数 try{ String hql=" from baoming where 1=1"; String ydy=""; String bsxm=""; if(ServletActionContext.getRequest().getParameter("ydy")!=null){ ydy=ServletActionContext.getRequest().getParameter("ydy").toString(); if(!ydy.equals("")) hql+=" and ydy='"+ydy+"'"; } if(ServletActionContext.getRequest().getParameter("bsxm")!=null){ bsxm=ServletActionContext.getRequest().getParameter("bsxm").toString(); if(!bsxm.equals("")) hql+=" and bsxm='"+bsxm+"'"; } int count=dao.getbaomings(hql).size(); pageCount=count%size==0?count/size:(count/size+1); if(pageNum<1) { pageNum=1; }else if(pageNum>pageCount) { pageNum=pageCount; } baomings=dao.getbaomings(hql, pageNum, size); }catch(Exception e){ System.out.println(e.toString()); } return "baominglist"; } public String listp() {//对报名进行管理 对表baoming进行查询 try{ String sql=" from baoming where 1=1"; if(ServletActionContext.getRequest().getSession().getAttribute("yhm")!=null){ sql+=" and ydy='"+ServletActionContext.getRequest().getSession().getAttribute("yhm").toString()+"'"; } baomings=dao.getbaomings(sql); }catch(Exception e){ System.out.println(e.toString()); } return "baominglistp"; } public String del() {//对报名进行删除 对表baoming进行删除 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); baoming tempbean=dao.getbaoming("from baoming where bmid="+keyid); try{ dao.delbaoming(tempbean); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('删除成功');</script>"); return list(); } public String modPage(){ ////对报名修改页面 对表baoming进行修改 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); try{ baoming=dao.getbaoming("from baoming where bmid="+keyid); }catch(Exception e){ System.out.println(e.toString()); } return "baomingmodPage"; } public String detail(){ ////对报名修改页面 对表baoming进行修改 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); try{ baoming=dao.getbaoming("from baoming where bmid="+keyid); }catch(Exception e){ System.out.println(e.toString()); } return "baomingdetail"; } public String mod(){ ////对报名进行修改操作 对表baoming进行修改 try{ dao.modifybaoming(baoming); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('操作成功');</script>");//location.href='bookmanage'; return list(); } 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; } }