数据库最大值，循环取固定位数

sql

 SELECT max(SUBSTR(plbh, -6))+1 plbh FROM sy_dk_qzxhmcmx

java代码

 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;
        }


    public static String getCurrentYear() {
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy");
        Date date = new Date();
        return sdf.format(date);
    }

这辈子坚持与不坚持都不可怕，怕的是独自走在坚持的道路上。。