package?dao;

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

import?vo.Book;

import?dbc.DbConn;

public?class?BookDao?implements?IBookDAO?{
	protected?static?final?String?FIELDS_INSERT?=?“ISBNtitleAuthorBookPriceRemarks“;
	
	protected?static?String?INSERT_SQL?=?“insert?into?Book?（“?+?FIELDS_INSERT
			+?“）“?+?“values?（?????）“;
	protected?static?String?SELECT_SQL?=?“select?“?+?FIELDS_INSERT
			+?“?from?Book?where?ISBN=?“;
	protected?static?String?UPDATE_SQL?=?“update?book?set?ISBN=?title=?Author=?BookPrice=?Remarks=??where?ISBN=?“;
	protected?static?String?DELETE_SQL?=?“delete?from?Book?where?ISBN=?“;

	public?Book?create（Book?book）?throws?Exception?{
		Connection?con?=?null;
		PreparedStatement?prepStmt?=?null;
		ResultSet?rs?=?null;
		try?{
			con?=?DbConn.getConnection（）;
			prepStmt?=?con.prepareStatement（INSERT_SQL）;
			prepStmt.setString（1?book.getISBN（））;
			prepStmt.setString（2?book.gettitle（））;
			prepStmt.setString（3?book.getAuthor（））;
			prepStmt.setFloat（4?book.getBookPrice（））;
			prepStmt.setString（5?book.getRemarks（））;
			prepStmt.executeUpdate（）;
		}?catch?（Exception?e）?{
			//
		}?finally?{
			DbConn.free（rs?prepStmt?con）;
		}
		return?book;
	}

	public?Book?find（Book?book）?throws?Exception?{
		Connection?con?=?null;
		PreparedStatement?prepStmt?=?null;
		ResultSet?rs?=?null;
		Book?book2?=?null;
		try?{
			con?=?DbConn.getConnection（）;
			prepStmt?=?con.prepareStatement（SELECT_SQL）;
			prepStmt.setString（1?book.getISBN（））;
			rs?=?prepStmt.executeQuery（）;
			if?（rs.next（））?{
				book2?=?new?Book（）;
				book2.setISBN（rs.getString（1））;
				book2.settitle（rs.getString（2））;
				book2.setAuthor（rs.getString（3））;
				book2.setBookPrice（rs.getFloat（4））;
				book2.setRemarks（rs.getString（5））;
			}
		}?catch?（Exception?e）?{
			//?handle?exception
		}?finally?{
			DbConn.free（rs?prepStmt?con）;

			return?book2;
		}
	}

	public?List?findAll（）?throws?Exception?{
		Connection?con?=?null;
		PreparedStatement?prepStmt?=?null;
		ResultSet?rs?=?null;
		List?student?=?new?ArrayList（）;
		con?=?DbConn.getConnection（）;
		prepStmt?=?con.prepareStatement（“select?*?from?Book“）;
		rs?=?prepStmt.executeQuery（）;
		while?（rs.next（））?{
			Book?book2?=?new?Book（）;
			book2.setId（rs.getInt（1））;
			book2.setISBN（rs.getString（2））;
			book2.settitle（rs.getString（3））;
			book2.setAuthor（rs.getString（4））;
			book2.setBookPrice（rs.getFloat（5））;
			book2.setRemarks（rs.getString（6））;
			book2.setNumber（rs.getInt（7））;
			student.add（book2）;
		}
		DbConn.free（rs?prepStmt?con）;
		return?student;
	}

	public?void?remove（Book?book）?throws?Exception?{
		Connection?con?=?null;
		PreparedStatement?prepStmt?=?null;
		ResultSet?rs?=?null;
		try?{
			con?=?DbConn.getConnection（）;
			prepStmt?=?con.prepareStatement（DELETE_SQL）;
			prepStmt.setString（1?book.getISBN（））;
			prepStmt.executeUpdate（）;
		}?catch?（Exception