taskservice.java

Webwork+Spring+Freemake框架

package neo.task.service;

import java.util.Map;

import neo.core.common.PagingList;
import neo.core.util.MapUtil;

public class TaskService extends BaseService {

	private static final String SQL_GET_TASKS_BY_USERID = "select * from task_tasks where userid = ? order by taskid asc";

	/**
	 * 获取用户任务列表
	 * 
	 * @param userId
	 *            用户编号
	 */
	public PagingList getTasksByUserId(Long userId) {
		return getPagingList(SQL_GET_TASKS_BY_USERID, new Object[] { userId });
	}

	private static final String SQL_ADD_TASK = "insert into task_tasks(taskid, taskname, userid) values (seq_task_tasks.nextval, ?, ?)";

	/**
	 * 添加新任务
	 * 
	 * @param taskName
	 *            任务名
	 * @param userId
	 *            用户编号
	 */
	public void addTask(String taskName, Long userId) {
		jt.update(SQL_ADD_TASK, new Object[] { taskName, userId });
	}

	private static final String SQL_CHANGE_TASK_STATUS = "update task_tasks set status = ? where taskid = ?";

	/**
	 * 修改任务状态
	 * 
	 * @param taskId
	 *            任务编号
	 * @param status
	 *            任务状态 可为0或1
	 */
	public void changeTaskStatus(Long taskId, Integer status) {
		jt.update(SQL_CHANGE_TASK_STATUS, new Object[] { status, taskId });
	}

	private static final String SQL_DELETE_TASK = "delete from task_tasks where taskid = ?";

	/**
	 * 删除任务
	 * 
	 * @param taskId
	 *            任务编号
	 */
	public void deleteTask(Long taskId) {
		jt.update(SQL_DELETE_TASK, new Object[] { taskId });
	}

	private static final String SQL_GET_TASK = "select * from task_tasks where taskid = ?";

	/**
	 * 获取任务信息
	 * 
	 * @param taskId
	 *            任务编号
	 */
	public Map getTask(Long taskId) {
		return jt.queryForMap(SQL_GET_TASK, new Object[] { taskId });
	}

	private static final String SQL_UPDATE_TASK = "update task_tasks set taskname = ? where taskid = ?";

	/**
	 * 更新任务
	 * 
	 * @param map
	 *            包含任务信息的Map
	 */
	public void updateTask(Map map) {
		Object[] params = MapUtil
				.getObjectArrayFromMap(map, "taskName, taskId");
		jt.update(SQL_UPDATE_TASK, params);
	}
}