package?com.dao;

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

import?javax.swing.plaf.TreeUI;

import?com.model.Book;
import?com.util.StringUtil;

public?class?BookDao?{
	
	/**
	?*?添加圖書
	?*?@param?con
	?*?@param?book
	?*?@return?返回添加結果（int）
	?*?@throws?Exception
	?*/
	public?int?addBook（Connection?conBook?book）throws?Exception{
		String?sql=“insert?into?t_book?values（null??????）“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setString（1?book.getBookName（））;
		pstmt.setString（2?book.getAuthor（））;
		pstmt.setString（3?book.getSex（））;
		pstmt.setFloat（4?book.getPrice（））;
		pstmt.setString（5?book.getBookDesc（））;
		pstmt.setInt（6?book.getBookTypeId（））;
		return?pstmt.executeUpdate（）;
	}
	
	/**
	?*?查詢圖書
	?*?@param?con
	?*?@param?book
	?*?@return?返回查詢結果（ResultSet）
	?*?@throws?Exception
	?*/
	public?ResultSet?listBook（Connection?con?Book?book）?throws?Exception{
		StringBuffer?sb?=?new?StringBuffer（“select?*?from?t_book?bt_booktype?bt?where?b.bookTypeId?=?bt.id“）;
		if?（StringUtil.isNotEmpty（book.getBookName（）））?{
			sb.append（“?and?b.bookName?like?‘%“+book.getBookName（）+“%‘“）;
		}
		if?（StringUtil.isNotEmpty（book.getAuthor（）））?{
			sb.append（“?and?b.author?like?‘%“+book.getAuthor（）+“%‘“）;
		}
		if?（book.getBookTypeId（）?!=?null）?{
			sb.append（“?and?b.bookTypeId?=?“+book.getBookTypeId（））;
		}
		PreparedStatement?pstmt?=?con.prepareStatement（sb.toString（））;
		ResultSet?rs?=?pstmt.executeQuery（）;
		return?rs;
	}
	
	/**
	?*?修改圖書
	?*?@param?con
	?*?@param?book
	?*?@return?返回修改結果（int）
	?*?@throws?Exception
	?*/
	public?int?updateBook（Connection?con?Book?book）?throws?Exception{
		String?sql?=?“update?t_book?set?bookName=?author=?sex=?price=?bookDesc=?bookTypeId=??where?id=?“;
		PreparedStatement?pstmt?=?con.prepareStatement（sql）;
		pstmt.setString（1?book.getBookName（））;
		pstmt.setString（2?book.getAuthor（））;
		pstmt.setString（3?book.getSex（））;
		pstmt.setFloat（4?book.getPrice（））;
		pstmt.setString（5?book.getBookDesc（））;
		pstmt.setInt（6?book.getBookTypeId（））;
		pstmt.setInt（7?book.getId（））;
		return?pstmt.executeUpdate（）;
	}
	
	/**
	?*?刪除圖書
	?*?@param?con
	?*?@param?book
	?*?@return?返回刪除結果（int）
	?*?@throws?Exception
	?*/
	public?int?deleteBook（Connection?con?Book?book）?throws?Exception{
		String?sql?=?“delete?from?t_book?where?id=?“;
		PreparedStatement?pstmt?=?con.prepareStatement（sql）;
		pstmt.setInt（1?book.getId（））;
		return?pstmt.executeUpdate（）;
	}
	
	/**
	?*?判斷圖書類別下是否存在圖書
	?*?@param?con
	?*?@param?id
	?*?@return?判斷結果（boolean）
	?*?@throws?Exception
	?*/
	public?boolean?isExistBook（Connection?con?int?id）?throws?Exception{
		String?sql?=?“select?*?from?t_book?bt_booktype?bt?where?b.bookTypeId=bt.id?and?b.bookTypeId=?“;
		PreparedStatement?pstmt?=?con.prepareStatement（sql）;
		pstmt.setInt（1?id）;
		ResultSet?rs?=?pstmt.executeQuery（）;
		
		return?rs.next（）;
	}
	
	

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

?????文件????????376??2017-06-04?16:36??LibraryManager\.classpath

?????文件????????390??2017-05-31?11:23??LibraryManager\.project

?????文件????????598??2017-05-31?11:23??LibraryManager\.settings\org.eclipse.jdt.core.prefs

?????文件???????4116??2017-08-09?21:07??LibraryManager\bin\com\dao\BookDao.class

?????文件???????2720??2017-08-09?21:07??LibraryManager\bin\com\dao\BookTypeDao.class

?????文件???????1491??2017-08-09?21:07??LibraryManager\bin\com\dao\UserDao.class

?????文件???????3044??2017-08-09?21:07??LibraryManager\bin\com\model\Book.class

?????文件???????1634??2017-08-09?21:07??LibraryManager\bin\com\model\BookType.class

?????文件???????1055??2017-08-09?21:07??LibraryManager\bin\com\model\User.class

?????文件???????1194??2017-08-10?11:30??LibraryManager\bin\com\util\DbUtil.class

?????文件????????660??2017-08-09?21:07??LibraryManager\bin\com\util\StringUtil.class

?????文件????????748??2017-08-10?11:35??LibraryManager\bin\com\view\AboutInterFrm$1.class

?????文件???????3145??2017-08-10?11:35??LibraryManager\bin\com\view\AboutInterFrm.class

?????文件????????758??2017-08-09?21:07??LibraryManager\bin\com\view\AddBookInterFrm$1.class

?????文件????????762??2017-08-09?21:07??LibraryManager\bin\com\view\AddBookInterFrm$2.class

?????文件????????762??2017-08-09?21:07??LibraryManager\bin\com\view\AddBookInterFrm$3.class

?????文件??????11457??2017-08-09?21:07??LibraryManager\bin\com\view\AddBookInterFrm.class

?????文件????????778??2017-08-09?21:07??LibraryManager\bin\com\view\AddBookTypeInterFrm$1.class

?????文件????????790??2017-08-09?21:07??LibraryManager\bin\com\view\AddBookTypeInterFrm$2.class

?????文件????????790??2017-08-09?21:07??LibraryManager\bin\com\view\AddBookTypeInterFrm$3.class

?????文件???????8134??2017-08-09?21:07??LibraryManager\bin\com\view\AddBookTypeInterFrm.class

?????文件????????773??2017-08-09?21:07??LibraryManager\bin\com\view\BookManageInterFrm$1.class

?????文件????????783??2017-08-09?21:07??LibraryManager\bin\com\view\BookManageInterFrm$2.class

?????文件????????783??2017-08-09?21:07??LibraryManager\bin\com\view\BookManageInterFrm$3.class

?????文件????????751??2017-08-09?21:07??LibraryManager\bin\com\view\BookManageInterFrm$4.class

?????文件????????879??2017-08-09?21:07??LibraryManager\bin\com\view\BookManageInterFrm$5.class

?????文件????????783??2017-08-09?21:07??LibraryManager\bin\com\view\BookManageInterFrm$6.class

?????文件??????18678??2017-08-09?21:07??LibraryManager\bin\com\view\BookManageInterFrm.class

?????文件????????793??2017-08-09?21:07??LibraryManager\bin\com\view\BookTypeManageInterFrm$1.class

?????文件????????811??2017-08-09?21:07??LibraryManager\bin\com\view\BookTypeManageInterFrm$2.class

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