bugbean.java

来自「1 系统简介 1.1 系统名称：bugtrail 1.2 适用范围：大型或小」· Java 代码 · 共 304 行

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

import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.Enumeration;
import java.util.Vector;

import bugtrail.basic.Bug;
import bugtrail.basic.Staff;
import bugtrail.util.CharsetProcess;
import bugtrail.util.SqlHelper;

public class BugBean {
	private SqlHelper helper;
    private int totalCount = 0;
	
	//得到一个连接
//	public BugBean() throws Exception{
//		helper = new SqlHelper();
//	}
	
	//得到查询的bug总数
	public int getTotalCount(){
		return totalCount;
	}
	
	//添加bug
	public void addBug(Bug bug) throws Exception{
		helper = new SqlHelper();
		helper.updateHelper("insert into bug(title,state,priority,description,establishTime," +
				"finder,owner,project,file) values('"
				+CharsetProcess.U2C(bug.getTitle())
				+"','"+ 2
				+"','"+ CharsetProcess.U2C(bug.getPriority())
				+"','"+ CharsetProcess.U2C(bug.getDescription())
				+"','"+ (new SimpleDateFormat("yyyy-MM-dd hh:mm:ss")).format(bug.getEstablishTime())
				+"','"+ bug.getFinder()
				+"','"+ bug.getOwner()
				+"','"+ bug.getProject()
				+"','"+ bug.getFile()+"')");
		helper.closeAll();
	}
	
	//得到所有bug,分页显示
	public Vector getPartBug(Integer pageNum,Integer rows)throws Exception{
		helper = new SqlHelper();
		ResultSet rset = helper.executeHelper("select count(*) from bug");
		while(rset.next())
			totalCount = rset.getInt(1);
		
		ResultSet rs = helper.executeHelper("select * from bug",pageNum,rows);
		Vector<Bug> bugList = new Vector<Bug>();
		while(rs.next()){
			Bug temp = new Bug();
			temp.setBugID(rs.getInt("bugID"));
			temp.setTitle(rs.getString("title"));
			temp.setState(rs.getInt("state"));
			temp.setPriority(rs.getString("priority"));
			temp.setDescription(rs.getString("description"));
			temp.setEstablishTime(rs.getDate("establishTime"));
			temp.setLastEdit(rs.getInt("lastEdit"));
			temp.setFinder(rs.getInt("finder"));
			temp.setOwner(rs.getInt("owner"));
			temp.setValidater(rs.getInt("validater"));
			temp.setProject(rs.getInt("project"));
			bugList.add(temp);
		}
		helper.closeAll();
		return bugList;
	}

	//得到某个角色能看到的bug,分页显示
	public Vector getPartBug(Integer pageNum,Integer rows,
			int roleID)throws Exception{
		int a = 0,b = 0,c = 0,d = 0,e = 0,f = 0,g = 0,h = 0,i = 0,j = 0;
		helper = new SqlHelper();
		ResultSet rst = helper.executeHelper("select * from stateinit where roleID='"
				+roleID+"'");
		while(rst.next()){
			a  = rst.getInt("new")==1?1:0;
			b  = rst.getInt("wait_deal")==1?2:0;
			c  = rst.getInt("dealing")==1?3:0;
			d  = rst.getInt("wait_validate")==1?4:0;
			e  = rst.getInt("validating")==1?5:0;
			f  = rst.getInt("wait_decide")==1?6:0;
			g  = rst.getInt("_delayed")==1?7:0;
			h  = rst.getInt("closed")==1?8:0;
			i  = rst.getInt("reassign")==1?9:0;
			j  = rst.getInt("must_edit")==1?10:0;
		}
		rst.close();

		String state = a+","+b+","+c+","+d+","+e+","+f+","+g+","+h;
		
		ResultSet rset = helper.executeHelper("select count(*) from bug where state in("
				+state+")");
		while(rset.next())
			totalCount = rset.getInt(1);
		rset.close();
		
		ResultSet rs = helper.executeHelper("select * from bug where state in("
				+state+")",pageNum,rows);
		Vector<Bug> bugList = new Vector<Bug>();
		while(rs.next()){
			Bug temp = new Bug();
			temp.setBugID(rs.getInt("bugID"));
			temp.setTitle(rs.getString("title"));
			temp.setState(rs.getInt("state"));
			temp.setPriority(rs.getString("priority"));
			temp.setDescription(rs.getString("description"));
			temp.setEstablishTime(rs.getDate("establishTime"));
			temp.setLastEdit(rs.getInt("lastEdit"));
			temp.setFinder(rs.getInt("finder"));
			temp.setOwner(rs.getInt("owner"));
			temp.setValidater(rs.getInt("validater"));
			temp.setProject(rs.getInt("project"));
			bugList.add(temp);
		}
		helper.closeAll();
		return bugList;
	}


