project_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.Project;


public class Project_Manager {
	
	public static boolean HasProject(String project_id)
	{
		String query = "select * from project where project_id='"+project_id+"'";

		int count = DataProcess.nCount(query);


		if(count>0)
		{
			return true;
		}
		else
			return false;
	}
	
	public static void Add_Project(String title,String content,String datatime,String manager_name,String employee_name,String project_id)
	{
		try
		{
			title=new String(title.getBytes("ISO8859_1"));
		
			content=new String(content.getBytes("ISO8859_1"));
			
			datatime=new String(datatime.getBytes("ISO8859_1"));		
			
		    employee_name=new String(employee_name.getBytes("ISO8859_1"));
			
			project_id=new String(project_id.getBytes("ISO8859_1"));
		   
			manager_name=new String(manager_name.getBytes("ISO8859_1"));
			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		String query = "insert into project(title,content,datatime,manager_name,employee_name,project_id) values('"+title+
						"','"+content+"','"+datatime+"','"+manager_name+"','"+employee_name+"','"+project_id+"')";
		
		try
		{
			DataProcess.ExeQuery(query);
		}
		catch(Exception e){
			e.printStackTrace();
		}
		
	}
	

	
	public static void Edit_Project(String title,String content,String datatime,String employee_name,String project_id)
	{
		try
		{
			title=new String(title.getBytes("ISO8859_1"));
			
			content=new String(content.getBytes("ISO8859_1"));
			
		    datatime=new String(datatime.getBytes("ISO8859_1"));	
            
            employee_name=new String(employee_name.getBytes("ISO8859_1"));
		
		
		
		    
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		String query = "update project set title='"+title+
						"',content='"+content+"',datatime='"+datatime+"',employee_name='"+employee_name+"',project_id='"+project_id+"' where project_id="+project_id;
		
		try
		{
			DataProcess.ExeQuery(query);
		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
	
	public static void Delete_Project(String project_id)
	{
		String query = "delete from project where project_id="+project_id;
		
		try
		{
			DataProcess.ExeQuery(query);
		}
		catch(Exception e){
			e.printStackTrace();
		}
		
	}
	
	public static void Delete_Plan(String project_id)
	{
		String query = "update project set plan='"+"无 "+"'  where project_id="+project_id;
		
		try
		{
			DataProcess.ExeQuery(query);
		}
		catch(Exception e){
			e.printStackTrace();
		}
		
	}
	
	public static void Edit_Plan(String plan,String project_id)
	{
		try
		{
		
			
			plan=new String(plan.getBytes("ISO8859_1"));
			
          
		
			project_id=new String(project_id.getBytes("ISO8859_1"));
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		String query = "update project set plan='"+plan+"' where project_id="+project_id;
		
		try
		{
			DataProcess.ExeQuery(query);
		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
	
	public static void Edit_Evolve(String evolve,String project_id)
	{
		try
		{
		
			
			evolve=new String(evolve.getBytes("ISO8859_1"));
			
            project_id=new String(project_id.getBytes("ISO8859_1"));
		
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		String query = "update project set evolve='"+evolve+"' where project_id="+project_id;
		
		try
		{
			DataProcess.ExeQuery(query);
		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
	
	public static Project getProject(String project_id)
	{
		String selectStr = "select * from project where Project_id="+project_id;
		
		Connection con = DataProcess.getConnection();
		
		Project pro = Project.getInstance();
		
		try{
			
			Statement stmt = con.createStatement();
			
			ResultSet rs = stmt.executeQuery(selectStr);
			
			if(rs.next())
			{				
				
				
				String title = rs.getString("title");
				
				String content = rs.getString("content");
								
				String plan=rs.getString("plan");
				
				String datatime = rs.getString("datatime");
				
				String manager_name=rs.getString("manager_name");
				
				String employee_name=rs.getString("employee_name");
				String evolve=rs.getString("evolve");
				
				pro.setProject_id(project_id);
				
				pro.setTitle(title);
				
				pro.setContent(content);
				
				pro.setPlan(plan);
				
				pro.setDatatime(datatime);
			
			    pro.setMagager_name(manager_name);
			    
			    pro.setEmployee_name(employee_name);
			
			    pro.setEvolve(evolve);
			}
			
			rs.close();
			
			stmt.close();
			
			con.close();
			
			return pro;
		
		}
		catch(Exception e)
		{
			e.printStackTrace();
			
			return null;
		}
	}

	public static ArrayList getManagerProjectList(String manager_name)
	{
		try
		{
			
			manager_name=new String(manager_name.getBytes("ISO8859_1"));
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		
		String query = "select id,title,content,plan,datatime,manager_name,employee_name,project_id ,evolve from project where manager_name=(select manager_name from manager where manager_name='"+manager_name+"')";
		
		Connection con = DataProcess.getConnection();
		
		ArrayList pl = new ArrayList();
		
		try{
			
			Statement stmt = con.createStatement();
			
			ResultSet rs = stmt.executeQuery(query);
			
			while(rs.next())
			{				
				String project_id = rs.getString("project_id");
				
				String title = rs.getString("title");
				
				String content = rs.getString("content");
								
				String plan = rs.getString("plan");
				
				String datatime=rs.getString("datatime");
				
				String employee_name=rs.getString("employee_name");
				
				String evolve=rs.getString("evolve");
				Project pro = Project.getInstance();
				
				pro.setProject_id(project_id);
				
				pro.setTitle(title);
				
				pro.setContent(content);
				
				pro.setPlan(plan);
				
				pro.setDatatime(datatime);
				
				pro.setMagager_name(manager_name);
				
				pro.setEmployee_name(employee_name);
				
				pro.setEvolve(evolve);
				pl.add(pro);
			}
			
			rs.close();
			
			stmt.close();
			
			con.close();
			
			return pl;
		
		}
		catch(Exception e)
		{
			e.printStackTrace();
			
			return null;
		}
		
	}	

	
	public static ArrayList getEmployeePlanList(String employee_name)
	{
		try
		{
			
			employee_name=new String(employee_name.getBytes("ISO8859_1"));
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		
		String query = "select id,title,content,plan,datatime,manager_name,employee_name,project_id,evolve from project where employee_name=(select employee_name from employee where employee_name='"+employee_name+"')";
		
		Connection con = DataProcess.getConnection();
		
		ArrayList pl = new ArrayList();
		
		try{
			
			Statement stmt = con.createStatement();
			
			ResultSet rs = stmt.executeQuery(query);
			
			while(rs.next())
			{				
				
				
				String title = rs.getString("title");
				
				String content = rs.getString("content");
								
				String plan = rs.getString("plan");
				
				String datatime=rs.getString("datatime");
				
				String project_id=rs.getString("project_id");
				
				String manager_name=rs.getString("manager_name");
				
				String evolve=rs.getString("evolve");
				
				Project pro = Project.getInstance();
				
				pro.setProject_id(project_id);
				
				pro.setTitle(title);
				
				pro.setContent(content);
				
				pro.setPlan(plan);
				
				pro.setDatatime(datatime);
				
				pro.setMagager_name(manager_name);
				
				pro.setEmployee_name(employee_name);
				
				pro.setEvolve(evolve);
				pl.add(pro);
			}
			
			rs.close();
			
			stmt.close();
			
			con.close();
			
			return pl;
		
		}
		catch(Exception e)
		{
			e.printStackTrace();
			
			return null;
		}
		
	}	
}