booklist.java

网上书店

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;
	}
}