package?com.tushugl.daos;

import?java.sql.*;
import?java.util.ArrayList;

import?com.tushugl.DbUtil.Dbutil;
import?com.tushugl.vos.Book;

public?class?Bookdao?{
	//?添加圖書
	public?boolean?addBook（Book?book）?{
		boolean?result?=?false;
		Connection?conn?=?Dbutil.getConn（）;
		try?{
			PreparedStatement?ps?=?conn.prepareStatement（“insert?into?books（b“
					+?“nameprice）?values（??）“）;
			ps.setString（1?book.getName（））;
			ps.setFloat（2?book.getPrice（））;
			ps.execute（）;
			result?=?true;
		}?catch?（SQLException?e）?{

			e.printStackTrace（）;
		}?finally?{
			Dbutil.close（）;
		}
		return?result;
	}

	//?根據(jù)圖書的編號查詢圖書
	public?Book?queryBookById（int?id）?{
		Connection?conn?=?Dbutil.getConn（）;
		Book?book?=?null;

		try?{
			PreparedStatement?ps?=?conn
					.prepareStatement（“select?idbnameprice?from?books?where?id?=??“）;
			ps.setInt（1?id）;
			ResultSet?rs?=?ps.executeQuery（）;
			if?（rs.next（））?{
				book?=?new?Book（rs.getInt（1）?rs.getString（2）?rs.getFloat（3））;
			}

		}?catch?（SQLException?e）?{

			e.printStackTrace（）;
		}
		return?book;

	}

	//?根據(jù)圖書編號刪除圖書
	public?int?deleteBook（int?id）?{

		Connection?conn?=?Dbutil.getConn（）;
		int?ret?=?0;
		try?{
			PreparedStatement?ps?=?conn
					.prepareStatement（“delete?from?books?where?id?=??“）;
			ps.setInt（1?id）;
			ret?=?ps.executeUpdate（）;

		}?catch?（SQLException?e）?{

			e.printStackTrace（）;
		}
		return?ret;
	}

	//?修改圖書
	public?int?modifyBook（int?id?String?name?float?price）?{
		Connection?conn?=?Dbutil.getConn（）;
		int?ret?=?0;
		try?{
			PreparedStatement?ps?=?conn
					.prepareStatement（“update?books?set?bname=???price=??where?id?=?“）;
			ps.setString（1?name）;
			ps.setFloat（2?price）;
			ps.setInt（3?id）;
			ret?=?ps.executeUpdate（）;
		}?catch?（SQLException?e）?{

			e.printStackTrace（）;
		}
		return?ret;

	}

	//?查詢所有圖書
	public?ArrayList?queryAllBook（）?{
		ArrayList?list?=?new?ArrayList（）;
		Connection?conn?=?Dbutil.getConn（）;

		try?{
			PreparedStatement?ps?=?conn.prepareStatement（“select?*?from?books“）;
			ResultSet?rs?=?ps.executeQuery（）;
			while?（rs.next（））?{
				int?id?=?rs.getInt（1）;
				String?name?=?rs.getString（2）;
				float?price?=?rs.getFloat（3）;
				Book?book?=?new?Book（id?name?price）;
				list.add（book）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}

		return?list;
	}

}

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

?????文件????????377??2011-07-05?08:53??tushugl\.classpath

?????文件????????383??2011-07-05?08:34??tushugl\.project

?????文件????????629??2011-07-05?08:34??tushugl\.settings\org.eclipse.jdt.core.prefs

?????文件???????3447??2011-07-09?21:44??tushugl\bin\com\tushugl\daos\Bookdao.class

?????文件???????1289??2011-07-09?21:44??tushugl\bin\com\tushugl\DbUtil\Dbutil.class

?????文件???????4088??2011-07-09?21:44??tushugl\bin\com\tushugl\ui\MainUi.class

?????文件???????1190??2011-07-09?21:44??tushugl\bin\com\tushugl\vos\Book.class

?????文件???????2465??2011-07-05?16:10??tushugl\src\com\tushugl\daos\Bookdao.java

?????文件????????620??2011-07-05?10:28??tushugl\src\com\tushugl\DbUtil\Dbutil.java

?????文件???????2907??2011-07-05?16:10??tushugl\src\com\tushugl\ui\MainUi.java

?????文件????????687??2011-07-05?14:41??tushugl\src\com\tushugl\vos\Book.java

?????目錄??????????0??2011-07-09?21:44??tushugl\bin\com\tushugl\daos

?????目錄??????????0??2011-07-09?21:44??tushugl\bin\com\tushugl\DbUtil

?????目錄??????????0??2011-07-09?21:44??tushugl\bin\com\tushugl\ui

?????目錄??????????0??2011-07-09?21:44??tushugl\bin\com\tushugl\vos

?????目錄??????????0??2011-07-09?21:44??tushugl\src\com\tushugl\daos

?????目錄??????????0??2011-07-09?21:44??tushugl\src\com\tushugl\DbUtil

?????目錄??????????0??2011-07-09?21:44??tushugl\src\com\tushugl\ui

?????目錄??????????0??2011-07-09?21:44??tushugl\src\com\tushugl\vos

?????目錄??????????0??2011-07-09?21:44??tushugl\bin\com\tushugl

?????目錄??????????0??2011-07-09?21:44??tushugl\src\com\tushugl

?????目錄??????????0??2011-07-09?21:44??tushugl\bin\com

?????目錄??????????0??2011-07-09?21:44??tushugl\src\com

?????目錄??????????0??2011-07-09?21:44??tushugl\.settings

?????目錄??????????0??2011-07-09?21:44??tushugl\bin

?????目錄??????????0??2011-07-09?21:44??tushugl\src

?????目錄??????????0??2011-07-09?21:44??tushugl

-----------?---------??----------?-----??----

????????????????18082????????????????????27



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