catebean.java

网上书店 一个在线购物的完整例子-网上书店JSP系统。

package com.bitc.store;
//定义Bean所属的套件

//定义使用的套件
import java.sql.*;

public class CateBean
{
	//与资料库连结有关的Bean属性
	private Connection con = null;
	private Statement stmt = null;
	private ResultSet CateRs = null;

	public CateBean()  //建构子
	{		
	}

	//起始建立ResultSet物件
	public void InitCateRs(Connection con)
	{
		try{
			if (this.con != con)
				this.con = con;									
			stmt = con.createStatement(
					ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			//建立Statement物件	
			
			CateRs = stmt.executeQuery
				 ("SELECT * FROM Category");
			//执行SQL叙述
		}
		catch(SQLException sex)
		{
			System.out.println(sex.toString());
		}		
	}

	//关闭ResultSet物件与Statement物件
	public void CloseCateRs()
	{ 
		try{
			if(CateRs != null)
			{
				CateRs.close();
				CateRs = null;
			}
			
			if(stmt != null)
			{
				stmt.close();
				stmt = null;
			}
		}
		catch(SQLException sex)
		{
			System.out.println(sex.toString());
		}
	}

	//移至下一笔
	public boolean next()
	{ 
		boolean result = false;

		try{
			result = CateRs.next();
			//移至下一笔
		}
		catch(SQLException sex)
		{
			System.out.println(sex.toString());
		}		
		return result;
	}
	
	//取得记录集中的Category栏
	public String getCategory()
	{ 
		String result = null;

		try{
			result = CateRs.getString("Category");
		}
		catch(SQLException sex)
		{
			System.out.println(sex.toString());
		}		
		return result;
	}

	//取得记录集中的CateID栏
	public String getCateID()
	{ 
		String result = null;

		try{
			result = CateRs.getString("ID");
		}
		catch(SQLException sex)
		{
			System.out.println(sex.toString());
		}		
		return result;
	}
}