package com.bitc.store;

//定義Bean所屬的套件



//定義欲使用的套件

import java.sql.*;



public class BookList

{

	//與資料庫連結有關的Bean屬性

	private Connection con = null;

	private Statement stmt = null;

	private ResultSet BookRs = null;



	public BookList()  //建構子

	{		

	}	



	//以下為設定Bean屬性的方法

	public void InitBookRs(Connection con, String filter)

	{

		try{

			if(this.con != con)

			{

				this.con = con;				

			}			



			stmt = con.createStatement(

					ResultSet.TYPE_SCROLL_INSENSITIVE,

					ResultSet.CONCUR_READ_ONLY);

			//建立Statement物件		



			BookRs = stmt.executeQuery

				 ("SELECT * FROM Book WHERE " + filter);

			//執行SQL敘述從Book資料表取得記錄

		}

		catch(SQLException sex)

		{

			System.out.println(sex.toString());

		}		

	}



	//關閉ResultSet物件

	public void CloseBookRs ()

	{ 

		try{

			if(BookRs != null)

			{

				BookRs.close();

				BookRs = null;

			}



			if(stmt != null)

			{

				stmt.close();

				stmt = null;

			}

		}

		catch(SQLException sex)

		{

			System.out.println(sex.toString());

		}

	}



	//移至下一筆記錄

	public boolean next()

	{

		boolean result = false;

		

		try{

			result = BookRs.next();			

		}

		catch(SQLException sex)

		{

			System.out.println(sex.toString());

		}		

		return result;

	}



	//取得記錄集中ID欄位的資料	

	public String getID()

	{

		String result = null;



		try{

			result = BookRs.getString("ID");

		}

		catch(SQLException sex)

		{

			System.out.println(sex.toString());

		}		

		return result;

	}

	

	//取得記錄集中BookID欄位的資料

	public String getBookID()

	{ 

		String result = null;



		try{

			result = BookRs.getString("BookID");

		}

		catch(SQLException sex)

		{

			System.out.println(sex.toString());

		}		

		return result;

	}	

	

	//取得記錄集中BookNm欄位的資料

	public String getBookNm()

	{ 

		String result = null;

		try{

			result = BookRs.getString("BookNm");

		}

		catch(SQLException sex)

		{

			System.out.println(sex.toString());

		}		

		return result;

	}



	//取得記錄集中Author欄位的資料

	public String getAuthor()

	{ 

		String result = null;



		try{

			result = BookRs.getString("Author");

		}

		catch(SQLException sex)

		{

			System.out.println(sex.toString());

		}



		return result;

	}



	//取得記錄集中Price欄位的資料

	public String getPrice()

	{ 

		String result = null;



		try{

			result = BookRs.getString("Price");

		}

		catch(SQLException sex)

		{

			System.out.println(sex.toString());

		}		

		return result;

	}



	//取得記錄集中Abstract欄位的資料

	public String getAbstract()

	{ 

		String result = null;



		try{

			result = BookRs.getString("Abstract");

		}

		catch(SQLException sex)

		{

			System.out.println(sex.toString());

		}		

		return result;

	}

}