课设服装连锁商店调货系统

package dao; import java.util.List; import javax.servlet.http.HttpServletRequest; import org.apache.struts2.ServletActionContext; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.Transaction; import pojo.Schedule; import pojo.User; import util.HibernateUtil; import pojo.Clothes; public class UserDao { public List<Clothes> findall(){ Session s = null; Query query=null; try{ s = HibernateUtil.getSession(); HttpServletRequest request; request=ServletActionContext.getRequest(); String shopname=(String)request.getSession().getAttribute("shop"); request=ServletActionContext.getRequest(); String queryString="from Clothes where shopname="+"'"+shopname+"'"; query=s.createQuery(queryString); List<Clothes> list=query.list(); return list; }finally{ HibernateUtil.closeSession(s); } } public boolean saveOrder(Schedule info){ Session s = null; Transaction tx = null; try{ s = HibernateUtil.getSession(); tx=s.beginTransaction(); s.save(info); tx.commit(); return true; }finally{ HibernateUtil.closeSession(s); } } public List<Schedule> findAppToMe(String value){ Session s = null; Query query=null; try{ s = HibernateUtil.getSession(); String queryString="from Schedule as model where model.outid=? ORDER BY state"; query=s.createQuery(queryString); query.setParameter(0, value); System.out.println(value); System.out.println("luelue"); List<Schedule> list=query.list(); return list; }finally{ HibernateUtil.closeSession(s); } } public List<Schedule> findAppOfMe(String value){ Session s = null; Query query=null; try{ s = HibernateUtil.getSession(); String queryString="from Schedule as model where model.inid=? ORDER BY state"; query=s.createQuery(queryString); query.setParameter(0, value); List<Schedule> list=query.list(); return list; }finally{ HibernateUtil.closeSession(s); } } public List<Clothes> findBarcode(String type,Object value){ Session s = null; Query query=null; HttpServletRequest request; request=ServletActionContext.getRequest(); String shopname=(String)request.getSession().getAttribute("shop"); try{ s = HibernateUtil.getSession(); String queryString="from Clothes as model where model."+type+"=? and shopname!=?"; query=s.createQuery(queryString); query.setParameter(0, value); query.setParameter(1, shopname); List<Clothes> list=query.list(); return list; }finally{ HibernateUtil.closeSession(s); } } public List<User> findInfo(String type,Object value){ Session s = null; Query query=null; try{ s = HibernateUtil.getSession(); String queryString="from User as model where model."+type+"=?"; query=s.createQuery(queryString); query.setParameter(0, value); List<User> list=query.list(); return list; }finally{ HibernateUtil.closeSession(s); } } public List<User> check(String id,String pw,Object idvalue,Object pwvalue){ Session s = null; Query query=null; try{ s = HibernateUtil.getSession(); String queryString="from User as model where model."+id+"=?"+" and model."+pw+"=?"; query=s.createQuery(queryString); query.setParameter(0, idvalue); query.setParameter(1, pwvalue); List<User> list=query.list(); return list; }finally{ HibernateUtil.closeSession(s); } } public boolean saveInfo(User info){ Session s = null; Transaction tx = null; try{ s = HibernateUtil.getSession(); tx=s.beginTransaction(); s.save(info); tx.commit(); return true; }finally{ HibernateUtil.closeSession(s); } } public boolean saveNewClothes(Clothes clothes){ Session s = null; Transaction tx = null; try{ s = HibernateUtil.getSession(); tx=s.beginTransaction(); s.saveOrUpdate(clothes); tx.commit(); return true; }finally{ HibernateUtil.closeSession(s); } } public boolean permit(String orderid){ Session s = null; Query query=null; try{ s = HibernateUtil.getSession(); s.beginTransaction(); String queryString="update Schedule as s set s.state=1 where dhid=?"; query=s.createQuery(queryString); query.setParameter(0, orderid); query.executeUpdate(); s.getTransaction().commit(); return true; }finally{ HibernateUtil.closeSession(s); } } public boolean refuse(String orderid){ Session s = null; Query query=null; try{ s = HibernateUtil.getSession(); s.beginTransaction(); String queryString="update Schedule as s set s.state=3 where dhid=?"; query=s.createQuery(queryString); query.setParameter(0, orderid); query.executeUpdate(); s.getTransaction().commit(); return true; }finally{ HibernateUtil.closeSession(s); } } public boolean gotit(String orderid){ Session s = null; Query query=null; try{ s = HibernateUtil.getSession(); s.beginTransaction(); String queryString,queryString1,queryString2,queryString3,queryString4; queryString="update Schedule as s set s.state=2 where dhid=?"; query=s.createQuery(queryString); query.setParameter(0, orderid); query.executeUpdate(); //找出订单号，保存进、出货店铺，数量，条形码 queryString1="from Schedule as s where dhid=?"; query=s.createQuery(queryString1); query.setParameter(0, orderid); List<Schedule> list=query.list(); String inid=list.get(0).getInid(); String outid=list.get(0).getOutid(); Integer num=list.get(0).getNum(); String barcode=list.get(0).getBarcode(); //更新出货的商铺 queryString2="update Clothes as c set c.stock=c.stock-? where c.shopname=? and c.barcode=?"; query=s.createQuery(queryString2); query.setParameter(0, num); query.setParameter(1, outid); query.setParameter(2, barcode); query.executeUpdate(); //判断是否存在 queryString4="from Clothes as c where c.shopname=? and c.barcode=?"; query=s.createQuery(queryString4); query.setParameter(0, inid); query.setParameter(1, barcode); List<Clothes> list5=query.list(); Integer i=0; if(!list5.isEmpty()) i=list5.get(0).getStock(); //保存一个Clothes对象 queryString4="from Clothes as c where c.shopname=? and c.barcode=?"; query=s.createQuery(queryString4); query.setParameter(0, outid); query.setParam