package com.bookstore.product.dao.hibernate;
import java.util.ArrayList;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import com.bookstore.customer.model.Customer;
import com.bookstore.product.dao.productDao;
import com.bookstore.product.model.Book;
import com.bookstore.product.model.BookType;
import com.bookstore.product.model.Collection;
import com.bookstore.product.model.Comment;
import com.bookstore.shoppingcart.model.ShoppingCart;
import com.bookstore.shoppingcart.model.ShoppingCartInfo;
public class productDaoImpl implements productDao{
private SessionFactory sessionFactory;
public SessionFactory getSessionFactory() {
return sessionFactory;
}
public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}
//获取所有书籍的类型。
public List<BookType> findBookType(){
Session session=sessionFactory.openSession();
try{
String queryString="from BookType";
Query query=session.createQuery(queryString);
List<BookType> list=query.list();
if(list.size()>0)
return list;
else{
return null;
}
}catch(Exception e){
e.printStackTrace();
return null;
}finally{
session.close();
}
}
//根据id获取书籍信息。
public Book findonebookbyID(int id){
Session session=null;
try{
session=sessionFactory.openSession();
String queryString="from Book where id=?";
Query query=session.createQuery(queryString);
query.setParameter(0, id);
List<Book> list=query.list();
Book book=new Book();
if(list.size()>0){
book=(Book)list.get(0);
return book;}
else{
return null;
}
}catch (Exception e) {
e.printStackTrace();
return null;
}finally{//关闭session
session.close();
}
}
public int getmaxbookid(){
Session session=null;
int sum=0;
try{
session=sessionFactory.openSession();
String queryString="select max(id) from Book";
Query query=session.createQuery(queryString);
sum=Integer.parseInt(query.list().get(0).toString());
return sum;
}catch (Exception e) {
e.printStackTrace();
return sum;
}finally{//关闭session
session.close();
}
}
public Book queryBookById(int id){
Session session=null;
try{
session=sessionFactory.openSession();
//根据id获取要修改的用户数据
Book book=(Book)session.get(Book.class, id);
return book ;
}catch (Exception e) {
e.printStackTrace();
return null;
}finally{//关闭session
session.close();
}
}
public List<Book> shownewbook(){
Session session=null;
try{
session=sessionFactory.openSession();
String queryString="from Book order by id desc";
Query query=session.createQuery(queryString);
query.setFirstResult(0);
query.setMaxResults(6);
List<Book> newbook=query.list();
if(newbook.size()>0)
return newbook;
else{
return null;
}
}catch (Exception e) {
e.printStackTrace();
return null;
}finally{//关闭session
session.close();
}
}
public List<Book> showhotbook(){
Session session=null;
try{
session=sessionFactory.openSession();
String queryString="from Book order by bookdealmount desc";
Query query=session.createQuery(queryString);
query.setFirstResult(0);
query.setMaxResults(6);
List<Book> hotbook=query.list();
if(hotbook.size()>0)
return hotbook;
else{
return null;
}
}catch (Exception e) {
e.printStackTrace();
return null;
}finally{//关闭session
session.close();
}
}
//按照书籍类型的ID和状态获取该ID所有书籍的状态。
public List<Book> showbookbyTypeId(int now_page,int maxnum,int Page_booktype_num,int Page_booktype_id,int Page_bookstatus){
System.out.println("showbookbyTypeId");
Session session=null;
try{
session=sessionFactory.openSession();
String queryString="";
List<Book> newbook=new ArrayList();
if(Page_booktype_num==0){
queryString=queryString+"from Book ";
if(Page_bookstatus==1){
queryString=queryString+"order by bookdealmount desc";
}else if(Page_bookstatus==2){
queryString=queryString+"order by booklookmount desc";
}else if(Page_bookstatus==3){
queryString=queryString+"order by id desc";
}
Query query=session.createQuery(queryString);
query.setFirstResult(0);
query.setMaxResults(maxnum);
newbook=query.list();
}else{
queryString=queryString+"from Book where typeid=? ";
if(Page_bookstatus==1){
queryString=queryString+"order by bookdealmount desc";
}else if(Page_bookstatus==2){
queryString=queryString+"order by booklookmount desc";
}else if(Page_bookstatus==3){
queryString=queryString+"order by id desc";
}
Query query=session.createQuery(queryString);
query.setParameter(0, Page_booktype_id);
query.setFirstResult(0);
query.setMaxResults(maxnum);
newbook=query.list();
}
System.out.println(Page_booktype_id+"!!"+Page_bookstatus+queryString);
if(newbook.size()>0)
return newbook;
else{
return null;
}
}catch (Exception e) {
e.printStackTrace();
return null;
}finally{//关闭session
session.close();
}
}
//按照书籍类型的ID获取该ID所有书籍。
public List<Book> showAllbookbyTypeId(int now_page,int maxnum,int Page_booktype_num,int Page_booktype_id){
System.out.println("showAllbookbyTypeId");
Session session=null;
List<Book> allbook=new ArrayList();
try{
session=sessionFactory.openSession();
String queryString="";
if(Page_booktype_num==0){//0代表所有类型的书籍。
queryString=queryString+"from Book";
Query query=session.createQuery(queryString);
query.setFirstResult((now_page-1)*maxnum);
query.setMaxResults(maxnum);
allbook=query.list();
}else{
queryString=queryString+"from Book where typeid=?";
Query query=session.createQuery(queryString);
query.setParameter(0, Page_booktype_id);
query.setFirstResult((now_page-1)*maxnum);
query.setMaxResults(maxnum);
allbook=query.list();
}
System.out.println("allbook.size():"+allbook.size());
if(allbook.size()>0)
return allbook;
else{
return null;
}
}catch (Exception e) {
e.printStackTrace();
return null;
}finally{//关闭session
session.close();
}
}
public int showbookbyTypeId_num(int Page_booktype_num,int Page_booktype_id,int Page_bookstatus){
System.out.println("showbookbyTypeId_num");
Session session=null;
try{
session=sessionFactory.openSession();
String queryString="";
int totalnum;
if(Page_booktype_num==0){
queryString=queryString+"select count(*) from Book ";
Query query=session.createQuery(queryString);
System.out.println("showbookbyTypeId_num!!!!!");
totalnum=Integer.parseInt(query.list().get(0).toString());
}else{
queryString=queryString+"select count(*) from Book where typeid=? ";
Query query=session.createQuery(queryString);
query.setParameter(0, Page_booktype_id);
System.out.println("showbookbyTypeId_num!!!!!");
totalnum=Integer.parseInt(query.list().get(0).toString());
}
System.out.println("showbookbyTypeId_num"+totalnum);
return totalnum;
}catch (Exception e) {
e.printStackTrace();
return 0;
}finally{//关闭session
session.close();
}
}
public int showAllbookbyTypeId_num(int Page_booktype_num,int Page_booktype_id){
System.out.println("showAllbookbyTypeId_num");
Session session=null;
int totalnum;
try{
session=sessionFactory.openSession();
String queryString="";
if(Page_booktype_num==0){//0代表所有类型的书籍。
queryString=queryString+"select count(*) from Book";
Query query=session.createQuery(queryString);
System.out.println("showbookbyTypeId_num!!!!!");
totalnum=Integer.parseInt(query.list().get(0).toString());
}else{
queryString=queryString+"select count(*) from Book where typeid=?";
Query query=session.createQuery(queryString);
query.setParameter(0, Page_booktype_id);
毕设&课设&项目&实训-大三课程实践作业.zip
版权申诉
124 浏览量
2024-02-03
14:37:08
上传
评论
收藏 40.24MB ZIP 举报
毕设&课设&项目&实训-大三课程实践作业.zip （732个子文件） 
productDaoImpl.class 18KB AddOrderAction.class 11KB showonebookAction.class 10KB ShoppingCartDao.class 10KB ShowOrderAction.class 10KB OrderDao.class 9KB ManagerDaoImpl.class 8KB BookDaoImpl.class 8KB ManagerAction.class 8KB CustomerDao.class 7KB BuildOrderAtion.class 6KB ShowShoppingCartAction.class 6KB showresultbookAction.class 6KB DownShoppingCartAction.class 6KB GetCustomerConsigneeDetailBycaccountAction.class 6KB UpdateShoppingCartAction.class 6KB ManagerOrderAction.class 6KB ChangeOrderAction.class 5KB productServiceImpl.class 5KB ManagerServiceImpl.class 5KB addBookAction.class 5KB changeBookAction.class 5KB ConsigneeDao.class 5KB CustomerDaoImpl.class 5KB DeleteShoppingCartAction.class 5KB ShowOrderdetailsAction.class 5KB GetCode.class 5KB GetMessageAction.class 5KB ManagerMessageAction.class 4KB showbookAction.class 4KB Order.class 4KB mainpageAction.class 4KB queryBookAction.class 3KB ChangepasswordByMtself_m3.class 3KB ManagerLoginAction.class 3KB RegisterAction.class 3KB LoginAction.class 3KB AddMessageAction.class 3KB Book.class 3KB queryBookTypeAction.class 3KB queryCustomerAction.class 3KB UpdateConsigneeAction.class 3KB AddConsigneeAction.class 3KB QueryConsigneeDetailAction.class 3KB DelAllShoppingCartAction.class 3KB QueryCustomerBycaccountAction.class 3KB ReturnOrderAction.class 3KB topAction.class 3KB SecurityImage.class 3KB ChangepassowrdAction.class 3KB queryCustomerByIDAction.class 2KB Customer.class 2KB AfterLogin.class 2KB ManageLoginCheck.class 2KB SecurityCode.class 2KB GetCustomerDetailBycaccountAction.class 2KB productService.class 2KB productDao.class 2KB queryBookByIDAction.class 2KB ChangeCustomerDetailAction.class 2KB changeCustomerINFAction.class 2KB ShoppingCartInfo.class 2KB Consignee.class 2KB CheckCustomercaccountByphone_numAction.class 2KB Manager.class 2KB addBookTypeAction.class 2KB BeforeLogin.class 2KB QueryMessageDetailAction.class 2KB Orderdetail.class 2KB SecurityCodeImageAction.class 2KB Comment.class 2KB SecurityCodeAction.class 1KB Message.class 1KB DeleteConsigneeAction.class 1KB SecurityCode$SecurityCodeLevel.class 1KB LoginInterceptor.class 1KB deleteBookAction.class 1KB ManagerService.class 1KB ShoppingCart.class 1KB Collection.class 1002B ExtiAction.class 926B ManagerDao.class 925B CustomerDaoInterface.class 905B BookDao.class 887B BookType.class 748B ConsigneeDaoInterface.class 712B CustomerDao.class 584B .classpath 1KB org.eclipse.wst.common.component 478B org.eclipse.wst.jsdt.ui.superType.container 49B jquery.mCustomScrollbar.css 52KB ueditor.css 43KB ueditor.min.css 34KB image.css 18KB style2.css 15KB style.css 15KB video.css 15KB attachment.css 14KB scrawl.css 4KB showonebook.css 4KB共 732 条
- 1
- 2
- 3
- 4
- 5
- 6
- 8
资源评论
