分类的生成规则

 /*
        顶级分类默认值:100

        一级分类:101100(自然数增加)

        二级分类:101100100(前6位是父类ID,后3位取当前分类下的最大值加1,从100--999)

        顶级分类:100

        一级分类:101101(自然数增加)

        二级分类:101101100(前6位是父类ID,后3位取当前分类下的最大值加1,从100--999)  

        每个二级分类下可添加900个子类。

 */

 1     //新增分类
    public String addCategory(Category cate) {
        try {
        //1.取模块代码
        String parentid=cate.getParentid();
        int begin=parentid.length()+1;
        String sql1="";
        int flag = 0;
        //顶级节点为100,一级节点
        if(parentid.equals("100")){
            sql1="SELECT (CASE WHEN MAX(TO_NUMBER(CATID)) IS NULL THEN 100 ELSE MAX(TO_NUMBER(CATID)) END)+1 FROM MALL_CATEGORY WHERE PARENTID='100'";
            log.info("==addCategory:===="+sql1+"========");
            Long maxcatid=this.getJdbcTemplate().queryForLong(sql1);
            cate.setCatid(maxcatid.toString());
            cate.setParentid("100");
            flag = 3;
        }
        //非一级节点
        else{            
            sql1 = "select min(catid) from mall_category  where parentid='"+parentid+"' and status=2";
            Long mincatid=this.getJdbcTemplate().queryForLong(sql1);
            if(mincatid != 0L){
                //使用删除的子分类ID作为新的ID,跟新数据
                cate.setCatid(mincatid.toString());
                flag = 1;
            }else{
                //获取所有分类ID
                List<Category> listCatid = findAllCatid(parentid);
                HashSet<String> set = new HashSet<String>();
                Category item = null;
                if(!StringUtils.isEmpty(listCatid)){
                    //该父分类下已有子分类,使用未使用过的子分类ID
                    for(int a = 0 ;a<listCatid.size();a++){
                        item = listCatid.get(a);
                        set.add(item.getCatid());
                    }
                    for(int a = 101;a <= 1000;a++){
                        if(a==1000){
                            flag = 2;
                            break;
                        }
                        if(!set.contains(a+"")){
                            cate.setCatid(parentid+a);
                            flag = 3;
                            break; 
                         }
                    }
                }else{
                    //该父分类下首次增加子分类
                    cate.setCatid(parentid+100);
                    flag = 3;
                }
            }
        }
        //2.取模块顺序
        String sql2="SELECT (CASE WHEN MAX(TO_NUMBER(LISTORDER)) IS NULL THEN 0 ELSE MAX(TO_NUMBER(LISTORDER)) END)+1 FROM MALL_CATEGORY WHERE parentid='"+cate.getParentid()+"'";
        log.info("==addCategory:===="+sql2+"========");
        Integer listorder=this.getJdbcTemplate().queryForInt(sql2);
        cate.setListorder(listorder);
        cate.setStatus(1);
        String sql = "",catid = "";
        if(flag != 2){
            if(flag == 3){
                //新增
                sql = "INSERT INTO MALL_CATEGORY(CATID,CATNAME,PARENTID,LISTORDER,THUMB,STATUS,CATNAME2) VALUES('"+cate.getCatid()+"','"+cate.getCatname()+"','"+cate.getParentid()+"',"+cate.getListorder()+",'"+cate.getThumb()+"',"+cate.getStatus()+",'"+cate.getCatname2()+"')";
            }else if(flag == 1){
                //修改
                sql = "update MALL_CATEGORY set CATNAME='"+cate.getCatname()+"',LISTORDER="+cate.getListorder()+",THUMB='"+cate.getThumb()+"',STATUS="+cate.getStatus()+",CATNAME2='"+cate.getCatname2()+"' where catid ='"+cate.getCatid()+"'";
            }
            log.info("sql:"+sql);
            this.getJdbcTemplate().execute(sql);
            catid = cate.getCatid();
        }else{
            catid = "";
        }
        return catid;
        } catch (Exception e) {
            log.info("==CategoryDao：addCategory==异常=====msg:"+e.getMessage());
            return "";
        }
    }