rstostringtool.java

公司自己开发的工作流引擎

package cn.com.iaspec.workflow.organize;

import java.sql.*;
import java.util.*;
import org.apache.log4j.*;
import cn.com.iaspec.workflow.manage.managetree.*;
import cn.com.iaspec.workflow.organize.tree.*;

//import cn.com.iaspec.lamis.workflow.manage.managetree.TreeModule;
/**
 * <p>Title: 把信息结果集转换成有规律String(针对工作流机构部门)</p>
 *
 * <p>Description: 深圳市劳动仲裁信息管理系统</p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: 永泰软件工程有限公司</p>
 *
 * @author syj
 * @version 1.0
 */
public class RsToStringTool{
  private static Logger logger=Logger.getLogger(RsToStringTool.class);

  /**
   * 把结果集转换成有规律的String(直属下级信息)
   * @param rs ResultSet
   * @return String
   */
  public synchronized static Collection getString(ResultSet rs,String orgRel)
      throws Exception{
    logger.info("begin getString...");
    HashSet hashset=new HashSet();
    while(rs.next()){
      String role_id=rs.getString("role_id")==null?"":rs.getString("role_id");
      String user_id=rs.getString("user_id")==null?"":rs.getString("user_id");
      logger.info(" user id is:"+rs.getString("user_id")+" user name is:"+
          rs.getString("user_name")+" role id is:"+rs.getString("role_id")+
          " role_name is:"+rs.getString("role_name")+" org_id is:"+
          rs.getString("org_id"));

      if(orgRel!=null&&(orgRel.equals("user")||orgRel.equals("user-fixed-role")||
          orgRel.equals("user-role")||orgRel.equals("user-all"))){
        if(user_id.equals("")){
          TreeExample treeExamle1=new TreeExample("org:"+rs.getString("org_id"),
              "org:"+rs.getString("up_org"),rs.getString("org_id"),
              rs.getString("org_name"),rs.getString("up_org"),
              rs.getString("org_id"),rs.getInt("org_level"),"org","0");
          treeExamle1.setOrder(Integer.parseInt(rs.getString("org_order")==null ? "0":rs.getString("org_order")));
          hashset.add(treeExamle1);
        }
        else if(!user_id.equals("")&&role_id.equals("0")){
          TreeExample treeExamle1=new TreeExample("user:"+
              rs.getString("user_id")+":org:"+rs.getString("org_id"),
              "org:"+rs.getString("org_id"),rs.getString("user_id"),
              rs.getString("user_name"),rs.getString("org_id"),
              rs.getString("org_id"),rs.getInt("org_level")+1,"user","0");
          treeExamle1.setOrder(Integer.parseInt(rs.getString("user_order")==null ? "0":rs.getString("user_order")));
          TreeExample treeExamle2=new TreeExample("org:"+rs.getString("org_id"),
              "org:"+rs.getString("up_org"),rs.getString("org_id"),
              rs.getString("org_name"),rs.getString("up_org"),
              rs.getString("org_id"),rs.getInt("org_level"),"org","0");
          treeExamle2.setOrder(Integer.parseInt(rs.getString("org_order")==null ? "0":rs.getString("org_order")));
          hashset.add(treeExamle1);
          hashset.add(treeExamle2);
        }
        else if(!user_id.equals("")&&!role_id.equals("0")){
          TreeExample treeExamle1=new TreeExample("user:"+
              rs.getString("user_id")+":org:"+rs.getString("org_id")+":role:"+
              rs.getString("role_id"),
              "org:"+rs.getString("org_id")+":role:"+rs.getString("role_id"),
              rs.getString("user_id"),rs.getString("user_name"),
              rs.getString("role_id"),rs.getString("org_id"),
              rs.getInt("org_level")+2,"user","0");
          TreeExample treeExamle2=new TreeExample("org:"+rs.getString("org_id")+
              ":role:"+rs.getString("role_id"),"org:"+rs.getString("org_id"),
              role_id,
              rs.getString("role_name")==null?"":rs.getString("role_name"),
              rs.getString("org_id"),rs.getString("org_id"),
              rs.getInt("org_level")+1,"role",rs.getString("role_id"));
          TreeExample treeExamle3=new TreeExample("org:"+rs.getString("org_id"),
              "org:"+rs.getString("up_org"),rs.getString("org_id"),
              rs.getString("org_name"),rs.getString("up_org"),
              rs.getString("org_id"),rs.getInt("org_level"),"org","0");
          hashset.add(treeExamle1);
          hashset.add(treeExamle2);
          hashset.add(treeExamle3);
        }
      }
      else if(orgRel!=null&&orgRel.equals("user-only-fixed-role")&&
          !user_id.equals("")){
        TreeExample treeExamle1=new TreeExample("user:"+rs.getString("user_id")+
            ":org:-1:role:-1","org:-1:role:-1",rs.getString("user_id"),
            rs.getString("user_name"),"-1",rs.getString("org_id"),0,"user","0");
        hashset.add(treeExamle1);
      }
      else if(orgRel!=null&&(orgRel.equals("role")||orgRel.equals("role-fixed"))){
        if(role_id.equals("")||role_id.equals("0")){
          TreeExample treeExamle1=new TreeExample("org:"+rs.getString("org_id"),
              "org:"+rs.getString("up_org"),rs.getString("org_id"),
              rs.getString("org_name"),rs.getString("up_org"),
              rs.getString("org_id"),rs.getInt("org_level"),"org","0");
          hashset.add(treeExamle1);

        }
        else{
          TreeExample treeExamle1=new TreeExample("org:"+rs.getString("org_id")+
              ":role:"+rs.getString("role_id"),"org:"+rs.getString("org_id"),
              rs.getString("role_id"),rs.getString("role_name"),
              rs.getString("org_id"),rs.getString("org_id"),
              rs.getInt("org_level")+1,"role",rs.getString("role_id"));
          TreeExample treeExamle2=new TreeExample("org:"+rs.getString("org_id"),
              "org:"+rs.getString("up_org"),rs.getString("org_id"),
              rs.getString("org_name"),rs.getString("up_org"),
              rs.getString("org_id"),rs.getInt("org_level"),"org","0");
          hashset.add(treeExamle1);
          hashset.add(treeExamle2);
        }
      }
      else if(orgRel!=null&&orgRel.equals("org-role-fixed")){
        if(!(role_id.equals("")||role_id.equals("0"))){
          TreeExample treeExamle1=new TreeExample("org:"+rs.getString("org_id"),
              "org:"+rs.getString("up_org"),rs.getString("org_id"),
              rs.getString("org_name"),rs.getString("up_org"),
              rs.getString("org_id"),rs.getInt("org_level"),"org",
              rs.getString("role_id"));
          hashset.add(treeExamle1);

        }
      }
      else if(orgRel!=null&&(orgRel.equals("org"))){
        TreeExample treeExamle1=new TreeExample("org:"+rs.getString("org_id"),
            "org:"+rs.getString("up_org"),rs.getString("org_id"),
            rs.getString("org_name"),rs.getString("up_org"),
            rs.getString("org_id"),rs.getInt("org_level"),"org","0");
        hashset.add(treeExamle1);
      }
    }
    return hashset;
  }

