package?bookstore.bean;

import?java.sql.Blob;?????//
import?java.sql.Connection;????//
import?java.sql.PreparedStatement?;??//
import?java.sql.SQLException;???//
import?java.sql.Statement;??????//
import?java.util.Vector;????
import?org.apache.log4j.*;
import?bookstore.model.DBAccess;

public?class?BookBean?{

	public?Logger?log?=?Logger.getLogger（this.getClass（）.getName（））;

	private?int?bookId?=?0;

	private?int?sortId?=?0;

	private?String?bookName?=?“dd“;

	private?double?price?=?0.0;

	private?double?salePrice?=?90000.0;

	private?String?bookDesc?=?null;

	private?String?author?=?null;

	private?String?image?=?null;

	private?String?publish?=?null;
	private?String?join_date?=?null;???
	public?BookBean（）?{

	}

	public?void?setBookId（int?bookId）?{

		this.bookId?=?bookId;
	}

	public?int?getBookId（）?{

		return?this.bookId;
	}

	public?void?setSortId（int?sortId）?{

		this.sortId?=?sortId;
	}

	public?int?getSortId（）?{

		return?this.sortId;
	}

	public?void?setBookName（String?bookName）?{

		this.bookName?=?bookName;
	}

	public?String?getBookName（）?{

		return?this.bookName;
	}

	public?void?setPrice（double?price）?{

		this.price?=?price;
	}

	public?double?getPrice（）?{

		return?this.price;
	}

	public?void?setSalePrice（double?salePrice）?{

		this.salePrice?=?salePrice;
	}

	public?double?getSalePrice（）?{

		return?this.salePrice;
	}

	public?void?setBookDesc（String?bookDesc）?{

		this.bookDesc?=?bookDesc;
	}

	public?String?getBookDesc（）?{

		return?this.bookDesc;
	}

	public?void?setAuthor（String?author）?{

		this.author?=?author;
	}

	public?String?getAuthor（）?{

		return?this.author;
	}

	public?void?setImage（String?image）?{

		this.image?=?image;
	}

	public?String?getImage（）?{

		return?this.image;
	}

	public?void?setPublish（String?publish）?{
		this.publish?=?publish;
	}

	public?String?getPublish（）?{
		return?this.publish;
	}
	public?void?setJoinDate（String?join_date）?{????//出版時間

		this.join_date?=?join_date;
	}

	public?String?getJoinDate（）?{

		return?this.join_date;
	}

	/**
	?*?通過種類查詢圖書的方法
	?*?
	?*?@param?sortId
	?*????????????圖書種類Id
	?*?@return
	?*/
	public?Vector?bookQuery（String?sortId）?{

		String?strSql;
		Vector?vecBook?=?null;
		String[][]?strTemp?=?null;
		DBAccess?dba?=?new?DBAccess（）;
		strSql?=?“select?*?from?book_info?where?sort_id=‘“?+?sortId?+?“‘“;
		System.out.println（“strSql:“?+?strSql）;
		strTemp?=?dba.Query（strSql）;
		if?（strTemp?!=?null?&&?strTemp.length?>?0）?{
			vecBook?=?new?Vector（）;
			for?（int?i?=?0;?i?				BookBean?bookBean?=?new?BookBean（）;
				bookBean.setBookId（（new?Integer（strTemp[i][0].trim（）））
						.intValue（））;
				bookBean.setSortId（（new?Integer（strTemp[i][1].trim（）））
						.intValue（））;
				bookBean.setBookName（strTemp[i][2]）;
				bookBean.setPrice（new?Double（strTemp[i][3].trim（））.doubleValue（））;
				bookBean.se