package?cn.crsuka.cu;

import?java.sql.Connection;
//import?java.sql.Date;
import?java.sql.Date;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;

import?cn.crsuka.model.Book;
import?cn.crsuka.model.BookBorrow;
import?cn.crsuka.model.User;
import?cn.crsuka.util.StringUtil;

public?class?BookCU?{
	/**
	?*?書籍添加
	?*?@param?con
	?*?@param?book
	?*?@return
	?*?@throws?Exception
	?*/
	public?int?BookTypeAdd（Connection?conBook?book）?throws?Exception
	{

		String?sql=“insert?into?t_book?（booknamebookdescbookpricebookbpricebookstateintime）?values?（??????）“;
		PreparedStatement?pstmt=?con.prepareStatement（sql）;
		pstmt.setString（1?book.getBookname（））;
		pstmt.setString（2?book.getBookdesc（））;
		pstmt.setFloat（3?book.getBookprice（））;
		pstmt.setFloat（4?book.getBookbprice（））;
		pstmt.setString（5book.getBookstate（））;
		pstmt.setDate（6?（Date）?book.getIntime（））;
		return?pstmt.executeUpdate（）;
	}?
	/**
	?*?圖書列表顯示
	?*?@param?con
	?*?@param?book
	?*?@return
	?*?@throws?Exception
	?*/
	public?ResultSet?bookList（Connection?conBook?book）throws?Exception{
		StringBuffer?stb=new?StringBuffer（“select?*?from?t_book“）;
		if（StringUtil.isNotEmpty（book.getBookname（）））
		{
			stb.append（“?and?bookname?like?‘%“+book.getBookname（）+“%‘“）;
		}
		PreparedStatement?pstmt=con.prepareStatement（stb.toString（）.replaceFirst（“and“?“where“））;
		return?pstmt.executeQuery（）;
	}
	/**
	?*?圖書借出狀態改變
	?*?@param?con
	?*?@param?book
	?*?@return
	?*?@throws?Exception
	?*/
	public?int?BookBorrow（Connection?conBook?book）?throws?Exception
	{
		String?sql?=?“update?t_book?set?bookstate=???where?bookname=?“;
//		String?sql?=?“updata?t_book?set?bookState?=???where?id?=??“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;	
		pstmt.setString（1book.getBookstate（））;
		pstmt.setString（2book.getBookname（））;
//		pstmt.setInt（1book.getId（））;
		return?pstmt.executeUpdate（）;
	}
	
	/**
	?*?圖書借出緩存區
	?*?@param?con
	?*?@param?borrow
	?*?@return
	?*?@throws?Exception
	?*/
	public?int?BookBorrowT（Connection?conBookBorrow?borrowUser?user）?throws?Exception
	{
		String?sql?=?“insert?into?t_borrowbook?（borrowbookborrowpriceborrowstateborrowtimeborrowman）?values?（?????）“;
		PreparedStatement?pstmt=?con.prepareStatement（sql）;
		pstmt.setString（1?borrow.getBorrowbook（））;
		pstmt.setFloat（2?borrow.getBorrowprice（））;
		pstmt.setString（3borrow.getBorrowstate（））;
		pstmt.setDate（4?borrow.getBorrowtime（））;
		pstmt.setString（5user.getUserName（））;
		return?pstmt.executeUpdate（）;
	}
	
	/**
	?*?借出圖書的列表
	?*?@param?con
	?*?@param?bookborrow
	?*?@return
	?*?@throws?Exception
	?*/
	public?ResultSet?bookBackList（Connection?conBookBorrow?bookborrow）throws?Exception{
		StringBuffer?stb=new?StringBuffer（“select?*?from?t_borrowbook“）;
		if（StringUtil.isNotEmpty（bookborrow.getBorrowbook（）））
		{
			stb.append（“?and?borrowbook?like?‘%“+bookborrow.getBorrowbook（）+“%‘“）;
		}
		PreparedStatement?

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

?????文件????????394??2013-05-31?21:06??BookManage\.classpath

?????文件????????386??2013-05-31?20:00??BookManage\.project

?????文件????????629??2013-05-31?20:00??BookManage\.settings\org.eclipse.jdt.core.prefs

?????文件???????5521??2013-07-02?20:08??BookManage\bin\cn\crsuka\cu\BookCU.class

?????文件???????2003??2013-07-02?17:03??BookManage\bin\cn\crsuka\cu\CountCU.class

?????文件???????7106??2013-07-03?10:16??BookManage\bin\cn\crsuka\cu\DataCU.class

?????文件???????5506??2013-07-02?20:35??BookManage\bin\cn\crsuka\cu\PerCU.class

?????文件???????6232??2013-07-03?09:48??BookManage\bin\cn\crsuka\cu\UserCU.class

?????文件???????3427??2013-07-02?09:33??BookManage\bin\cn\crsuka\model\Book.class

?????文件???????1736??2013-06-28?15:16??BookManage\bin\cn\crsuka\model\BookBorrow.class

?????文件???????2630??2013-07-02?19:12??BookManage\bin\cn\crsuka\model\DataSave.class

?????文件???????3436??2013-07-02?09:37??BookManage\bin\cn\crsuka\model\Peri.class

?????文件???????1745??2013-06-28?15:19??BookManage\bin\cn\crsuka\model\PeriBorrow.class

?????文件???????3981??2013-07-02?21:15??BookManage\bin\cn\crsuka\model\User.class

?????文件???????1676??2013-07-03?09:47??BookManage\bin\cn\crsuka\util\DbUtil.class

?????文件????????627??2013-06-27?21:30??BookManage\bin\cn\crsuka\util\StringUtil.class

?????文件???????7600??2013-07-03?19:24??BookManage\bin\cn\crsuka\view\BookAddView.class

?????文件????????862??2013-07-02?18:15??BookManage\bin\cn\crsuka\view\BookInView$1.class

?????文件???????1054??2013-07-02?18:15??BookManage\bin\cn\crsuka\view\BookInView$2.class

?????文件???????9781??2013-07-02?18:15??BookManage\bin\cn\crsuka\view\BookInView.class

?????文件????????869??2013-07-02?19:19??BookManage\bin\cn\crsuka\view\BookOutView$1.class

?????文件???????1062??2013-07-02?19:19??BookManage\bin\cn\crsuka\view\BookOutView$2.class

?????文件??????10263??2013-07-02?19:19??BookManage\bin\cn\crsuka\view\BookOutView.class

?????文件????????893??2013-07-03?10:21??BookManage\bin\cn\crsuka\view\BPBackCountView$1.class

?????文件???????3796??2013-07-03?10:21??BookManage\bin\cn\crsuka\view\BPBackCountView$2.class

?????文件????????809??2013-07-03?10:21??BookManage\bin\cn\crsuka\view\BPBackCountView$3.class

?????文件???????8362??2013-07-03?10:21??BookManage\bin\cn\crsuka\view\BPBackCountView.class

?????文件????????862??2013-07-02?18:16??BookManage\bin\cn\crsuka\view\BPBackView$1.class

?????文件???????3337??2013-07-02?18:16??BookManage\bin\cn\crsuka\view\BPBackView$2.class

?????文件????????779??2013-07-02?18:16??BookManage\bin\cn\crsuka\view\BPBackView$3.class

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