departmentbean.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.Department;
import bugtrail.util.CharsetProcess;
import bugtrail.util.SqlHelper;

public class DepartmentBean {
	private SqlHelper helper;

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

	public Vector getDepartmentNames()throws Exception{
		helper = new SqlHelper();
		ResultSet rs = helper.executeHelper("select * from department");
		Vector<Department> list = new Vector<Department>();
		while(rs.next()){
			Department temp = new Department();
			temp.setDepartmentID(rs.getInt("departmentID"));
			temp.setName(rs.getString("name"));
			list.add(temp);
		}
		helper.closeAll();
		return list;
	 }
	public String getDepartmentName(int departmentID) throws Exception{
		String departmentName = null;
		helper = new SqlHelper();
		ResultSet rs = helper.executeHelper("select name from department where departmentID='"
				+departmentID+"'");
		while(rs.next())
			departmentName = rs.getString(1);
		helper.closeAll();
		return departmentName;
	}
	
	public void addDepartment(String name) throws Exception{
		helper = new SqlHelper();
		helper.updateHelper("insert into department(name) values('"
				+CharsetProcess.U2C(name)+"')");
		helper.closeAll();
	}
	
	public void deleteDepartment(int depID) throws Exception{
		helper = new SqlHelper();
		helper.updateHelper("delete from department where departmentID='"
				+depID+"'");
		helper.closeAll();
	}
	
	public Department getDepartment(int depID) throws Exception{
		Department dep = new Department();
		helper = new SqlHelper();
		ResultSet rs = helper.executeHelper("select * from department where departmentID='"
				+depID+"'");
		while(rs.next()){	
			dep.setDepartmentID(rs.getInt("departmentID"));
			dep.setName(rs.getString("name"));
		}
		helper.closeAll();
		return dep;
	}
}