package cn.joker.store.daoImpl;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.query.Query;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate5.HibernateCallback;
import org.springframework.orm.hibernate5.HibernateTemplate;
import org.springframework.stereotype.Repository;
import cn.joker.entity.Food;
import cn.joker.entity.FoodInfo;
import cn.joker.entity.FoodPictures;
import cn.joker.entity.Store;
import cn.joker.entity.StoreInfo;
import cn.joker.entity.StorePictures;
import cn.joker.store.dao.DataDisplayDao;
@Repository("dataDisplayDaoImpl")
public class DataDisplayDaoImpl implements DataDisplayDao {
@Autowired
private HibernateTemplate hibernateTemplate;
@Override
public List<FoodPictures> getFoodDisplayInfo(String pageNum,String sortRule,String pageCount) {
return getFoodDisplayInfo(pageNum, Integer.parseInt(pageCount), sortRule);
}
@Override
public List<StorePictures> getStoreDisplayInfo(String pageNum, String sortRule,String pageCount) {
return getStoreDisplayInfo(pageNum, Integer.parseInt(pageCount), sortRule);
}
@Override
public List<Food> searchFood(String name) {
return hibernateTemplate.execute(new HibernateCallback<List<Food>>() {
@Override
public List<Food> doInHibernate(Session session) throws HibernateException {
@SuppressWarnings("unchecked")
Query<Food> query = session.createQuery("from Food f where f.name like :name and f.isDel = :isDel");
query.setParameter("name", "%"+name+"%");
query.setParameter("isDel", 0);
return query.getResultList();
}
});
}
@Override
public List<Store> searchStore(String name) {
return hibernateTemplate.execute(new HibernateCallback<List<Store>>() {
@Override
public List<Store> doInHibernate(Session session) throws HibernateException {
@SuppressWarnings("unchecked")
Query<Store> query = session.createQuery("from Store s where s.name like :name and s.isDel = :isDel");
query.setParameter("name", "%"+name+"%");
query.setParameter("isDel", 0);
return query.getResultList();
}
});
}
private List<FoodPictures> getFoodDisplayInfo(String pageNum,int pageCount,String sortRule) {
List<FoodInfo> foodInfoList = hibernateTemplate.execute(new HibernateCallback<List<FoodInfo>>() {
@Override
public List<FoodInfo> doInHibernate(Session session) throws HibernateException {
@SuppressWarnings("unchecked")
Query<FoodInfo> query = session.createQuery("from FoodInfo fi order by fi."+sortRule.split("/")[0]+" "+sortRule.split("/")[1]);
int page = Integer.parseInt(pageNum);
if(page<0)
page=0;
query.setFirstResult(page*9);
query.setMaxResults(pageCount);
return query.getResultList();
}
});
List<FoodPictures> lists = new ArrayList<>();
Iterator<FoodInfo> iterator = foodInfoList.iterator();
FoodInfo foodInfo = null;
while(iterator.hasNext()) {
foodInfo = iterator.next();
String f_id = foodInfo.getFood().getId();
lists.add(hibernateTemplate.execute(new HibernateCallback<FoodPictures>() {
@Override
public FoodPictures doInHibernate(Session session) throws HibernateException {
@SuppressWarnings("unchecked")
Query<FoodPictures> query = session.createQuery("from FoodPictures fp where fp.food.id = ?0 and fp.isDel = ?1");
query.setParameter(0, f_id);
query.setParameter(1, 0);
return query.getResultList().isEmpty()?null:query.getResultList().get(0);
}
})
);
}
return lists;
}
// 首页展示，需传入页数，每页最大显示数，排序规则
private List<StorePictures> getStoreDisplayInfo(String pageNum, int pageCount,String sortRule) {
List<StoreInfo> storeInfoList = hibernateTemplate.execute(new HibernateCallback<List<StoreInfo>>() {
@Override
public List<StoreInfo> doInHibernate(Session session) throws HibernateException {
@SuppressWarnings("unchecked")
Query<StoreInfo> query = session.createQuery("from StoreInfo si order by si."+sortRule.split("/")[0]+" "+sortRule.split("/")[1]);
int page = Integer.parseInt(pageNum);
if(page<0)
page=0;
query.setFirstResult(page*9);
query.setMaxResults(pageCount);
return query.getResultList();
}
});
List<StorePictures> lists = new ArrayList<>();
Iterator<StoreInfo> iterator = storeInfoList.iterator();
StoreInfo storeInfo = null;
while(iterator.hasNext()) {
storeInfo = iterator.next();
int s_id = storeInfo.getStore().getId();
lists.add(hibernateTemplate.execute(new HibernateCallback<StorePictures>() {
@Override
public StorePictures doInHibernate(Session session) throws HibernateException {
@SuppressWarnings("unchecked")
Query<StorePictures> query = session.createQuery("from StorePictures sp where sp.store.id = ?0 and sp.isDel = ?1");
query.setParameter(0, s_id);
query.setParameter(1, 0);
return query.getResultList().isEmpty()?null:query.getResultList().get(0);
}
})
);
}
return lists;
}
}
美食网站-2018年毕业设计.zip （268个子文件） 
FoodController.class 5KB AccountManageController.class 5KB EvaluateDaoImpl.class 5KB DataDisplayDaoImpl.class 4KB ChatDaoImpl.class 4KB CoverController.class 4KB AccountDaoImpl.class 4KB MessagePushController.class 4KB CollectionController.class 3KB FoodDaoImpl.class 3KB CollectDaoImpl.class 3KB UserManageController.class 3KB MessagePushDaoImpl.class 3KB OrderUtils.class 3KB EvaluateController.class 3KB ChatController.class 3KB DataController.class 3KB DataDisplayController.class 3KB StoreAdminWebSocketHandler.class 3KB UserWebSocketHandler.class 3KB StoreInfo.class 3KB DataDaoImpl.class 3KB WebSocketConfig.class 3KB GetStoreScore.class 2KB UserAccountDaoImpl.class 2KB GetFoodScore.class 2KB StoreAdminHandshakeInterceptor.class 2KB DataDisplayDaoImpl$5.class 2KB UserHandshakeInterceptor.class 2KB DataDisplayDaoImpl$3.class 2KB USChat.class 2KB SUChat.class 2KB EvaluateDaoImpl$1.class 2KB EvaluateDaoImpl$2.class 2KB UUChat.class 2KB Food.class 2KB Recommended.class 2KB ChatService.class 2KB FoodInfo.class 2KB DataDisplayDaoImpl$2.class 2KB DataDisplayDaoImpl$1.class 2KB Order.class 2KB FoodService.class 2KB AccountDaoImpl$1.class 2KB DataDisplayDaoImpl$4.class 2KB DataService.class 2KB EvaluateService.class 2KB DataDisplayDaoImpl$6.class 2KB Store.class 2KB StoreAdmin.class 2KB AccountManageService.class 2KB DataDisplayService.class 2KB UserEvaluateDaoImpl.class 2KB User.class 2KB CollectService.class 2KB LikeFood.class 2KB StorePictures.class 2KB UserEvaluateController.class 2KB FoodPictures.class 2KB MessageService.class 2KB CoverDaoImpl$1.class 2KB ChatDaoImpl$3.class 2KB ChatDaoImpl$1.class 2KB ChatDaoImpl$2.class 2KB FoodDaoImpl$2.class 2KB StoreCollect.class 2KB FoodCollect.class 2KB FoodDaoImpl$1.class 2KB Category.class 2KB CoverDaoImpl.class 2KB UserManageService.class 1KB UserEvaluateService.class 1KB EmailConfig.class 1KB CoverService.class 1KB Restaurant.class 1KB DataDisplayDao.class 730B ChatDao.class 726B EvaluateDao.class 639B DataDao.class 627B MessagePushDao.class 596B CollectDao.class 577B FoodDao.class 566B AccountDao.class 533B UserEvaluateDao.class 396B JdbcTest.class 395B UserAccountDao.class 315B CoverDao.class 237B .classpath 4KB org.eclipse.wst.common.component 465B org.eclipse.wst.jsdt.ui.superType.container 49B bootstrap.css 143KB bootstrap.min.css 118KB bootstrap-theme.css 26KB bootstrap-theme.min.css 23KB style_userManage.css 10KB zzsc-demo.css 6KB food.css 1KB reset.css 1KB header.css 333B glyphicons-halflings-regular.eot 20KB共 268 条
- 1
- 2
- 3
资源评论
