bugstatebean.java

1 系统简介 1.1 系统名称：bugtrail 1.2 适用范围：大型或小型公司 1.3 用途：在项目周期内进行项目管理

/*
 * 创建日期 2007-1-1
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package bugtrail.bean;

import java.sql.ResultSet;
import java.util.Vector;

import bugtrail.basic.BugState;
import bugtrail.basic.Role;
import bugtrail.util.SqlHelper;

public class BugStateBean {
	private SqlHelper helper;

	//得到一个连接
//	public BugStateBean() throws Exception{
//		helper = new SqlHelper();
//	}

	public Vector getBugStateNames()throws Exception
	{
		helper = new SqlHelper();
		ResultSet rs = helper.executeHelper("select stateID,name from bugState");
		Vector<BugState> list = new Vector<BugState>();
		while(rs.next()){
			BugState temp = new BugState();
			temp.setBugStateID(rs.getInt("stateID"));
			temp.setName(rs.getString("name"));
			list.add(temp);
		}
		helper.closeAll();
		return list;
	 }
	
	public String getStateName(int stateID) throws Exception{
		String name = null;
		helper = new SqlHelper();
		ResultSet rs = helper.executeHelper("select name from bugState where stateID='"
				+stateID+"'");
		while(rs.next())
			name = rs.getString(1);
		helper.closeAll();
		return name;
	}

}