rolebean.java

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

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

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

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

public class RoleBean {
	private SqlHelper helper;

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

	public Vector getRoleNames()throws Exception{
		helper = new SqlHelper();
		ResultSet rs = helper.executeHelper("select roleID,name from role");
		Vector<Role> list = new Vector<Role>();
		while(rs.next()){
			Role temp = new Role();
			temp.setRoleID(rs.getInt("roleID"));
			temp.setName(rs.getString("name"));
			list.add(temp);
		}
		helper.closeAll();
		return list;
	 }
	
	public String getRoleName(int roleID) throws Exception{
		String roleName = null;
		helper = new SqlHelper();
		ResultSet rs =  helper.executeHelper("select name from role where roleID='"
				+roleID+"'");
		while(rs.next())
			roleName = rs.getString(1);
		helper.closeAll();
		return roleName;
	}
	
	public Role getRole(int roleID) throws Exception{
		Role role = new Role();
		helper = new SqlHelper();
		ResultSet rs = helper.executeHelper("select * from role where roleID='"
				+roleID+"'");
		if(rs.next()){
			role.setRoleID(rs.getInt("roleID"));
			role.setName(rs.getString("name"));
			role.setSystemConfig(rs.getInt("systemConfig"));
			role.setUserConfig(rs.getInt("userConfig"));
			role.setProjectConfig(rs.getInt("projectConfig"));
			role.setAddBug(rs.getInt("addBug"));
			role.setEditBug(rs.getInt("editBug"));
			role.setValidateBug(rs.getInt("validateBug"));
			role.setAssign_wait_deal_Bug(rs.getInt("assign_wait_deal_Bug"));
			role.setAssign_wait_validate_Bug(rs.getInt("assign_wait_validate_Bug"));
			role.setDecideBug(rs.getInt("decideBug"));
		}
		helper.closeAll();
		return role;
	}
	
	public int getRoleID(String name) throws Exception{
		int roleID = 0;
		helper = new SqlHelper();
		ResultSet rs = helper.executeHelper("select roleID from role where name='"
				+name+"'");
		if(rs.next())
			roleID = rs.getInt(1);
		helper.closeAll();
		return roleID;
	}
	
	public void deleteRole(int roleID) throws Exception{
		helper = new SqlHelper();
		helper.updateHelper("delete from role where roleID='"
				+roleID+"'");
		helper.closeAll();
	}
	
	public void updateRole(Role role) throws Exception{
		helper = new SqlHelper();
		helper.updateHelper("update role set name='" 
				+ CharsetProcess.U2C(role.getName())
				+ "',systemConfig='" + role.getSystemConfig()
				+"',userConfig='"+ role.getUserConfig()
				+"',projectConfig='"+ role.getProjectConfig()
				+"', addBug='"+ role.getAddBug()
				+ "', editBug='"+ role.getEditBug()
				+ "', validateBug='"+ role.getValidateBug()
				+ "', assign_wait_deal_Bug='"+ role.getAssign_wait_deal_Bug()
				+ "', assign_wait_validate_Bug='"+ role.getAssign_wait_validate_Bug()
				+ "', decideBug='"+ role.getDecideBug()
				+ "' where roleID='"+ role.getRoleID() + "'");
		helper.closeAll();
	}
	
	public void addRole(Role role) throws Exception{
		helper = new SqlHelper();
		helper.updateHelper("insert into role(name,systemConfig,userConfig,projectConfig," +
				"addBug,editBug,validateBug,assign_wait_deal_Bug,assign_wait_validate_Bug," +
				"decideBug) values('"
				+ CharsetProcess.U2C(role.getName())
				+ "','" + role.getSystemConfig()
				+"','"+ role.getUserConfig()
				+"','"+ role.getProjectConfig()
				+"','"+ role.getAddBug()
				+ "','"+ role.getEditBug()
				+ "','"+ role.getValidateBug()
				+ "','"+ role.getAssign_wait_deal_Bug()
				+ "','"+ role.getAssign_wait_validate_Bug()
				+ "','"+ role.getDecideBug()
				+"')");
		helper.closeAll();
	}
}