SSH2+mysql写的物资管理系统

package com.tianyuan.CWMM.action; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import org.hibernate.Session; import com.opensymphony.xwork2.ActionContext; import com.opensymphony.xwork2.ActionSupport; import com.tianyuan.CWMM.model.Material; import com.tianyuan.CWMM.model.MaterialCategory; import com.tianyuan.CWMM.service.MaterialOperation; import com.tianyuan.CWMM.service.impl.MaerialOperationImpl; import com.tianyuan.CWMM.util.HibernateSessionFactory; import com.tianyuan.CWMM.vo.MaterialVO; public class MaterialAction extends ActionSupport { private int id, price, quantity, category_id, flag; private String name, categoryName; List<MaterialVO> materialList = null; List<MaterialCategory> materialCategoryList = null; public int getFlag() { return flag; } public void setFlag(int flag) { this.flag = flag; } public String getCategoryName() { return categoryName; } public void setCategoryName(String categoryName) { this.categoryName = categoryName; } public List<MaterialCategory> getMaterialCategoryList() { return materialCategoryList; } public void setMaterialCategoryList( List<MaterialCategory> materialCategoryList) { this.materialCategoryList = materialCategoryList; } public int getId() { return id; } public void setId(int id) { this.id = id; } public int getPrice() { return price; } public void setPrice(int price) { this.price = price; } public int getQuantity() { return quantity; } public void setQuantity(int quantity) { this.quantity = quantity; } public String getName() { return name; } public void setName(String name) { this.name = name; } public int getCategory_id() { return category_id; } public void setCategory_id(int category_id) { this.category_id = category_id; } public List<MaterialVO> getMaterialList() { return materialList; } public void setMaterialList(List<MaterialVO> materialList) { this.materialList = materialList; } public String queryMaterial() throws Exception { String materialCategory = null; materialList = new ArrayList<MaterialVO>(); //MaterialVO tempMaterialVO = new MaterialVO(); Session session = new HibernateSessionFactory().getSessionFactory() .openSession(); session.beginTransaction(); List<Material> tempList = session.createQuery("from Material").list(); for(Iterator<Material> tempIterator = tempList.iterator() ; tempIterator.hasNext() ; ) { MaterialVO tempMaterialVO = new MaterialVO(); Material tempMaterial = tempIterator.next(); int materialId = tempMaterial.getId(); int id = (int) session .createQuery( "select category_id from Material m where m.id= :id") .setInteger("id", materialId).list().get(0); materialCategory = (String) session .createQuery( "select categoryName from MaterialCategory mc where mc.id= :id") .setInteger("id", id).list().get(0); tempMaterialVO.setId(materialId); tempMaterialVO.setCategory(materialCategory); tempMaterialVO.setName(tempMaterial.getName()); tempMaterialVO.setPrice(tempMaterial.getPrice()); tempMaterialVO.setQuantity(tempMaterial.getQuantity()); tempMaterialVO.setCategoryId(id); materialList.add(tempMaterialVO); } queryMaterialCategory(); return "queryMaterial"; } public String updateMaterialInfo() { Material m = new Material(); MaterialOperation materialOperation = new MaerialOperationImpl(); m.setCategory_id(category_id); m.setId(id); m.setName(name); m.setPrice(price); m.setQuantity(quantity); materialOperation.updateMaterialInfo(m); return "updateMaterialInfo"; } public String queryMaterialCategory() { Session session = new HibernateSessionFactory().getSessionFactory() .openSession(); session.beginTransaction(); materialCategoryList = session.createQuery("from MaterialCategory") .list(); session.getTransaction().commit(); session.close(); if(flag == 1) { return "queryMaterialCategory1"; } return "queryMaterialCategory2"; } public String deleteMaterial() { Session session = new HibernateSessionFactory().getSessionFactory() .openSession(); session.beginTransaction(); session.delete(session.load(Material.class, id)); session.getTransaction().commit(); session.close(); return "deleteMaterial"; } public String addMaterial() { Material m = new Material(); MaterialOperation materialOperation = new MaerialOperationImpl(); m.setCategory_id(category_id); m.setId(id); m.setName(name); m.setPrice(price); m.setQuantity(quantity); materialOperation.addMaterial(m); return "addMaterial"; } public String updateMaterialCategory() { MaterialCategory materialCategory = new MaterialCategory(); materialCategory.setId(id); materialCategory.setCategoryName(categoryName); Session session = new HibernateSessionFactory().getSessionFactory() .openSession(); session.beginTransaction(); session.update(materialCategory); session.getTransaction().commit(); session.close(); return "updateMaterialCategory"; } public String addMaterialCategory() { MaterialCategory materialCategory = new MaterialCategory(); materialCategory.setCategoryName(categoryName); Session session = new HibernateSessionFactory().getSessionFactory() .openSession(); session.beginTransaction(); session.save(materialCategory); session.getTransaction().commit(); session.close(); return "addMaterialCategory"; } public String deleteMaterialCategory() { Session session = new HibernateSessionFactory().getSessionFactory() .openSession(); session.beginTransaction(); session.delete(session.load(MaterialCategory.class, id)); session.getTransaction().commit(); session.close(); return "deleteMaterialCategory"; } }