实习项目，基于SSH的器材管理系统，Mysql数据库，内容完整

package com.audiovisualcenter.action; import java.io.IOException; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.ServletContext; import javax.swing.text.AsyncBoxView.ChildState; import org.apache.struts2.ServletActionContext; import com.audiovisualcenter.factory.DatabaseFactory; import com.audiovisualcenter.model.Equip; import com.audiovisualcenter.model.EquipCategory; import com.audiovisualcenter.service.CommonService; import com.audiovisualcenter.service.EquipService; import com.audiovisualcenter.util.JsonUtil; import com.audiovisualcenter.util.StringUtil; import com.common.util.SearchObject; import com.common.util.SearchRelation; import com.common.util.SearchUtil; import com.opensymphony.xwork2.ModelDriven; public class EquipManagerAction extends CommonAction implements ModelDriven<Equip>{ //jqgrid属性 private Integer rows; private Integer page; private boolean _search; private String sidx; private String sord; private String nd; private String ids;//传过来的ids private Equip equip = new Equip();// private String equipstatus;//器材的状态 private List<String> childno;//子选项的编号 private List<String> childremarks;//子选项的备注 private List<String> childcon;//子选项的状态 private int flag;//标记变量 private Map<String, Object> map; public Map<String, Object> getMap() { return map; } public void setMap(Map<String, Object> map) { this.map = map; } public Equip getEquip() { return equip; } public void setEquip(Equip equip) { this.equip = equip; } // public Integer getPage() { return page; } public void setPage(Integer page) { this.page = page; } public boolean is_search() { return _search; } public void set_search(boolean _search) { this._search = _search; } public String getSidx() { return sidx; } public void setSidx(String sidx) { this.sidx = sidx; } public String getSord() { return sord; } public void setSord(String sord) { this.sord = sord; } public void setRows(Integer rows) { this.rows = rows; } public Integer getRows() { return rows; } public String getNd() { return nd; } public void setNd(String nd) { this.nd = nd; } public String getIds() { return ids; } public void setIds(String ids) { this.ids = ids; } public String getEquipstatus() { return equipstatus; } public void setEquipstatus(String equipstatus) { this.equipstatus = equipstatus; } public List<String> getChildno() { return childno; } public void setChildno(List<String> childno) { this.childno = childno; } public List<String> getChildremarks() { return childremarks; } public void setChildremarks(List<String> childremarks) { this.childremarks = childremarks; } public List<String> getChildcon() { return childcon; } public void setChildcon(List<String> childcon) { this.childcon = childcon; } public int getFlag() { return flag; } public void setFlag(int flag) { this.flag = flag; } @Override public String execute() throws Exception { return "success"; } //启动器材添加界面 public String equipAddManager(){ ServletContext servletContext = ServletActionContext.getServletContext(); CommonService commonService = DatabaseFactory.getCommonService(servletContext); List<Object> lists = commonService.findListByHql2("from EquipCategory ec", null); setDataList(lists); return "equipadd"; } //启动器材编辑界面 public String equipEditManager(){ ServletContext servletContext = ServletActionContext.getServletContext(); CommonService commonService = DatabaseFactory.getCommonService(servletContext); List<Object> lists = commonService.findListByHql2("from EquipCategory ec", null); setDataList(lists); // System.out.println(equip.getId()); equip = (Equip) commonService.findObjectById(Equip.class, equip.getId()); List<Object> childs = commonService.findListByHql2("from Equip e where e.parentId=?", new Object[]{equip.getId()}); // Equip firstequip = (Equip) childs.get(0); // System.out.println(firstequip.getRemarks()); if(childs==null || childs.size()==0){//表示没有子编号 setFlag(0);// }else{//表示含有子编号 ServletActionContext.getRequest().setAttribute("childs", childs); setFlag(1); } return "equipedit"; } //加载信息 public String equipManager() throws IOException { // System.out.println(getRows() + ":" + getPage() + ":" + getSidx() + ":" + getSord()); ServletContext servletContext = ServletActionContext.getServletContext(); CommonService commonService = DatabaseFactory.getCommonService(servletContext); EquipService equipService = DatabaseFactory.getEquipService(servletContext); int firstResult = (getPage()-1)*getRows(); int size = getRows(); //总数量 List<Object> lists = new ArrayList<Object>(); lists.add(0L); Long obj = (Long) commonService.executeSqlWithReport("select count(*) from Equip e where e.parentId=?", lists); int totalRecord = obj.intValue(); int totalPages = (totalRecord%size==0?totalRecord/size:(totalRecord/size)+1); List<SearchObject> params = new ArrayList<SearchObject>(); params.add(SearchUtil.add(false, "parentId", 0L)); //关联表查询 List<SearchRelation> relations = new ArrayList<SearchRelation>(); List<SearchObject> searchList = new ArrayList<SearchObject>(); relations.add(SearchUtil.addRelation("EquipCategory", "id", "ec", true, searchList, "Equip", "typeId")); Map<String, String> orderColumns = null; if(getSidx()!=null && !("").equals(getSidx().trim()) && getSord()!=null && !("").equals(getSord().trim())){ orderColumns = new HashMap<String, String>(); // System.out.println("typeName".equals(getOrderColumn())); if("typeName".equals(getSidx())){ orderColumns.put("ec.name", getSord()); }else{ orderColumns.put("e."+getSidx(), getSord()); } } List<Equip> equipList = new ArrayList<Equip>(); List<Object[]> objLists = equipService.findObjectsListByParamsWithOrderAndPage(params, relations, orderColumns, firstResult, size); for (Object[] objs:objLists) { Equip e = (Equip) objs[0]; EquipCategory ec = (EquipCategory) objs[1]; e.setTypeName(ec.getName()); equipList.add(e); } // this.test(totalRecord/10, 1, totalRecord, equipList); setMap(this.getJsonMap(totalPages, getPage(), totalRecord, equipList)); // setJsondata(JsonUtil.jqGrids(totalRecord/10, 1, totalRecord, equipList)); return "success"; } //添加器材 public String addEquipManager() { ServletContext servletContext = ServletActionContext.getServletContext(); CommonService commonService = DatabaseFactory.getCommonService(servletContext); try{ commonService.getTransactionManager().begin(); if(getEquip().getId()==null || getEquip().getId()==0L){ boolean status = ("1").equals(getEquipstatus())?true:false; status = true;//器材默认的状态是true getEquip().setStatus(status); getEquip().setParentId(0L); if(getChildno()!=null && getChildno().size()>0){ getEquip().setTotal(getChildno().size()); getEquip().setSurplus(getChildno().size()); } getEquip().setSurplus(getEquip().getTotal()); commonService.add(equip); if(getChildno()!=null && getChildno().size()>0){//存在子选项 for(int i=0;i<childno.size();i++){ String no = childno.get(i); String con = childcon.get(i); String remarks = childremarks.get(i); if(no!=null && !("").equals(no.trim())){ Equip e = new Equip(); e.setName(no); e.setNo(no); e.setTotal(1); e.setSurplus(1); e.setCon(Integer.parseInt(con)); e.setTypeId(getEquip().getTypeId()); e.setParentId(equip.getId());