文章标题

第三步 action
package com.isoftstone.zfmi.struts.action.claim;

import java.util.ArrayList;
import java.util.List;

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

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.isoftstone.iaeap.op.DBPersistenceManager;
import com.isoftstone.iaeap.op.OPSysManager;
import com.isoftstone.iaeap.op.QuerySet;

import com.isoftstone.zfmi.boc.Application.entity.Code;
import com.isoftstone.zfmi.boc.Application.entity.Codefilee;

/**
* @author 1
* wj 编码规则多级菜单的跳转
*
*/
public class ProjectAction extends Action{

public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request,
        HttpServletResponse response) throws Exception {
    // TODO 自动生成方法存根

     String aa = request.getParameter("project");


    List realsubcodetypeList = new ArrayList();
    List<Codefilee> list4 = new ArrayList();

        Object[] paras = {};

        DBPersistenceManager dbpm = OPSysManager.getInstance().getDBPersistenceManager();



     try{
         dbpm.currentTransaction().begin();

         String sql3="SELECT a.realsubcodetype FROM tb_code_filee a where flag='1' group by realsubcodetype,grade order by grade";

         QuerySet dptSet2 = dbpm.executeQuery(sql3, paras);
         int num3 = dptSet2.getRowCount();
            if(num3>0){
                 for( int i=1; i<= num3; i++ ){
                     String realsubcodetype =dptSet2.getString(i,"realsubcodetype");//标题编号 
                     realsubcodetypeList.add(realsubcodetype);

                 }
            }
            for (int i = 0; i < realsubcodetypeList.size(); i++) {
                String strRealsubcodetype = (String)realsubcodetypeList.get(i);

                Object[] paras1 = {strRealsubcodetype};


            String sql1 = " SELECT t.* FROM tb_code_filee t where realsubcodetype=? ";
            QuerySet dptSet = dbpm.executeQuery(sql1, paras1);
            int num = dptSet.getRowCount();
             if(num>0){
                 List list = new ArrayList();
                 for( int j=1; j<= num; j++ ){
                    String codecode= dptSet.getString(j,"codecode");//上级代码
                    String subcode = dptSet.getString(j,"subcode");//本级代码
                    String realsubcode= dptSet.getString(j,"realsubcode");//本级编号
                    String realsubcodetype =dptSet.getString(j,"realsubcodetype");//标题编号
                    String realsubcname = dptSet.getString(j,"realsubcname");//标题名字
                    String subcodecname = dptSet.getString(j,"subcodecname");//属性中文名
                    String grade = dptSet.getString(j,"grade");//等级
                    Code code =new Code();
                    code.setCodecode(codecode);
                    code.setSubcode (subcode );
                    code.setRealsubcode(realsubcode);
                    code.setRealsubcodetype(realsubcodetype);
                    code.setRealsubcname(realsubcname);
                    code.setSubcodecname(subcodecname);
                    code.setGrade(grade);
                    list.add(code);                     
                }

                    Codefilee codefileeDto = new Codefilee();
                    codefileeDto.setTitleName(((Code)list.get(0)).getRealsubcname());
                    codefileeDto.setGrade(((Code)list.get(0)).getGrade());
                    codefileeDto.setSubCode(((Code)list.get(0)).getSubcode());
                    codefileeDto.setRealsubcode(((Code)list.get(0)).getRealsubcode());
                    codefileeDto.setCodecode(((Code)list.get(0)).getCodecode());
                    codefileeDto.setListcode(list);
                    list4.add(codefileeDto);
                }
            }

              dbpm.currentTransaction().commit();
                dbpm.close();
     }catch(Exception ex){

     }

        request.setAttribute("list4", list4);//传值到前端
        //log.debug(mapping.getInputForward());
     return mapping.findForward("result");  //返回到配置文件指定路径跳转jsp页面 result



}

}