package?com.cn.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;

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

public?class?BookDao?extends?DbUtil?{
	PreparedStatement?ps?=?null;
	Connection?conn?=?null;
	ResultSet?rs?=?null;
	
	//添加方法
	public?int?addBook（Book?book）?{
		DbUtil?db?=?new?DbUtil（）;
		conn?=?db.getCon（）;
		String?sql?=?“insert?into?book?（bookid?bookname?author?price?other）?VALUES?（?????????）“;
		int?num?=?0;

		try?{
			ps?=?conn.prepareStatement（sql）;
			ps.setString（1?book.getBookId（））;
			ps.setString（2?book.getName（））;
			ps.setString（3?book.getAuthor（））;
			ps.setDouble（4?book.getPrice（））;
			ps.setString（5?book.getOther（））;

			//?執行更新操作
			num?=?ps.executeUpdate（）;

		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?finally?{
			//?釋放資源
			super.release（null?ps?conn）;
		}

		return?num;
	}
	
	//查詢方法
	public?ArrayList?getBook（String?bookname）{
		conn?=?super.getCon（）;
???????
????????ArrayList?list?=?new?ArrayList<>（）;

????????Book?book;

????????try?{
????????????//構造SQL語句
????????????StringBuffer?sql?=?new?StringBuffer（“SELECT?*?FROM?book“）;
????????????
????????????if?（!StringUtil.isNull（bookname））{
????????????	sql.append（“?where?bookname?like?‘%“?+?bookname?+?“%‘“）;
????????????}

????????????//創建執行對象
????????????ps?=?conn.prepareStatement（new?String（sql））;

????????????//執行查詢，得到結果集
????????????rs?=?ps.executeQuery（）;

????????????//對結果集進行遍歷
????????????while?（rs.next（））?{
????????????????//實例化book對象
????????????	book?=?new?Book（）;

????????????????//利用set方法對book對象進行賦值
????????????	book.setBookId（rs.getString（“bookid“））;
????????????	book.setName（rs.getString（“bookname“））;
????????????	book.setAuthor（rs.getString（“author“））;
????????????	book.setPrice（rs.getDouble（“price“））;
????????????	book.setOther（rs.getString（“other“））;

????????????????list.add（book）;
????????????}
????????}?catch?（SQLException?e）?{
????????????//異常處理
????????????e.printStackTrace（）;
????????}?finally?{
????????????//釋放資源
????????????super.release（null?ps?conn）;
????????}
		return?list;
	}
	
	public?static?void?main（String[]?args）?{
		BookDao?bDao?=?new?BookDao（）;
		ArrayList?list?=?bDao.getBook（““）;
		System.out.println（list.get（0））;
		
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-07-06?16:23??20200706_gui_demo01\
?????文件?????????917??2020-07-06?16:25??20200706_gui_demo01\.classpath
?????文件?????????733??2020-07-06?11:07??20200706_gui_demo01\.project
?????目錄???????????0??2020-07-06?11:07??20200706_gui_demo01\.settings\
?????文件?????????364??2020-07-06?11:07??20200706_gui_demo01\.settings\org.eclipse.jdt.core.prefs
?????文件?????????130??2020-07-06?11:07??20200706_gui_demo01\.settings\org.eclipse.jpt.core.prefs
?????文件?????????167??2020-07-06?11:07??20200706_gui_demo01\.settings\org.eclipse.wst.common.project.facet.core.prefs.xml
?????文件?????????255??2020-07-06?11:07??20200706_gui_demo01\.settings\org.eclipse.wst.common.project.facet.core.xml
?????目錄???????????0??2020-07-06?11:07??20200706_gui_demo01\build\
?????目錄???????????0??2020-07-09?08:48??20200706_gui_demo01\build\classes\
?????目錄???????????0??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\
?????目錄???????????0??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\cn\
?????目錄???????????0??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\cn\dao\
?????文件????????3903??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\cn\dao\BookDao.class
?????文件????????1789??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\cn\dao\UserDao.class
?????目錄???????????0??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\cn\model\
?????文件????????2173??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\cn\model\Book.class
?????文件????????1061??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\cn\model\User.class
?????目錄???????????0??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\cn\util\
?????文件????????1965??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\cn\util\DbUtil.class
?????文件?????????652??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\cn\util\StringUtil.class
?????目錄???????????0??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\java\
?????目錄???????????0??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\java\view\
?????文件?????????738??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\java\view\AboutMe$1.class
?????文件????????2837??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\java\view\AboutMe.class
?????文件?????????738??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\java\view\AddBook$1.class
?????文件?????????678??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\java\view\AddBook$2.class
?????文件?????????678??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\java\view\AddBook$3.class
?????文件????????6375??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\java\view\AddBook.class
?????文件?????????785??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\java\view\Login$1.class
?????文件?????????722??2020-07-09?08:48??20200706_gui_demo01\build\classes\com\java\view\Login$2.class
............此處省略169個文件信息