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
没有合适的资源?快使用搜索试试~ 我知道了~
课设服装连锁商店调货系统
共94个文件
jar:22个
class:20个
java:20个
需积分: 0 3 下载量 44 浏览量
2018-06-15
21:18:02
上传
评论
收藏 10.73MB ZIP 举报
温馨提示
这是大学期间的JavaWeb课程设计,服装连锁店调货系统,界面很简单,后台主要用到Struts2+Hibernate。
资源推荐
资源详情
资源评论
收起资源包目录
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
共 94 条
- 1
资源评论
哦吼吼吼吼吼吼吼
- 粉丝: 9
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功