package?com.zyr.dao;

import?com.zyr.entity.Book;
import?com.zyr.utils.StringUtils;

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

/**
?*?@author?Zyr
?*?@version?1.0
?*?@date?2020/9/22?22:05
?*/
public?class?BookAddDao?{

????public?BookAddDao（）?{

????}

????/**
?????*?圖書添加
?????*
?????*?@param?con
?????*?@param?book
?????*?@return
?????*?@throws?Exception
?????*/
????public?int?add（Connection?con?Book?book）?throws?Exception?{
????????String?sql?=?“insert?into?book?values（null??????）“;
????????PreparedStatement?ps?=?con.prepareStatement（sql）;
????????ps.setString（1?book.getBookName（））;
????????ps.setString（2?book.getAuthor（））;
????????ps.setString（3?book.getSex（））;
????????ps.setFloat（4?book.getPrice（））;
????????ps.setInt（5?book.getBookTypeId（））;
????????ps.setString（6?book.getBookDesc（））;
????????return?ps.executeUpdate（）;
????}

????/**
?????*?圖書信息查詢
?????*
?????*?@param?con
?????*?@param?book
?????*?@return
?????*?@throws?Exception
?????*/
????public?ResultSet?list（Connection?con?Book?book）?throws?Exception?{
????????StringBuffer?sb?=?new?StringBuffer（“select?*?from?book?bbookType?bt?where?b.bookTypeId?=?bt.id“）;
????????if?（StringUtils.isNotEmpty（book.getBookName（）））?{
????????????sb.append（“?and?b.bookName?like?‘%“?+?book.getBookName（）?+?“%‘“）;
????????}
????????if?（StringUtils.isNotEmpty（book.getAuthor（）））?{
????????????sb.append（“?and?b.author?like?‘%“?+?book.getAuthor（）?+?“%‘“）;
????????}
????????if?（book.getBookTypeId（）?!=?null?&&?book.getBookTypeId（）?!=?-1）?{
????????????sb.append（“?and?b.bookTypeId?=?“?+?book.getBookTypeId（）?+?““）;
????????}
????????PreparedStatement?preparedStatement?=?con.prepareStatement（sb.toString（））;
????????return?preparedStatement.executeQuery（）;
????}

????/**
?????*?圖書刪除
?????*
?????*?@param?con
?????*?@param?id
?????*?@return
?????*/
????public?int?delete（Connection?con?String?id）?throws?Exception?{
????????String?sql?=?“delete?from?book?where?id?=??“;
????????PreparedStatement?ps?=?con.prepareStatement（sql）;
????????ps.setString（1?id）;

????????return?ps.executeUpdate（）;
????}

????/**
?????*?圖書信息修改
?????*
?????*?@param?con
?????*?@param?book
?????*?@return
?????*/
????public?int?update（Connection?con?Book?book）?throws?Exception?{
????????String?sql?=?“update?book?set?bookName=?author=?sex=?price=?bookTypeId=?bookDesc=??where?id=?“;
????????PreparedStatement?ps?=?con.prepareStatement（sql）;
????????ps.setString（1book.getBookName（））;
????????ps.setString（2?book.getAuthor（））;
????????ps.setString（3?book.getSex（））;
????????ps.setFloat（4?book.getPrice（））;
????????ps.setInt（5?book.getBookTypeId（））;
????????ps.setString（6?book.getBookDesc（））;
????????ps.setInt（7book.getId（））;
????????return?ps.executeUpdate（）;
????}

????/**
?????*?指定圖書類別下是否有書
?????*?@param?con
?????*?@param?bookTypeId
?????*?@return
?????*?@throws?Exception
?????*/
???

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

?????文件???????3411??2020-10-18?09:25??圖書管理系統(tǒng)\book.sql

?????文件????????503??2020-09-23?22:02??圖書管理系統(tǒng)\Test\.idea\artifacts\Test_jar.xml

?????文件????????284??2020-09-21?20:45??圖書管理系統(tǒng)\Test\.idea\libraries\mysql_connector_java_8_0_21.xml

?????文件????????278??2020-09-21?20:45??圖書管理系統(tǒng)\Test\.idea\misc.xml

?????文件????????255??2020-09-21?20:45??圖書管理系統(tǒng)\Test\.idea\modules.xml

?????文件???????9045??2020-09-23?22:49??圖書管理系統(tǒng)\Test\.idea\uiDesigner.xml

?????文件??????34509??2020-10-08?22:18??圖書管理系統(tǒng)\Test\.idea\workspace.xml

?????文件?????272896??2020-01-09?18:57??圖書管理系統(tǒng)\Test\out\artifacts\Test_jar\demo\exe12125533746502519545.tmp

?????文件?????272896??2020-01-09?18:57??圖書管理系統(tǒng)\Test\out\artifacts\Test_jar\demo\exe5025586076953044048.tmp

?????文件????2488371??2020-09-23?15:28??圖書管理系統(tǒng)\Test\out\artifacts\Test_jar\Test.jar

?????文件???????3421??2020-09-24?12:17??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\dao\BookAddDao.class

?????文件???????2559??2020-09-24?22:35??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\dao\BookTypeDao.class

?????文件???????1621??2020-09-24?12:17??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\dao\UserDao.class

?????文件???????3360??2020-09-24?12:17??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\entity\Book.class

?????文件???????1422??2020-09-24?12:17??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\entity\BookType.class

?????文件???????1602??2020-09-24?12:17??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\entity\User.class

?????文件???????1221??2020-09-24?12:17??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\utils\DButils.class

?????文件????????674??2020-09-24?12:17??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\utils\StringUtils.class

?????文件???????1039??2020-09-24?12:17??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\view\AboutFrm.class

?????文件????????711??2020-09-24?12:17??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\view\AddBookTypeFrm$1.class

?????文件???????2601??2020-09-24?12:17??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\view\AddBookTypeFrm$2.class

?????文件???????3542??2020-09-24?12:17??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\view\AddBookTypeFrm.class

?????文件????????747??2020-09-24?12:17??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\view\BookAddFrm$1.class

?????文件????????687??2020-09-24?12:17??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\view\BookAddFrm$2.class

?????文件???????7726??2020-09-24?12:17??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\view\BookAddFrm.class

?????文件????????754??2020-09-27?13:42??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\view\BookFindFrm$1.class

?????文件????????754??2020-09-27?13:42??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\view\BookFindFrm$2.class

?????文件????????754??2020-09-27?13:42??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\view\BookFindFrm$3.class

?????文件????????689??2020-09-27?13:42??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\view\BookFindFrm$4.class

?????文件??????13278??2020-09-27?13:42??圖書管理系統(tǒng)\Test\out\production\Test\com\zyr\view\BookFindFrm.class

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