package?book;

import?java.awt.print.Book;
import?java.sql.Connection;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;

import?com.msit.books.Books;
import?com.msit.util.SqlHelper;
import?com.msit.books.*;

public?class?books?{

	/**
	?*?根據分類?取得分頁數據
	?*/
	public?List?getfenlei（int?pageSize?int?pageIndex）?{
		String?sql?=?“SELECT?*?from?books?WHERE?CategoryId=“
				+?“ORDER?BY?PublishDate?DESC?“?+?“LIMIT?“?+?pageSize
				*?（pageIndex?-?1）?+?““?+?pageSize;
		//?Limit?開始行要取得的條數
		System.out.println（sql）;
		try?{
			return?selectAll（sql）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?null;
	}


	//?根據圖書編號查詢圖書
	public?Books?BookISBN（String?isbn）?throws?SQLException?{
		Books?n?=?null;
		String?sql?=?“select?*?from?books?where?ISBN=“?+?isbn;
		List?ns?=?selectAll（sql）;
		if?（null?!=?ns?&&?ns.size（）?>=?1）?{
			n?=?ns.get（0）;
		}
		return?n;
	}

	//?根據分類查詢書本信息
	public?Books?getFenleiByid（String?nid）?throws?SQLException?{
		Books?n?=?null;
		String?sql?=?“SELECT?*?from?books?WHERE?CategoryId=“?+?nid;
		List?ns?=?selectAll（sql）;
		if?（null?!=?ns?&&?ns.size（）?>=?1）?{
			n?=?ns.get（0）;
		}
		return?n;
	}
	/**整本
	?*?取得分頁數據
	?*/
	public?List?getPageList（int?pageSizeint?pageIndex）{
		String?sql=“SELECT?*?from?books?“?+
				“ORDER?BY?PublishDate?DESC?“?+
				“LIMIT?“+pageSize*（pageIndex-1）+““+pageSize;
		//Limit?開始行要取得的條數
		System.out.println（sql）;
		try?{
			return?selectAll（sql）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?null;
	}
	
	
	/**根據分類
	?*?取得分頁數據
	?*/
	public?List?getfenlei（int?pageSizeint?pageIndexString?nid）{
		String?sql=“SELECT?*?from?books?WHERE?CategoryId=“?+nid+
				“?LIMIT?“+pageSize*（pageIndex-1）+““+pageSize;
		//Limit?開始行要取得的條數
		System.out.println（sql）;
		try?{
			return?selectAll（sql）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?null;
	}
	/**
	?*?取得表的總數
	?*?@return
	?*/
	public?int?getBookCount（）{
		int?count=0;
		String?sql=“select?count（*）?from?books“;
		//創建鏈接
		Connection?con?=?SqlHelper.getConnection（）;
		try?{
			//創建執行對象
			Statement?stm?=?con.createStatement（）;
			//執行得到結果集
			ResultSet?rs?=?stm.executeQuery（sql）;
			if（rs.next（））{
				count?=?rs.getInt（1）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?count;
	}
	
	//根據分類查詢
	public?int?getfenleiCount（int?s）{
		int?count=0;
		String?sql=“select?count（*）?from?books?where?CategoryId=“+s;
		//創建鏈接
		Connection?con?=?SqlHelper.getConnection（）;
		try?{
			//創建執行對象
			Statement?stm?=?con.createStatement（）;
			//執行得到結果集
			ResultSet?rs?=?stm.executeQuery（sql）;
			if（rs.next（））{
				count?=?rs.getInt（1）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?count;
	}
	
	//查詢單個?書本信息
	public?Books?getBookByid（String?nid）?throws?S

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????630??2014-09-02?08:18??wangshangshucheng\.classpath

?????文件????????324??2015-03-03?17:48??wangshangshucheng\.mymetadata

?????文件????????240??2014-09-02?08:18??wangshangshucheng\.mystrutsdata

?????文件???????1843??2014-09-02?08:18??wangshangshucheng\.project

?????文件????????500??2014-09-02?08:18??wangshangshucheng\.settings\.jsdtscope

?????文件????????101??2015-03-03?18:00??wangshangshucheng\.settings\org.eclipse.core.resources.prefs

?????文件????????395??2014-09-02?08:18??wangshangshucheng\.settings\org.eclipse.jdt.core.prefs

?????文件????????489??2014-09-02?08:18??wangshangshucheng\.settings\org.eclipse.wst.common.component

?????文件????????252??2014-09-02?08:18??wangshangshucheng\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2014-09-02?08:18??wangshangshucheng\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2014-09-02?08:18??wangshangshucheng\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????5674??2014-09-02?08:18??wangshangshucheng\src\book\books.java

?????文件???????1669??2014-09-02?08:18??wangshangshucheng\src\book\dindan.java

?????文件???????2709??2014-09-02?08:18??wangshangshucheng\src\book\gouwuche.java

?????文件???????1208??2014-09-02?08:18??wangshangshucheng\src\book\pinglun.java

?????文件???????3157??2014-09-02?08:18??wangshangshucheng\src\book\Users.java

?????文件????????987??2014-09-02?08:18??wangshangshucheng\src\categories\categories.java

?????文件???????2690??2014-09-02?08:18??wangshangshucheng\src\com\msit\biz\bookCountServer.java

?????文件????????939??2014-09-02?08:18??wangshangshucheng\src\com\msit\biz\UserRoles.java

?????文件????????802??2014-09-02?08:18??wangshangshucheng\src\com\msit\books\bookCount.java

?????文件???????2739??2014-09-02?08:18??wangshangshucheng\src\com\msit\books\Books.java

?????文件????????293??2014-09-02?08:18??wangshangshucheng\src\com\msit\books\Categories.java

?????文件????????959??2014-09-02?08:18??wangshangshucheng\src\com\msit\books\Gouwuche.java

?????文件???????1425??2014-09-02?08:18??wangshangshucheng\src\com\msit\books\orderbook.java

?????文件????????640??2014-09-02?08:18??wangshangshucheng\src\com\msit\books\orders.java

?????文件????????324??2014-09-02?08:18??wangshangshucheng\src\com\msit\books\Publishers.java

?????文件????????963??2014-09-02?08:18??wangshangshucheng\src\com\msit\books\readercomments.java

?????文件????????497??2014-09-02?08:18??wangshangshucheng\src\com\msit\books\searchkeywords.java

?????文件????????305??2014-09-02?08:18??wangshangshucheng\src\com\msit\books\userroles.java

?????文件???????1405??2014-09-02?08:18??wangshangshucheng\src\com\msit\books\users.java

............此處省略1232個文件信息