department.java

jsp动态网站开发技术与实践 电子工业出版社 随书附赠源代码

package com.chapter15;

import java.sql.*;

public class Department extends ExecuteDB
{
	//定义类成员变量
	private long DepartmentID;    
	private String DepartmentName;       
	private long ManagerID;   
	private String strSql;
	
    
    //初始化类成员变量
	public Department()
	{
		this.DepartmentID=0;        
		this.DepartmentName="";		
		this.ManagerID=0;	
		this.strSql=""; 
	}
   
	//向departments数据表中添加一条新记录
	public boolean add()
	{
        
		this.strSql="insert into departments ";
		this.strSql=this.strSql + "(DepartmentName,ManagerID) ";       
		this.strSql=this.strSql + "values('" + this.DepartmentName + "','" + this.ManagerID + "')";
		
		boolean isAdd = super.exeSql(this.strSql);		
		return isAdd;
	}   
	
	//判断部门名称是否存在
	public boolean exist()
	{
		this.strSql="select * from departments ";
		this.strSql=this.strSql + " where DepartmentName='" + this.DepartmentName + "'"; 	
		try
		{
			ResultSet rs = super.exeQuery(this.strSql); 
			if (rs.next())
				return true;
			else
				return false;		
		}
		catch(Exception e)
		{		    
			return false;
		}
	}

   
  	//修改类成员变量DepartmentID对应的部门信息
	public boolean modify()
	{
		this.strSql="update departments set ";	
		this.strSql=this.strSql + "DepartmentName=" + "'" + this.DepartmentName + "',";
		this.strSql=this.strSql + "ManagerID=" + "'" + this.ManagerID + "'";	
		this.strSql=this.strSql + " where DepartmentID=" + this.DepartmentID;		
		
		boolean isUpdate = super.exeSql(this.strSql);		
		return isUpdate;
	}	
   
 	//删除sDepartmentID对应的部门信息
	public boolean delete(String sDepartmentID)
	{
		this.strSql="delete from departments where DepartmentID in (";
		this.strSql=this.strSql + sDepartmentID + ")";
		
		boolean isDelete = super.exeSql(this.strSql);		
		return isDelete;
	}
	
   
	//获取类成员变量DepartmentID对应的部门信息
	public boolean init()
	{
		this.strSql="select * from departments where DepartmentID=";
		this.strSql=this.strSql + this.DepartmentID;        

		try
		{
			ResultSet rs = super.exeQuery(this.strSql);
			if (rs.next())
			{
				this.DepartmentID=rs.getLong("DepartmentID");                
				this.DepartmentName=rs.getString("DepartmentName"); 
				this.ManagerID=rs.getInt("ManagerID");   
				return true;
			}
			else
				return false;			
		}
		catch(Exception e)
		{		 
			return false;
		}
	}
	
	//获取所有部门信息，返回一个ResultSet类型对象
	public ResultSet show_departments()
	{
		this.strSql="select * from departments";
		ResultSet rs = null;              
		try
		{
			rs = super.exeQuery(this.strSql); 
		}
		catch(Exception e)
		{
			System.out.println(e.toString());            
		}
		return rs;        
	} 
   
	//设置类成员变量DepartmentID的值 
	public void setDepartmentID(long DepartmentID)
	{
		this.DepartmentID = DepartmentID;	
	}   

	//获取类成员变量DepartmentID的值  
	public long getDepartmentID()
	{
		return this.DepartmentID;	
	} 
	
	 //设置类成员变量DepartmentName的值 
 	public void setDepartmentName(String DepartmentName)
	{
		this.DepartmentName = DepartmentName;	
	}   

	//获取类成员变量DepartmentName的值  
	public String getDepartmentName()
	{
		return this.DepartmentName;	
	} 
	
	//设置类成员变量ManagerID的值 
 	public void setManagerID(long ManagerID)
	{
		this.ManagerID = ManagerID;	
	}   

	//获取类成员变量ManagerID的值  
	public long getManagerID()
	{
		return this.ManagerID;	
	}
}