employee_manager.java

这是基于jsp的任务管理系统

package cn.project.bit.business;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import cn.project.bit.DBQuery.DataProcess;
import cn.project.bit.Object.Employee;
import cn.project.bit.Object.Manager;


public class Employee_Manager {

	
	public static boolean CheckEmployee(String employee_name,String employee_password)
	{
		try
		{
			employee_name=new String(employee_name.getBytes("ISO8859_1"));
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		String query = "select count(*) from employee where employee_name='"+employee_name+
						"' and employee_password='"+employee_password+"'";
		
		int count = DataProcess.nCount(query);
		
		
		if(count>0)
		{
			return true;
		}
		else
			return false;
	}
	
	public static boolean HasEmployee(String employee_name)
	{
		
		
		String query = "select count(*) from employee where employee_name='"+employee_name+"'";

		int count = DataProcess.nCount(query);


		if(count>0)
		{
			return true;
		}
		else
			return false;
	}
	
	public static void add_Employee(String employee_name,String employee_password,String department)
	{
	
			
		String query = "insert into employee(employee_name,employee_password,department) values('"+employee_name+
						"','"+employee_password+"','"+department+"')";
		
		try
		{
			DataProcess.ExeQuery(query);
		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
	
	public static void Edit_Employee(int ID,String employee_name,String employee_password,String department)
	{
		
		
		String query = "update employee set employee_name='"+employee_name+
		"',employee_password='"+employee_password+"',department='"+department+"' where employee_id="+ID;
		
		try
		{
			DataProcess.ExeQuery(query);
		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
	
	public static void Delete_Employee(int ID)
	{
		String query =  "delete from employee where employee_id="+ID;
		System.out.println(query);
		try
		{
			DataProcess.ExeQuery(query);
		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
	
	
	public static Employee getEmployee(int ID)
	{
		String query = "select * from employee where employee_id="+ID;
		
		Connection con = DataProcess.getConnection();
		
		Employee ad = Employee.getInstance();
		
		try{
			
			Statement stmt = con.createStatement();
			
			ResultSet rs = stmt.executeQuery(query);
			
			if(rs.next())
			{				
				int employee_id=rs.getInt("employee_id");
				
				String employee_name = rs.getString("employee_name");
				
				String employee_password = rs.getString("employee_password");
								
				String department=rs.getString("department");
			
				ad.setId(employee_id);
				ad.setEmployeename(employee_name);
				
				ad.setEmployeepassword(employee_password);
				ad.setDepartment(department);
				
				
			}
			
			rs.close();
			
			stmt.close();
			
			con.close();
			
			return ad;
		
		}
		catch(Exception e)
		{
			e.printStackTrace();
			
			return null;
		}
	}

	public static ArrayList getEmployee()
	{
		String query = "select * from employee";
		
		Connection con = DataProcess.getConnection();
		
		ArrayList al = new ArrayList();
		
		try{
			
			Statement stmt = con.createStatement();
			
			ResultSet rs = stmt.executeQuery(query);
			
			while(rs.next())
			{				
				int employee_id=rs.getInt("employee_id");
				
				String employee_name = rs.getString("employee_name");
				
				String employee_password = rs.getString("employee_password");
				String department=rs.getString("department");
			
				
				Employee ad =Employee.getInstance();
				
				ad.setId(employee_id);
				ad.setEmployeename(employee_name);
				
				ad.setEmployeepassword(employee_password);
				ad.setDepartment(department);
				al.add(ad);
				System.out.println("employee_id="+employee_id);
				System.out.println("employee_name="+employee_name);
			    System.out.println("employee_password="+employee_password);
			    System.out.println("department="+department);
			}
			
			rs.close();
			
			stmt.close();
			
			con.close();
			
			return al;
		
		}
		catch(Exception e)
		{
			e.printStackTrace();
			
			return null;
		}
		
		
	}
	
}