manager_manager.java

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

 /*
 * 创建日期 2005-8-27
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
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.Manager;

/**
 * @author ligang
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class Manager_Manager {

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

		int count = DataProcess.nCount(query);


		if(count>0)
		{
			return true;
		}
		else
			return false;
	}
	
	public static void add_Manager(String manager_name,String manager_password,String department)
	{   
			
		String query = "insert into manager(manager_name,manager_password,department) values('"+manager_name+
						"','"+manager_password+"','"+department+"')";
		
		try
		{
			DataProcess.ExeQuery(query);
		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
	
	public static void Edit_Manager(int ID,String manager_name,String manager_password,String department)
	{
	
		
		
		String query = "update manager set manager_name='"+manager_name+
		"',manager_password='"+manager_password+"',department='"+department+"' where manager_id="+ID;
		
		try
		{
			DataProcess.ExeQuery(query);
		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
	
	public static void Delete_Manager(int ID)
	{
		String query =  "delete from manager where manager_id="+ID;
		System.out.println(query);
		try
		{
			DataProcess.ExeQuery(query);
		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
	
	
	public static Manager getManager(int ID)
	{
		String query = "select * from manager where manager_id="+ID;
		
		Connection con = DataProcess.getConnection();
		
		Manager ad = Manager.getInstance();
		
		try{
			
			Statement stmt = con.createStatement();
			
			ResultSet rs = stmt.executeQuery(query);
			
			if(rs.next())
			{				
				int manager_id=rs.getInt("manager_id");
				
				String manager_name = rs.getString("manager_name");
				
				String manager_password = rs.getString("manager_password");
								
				String department=rs.getString("department");
				
				
				ad.setId(manager_id);
				ad.setManagername(manager_name);
				
				ad.setManagerpassword(manager_password);
				ad.setDepartment(department);
				
				
			}
			
			rs.close();
			
			stmt.close();
			
			con.close();
			
			return ad;
		
		}
		catch(Exception e)
		{
			e.printStackTrace();
			
			return null;
		}
	}

	public static ArrayList getmanager()
	{
		String query = "select * from manager";
		
		Connection con = DataProcess.getConnection();
		
		ArrayList al = new ArrayList();
		
		try{
			
			Statement stmt = con.createStatement();
			
			ResultSet rs = stmt.executeQuery(query);
			
			while(rs.next())
			{				
				int manager_id=rs.getInt("manager_id");
				
				String manager_name = rs.getString("manager_name");
				
				String manager_password = rs.getString("manager_password");
				String department=rs.getString("department");
			
				
				Manager ad = Manager.getInstance();
				
				ad.setId(manager_id);
				ad.setManagername(manager_name);
				
				ad.setManagerpassword(manager_password);
				ad.setDepartment(department);
				al.add(ad);
				System.out.println("manager_id="+manager_id);
				System.out.println("manager_name="+manager_name);
			    System.out.println("manager_password="+manager_password);
			    System.out.println("department="+department);
			}
			
			rs.close();
			
			stmt.close();
			
			con.close();
			
			return al;
		
		}
		catch(Exception e)
		{
			e.printStackTrace();
			
			return null;
		}
		
		
	}
	
}