package?com.zking.wj.dao;

import?java.sql.SQLException;
import?java.util.List;
import?java.util.Map;

import?com.mysql.jdbc.StringUtils;
import?com.zking.wj.entity.Book;
import?com.zking.wj.util.baseEntityDao;
import?com.zking.wj.util.PageBean;

public?class?BookDao?extends?baseEntityDao{

	/**
	?*?下架處理
	?*?@param?book
	?*?@return
	?*?@throws?IllegalArgumentException
	?*?@throws?IllegalAccessException
	?*?@throws?NoSuchFieldException
	?*?@throws?SecurityException
	?*?@throws?SQLException
	?*/
	public?int?xj（Book?book）?throws?IllegalArgumentException?IllegalAccessException?NoSuchFieldException?SecurityException?SQLException?{
		String?sql?=?“update?t_book?set?book_state?=?3?where?book_id?=??“;
		return?super.executeUpdate（sqlnew?String[]?{“book_id“}?book）;
	}
	
	
	/**
	?*?上架處理
	?*?@param?book
	?*?@return
	?*?@throws?IllegalArgumentException
	?*?@throws?IllegalAccessException
	?*?@throws?NoSuchFieldException
	?*?@throws?SecurityException
	?*?@throws?SQLException
	?*/
	public?int?sj（Book?book）?throws?IllegalArgumentException?IllegalAccessException?NoSuchFieldException?SecurityException?SQLException?{
		String?sql?=?“update?t_book?set?book_state?=?2?where?book_id?=??“;
		return?super.executeUpdate（sqlnew?String[]?{“book_id“}?book）;
	}
	
	
	
	

	

	//----------------------------------------------------------------------------------------------------------//
				//------------------------普通用戶---------------------------------//
	
	/**
	?*?findbook.jsp展示所有的書??以及根據書本類別展示
	?*?@param?book
	?*?@param?pageBean
	?*?@return
	?*?@throws?InstantiationException
	?*?@throws?IllegalAccessException
	?*?@throws?SQLException
	?*/
	public?List?list（Book?book?PageBean?pageBean）?throws?InstantiationException?IllegalAccessException?SQLException{
		String?sql?=?“select?*?from?t_book?where?true“;
		//根據書本類別展示
		if（book.getBook_category_id（）!=0）?{
			sql?+=?“?and?book_category_id?=“+book.getBook_category_id（）;
		}
		return?executeQuery（sql?pageBean?Book.class）;
	}
	//模糊查
	public?List?listByName（Book?book?PageBean?pageBean）?throws?InstantiationException?IllegalAccessException?SQLException{
		String?sql?=?“select?*?from?t_book?where?true“;
		if（book.getBook_name（）!=null）?{
			sql?+=?“?and?book_name?like?‘%“+book.getBook_name（）+“%‘“;
		}
		return?executeQuery（sql?pageBean?Book.class）;
	}
	//index.jsp???新書上架??根據上架時間降序展示
	public?List?listtime（Book?book?PageBean?pageBean）?throws?InstantiationException?IllegalAccessException?SQLException{
		String?sql?=?“select?*?from?t_book?order?by?deploy_datetime?desc“;
		return?executeQuery（sql?pageBean?Book.class）;
	}
	//index.jsp??熱銷圖書??根據銷量降序展示
	public?List?listsales（Book?book?PageBean?pageBean）?throws?InstantiationException?IllegalAccessException?SQLException{
		String?sql?=?“select?*?from?t_book?order?by?sales_volume?desc“;
		return?executeQuery（sql?pageBean?Book.class）;
	}
	//findbook.jsp?根據

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-10-14?15:32??T212_wj_project\
?????文件?????????920??2018-08-27?18:25??T212_wj_project\.classpath
?????文件?????????915??2018-08-07?15:58??T212_wj_project\.project
?????目錄???????????0??2018-10-14?15:32??T212_wj_project\.settings\
?????文件?????????567??2018-08-07?15:58??T212_wj_project\.settings\.jsdtscope
?????文件?????????364??2018-08-07?15:58??T212_wj_project\.settings\org.eclipse.jdt.core.prefs
?????文件?????????497??2018-08-07?15:58??T212_wj_project\.settings\org.eclipse.wst.common.component
?????文件?????????345??2018-08-07?15:58??T212_wj_project\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-08-07?15:58??T212_wj_project\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-08-07?15:58??T212_wj_project\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-10-14?15:32??T212_wj_project\build\
?????目錄???????????0??2018-10-14?15:32??T212_wj_project\build\classes\
?????目錄???????????0??2018-10-14?15:32??T212_wj_project\build\classes\com\
?????目錄???????????0??2018-10-14?15:32??T212_wj_project\build\classes\com\zking\
?????目錄???????????0??2018-10-14?15:32??T212_wj_project\build\classes\com\zking\wj\
?????目錄???????????0??2018-10-14?15:32??T212_wj_project\build\classes\com\zking\wj\dao\
?????文件????????2990??2018-10-13?18:16??T212_wj_project\build\classes\com\zking\wj\dao\BookDao.class
?????文件????????1153??2018-10-13?18:16??T212_wj_project\build\classes\com\zking\wj\dao\CategoryDao.class
?????文件????????4572??2018-10-13?18:16??T212_wj_project\build\classes\com\zking\wj\dao\MBookDao.class
?????文件????????3694??2018-10-13?18:16??T212_wj_project\build\classes\com\zking\wj\dao\MenuDao.class
?????文件????????1527??2018-10-13?18:16??T212_wj_project\build\classes\com\zking\wj\dao\MenuDaoTest.class
?????文件????????3938??2018-10-13?18:16??T212_wj_project\build\classes\com\zking\wj\dao\OrderDao.class
?????文件????????1633??2018-10-13?18:16??T212_wj_project\build\classes\com\zking\wj\dao\OrderItemDao.class
?????文件????????1955??2018-10-13?18:16??T212_wj_project\build\classes\com\zking\wj\dao\UserDao.class
?????目錄???????????0??2018-10-14?15:32??T212_wj_project\build\classes\com\zking\wj\entity\
?????文件????????3229??2018-10-13?18:16??T212_wj_project\build\classes\com\zking\wj\entity\Book.class
?????文件????????1384??2018-10-13?18:16??T212_wj_project\build\classes\com\zking\wj\entity\BookCategory.class
?????文件????????1086??2018-10-13?18:16??T212_wj_project\build\classes\com\zking\wj\entity\Doc.class
?????文件????????1407??2018-10-13?18:16??T212_wj_project\build\classes\com\zking\wj\entity\Menu.class
?????文件????????2966??2018-10-13?18:16??T212_wj_project\build\classes\com\zking\wj\entity\Order.class
?????文件????????1708??2018-10-13?18:16??T212_wj_project\build\classes\com\zking\wj\entity\OrderItem.class
............此處省略1105個文件信息