package?com.lemon.dao;

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

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

/**
?*?教科書Dao類
?*?@author?An
?*
?*/
public?class?BookDao?{
	
	/**
	?*?教科書添加
	?*?@param?con
	?*?@param?book
	?*?@return
	?*?@throws?Exception
	?*/
	public?int?add（Connection?conBook?book）throws?Exception{
		String?sql=“insert?into?t_book?values（??????）“;
		PreparedStatement?pstm?=con.prepareStatement（sql）;
		pstm.setString（1?book.getBookName（））;
		pstm.setString（2?book.getAuthor（））;
		pstm.setString（3?book.getSex（））;
		pstm.setFloat（4?book.getPrice（））;
		pstm.setString（5?book.getBookTypeName（））;
		pstm.setString（6?book.getBookDesc（））;
		return?pstm.executeUpdate（）;
		
	}
	/**
	?*?教科書查詢
	?*?@param?con
	?*?@param?book
	?*?@return
	?*?@throws?Exception
	?*/
	public?ResultSet?list（Connection?conBook?book）throws?Exception{
		StringBuffer?sb=new?StringBuffer（“select?*?from?t_book?bt_bookType?bt?where?b.bookTypeName=bt.bookTypeName“）;
		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（StringUtil.isNotEmpty（book.getBookTypeName（）））{
			sb.append（“?and?b.bookTypeName?like?‘%“+book.getBookTypeName（）+“%‘“）;
		}
		PreparedStatement?pstm=con.prepareStatement（sb.toString（））;
		return?pstm.executeQuery（）;
	}
	/**
	?*?教科書刪除
	?*?@param?con
	?*?@param?bookName
	?*?@return
	?*?@throws?Exception
	?*/
	public?int?delete（Connection?conString?bookName）throws?Exception{
		String?sql=“delete?from?t_book?where?bookName=?“;
		PreparedStatement?pstm=con.prepareStatement（sql）;
		pstm.setString（1?bookName）;	
		return?pstm.executeUpdate（）;
	}
	/**
	?*?教科書刪除
	?*?@param?con
	?*?@param?book
	?*?@return
	?*?@throws?Exception
	?*/
	public?int?update（Connection?conBook?book）throws?Exception{
		String?sql=“update?t_book?set?bookName?=??author=?sex=?price=?bookDesc=??where?bookName=?“;
		PreparedStatement?pstm?=con.prepareStatement（sql）;
		pstm.setString（1?book.getBookName（））;
		pstm.setString（2?book.getAuthor（））;
		pstm.setString（3?book.getSex（））;
		pstm.setFloat（4?book.getPrice（））;
		pstm.setString（5?book.getBookDesc（））;
		pstm.setString（6?book.getBookName（））;
		return?pstm.executeUpdate（）;
	}
	/**
	?*?制定教科書類別下是否存在圖書
	?*?@param?con
	?*?@param?bookTypeName
	?*?@return
	?*?@throws?Exception
	?*/
	public?boolean?existBookByBookTypeName（Connection?conString?bookTypeName）throws?Exception{
		String?sql=“select?*?from?t_book?where?bookTypeName=?“;
		PreparedStatement?pstm=con.prepareStatement（sql）;
		pstm.setString（1?bookTypeName）;
		ResultSet?rs=pstm.executeQuery（）;
		
		return?rs.next（）;
		
		
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-11-20?21:03??BookManager\
?????文件?????????399??2017-06-07?16:41??BookManager\.classpath
?????文件?????????387??2017-05-18?16:59??BookManager\.project
?????目錄???????????0??2017-11-20?21:03??BookManager\.settings\
?????文件?????????598??2017-05-18?16:59??BookManager\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2017-11-20?21:03??BookManager\bin\
?????目錄???????????0??2017-11-20?21:03??BookManager\bin\com\
?????目錄???????????0??2017-11-20?21:03??BookManager\bin\com\lemon\
?????文件???????21600??2017-06-12?21:34??BookManager\bin\com\lemon.zip
?????目錄???????????0??2017-11-20?21:03??BookManager\bin\com\lemon\dao\
?????文件????????3211??2017-11-16?20:18??BookManager\bin\com\lemon\dao\BookDao.class
?????文件????????2500??2017-11-16?20:18??BookManager\bin\com\lemon\dao\BookTypeDao.class
?????文件????????1498??2017-11-16?20:18??BookManager\bin\com\lemon\dao\UserDao.class
?????目錄???????????0??2017-11-20?21:03??BookManager\bin\com\lemon\model\
?????文件????????2731??2017-11-16?20:18??BookManager\bin\com\lemon\model\Book.class
?????文件?????????982??2017-11-16?20:18??BookManager\bin\com\lemon\model\BookType.class
?????文件?????????874??2017-11-16?20:18??BookManager\bin\com\lemon\model\User.class
?????目錄???????????0??2017-11-20?21:03??BookManager\bin\com\lemon\util\
?????文件????????1361??2017-11-16?20:18??BookManager\bin\com\lemon\util\DbUtil.class
?????文件?????????674??2017-11-16?20:18??BookManager\bin\com\lemon\util\StringUtil.class
?????目錄???????????0??2017-11-20?21:03??BookManager\bin\com\lemon\view\
?????文件?????????772??2017-11-16?20:18??BookManager\bin\com\lemon\view\anqiInterFrim$1.class
?????文件????????1199??2017-11-16?20:18??BookManager\bin\com\lemon\view\anqiInterFrim.class
?????文件?????????782??2017-11-16?20:18??BookManager\bin\com\lemon\view\BookAddInterFrm$1.class
?????文件?????????884??2017-11-16?20:18??BookManager\bin\com\lemon\view\BookAddInterFrm$2.class
?????文件?????????798??2017-11-16?20:18??BookManager\bin\com\lemon\view\BookAddInterFrm$3.class
?????文件?????????798??2017-11-16?20:18??BookManager\bin\com\lemon\view\BookAddInterFrm$4.class
?????文件???????10099??2017-11-16?20:18??BookManager\bin\com\lemon\view\BookAddInterFrm.class
?????文件?????????797??2017-11-16?20:18??BookManager\bin\com\lemon\view\BookManageInterFrm$1.class
?????文件?????????819??2017-11-16?20:18??BookManager\bin\com\lemon\view\BookManageInterFrm$2.class
?????文件?????????821??2017-11-16?20:18??BookManager\bin\com\lemon\view\BookManageInterFrm$3.class
............此處省略84個(gè)文件信息