java 毕业项目源码

package com.computerbookshop.dao.book; import java.sql.SQLException; import java.util.List; import org.hibernate.HibernateException; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.criterion.DetachedCriteria; import org.springframework.orm.ObjectRetrievalFailureException; import org.springframework.orm.hibernate3.HibernateCallback; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import com.computerbookshop.common.Common; import com.computerbookshop.entity.BookType; import com.computerbookshop.entity.Books; import com.computerbookshop.entity.HotspotSearch; import com.computerbookshop.entity.Publish; public class BookDaoImpl extends HibernateDaoSupport implements BookDao{ //书籍分页 public List<Books> selectPageBook(final String hql,final int size, final int firstNum) { List<Books> books=this.getHibernateTemplate().executeFind(new HibernateCallback(){ public Object doInHibernate(Session session) throws HibernateException, SQLException { Query query =session.createQuery(hql); query.setMaxResults(size); query.setFirstResult(firstNum); return query.list(); }}); return books; } /** * 根据查询条件获取书籍数量 * @param hqlCount 带聚合函数count 的hql语句 * @return */ public int getTotalNum(final String hqlCount){ return Integer.parseInt(this.getHibernateTemplate().find(hqlCount).get(0).toString()); } /** * 书籍分页方法 * @param size 每页条数 * @param page 第几页 * @return firstResult 的Number */ public int selectBookForpage(int page,int size){ return (page-1)* size; } public List<Books> SelectAllBooks(int page, int size) { DetachedCriteria hql = null; hql = DetachedCriteria.forClass(Books.class); //System.out.println("in bookdaoImpl method"); List<Books> books=this.getHibernateTemplate().findByCriteria(hql, page, size); // if(books.size()>0) // System.out.println("books.size()"+books.size()); return books; } public List<Books> selectBookByName(String name,int page){ List<Books> books =null; // books=this.getHibernateTemplate().find(hql); System.out.println("in bookdaoImpl booksearch"+books.size()); return books; } public List<HotspotSearch> selectHotspotSearch(final String hql) { List<HotspotSearch> hotspotSearchs=this.getHibernateTemplate().executeFind(new HibernateCallback(){ public Object doInHibernate(Session session) throws HibernateException, SQLException { Query query =session.createQuery(hql); query.setMaxResults(5); return query.list(); }}); return hotspotSearchs; } public List<Books> selectBookByCondition(final String hql,final int selectNum) { List<Books> books=this.getHibernateTemplate().executeFind(new HibernateCallback(){ public Object doInHibernate(Session session) throws HibernateException, SQLException { Query query=session.createQuery(hql); //query.setFirstResult(0); query.setMaxResults(selectNum); return query.list(); }}); return Common.interceptBooksDesc(books); } // heyuanbo///heyuanbo///heyuanbo///heyuanbo///heyuanbo///heyuanbo///////////////////////////// List<Books> books; // 得到选择的页的书籍 public List<Books> selectBooksPerPage(final String hql, final int idIndex, final int length){ books = this.getHibernateTemplate().executeFind(new HibernateCallback(){ public Object doInHibernate(Session session) throws HibernateException, SQLException { Query query = session.createQuery(hql); query.setFirstResult(idIndex); query.setMaxResults(length); List list = query.list(); return list; }}); return books; } // 根据查询条件得到books表记录条数 public long getCounts(String condition, String bookTypeName, String publishName){ String hqlByType = getHQL(condition, bookTypeName, publishName); String hqlCount = "select count(*) " + hqlByType; long count = (Long)this.getHibernateTemplate().find(hqlCount).get(0); return count; } // 根据查询条件获得页数 public int getAllPagesCount(String condition, String bookTypeName, String publishName){ long count = getCounts(condition, bookTypeName, publishName); int totalPageCount = (int)Math.ceil(count/15.0); return totalPageCount; } // 查看特定图书详细信息 public Books getBook(int bookId){ Books book = (Books)this.getHibernateTemplate().get(Books.class, new Integer(bookId)); if (book == null){ throw new ObjectRetrievalFailureException(Books.class, new Integer(bookId)); } System.out.println("查看特定图书详细信息-书名: " + book.getBookName()); // 测试语句 return book; } // 得到页码（第几页） public int getPageNum(int pageNum, String condition, String bookTypeName, String publishName){ int totalPageCount = getAllPagesCount(condition, bookTypeName, publishName); if (pageNum > totalPageCount){ pageNum = totalPageCount; } if (pageNum < 1){ pageNum = 1; } return pageNum; } // 得到查询第一条记录的起始位置 public int getIdIndex(int pageNum, String condition, String bookTypeName, String publishName){ int idIndex = 15 * (getPageNum(pageNum, condition, bookTypeName, publishName) - 1); return idIndex; } // 根据查询条件得到排序的查询语句 public String getHQLByOrder( int type, String condition, String bookTypeName, String publishName){ String hqlOrder = getHQL(condition, bookTypeName, publishName); switch(type){ case 1: hqlOrder += " order by bookClicks desc"; // 按点击率降序 break; case 2: hqlOrder += " order by bookName"; // 按字母升序 break; case 3: hqlOrder += " order by bookName desc"; // 按字母降序 break; case 4: hqlOrder += " order by bookPrice"; // 按价格升序 break; case 5: hqlOrder += " order by bookPrice desc"; // 按价格降序 break; case 6: hqlOrder += " order by publishTime"; // 按出版时间升序 break; case 7: hqlOrder += " order by publishTime desc"; // 按出版时间降序 break; case 8: hqlOrder += " order by bookAddTime"; // 按上架时间升序 break; case 9: hqlOrder += " order by bookAddTime desc"; // 按上架时间降序 break; default: hqlOrder += " order by bookClicks desc"; // 按点击率降序 break; } return hqlOrder; } // heyuanbo///heyuanbo///heyuanbo///heyuanbo///heyuanbo///heyuanbo///////////////////////////// //&&&&&图书后台管理&&&&&&&图书后台管理&&&&&&图书后台管理&&&&&&&&&&&图书后台管理&&&&&&&图书后台管理&&&&// // 查询所有的图书类别 public List<BookType> selectBookTypes(){ String hql = "from BookType order by typeName"; List<BookType> bookTypes = this.getHibernateTemplate().find(hql); return bookTypes; } // 查询所有的出版社 public List<Publish> selectPublishes(){ String hql = "from Publish order by publishName"; List<Publish> publishes = this.getHibernateTemplate().find(hql); return publishes; } // 图书入库 public boolean addBook(Books book){ try{ this.getHibernateTemplate().save(book); }catch(Exception ex){ return false; } return true; } // 添加图书类别 public boolean addBookType(BookType bookType){ try{ this.getHibernateTemplate().save(bookType); }catch(Exception ex){ return false; } return true; } // 添加出版社 public boolean addPublish(Publish publish){ try{ this.getHibernateTemplate().save(publish); }catch(Exception ex){ return false; } return true; } // 修改图书信息 public boolean updateBookInfo(Books book) { try{ this.getHibernateTemplate().update(book); }catch(Exception ex){ return false; } return true; } // 根据查询条件得到不同的hql语句 public String getHQL(String condition, String bookTypeName, String publishName) { String hql = ""; if (condition.equals(" ") && bookTypeName.equals(" ")