	//得到某个角色能看到的bug,分页显示
	public Vector getPartBug(Integer pageNum,Integer rows,
			int roleID,int staffID)throws Exception{
		int a = 0,b = 0,c = 0,d = 0,e = 0,f = 0,g = 0,h = 0,i = 0,j = 0;
		helper = new SqlHelper();
		ResultSet rst = helper.executeHelper("select * from stateinit where roleID='"
				+roleID+"'");
		while(rst.next()){
			a  = rst.getInt("new")==1?1:0;
			b  = rst.getInt("wait_deal")==1?2:0;
			c  = rst.getInt("dealing")==1?3:0;
			d  = rst.getInt("wait_validate")==1?4:0;
			e  = rst.getInt("validating")==1?5:0;
			f  = rst.getInt("wait_decide")==1?6:0;
			g  = rst.getInt("_delayed")==1?7:0;
			h  = rst.getInt("closed")==1?8:0;
			i  = rst.getInt("reassign")==1?9:0;
			j  = rst.getInt("must_edit")==1?10:0;
		}
        rst.close();
		
		String state = a+","+b+","+c+","+d+","+e+","+f+","+g+","+h;
		
		
		ResultSet rset = helper.executeHelper("select * from bug where state in("
				+state+") and owner='"+staffID+"'");
		while(rset.next())
			totalCount = rset.getInt(1);
		rset.close();
		
		ResultSet rs = helper.executeHelper("select * from bug where state in("
				+state+") and owner='"+staffID+"'",pageNum,rows);
		Vector<Bug> bugList = new Vector<Bug>();
		while(rs.next()){
			Bug temp = new Bug();
			temp.setBugID(rs.getInt("bugID"));
			temp.setTitle(rs.getString("title"));
			temp.setState(rs.getInt("state"));
			temp.setPriority(rs.getString("priority"));
			temp.setDescription(rs.getString("description"));
			temp.setEstablishTime(rs.getDate("establishTime"));
			temp.setLastEdit(rs.getInt("lastEdit"));
			temp.setFinder(rs.getInt("finder"));
			temp.setOwner(rs.getInt("owner"));
			temp.setValidater(rs.getInt("validater"));
			temp.setProject(rs.getInt("project"));
			bugList.add(temp);
		}
		helper.closeAll();
		return bugList;
	}
	
	//返回bug总条目数
	public Integer getTotalBug() throws Exception{
		Integer num = 0;
		helper = new SqlHelper();
		ResultSet rs = helper.executeHelper("select count(*) from bug");
		while(rs.next())
			num = rs.getInt(1);
		helper.closeAll();
		return num;
	}
	
	//返回某项目的bug总条目数
	public int getAvilableCount(int projectID) throws Exception{
		int num = 0;
		helper = new SqlHelper();
		ResultSet rs = helper.executeHelper("select count(*) from bug where project='" +
				+projectID+"'");
		while(rs.next())
			num = rs.getInt(1);
		helper.closeAll();
		return num;
	}
	
