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
课设服装连锁商店调货系统
需积分: 0 44 浏览量
2018-06-15
21:18:02
上传
评论
收藏 10.73MB ZIP 举报
ClothesSchedule.zip （94个子文件） 
student.sql 5KB
.settings org.eclipse.wst.jsdt.ui.superType.name 6B org.eclipse.wst.common.project.facet.core.xml 414B org.eclipse.wst.common.component 504B org.eclipse.wst.jsdt.ui.superType.container 49B .jsdtscope 522B org.eclipse.jdt.core.prefs 364B src dao UserDao.java 8KB ClothDao.java 2KB action Gotit.java 735B Permit.java 742B FindAll.java 688B ApplyInfo.java 1014B FindBs.java 953B FindBarcode.java 895B CheckUser.java 1KB Refuse.java 738B UpdateClothAction.java 619B DeleteClothAction.java 1015B Apply.java 1KB AddClothAction.java 1KB pojo User.hbm.xml 603B User.java 379B Clothes.hbm.xml 2KB Schedule.hbm.xml 1KB Clothes.java 2KB Schedule.java 886B struts.xml 4KB in PrivilegeInterceptor.java 985B filters LoginFilter.java 1KB hibernate.cfg.xml 2KB util HibernateUtil.java 813B .project 1KB WebRoot META-INF MANIFEST.MF 39B WEB-INF web.xml 2KB classes dao UserDao.class 8KB ClothDao.class 3KB action Permit.class 1KB Apply.class 2KB AddClothAction.class 2KB FindBs.class 2KB Gotit.class 1KB ApplyInfo.class 2KB CheckUser.class 2KB DeleteClothAction.class 2KB Refuse.class 1KB FindAll.class 1KB FindBarcode.class 2KB UpdateClothAction.class 1KB pojo User.hbm.xml 603B User.class 685B Clothes.hbm.xml 2KB Schedule.class 1KB Schedule.hbm.xml 1KB Clothes.class 3KB struts.xml 4KB in PrivilegeInterceptor.class 1KB filters LoginFilter.class 2KB hibernate.cfg.xml 2KB util HibernateUtil.class 1KB lib 
commons-fileupload-1.3.2.jar 69KB dom4j-1.6.1.jar 307KB javassist-3.11.0.GA.jar 600KB antlr-2.7.7.jar 435KB asm-tree-3.3.jar 21KB mysql-connector-java-5.1.39-bin.jar 966KB standard.jar 384KB xwork-core-2.3.30.jar 663KB asm-3.3.jar 43KB jboss-logging-3.1.0.GA.jar 59KB struts2-core-2.3.30.jar 853KB jstl.jar 20KB javassist-3.18.1-GA.jar 697KB freemarker-2.3.22.jar 1.24MB hibernate-commons-annotations-4.0.2.Final.jar 80KB hibernate-core-4.2.21.Final.jar 4.48MB ognl-3.0.19.jar 225KB hibernate-jpa-2.0-api-1.0.1.Final.jar 100KB asm-commons-3.3.jar 37KB commons-io-2.2.jar 170KB commons-lang3-3.2.jar 376KB jboss-transaction-api_1.1_spec-1.0.1.Final.jar 25KB student queryresult.jsp 2KB deleteCloth.jsp 1KB updateCloth.jsp 1KB updateClothz.jsp 5KB login.jsp 994B error.jsp 637B findall.jsp 2KB head.jsp 2KB applyInfo.jsp 3KB in.jsp 981B addCloth.jsp 2KB .classpath 1KB资源评论
