planinfoserver.java

该项目采用Struts框架

package com.cattsoft.plan.dao;

import java.sql.SQLException;
import java.util.List;

import com.cattsoft.vo.Plan;
import com.cattsoft.vo.Task;

public interface PlanInfoServer {
	//根据员工id查询任务信息
	public List<Task> queryTask(String emId)throws ClassNotFoundException, SQLException;
	//根据任务id查询任务详细信息
	public List<Task> queryTask(int tId)throws ClassNotFoundException, SQLException;
	//根据任务id修改任务状态
	public void update(int tId)throws ClassNotFoundException, SQLException;	
	//新增计划
	public int addPlan(Plan mp) throws ClassNotFoundException, SQLException;
	//根据任务id查询计划
	public List<Plan> query(int tId) throws ClassNotFoundException,SQLException;
	//根据计划id去删除对应的计划
	public void delPlan(int pId) throws ClassNotFoundException,SQLException;
	//修改任务状态
	public void updateTask(int tId)throws ClassNotFoundException, SQLException;	
	//根据计划id去查询对应计划的详细信息
	public List<Plan> queryBy(int pId) throws ClassNotFoundException,SQLException;
	//根据计划id和计划反馈信息更新计划表数据
	public void updatePlan(int pId,String p_state,String f_state,String fInfo,String fileName,String fileType) throws ClassNotFoundException,SQLException;
	//模糊查询计划信息
	public List<Plan> queryLike(String e_id,String pName,int tId,String pStime,String pStime2,String pEtime,String pEtime2,String fState) throws ClassNotFoundException,SQLException;
	//根据任务id去查询对应的任务名称
	public String selectBy(int tId) throws ClassNotFoundException,SQLException;
}