	//返回bug表里某状态的总条目数
	public int getCountByState(int state) throws Exception{
		int num = 0;
		helper = new SqlHelper();
		ResultSet rs = helper.executeHelper("select count(*) from bug where state='"
				+state+"'");
		while(rs.next())
			num = rs.getInt(1);
		helper.closeAll();
		return num;
	}
	
	public Bug getBug(int bugID) throws Exception{
		Bug bug = new Bug();
		helper = new SqlHelper();
		ResultSet rs = helper.executeHelper("select * from bug where bugID='"
				+bugID+"'");
		while(rs.next()){
			bug.setBugID(rs.getInt("bugID"));
			bug.setTitle(rs.getString("title"));
			bug.setState(rs.getInt("state"));
			bug.setPriority(rs.getString("priority"));
			bug.setDescription(rs.getString("description"));
			bug.setEstablishTime(rs.getDate("establishTime"));
			bug.setLastEdit(rs.getInt("lastEdit"));
			bug.setFinder(rs.getInt("finder"));
			bug.setOwner(rs.getInt("owner"));
			bug.setValidater(rs.getInt("validater"));
			bug.setProject(rs.getInt("project"));
			bug.setFile(rs.getString("file"));
		}
		helper.closeAll();
		return bug;
	}
	
	public Vector getBugByState(int bugState) throws Exception{
		helper = new SqlHelper();
		ResultSet rs = helper.executeHelper("select * from bug where state='"
				+bugState+"'");
		Vector<Bug> bugList = new Vector<Bug>();
		while(rs.next()){
			Bug temp = new Bug();
			temp.setBugID(rs.getInt("bugID"));
			temp.setTitle(rs.getString("title"));
			temp.setDescription(rs.getString("description"));
			temp.setState(rs.getInt("state"));
			temp.setPriority(rs.getString("priority"));
			temp.setEstablishTime(rs.getDate("establishTime"));
			temp.setLastEdit(rs.getInt("lastEdit"));
			temp.setOwner(rs.getInt("owner"));
			temp.setValidater(rs.getInt("validater"));
			temp.setFinder(rs.getInt("finder"));
			temp.setProject(rs.getInt("project"));
			bugList.add(temp);
		}
		helper.closeAll();
		return bugList;	
	}
	
	
	//修改bug状态,描述
	public void operateBug(int operatorID,int bugID,int state,String description) throws Exception{
		helper = new SqlHelper();
		helper.updateHelper("update bug set state='"+state+"',description='"
				+CharsetProcess.U2C(description)+"',lastEdit='"
				+operatorID+"' where bugID='"+bugID+"'");
		helper.closeAll();
	}
	
	//分配所有状态为待处理的给bug的属主
	public void assignAllEditBug(Vector bugs,int state)throws Exception{
		helper = new SqlHelper();
		for(Enumeration e = bugs.elements();e.hasMoreElements() ;){
			Bug bug = (Bug)e.nextElement();
			helper.updateHelper("update bug set state='"+state
					+"' where bugID='"+bug.getBugID()+"'");		
		}
		helper.closeAll();
	}
	
	//将bug分给某个开发者 并将其设为bug的owner
	public void assignEditBug(String []bugIDs,int state,int owner)throws Exception{
		helper = new SqlHelper();
		for(int i=0;i<bugIDs.length;i++){
			helper.updateHelper("update bug set state='"+state
					+"',owner='"+owner+"' where bugID='"+bugIDs[i]+"'");	
		}
		helper.closeAll();
	}
    //将bug分给某个测试者 并将其设为bug的validater
	public void assignValidateBug(String[] bugIDs, int state, int validater) throws Exception {
		helper = new SqlHelper();
		for(int i=0;i<bugIDs.length;i++){
			helper.updateHelper("update bug set state='"+state
					+"',validater='"+validater+"' where bugID='"+bugIDs[i]+"'");	
		}
		helper.closeAll();
	}
}