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.yonghu; import com.dao.yonghuDao; /* 对用户功能进行维护 */ @SuppressWarnings("serial") public class yonghuAction extends ActionSupport { private static final long serialVersionUID = 1L; private yonghuDao dao=null; private yonghu yonghu=new yonghu();////对用户进行管理bean private List<yonghu> yonghus=new ArrayList<yonghu>();//对用户进行管理获得结果集返回list private String key=""; private int pageNum=1; private int pageCount=0; public yonghu getYonghu() { return yonghu; } public void setDao(yonghuDao dao) { this.dao = dao; } public void setYonghu(yonghu yonghu) { this.yonghu = yonghu; } public List<yonghu> getYonghus() { return yonghus; } public String execute() {//默认用户功能 添加 暂时留空 return ""; } public String addPage(){ //用户添加页面 try{ }catch(Exception e){ System.out.println(e.toString()); } return "yonghuaddPage"; } public String add() {//对表yonghu进行添加操作 int num=0; ResultSet rs=null; DBO db=new DBO(); String sql=""; try{ sql="select count(1) as num from yonghu where yhm='"+yonghu.getYhm()+"'"; rs=db.query(sql); if(rs.next()){ num=rs.getInt("num"); } if(num>0){ ServletActionContext.getRequest().setAttribute("msg", "<script>alert('添加失败、用户名重复');</script>"); }else{ dao.addyonghu(yonghu); ServletActionContext.getRequest().setAttribute("msg", "<script>alert('添加成功');</script>"); } }catch(Exception e){ System.out.println(e.toString()); }finally{ db.close(); } return "yonghuadd"; } public String list() {//对用户进行管理 对表yonghu进行查询 try{ yonghus=dao.getyonghus(" from yonghu where 1=1"); }catch(Exception e){ System.out.println(e.toString()); } return "yonghulist"; } public String listp() {//对用户进行管理 对表yonghu进行查询 try{ yonghus=dao.getyonghus(" from yonghu where 1=1"); }catch(Exception e){ System.out.println(e.toString()); } return "yonghulistp"; } public String del() {//对用户进行删除 对表yonghu进行删除 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); yonghu tempbean=dao.getyonghu("from yonghu where yhid="+keyid); try{ dao.delyonghu(tempbean); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('删除成功');</script>"); return list(); } public String modPage(){ ////对用户修改页面 对表yonghu进行修改 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); try{ yonghu=dao.getyonghu("from yonghu where yhid="+keyid); }catch(Exception e){ System.out.println(e.toString()); } return "yonghumodPage"; } public String modp(){ ////对用户修改页面 对表yonghu进行修改 String keyid=ServletActionContext.getRequest().getSession().getAttribute("id").toString(); try{ yonghu=dao.getyonghu("from yonghu where yhid="+keyid); ServletActionContext.getRequest().setAttribute("qx",yonghu.getQx()); }catch(Exception e){ System.out.println(e.toString()); } return "yonghumodp"; } public String upd(){ ////对用户进行修改操作 对表yonghu进行修改 try{ dao.modifyyonghu(yonghu); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('修改成功');</script>");//location.href='bookmanage'; return modp(); } public String mod(){ ////对用户进行修改操作 对表yonghu进行修改 try{ dao.modifyyonghu(yonghu); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('修改成功');</script>");//location.href='bookmanage'; return list(); } public String detail(){ ////对用户修改页面 对表yonghu进行修改 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); try{ yonghu=dao.getyonghu("from yonghu where yhid="+keyid); }catch(Exception e){ System.out.println(e.toString()); } return "yonghudetail"; } 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; } }