拿取数据库的值和总值做对比

1.数据库的值如

 逻辑写法

    @Override
    public String findUserLevelName(int score) {
        List items = this.findSelectItemByTypeId("4028b181415432b90141545c8ea60004",null);
        String objname="";
        int i=0;
        for (ListBean item : items) {
            String[] split = item.getObjdesc().split("-");
            String name =item.getObjname();
            if(score<=Integer.valueOf(split[1])){//如果我的积分小于等于objdesc
                objname=name;
                break;
            }else if(score>Integer.valueOf(split[1]) && i==items.size()-1){
                objname=name;
            }
            i++;
        }
        return objname;
    }

只是对比值可以用下面的写法

    public int getExperienceLevel(int score) {
        //List items = this.findSelectItemByTypeId("4028b181415432b90141545c8ea60004",null);
        String sql=" select s.id,l.labelname num, s.objdesc,s.DSPORDER from selectitem s inner join label l on l.id=s.objname where s.typeid='4028a6815aa713ad015aa71e74ed0011'";
        List items = dataService.getBeanList(ListBean.class, sql);
        int nums=0;
        for (ListBean item : items) {
           // String[] split = item.getObjdesc().split("-");
            int itemNum =item.getNum();
            if(score<=itemNum){//如果我的积分小于等于objdesc
                nums=itemNum;
                break;
            }else if(score>=itemNum){
                nums=itemNum;
            }
        }
        return nums;
    }