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;

/**
?*?教科書(shū)Dao類
?*?@author?An
?*
?*/
public?class?BookDao?{
	
	/**
	?*?教科書(shū)添加
	?*?@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（）;
		
	}
	/**
	?*?教科書(shū)查詢
	?*?@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（）;
	}
	/**
	?*?教科書(shū)刪除
	?*?@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（）;
	}
	/**
	?*?教科書(shū)刪除
	?*?@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（）;
	}
	/**
	?*?制定教科書(shū)類別下是否存在圖書(shū)
	?*?@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??2018-02-20?14:01??MoneyManager\
?????文件?????????642??2017-11-21?11:55??MoneyManager\.classpath
?????文件?????????387??2017-05-18?16:59??MoneyManager\.project
?????目錄???????????0??2017-06-06?20:01??MoneyManager\.settings\
?????文件?????????598??2017-05-18?16:59??MoneyManager\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2018-02-20?14:01??MoneyManager\bin\
?????目錄???????????0??2018-02-20?14:01??MoneyManager\bin\com\
?????目錄???????????0??2018-02-20?14:01??MoneyManager\bin\com\lemon\
?????文件???????30431??2017-12-24?14:32??MoneyManager\bin\com\lemon.zip
?????目錄???????????0??2018-02-20?14:01??MoneyManager\bin\com\lemon\dao\
?????文件????????3211??2017-12-31?15:23??MoneyManager\bin\com\lemon\dao\BookDao.class
?????文件????????2500??2017-12-31?15:23??MoneyManager\bin\com\lemon\dao\BookTypeDao.class
?????文件????????3187??2017-12-31?15:23??MoneyManager\bin\com\lemon\dao\UserDao.class
?????目錄???????????0??2018-02-20?14:01??MoneyManager\bin\com\lemon\model\
?????文件????????2731??2017-12-31?15:23??MoneyManager\bin\com\lemon\model\Book.class
?????文件?????????982??2017-12-31?15:23??MoneyManager\bin\com\lemon\model\BookType.class
?????文件?????????812??2017-12-31?15:23??MoneyManager\bin\com\lemon\model\Manaer.class
?????文件????????1985??2017-12-31?15:23??MoneyManager\bin\com\lemon\model\User.class
?????目錄???????????0??2018-02-20?14:01??MoneyManager\bin\com\lemon\util\
?????文件????????1437??2017-12-31?15:23??MoneyManager\bin\com\lemon\util\DbUtil.class
?????文件?????????674??2017-12-31?15:23??MoneyManager\bin\com\lemon\util\StringUtil.class
?????目錄???????????0??2018-02-20?14:01??MoneyManager\bin\com\lemon\view\
?????文件?????????757??2017-12-31?15:23??MoneyManager\bin\com\lemon\view\AboutWeFrm$1.class
?????文件????????5426??2017-12-31?15:23??MoneyManager\bin\com\lemon\view\AboutWeFrm.class
?????文件?????????737??2017-12-31?15:23??MoneyManager\bin\com\lemon\view\addFrm$1.class
?????文件????????2810??2017-12-31?15:23??MoneyManager\bin\com\lemon\view\addFrm$2.class
?????文件????????5268??2017-12-31?15:23??MoneyManager\bin\com\lemon\view\addFrm.class
?????文件?????????772??2017-12-31?15:23??MoneyManager\bin\com\lemon\view\anqiInterFrim$1.class
?????文件????????1199??2017-12-31?15:23??MoneyManager\bin\com\lemon\view\anqiInterFrim.class
?????文件????????1070??2017-12-31?15:23??MoneyManager\bin\com\lemon\view\BookAddInterFrm$1.class
?????文件?????????884??2017-12-31?15:23??MoneyManager\bin\com\lemon\view\BookAddInterFrm$2.class
............此處省略144個(gè)文件信息