queryaction.java

来自「这是一个轻便的j2ee的web应用框架,是一个在多个项目中运用的实际框架,采用s」· Java 代码 · 共 59 行

/*
 * Created on 2004-5-20
 *
 */
package com.esimple.framework.web.action.support;

import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.esimple.framework.web.action.BaseForm;
import com.esimple.framework.web.action.IbatisSupportAction;

/**
 * @author steven
 *
 */
public class QueryAction extends IbatisSupportAction {
	

	/* (non-Javadoc)
	 * @see com.esimple.framework.web.action.BaseAction#execute(com.esimple.framework.web.action.BaseForm, javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	 */
	protected String execute(
		BaseForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception {
		
		int begin;
		int length;
		String statement = form.getValueAsString(Constants.INPUT_dbstat,true);	
		try{
			begin = form.getValueAsInt(  Constants.INPUT_beginNum );
			length = form.getValueAsInt( Constants.INPUT_pageLength);
		}catch(Exception e)	{
			logger.info( "intput para beginNum,length not correct" );
			begin = 0;
			length = -1;
		}	
	
		if( statement == null ) return FORWARD_FAILURE;
		
		List list=null;
		if( length > 0 ){
			list = sqlMapDao.paginatedQuery(statement,form.getValues(),begin,length);
		}else{
			list = sqlMapDao.query(statement,form.getValues());
		}
		if( list != null){
			request.setAttribute(Constants.OUT_result, list);
			form.setValue(Constants.OUT_recordCount, list.size());
		}
		return FORWARD_SUCCESS;		
	}

}