staffcfg.java

通过java语音实现灵活的权限控制功能

       String sql0 = "select MAX(INTID) FROM  ALL_RIGHTITEM";
       DBResultset rs0=null;
       int maxid=0;
       String str=null;
       rs0 = dbconn0.runQuery(sql0,1000);
      try {
        while (rs0.moveNext()) {
          str = rs0.fieldByIndex(0);
        }
      }
      catch (Exception ex1) {
        ex1.printStackTrace();
      }
      if(str!=null && !str.equalsIgnoreCase(""))
        maxid=Integer.parseInt(str)+1;

   //    System.out.println("maxidooo="+maxid);

      /* 从权限表中获取社区信息*/
      String regionid[]=null;
      regionid=getRegionidInUnit(conn_code);
  //    for(int j=0; j<regionid.length;j++)
 //     {
 //       System.out.println("regionid[" + j + "]=" + regionid[j]);
 //     }
      /** @todo 插入社区分局信息 */
      for(int j=0; j<regionid.length;j++)
      {
        String unitid[] = null;
        unitid = getUnitid(conn_code, regionid[j]);
 //       for (int k = 0; k < unitid.length; k++) {
 //         System.out.println("regionid["+k+"]="+unitid[k]);
 //       }

        for (int k = 0; k < unitid.length; k++) {

          dbConnect dbconn = new dbConnect(conn_code);
          String sql = "select UNIT_NAME from UNIT where UNIT_ID=" + unitid[k];
       //   System.out.println("select unitsql= "+sql);
          DBResultset rs = null;
          rs = dbconn.runQuery(sql, 1000);

          int i = 0;

          try {
            int iRow = rs.getRowSize();

            allmStru = new menu[iRow];
            while (rs.moveNext()) {
                 allmStru[i] = new menu();
                 allmStru[i].setStrName(rs.fieldByName("UNIT_NAME")); //菜单中文名字

                 String maxidStr = "" + maxid;
                 maxidStr.trim();
                 allmStru[i].setStrID(maxidStr); //菜单编号

                 allmStru[i].setStrGrade("3"); //菜单级别

                 String parentid=getParentid(conn_code,"STAFF_RIGHTITEM",regionid[j],2);
                 allmStru[i].setStrParentId(parentid); /*父菜单编号*/
                 allmStru[i].setStrLink("");
                 allmStru[i].setStrType(unitid[k]); // 菜单中文名称对应的编号，与社区营销资料对应

                 maxid++;
                 i++;
                 flag=1;
           //  System.out.println("regmaxid="+maxid);
            }//while
          }
          catch (Exception ex) {
            ex.printStackTrace();
          }
          /** @todo 执行插入片区信息 */
     if(allmStru!=null && flag==1){
       insert_menu(i, allmStru, conn_code);
       flag=0;
     }

        }//k
      }//j


}




    /**
     * 把组成的菜单数组插入权限表
     * @param allmStru menu[]
     * @param conn_code String
     */
    public void insert_menu(int len, menu[] allmStru, String conn_code)
    {
      /** @todo 执行插入社区信息 */
       dbConnect dbconn1 = new dbConnect(conn_code);
       if(allmStru==null) return;
       if(allmStru.length==0) return;
  //     System.out.println("allmStru.length="+allmStru.length);
      for(int j=0; j<len; j++)
      {
        String ins_sql = "insert into STAFF_RIGHTITEM values(" +
            allmStru[j].getStrID() + "," +
            "1" + ",'" +
            allmStru[j].getStrTpye() + "','" +
            allmStru[j].getStrName() + "','" +
            allmStru[j].getStrLevel()+ "'," +
            allmStru[j].getStrGrade() + "," +
            allmStru[j].getStrParentId() + "," +
            "''" + ")";

        try {
          System.out.println("j="+j+" || insert sql="+ins_sql);
          dbconn1.runUpdate(ins_sql);
        }
        catch (Exception ex2) {
          ex2.printStackTrace();
        }
      }


}


    /**
     * 设置父菜单号
     * @param conn_code String
     * @param branchid String
     * @return String
     */
    public String getParentid(String conn_code, String table, String branchid, int grade)
    {
          String parentid=null;

          dbConnect dbconn0 = new dbConnect(conn_code);
          String sql0="select INTID from "+table+"  where STRKEY='"+branchid+"'"+" and GRADE="+grade;
        //  System.out.println("gerparent sql="+sql0);
          DBResultset rs0=null;

          String str=null;
          rs0 = dbconn0.runQuery(sql0,1000);
          try {
           while (rs0.moveNext()) {
             str = rs0.fieldByIndex(0);
             parentid=str;
           }
         }
         catch (Exception ex1) {
           ex1.printStackTrace();
           str= null;
         }

         return parentid;

    }


    /**
     * 从权限表获取社区信息
     * @param conn_code String
     * @param branchid String
     * @return String[]
     */
    public String [] getRegionid(String conn_code, String branchid)
    {
          String []regionid=null;

          dbConnect dbconn0 = new dbConnect(conn_code);
          String sql0="select REGN_ID from REGION_RELATION where REGN_BRANCH_ID="+branchid;
          DBResultset rs0=null;

          int i=0;
          String str=null;
          rs0 = dbconn0.runQuery(sql0,1000);
          int irow = rs0.getRowSize();
          regionid = new String[irow];
          try {
           while (rs0.moveNext()) {
             str = rs0.fieldByIndex(0);
             regionid[i]=str;
             i++;
           }
         }
         catch (Exception ex1) {
           ex1.printStackTrace();
           str= null;
         }

         return regionid;

    }

    /**
     * 获取片区信息
     * @param conn_code String
     * @param regionid String
     * @return String[]
     */
    public String [] getUnitid(String conn_code, String regionid)
    {
          String []unitid=null;

          dbConnect dbconn0 = new dbConnect(conn_code);
          String sql0="select UNIT_ID from REGN_UNIT where REGN_ID="+regionid;
          DBResultset rs0=null;

          int i=0;
          String str=null;
          rs0 = dbconn0.runQuery(sql0,1000);
          int irow = rs0.getRowSize();
          unitid = new String[irow];
          try {
           while (rs0.moveNext()) {
             str = rs0.fieldByIndex(0);
             unitid[i]=str;
             i++;
           }
         }
         catch (Exception ex1) {
           ex1.printStackTrace();
           str= null;
         }

         return unitid;

    }



    public String [] getRegionidInUnit(String conn_code)
    {
          String []regionid=null;

          dbConnect dbconn0 = new dbConnect(conn_code);
          String sql0="select STRKEY from ALL_RIGHTITEM where GRADE=2";
          DBResultset rs0=null;

          int i=0;
          String str=null;
          rs0 = dbconn0.runQuery(sql0,1000);
          int irow = rs0.getRowSize();
          regionid = new String[irow];
          try {
           while (rs0.moveNext()) {
             str = rs0.fieldByIndex(0);
             regionid[i]=str;
             i++;
           }
         }
         catch (Exception ex1) {
           ex1.printStackTrace();
           str= null;
         }

         return regionid;

    }


    /**
     * 从权限表获取社区分局名称
     * @param conn_code String
     * @return String[]
     */
    public String [] getBranchName(String conn_code)
{
      String []branchname=null;
      dbConnect dbconn0 = new dbConnect(conn_code);
      String sql0="select REGN_BRANCH_NAME from REGION_BRANCH";
      DBResultset rs0=null;

      int i=0;
      String str=null;
      rs0 = dbconn0.runQuery(sql0,1000);
      if(rs0==null) return null;

      int irow = rs0.getRowSize();
      if(irow==0) return null;

      branchname = new String[irow];
      try {
       while (rs0.moveNext()) {
         str = rs0.fieldByIndex(0);
         branchname[i]=str;
         i++;
       }
     }
     catch (Exception ex1) {
       ex1.printStackTrace();
       str= null;
     }

     return branchname;

}

   public String [] getBranchid(String conn_code)
{
     String []branchid=null;
     dbConnect dbconn0 = new dbConnect(conn_code);
     String sql0="select REGN_BRANCH_NAME from REGION_BRANCH";
     DBResultset rs0=null;

     int i=0;
     String str=null;
     rs0 = dbconn0.runQuery(sql0,1000);
     if(rs0==null) return null;

     int irow = rs0.getRowSize();
     if(irow==0) return null;

     branchid = new String[irow];
     try {
      while (rs0.moveNext()) {
        str = rs0.fieldByIndex(0);
        branchid[i]=str;
        i++;
      }
    }
    catch (Exception ex1) {
      ex1.printStackTrace();
      str= null;
    }

    return branchid;

}


  public String [] getDataFromTable(String conn_code, String sql0)
{
    String []data=null;
    dbConnect dbconn0 = new dbConnect(conn_code);
//    String sql0="select REGN_BRANCH_ID from REGION_BRANCH";
    DBResultset rs0=null;

    int i=0;
    String str=null;
    rs0 = dbconn0.runQuery(sql0,1000);
    if(rs0==null) return null;

    int irow = rs0.getRowSize();
    if(irow==0) return null;

    data = new String[irow];
    try {
     while (rs0.moveNext()) {
       str = rs0.fieldByIndex(0);
       str = str.trim();
       if(str.equalsIgnoreCase("")) str="0000";
       data[i]=str;
       i++;
     }
   }
   catch (Exception ex1) {
     ex1.printStackTrace();
     str= null;
   }

   return data;

}



   /**
    * 权限表中是否存在该社区分局编号
    * @param conn_code String
    * @param branchid String
    * @return boolean
    */
   public boolean has_branchid(String conn_code, String branchid)
{
      boolean ret=false;

      dbConnect dbconn0 = new dbConnect(conn_code);
      String sql0 = "select count(STRKEY) FROM  ALL_RIGHTITEM where STRKEY='"+branchid+"'";
     // System.out.println("hasbranch sql: "+sql0);
      DBResultset rs0=null;
      int count=0;
      String str=null;
      rs0 = dbconn0.runQuery(sql0,1000);
      try {
       while (rs0.moveNext()) {
         str = rs0.fieldByIndex(0);
       }
     }
     catch (Exception ex1) {
       ex1.printStackTrace();
       str= null;
     }

     if(str==null && str.equalsIgnoreCase(""))
       ret=false;
      else
       count = Integer.parseInt(str);

       if(count>0) ret=true;

       return ret;
}

     /**
      * 权限表中是否存在社区标号
      * @param conn_code String
      * @param regionid String
      * @return boolean
      */
     public boolean has_regionid(String conn_code, String regionid)
     {
           boolean ret=false;

           dbConnect dbconn0 = new dbConnect(conn_code);
           String sql0 = "select count(STRKEY) FROM  ALL_RIGHTITEM where STRKEY='"+regionid+"' and GRADE=2";
          // System.out.println("hasreginsql= "+sql0);
           DBResultset rs0=null;
           int count=0;
           String str=null;
           rs0 = dbconn0.runQuery(sql0,1000);
           try {
            while (rs0.moveNext()) {
              str = rs0.fieldByIndex(0);
            }
          }
          catch (Exception ex1) {
            ex1.printStackTrace();
            str= null;
          }

          if(str==null && str.equalsIgnoreCase(""))
            ret=false;
           else
            count = Integer.parseInt(str);

            if(count>0) ret=true;

            return ret;
     }


}