showmodulelist.java.svn-base

用JSP JAVA 做的 系统 只是初来扎到还望西黄！别乱来哦！

/** 
 *
 * @File name:  ShowModuleList.java
 * @Description:   
 * @Create on:  2008-4-10
 * @Author   :  孙韬
 *
 * @ChangeList
 * ---------------------------------------------------
 * Date         Editor              ChangeReasons
 *
 *
 */

package com.chis.model.frame;



import com.stframe.dao.DaoUtil;
import com.stframe.dao.PageUtil;
import com.stframe.form.ActionForm;
import com.stframe.servlet.ActionInstance;

public class ShowModuleList extends ActionInstance{
	
	public int execute(ActionForm af) throws Exception {		
		String page =(String)af.getHttpRequest().getParameter("currentpage");
		String name="";
		if(null!=af.getHttpRequest().getParameter("SEL_NAME")){
			name=(String)af.getHttpRequest().getParameter("SEL_NAME");
		}
		String path = af.getHttpRequest().getContextPath()+ "/Selevet.do?action=SHOW_MODULE_LIST";

		int ipage=0;
		if (page!=null&&!page.equals("")){
			ipage=Integer.valueOf(page);
		}
		
		String sql="select distinct * from VIEW_USERID_MODULE where NAME like '%"+name+"%' ";
		PageUtil pu=(PageUtil) DaoUtil.selectPage(af.getConnection(),sql, ipage, 4);
		pu.setPath(path);
		af.getHttpRequest().setAttribute("PAGE", ipage);
		af.getHttpRequest().setAttribute("MODULELIST", pu.getContext());
		af.getHttpRequest().setAttribute("pageUrl",pu.pageBar());
		af.getHttpRequest().setAttribute("SEL_NAME", name);
		return 1;
	}
}