  /**
   * 数据的转换
   * @param rs ResultSet
   * @param i int
   * @return Collection
   */
  public synchronized static Collection getCollection(ResultSet rs,int i){
    HashSet hashset=new HashSet();
    try{
      while(rs.next()){
        TreeModule treeModule=new TreeModule();
        if(i==1){
          treeModule.setID(rs.getString("org_id"));
          treeModule.setTreeName(rs.getString("org_name"));
          treeModule.setFatherID(rs.getString("up_org"));
          treeModule.setArea_id(rs.getString("area_id"));
          treeModule.setOrg_level(rs.getInt("org_level"));
          treeModule.setActorSelType("org");
          hashset.add(treeModule);
        }
        else if(i==2){
          treeModule.setID(rs.getString("user_id"));
          treeModule.setTreeName(rs.getString("user_name"));
          treeModule.setFatherID(rs.getString("org_id"));
          treeModule.setOrg_level(rs.getInt("org_level")+1);
          treeModule.setArea_id(rs.getString("area_id"));
          treeModule.setActorSelType("user");
          hashset.add(treeModule);
        }
        else if(i==3){
          treeModule.setID(rs.getString("role_id"));
          treeModule.setTreeName(rs.getString("role_name"));
          treeModule.setFatherID(rs.getString("role_type"));
          treeModule.setOrg_level(1);
          //treeModule.setOrg_level ( 2 ) ;
          treeModule.setArea_id("0");
          treeModule.setM_role_id(rs.getString("role_id"));
          treeModule.setActorSelType("role");
          hashset.add(treeModule);

          /* TreeModule treeModule1 = new TreeModule () ;
           treeModule1.setID ( rs.getString ( "role_type" ) ) ;
           treeModule1.setTreeName (   Integer.parseInt(rs.getString ( "role_type" )) == 1 ?"功能角色" :(Integer.parseInt(rs.getString ( "role_type" )) == 2? "业务活动角色":"流程角色")) ;
           treeModule1.setFatherID ( "0" ) ;
           treeModule1.setOrg_level ( 1 ) ;
           treeModule1.setArea_id ( "" ) ;
           treeModule1.setActorSelType ( "role" ) ;
           hashset.add ( treeModule1 ) ;*/

        }
        else if(i==4){
          treeModule.setID(rs.getString("user_id"));
          treeModule.setTreeName(rs.getString("user_name"));
          treeModule.setFatherID(rs.getString("role_id"));
          treeModule.setOrg_level(3);
          treeModule.setArea_id("");
          treeModule.setActorSelType("user");
          hashset.add(treeModule);

        }
        else if(i==5){
          treeModule.setID(rs.getString("func_id"));
          treeModule.setTreeName(rs.getString("func_name"));
          treeModule.setFatherID(rs.getString("up_func_id"));
          treeModule.setOrg_level(rs.getInt("FUNC_LEVEL"));
          treeModule.setArea_id("");
          treeModule.setActorSelType("menu");
          hashset.add(treeModule);

        }
        else if(i==6){
          treeModule.setID(rs.getString("role_id"));
          treeModule.setTreeName(rs.getString("role_name"));
          treeModule.setFatherID("0");
          treeModule.setOrg_level(1);
          treeModule.setArea_id("");
          treeModule.setActorSelType("role");
          treeModule.setM_role_id(rs.getString("role_id"));
          hashset.add(treeModule);

        }
        else if(i==7){
          treeModule.setID(rs.getString("func_id"));
          treeModule.setTreeName(rs.getString("func_name"));
          if(rs.getString("up_func_id").equals("0")){
            treeModule.setFatherID(rs.getString("role_id"));
          }
          else{
            treeModule.setFatherID(rs.getString("up_func_id"));
          }
          treeModule.setOrg_level(rs.getInt("FUNC_LEVEL")+1);
          treeModule.setArea_id("");
          treeModule.setActorSelType("menu");
          treeModule.setM_role_id(rs.getString("role_id"));
          hashset.add(treeModule);

        }
        else if(i==8){
          treeModule.setID(rs.getString("atd_id"));
          treeModule.setTreeName(rs.getString("atd_name"));
          treeModule.setFatherID(rs.getString("role_id"));
          treeModule.setOrg_level(2);
          treeModule.setArea_id("");
          treeModule.setActorSelType("activity");
          treeModule.setM_role_id("0");
          treeModule.setUID(rs.getString("atd_uid"));
          hashset.add(treeModule);

        }
        else if(i==9){
          treeModule.setID(rs.getString("atd_prdid"));
          treeModule.setTreeName(rs.getString("atd_prdename"));
          treeModule.setFatherID(rs.getString("role_id"));
          treeModule.setOrg_level(2);
          treeModule.setArea_id("");
          treeModule.setActorSelType("process");
          treeModule.setM_role_id(rs.getString("role_id"));
          treeModule.setUID(rs.getString("prd_uid"));
          hashset.add(treeModule);

        }

      }

    }
    catch(Exception e){
      e.printStackTrace();
    }
    return hashset;

  }

  public static void main(String[] args){
    RsToStringTool rstostringtool=new RsToStringTool();
  }
}