//代码生成时,文件路径: E:/platform/myProject/svn/oss/quickbundle/trunk/quickbundle-securityweb/src/main/java/org/quickbundle/third/quartz/rmschedulerevent/web/RmSchedulerEventAction.java
//代码生成时,系统时间: 2012-04-02 22:28:45
//代码生成时,操作系统用户: qb
/*
* 系统名称:单表模板 --> quickbundle-securityweb
*
* 文件名称: org.quickbundle.third.quartz.rmschedulerevent.web --> RmSchedulerEventAction.java
*
* 功能描述:
*
* 版本历史: 2012-04-02 22:28:45 创建1.0.0版 (白小勇)
*
*/
package org.quickbundle.third.quartz.rmschedulerevent.web;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.quickbundle.base.beans.factory.RmBeanFactory;
import org.quickbundle.base.web.page.RmPageVo;
import org.quickbundle.project.IGlobalConstants;
import org.quickbundle.project.cache.RmSqlCountCache;
import org.quickbundle.third.quartz.rmschedulerevent.service.IRmSchedulerEventService;
import org.quickbundle.third.quartz.rmschedulerevent.util.IRmSchedulerEventConstants;
import org.quickbundle.third.quartz.rmschedulerevent.vo.RmSchedulerEventVo;
import org.quickbundle.third.struts.actions.RmDispatchAction;
import org.quickbundle.tools.helper.RmJspHelper;
import org.quickbundle.tools.helper.RmPopulateHelper;
import org.quickbundle.tools.helper.RmSqlHelper;
import org.quickbundle.tools.helper.RmVoHelper;
/**
* 功能、用途、现存BUG:
*
* @author 白小勇
* @version 1.0.0
* @see 需要参见的其它类
* @since 1.0.0
*/
public class RmSchedulerEventAction extends RmDispatchAction implements IRmSchedulerEventConstants {
/**
* 得到Service对象
*
* @return Service对象
*/
public IRmSchedulerEventService getService() {
return (IRmSchedulerEventService) RmBeanFactory.getBean(SERVICE_KEY); //得到Service对象,受事务控制
}
/**
* 从页面表单获取信息注入vo，并插入单条记录
*
* @param mapping
* @param form
* @param request
* @param response
* @return
* @throws Exception
*/
public ActionForward insert(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
RmSchedulerEventVo vo = new RmSchedulerEventVo();
RmPopulateHelper.populate(vo, request); //从request中注值进去vo
RmVoHelper.markCreateStamp(request,vo); //打创建时间,IP戳
String id = getService().insert(vo); //插入单条记录
request.setAttribute(IGlobalConstants.INSERT_FORM_ID, id); //新增记录的id放入request属性
return mapping.findForward(FORWARD_TO_QUERY_ALL);
}
/**
* 从页面的表单获取单条记录id，并删除单条记录
*
* @param mapping
* @param form
* @param request
* @param response
* @return
* @throws Exception
*/
public ActionForward delete(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
int deleteCount = getService().delete(request.getParameter(REQUEST_ID)); //删除单条记录
request.setAttribute(EXECUTE_ROW_COUNT, deleteCount); //sql影响的行数放入request属性
return mapping.findForward(FORWARD_TO_QUERY_ALL);
}
/**
* 从页面的表单获取多条记录id，并删除多条记录
*
* @param mapping
* @param form
* @param request
* @param response
* @return
* @throws Exception
*/
public ActionForward deleteMulti(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
String[] id = RmJspHelper.getArrayFromRequest(request, REQUEST_IDS); //从request获取多条记录id
int deleteCount = 0; //定义成功删除的记录数
if (id != null && id.length != 0) {
deleteCount = getService().delete(id); //删除多条记录
}
request.setAttribute(EXECUTE_ROW_COUNT, deleteCount); //sql影响的行数放入request属性
return mapping.findForward(FORWARD_TO_QUERY_ALL);
}
/**
* 从页面的表单获取单条记录id，查出这条记录的值，并跳转到修改页面
*
* @param mapping
* @param form
* @param request
* @param response
* @return
* @throws Exception
*/
public ActionForward find(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
detail(mapping, form, request, response);
return mapping.findForward(FORWARD_UPDATE_PAGE);
}
/**
* 从页面表单获取信息注入vo，并修改单条记录
*
* @param mapping
* @param form
* @param request
* @param response
* @return
* @throws Exception
*/
public ActionForward update(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
RmSchedulerEventVo vo = new RmSchedulerEventVo();
RmPopulateHelper.populate(vo, request); //从request中注值进去vo
RmVoHelper.markModifyStamp(request,vo); //打修改时间,IP戳
int count = getService().update(vo); //更新单条记录
request.setAttribute(EXECUTE_ROW_COUNT, count); //sql影响的行数放入request属性
return mapping.findForward(FORWARD_TO_QUERY_ALL);
}
/**
* 批量保存，没有主键的insert，有主键的update
*
* @param mapping
* @param form
* @param request
* @param response
* @return
* @throws Exception
*/
public ActionForward insertUpdateBatch(ActionMapping mapping, ActionForm form, final HttpServletRequest request, HttpServletResponse response) throws Exception {
List<RmSchedulerEventVo> lvo = RmPopulateHelper.populateAjax(RmSchedulerEventVo.class, request);
for(RmSchedulerEventVo vo : lvo) {
if(vo.getId() != null && vo.getId().trim().length() > 0) {
RmVoHelper.markModifyStamp(request, vo);
} else {
RmVoHelper.markCreateStamp(request, vo);
}
}
int[] sum_insert_update = getService().insertUpdateBatch(lvo.toArray(new RmSchedulerEventVo[0]));
request.setAttribute(REQUEST_OUTPUT_OBJECT, sum_insert_update);
return mapping.findForward(FORWARD_TO_QUERY_ALL);
}
/**
* 简单查询，分页显示，支持表单回写
*
* @param mapping
* @param form
* @param request
* @param response
* @return
* @throws Exception
*/
public ActionForward simpleQuery(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
IRmSchedulerEventService service = getService();
String queryCondition = getQueryCondition(request); //从request中获得查询条件
RmPageVo pageVo = RmJspHelper.transctPageVo(request, getCount(queryCondition));
String orderStr = RmJspHelper.getOrderStr(request); //得到排序信息
List<RmSchedulerEventVo> beans = service.queryByCondition(queryCondition, orderStr, pageVo.getStartIndex(), pageVo.getPageSize()); //按条件查询全部,带排序
//如果采用下边这句，就是不带翻页的，同时需要删掉list页面的page.jsp相关语句
//beans = service.queryByCondition(queryCondition, orderStr); //查询全部,带排序
RmJspHelper.saveOrderStr(orderStr, request); //保存排序信息
request.setAttribute(REQUEST_QUERY_CONDITION, queryCondition);
request.setAttribute(REQUEST_BEANS, beans); //把结果集放入request
request.setAttribute(REQUEST_WRITE_BACK_FORM_VALUES, RmVoHelper.getMapFromRequest((HttpServletRequest) request)); //回写表单
return mapping.findForward(FORWARD_LIST_PAGE);
}
/**
* 查询全部记录，分页显示，支持页面上触发的后台排序
*
* @param mapping
* @param form
* @param request
* @param response
* @return
* @throws Exception
*/
public ActionForward queryAll(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
request.setAttribute(REQUEST_QUERY_CONDITION, "");
simpleQuery(mapping, form, request, response);
return mapping.findForward(FORWARD_LIST_PAGE);
}
/**
* 从页面的表单获取单条记录id，并察看这条记录的详细信息
*
* @param mapping
* @param form
* @param request
* @param response
* @return
* @throws Exception
*/
public ActionForward detail(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
RmSchedulerEventVo bean = getService().find(request.getParameter(REQUEST_ID)); //通过id获取vo
request.setAttribute(REQUEST_BEAN, bean); //把vo放入request
if(RM_YES.equals(request.getParameter(REQUEST_IS_READ_ONLY))) {
request.setAttribute(REQUEST_IS_READ_ONLY, request.getParameter(REQUEST_IS_READ_ONLY));
}
return mapping.findForward(FORWARD_DETAIL_PAGE);
}
/**
* 功能: 从request中获得查询条件
*
* @param request
* @return
*/
protected String getQueryCondition(HttpServletRequest request) {
String queryCondition = null;
if(request.getAttribute(REQUEST_QUERY_CONDITION) != null) { //如果request.getAttribute中有，就不取request.getParameter
queryCondition = request.getAttribute(REQUEST_QUERY_CONDITION).toString();
} else {
List<String> lQuery = new ArrayList<String>();
lQuery.add(RmSqlHelper.buildQueryStr(TABLE_NAME + ".job_name", request.getParameter("job_name"), RmSqlHelper.TYPE_CHAR_LIKE));
lQuery.add(RmSqlHelper.buildQueryStr(TABLE_NAME + ".job_group", request.getParameter("job_group"), RmSqlHelper.TYPE_CHAR_LIKE));
lQuery.add(RmSqlHelper.buildQueryStr(TABLE_NAME + ".trigger_name", request.getParameter("trigger_name"), RmSqlHelper.TYPE_CHAR_LIKE));
lQuery.add(RmSqlHelper.buildQueryStr(TABLE_NAME + ".trigger_group", request.getParameter("trigger_group"), RmSqlHelper.TYPE_CHAR_LIKE));
lQuery.add(RmSqlHelper.buildQueryStr(TABLE_NAME + ".fire_instance_id", request.getParameter("fire_instance_id"), RmSqlHelper.TYPE_CHAR_LIKE));
lQuery.add(RmSqlHelper.buildQueryStr(TABLE_NAME + ".event_type", request.getParameter("event_type"), RmSqlHelper.TYPE_CHAR_LIKE));
lQuery.add(RmSqlHelper.buildQueryStr(TABLE_NAME + ".cost_millis", request.getParameter("cost_millis_from"), RmSqlHelper.TYPE_NUMBER_GREATER_EQUAL));
lQuery.add(RmSqlHelper.buildQueryStr(TABLE_NAME + ".cost_millis", request.getParameter("cost_millis_to"), RmSqlHelper.TYPE_NUMBER_LESS_EQUAL));
lQuery.add(RmSqlHelper.buildQueryStr(TABLE_NAME + ".result_status", request.getParameter("result_status"), RmSqlHelper.TYPE_CUSTOM, "='", "'"));
lQuery.add(RmSqlHelper.buildQueryStr(TABLE_NAME + ".create_time", request.getParameter("create_time_from"), RmSqlHelper.TYPE_DATE_GREATER_EQUAL));
lQuery.add(RmSqlHelper.buildQueryStr(TABLE_NAME + ".create_time", request.getParameter("create_time_to"), RmSqlHelper.TYPE_DATE_LESS_EQUAL));
lQuery.add(RmSqlHelper.buildQueryStr(TABLE_NAME + ".create_ip", request.getParameter("create_ip"), RmSqlHelper.TYPE_CHAR_LIKE));
lQuery.add(RmSqlHelper.buildQueryStr(TABLE_NAME + ".uuid", request.getParameter("uuid"), RmSqlHelper.TYPE_CHAR_LIKE));
lQuery.add(RmSqlHelper.buildQueryStr(TABLE_NAME + ".is_archive", request.getParameter("is_archive"), RmSqlHelper.TYPE_CUSTOM, "='", "'"));
lQuery.add(RmSqlHelper.buildQueryStr(TABLE_NAME + ".result", request.getParameter("result"), RmSqlHelper.TYPE_CHAR_LIKE));
queryCondition = RmSqlHelper.appendQueryStr(lQuery.toArray(new String[0]));
}
return queryCondition;
}
/**
* 得到缓存中查询条件对应的count(*)记录数，如返回-1则执行查询
*
* @param queryCondition
* @return
*/
protected int getCount(String queryCondition) {
int count = RmSqlCountCache.getCount(TABLE_NAME, queryCondition);
if(count < 0) {
count = getService().getRecordCount(queryCondition);
RmSqlCountCache.putCount(TABLE_NAME, queryCondition, count);
}
return count;
}
}