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.qiandao; import com.dao.qiandaoDao; /* 对签到功能进行维护 */ @SuppressWarnings("serial") public class qiandaoAction extends ActionSupport { private static final long serialVersionUID = 1L; private qiandaoDao dao=null; private qiandao qiandao=new qiandao();////对签到进行管理bean private List<qiandao> qiandaos=new ArrayList<qiandao>();//对签到进行管理获得结果集返回list private String key=""; private int pageNum=1; private int pageCount=0; public qiandao getQiandao() { return qiandao; } public void setDao(qiandaoDao dao) { this.dao = dao; } public void setQiandao(qiandao qiandao) { this.qiandao = qiandao; } public List<qiandao> getQiandaos() { return qiandaos; } public String execute() {//默认签到功能 添加 暂时留空 return ""; } public String addPage(){ //签到添加页面 try{ }catch(Exception e){ System.out.println(e.toString()); } return "qiandaoaddPage"; } public String add() {//对表qiandao进行添加操作 String sql="select count(1) as num from qiandao where kc='"+qiandao.getKc()+"' and xs='"+qiandao.getXs()+"'"; ResultSet rs=null; DBO db=new DBO(); int num=0; try{ rs=db.query(sql); if(rs.next()){ num=rs.getInt("num"); } if(num>0){ ServletActionContext.getRequest().setAttribute("msg", "<script>alert('添加失败、数据重复');</script>"); }else{ ServletActionContext.getRequest().setAttribute("msg", "<script>alert('签到成功');</script>"); dao.addqiandao(qiandao); } }catch(Exception e){ System.out.println(e.toString()); } return "qiandaoadd"; } public String list() {//对签到进行管理 对表qiandao进行页面查询 int size=10;//分页个数 try{ String hql=" from qiandao where 1=1"; int count=dao.getqiandaos(hql).size(); pageCount=count%size==0?count/size:(count/size+1); if(pageNum<1) { pageNum=1; }else if(pageNum>pageCount) { pageNum=pageCount; } qiandaos=dao.getqiandaos(hql, pageNum, size); }catch(Exception e){ System.out.println(e.toString()); } return "qiandaolist"; } public String listp() {//对签到进行管理 对表qiandao进行查询 try{ String kc="",xs=""; if(ServletActionContext.getRequest().getParameter("kc")!=null){ kc=(String)ServletActionContext.getRequest().getParameter("kc").toString(); } if(ServletActionContext.getRequest().getParameter("xs")!=null){ xs=(String)ServletActionContext.getRequest().getParameter("xs").toString(); } String sql=" from qiandao where 1=1"; if(!xs.equals("")){ sql+=" and xs='"+xs+"'"; } if(!kc.equals("")){ sql+=" and kc='"+kc+"'"; } qiandaos=dao.getqiandaos(sql); }catch(Exception e){ System.out.println(e.toString()); } return "qiandaolistp"; } public String mylist() {//对签到进行管理 对表qiandao进行查询 try{ String sql=" from qiandao where 1=1"; if(ServletActionContext.getRequest().getSession().getAttribute("yhm")!=null){ sql+=" and xs='"+ServletActionContext.getRequest().getSession().getAttribute("yhm").toString()+"'"; } qiandaos=dao.getqiandaos(sql); }catch(Exception e){ System.out.println(e.toString()); } return "qiandaomylist"; } public String del() {//对签到进行删除 对表qiandao进行删除 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); qiandao tempbean=dao.getqiandao("from qiandao where qdid="+keyid); try{ dao.delqiandao(tempbean); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('删除成功');</script>"); return list(); } public String modPage(){ ////对签到修改页面 对表qiandao进行修改 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); try{ qiandao=dao.getqiandao("from qiandao where qdid="+keyid); }catch(Exception e){ System.out.println(e.toString()); } return "qiandaomodPage"; } public String modify(){ ////对签到修改页面 对表qiandao进行修改 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); try{ qiandao=dao.getqiandao("from qiandao where qdid="+keyid); }catch(Exception e){ System.out.println(e.toString()); } return "qiandaomodify"; } public String detail(){ ////对签到修改页面 对表qiandao进行修改 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); try{ qiandao=dao.getqiandao("from qiandao where qdid="+keyid); }catch(Exception e){ System.out.println(e.toString()); } return "qiandaodetail"; } public String mod(){ ////对签到进行修改操作 对表qiandao进行修改 try{ dao.modifyqiandao(qiandao); }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; } }