www.pudn.com > StoreJava.rar > CateBean.java

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