while循环使用

本文已参与「新人创作礼」活动，一起开启掘金创作之路。

循环代码 查询最大值返回

  SyDkQzxhmcmx unionMx = syDkQzxhmcmxDAO.selectPlbh();
     String plbh = unionMx.getPlbh();
     if (StringUtils.isBlank(plbh)) {
         plbh = "QZ" + getCurrentYear() + "000001";
     } else {
         while (plbh.length() != 6) {
             StringBuffer sb = new StringBuffer(plbh);
             StringBuffer insert = sb.insert(0, "0");
             plbh = insert.toString();
         }
         plbh = "QZ" + getCurrentYear() + plbh;
     }
     
     
   @Override
    public SyDkQzxhmcmx selectPlbh() {
        String sql = " SELECT max(SUBSTR(plbh, -6))+1 plbh FROM sy_dk_qzxhmcjl";
        return getUnique(sql);
    }

查询数据库最大值 查询数据库最大值并且返回

    @Override
    public SyDkQzxhmcmx selectPlbh() {
        String sql = " SELECT max(SUBSTR(plbh, -6))+1 plbh FROM sy_dk_qzxhmcjl";
        return getUnique(sql);
    }