SELECT max(no_value+0) FROM `jm_xx`

public String getOldNum(){
? ? ? ? String oldNum ="00000001";
? ? ? ? String maxOldNum = jmDocMapper.findMaxOldNum();
? ? ? ? if(null !=maxOldNum){
? ? ? ? ? ? int i = Integer.parseInt(maxOldNum)+1;
? ? ? ? ? ? //%nd 輸出的整型寬度至少為n位，右對(duì)齊，%8d即寬度至少為8位，位數(shù)大于8則輸出實(shí)際位數(shù)，0表示用0補(bǔ)齊
? ? ? ? ? ? oldNum = String.format("%08d", i);
? ? ? ? }
? ? return oldNum;
}

package com.lyf.test;
public class Test2 {
?? ?
?? ?/**
?? ? * 生成規(guī)則設(shè)備編號(hào):設(shè)備類(lèi)型+五位編號(hào)（從1開(kāi)始，不夠前補(bǔ)0）
?? ? *?
?? ? * @param equipmentType
?? ? * ?? ??? ??? ??? ?設(shè)備類(lèi)型
?? ? * @param equipmentNo
?? ? * ?? ??? ??? ??? ?最新設(shè)備編號(hào)
?? ? * @return
?? ? */
?? ?public static String getNewEquipmentNo(String equipmentType, String equipmentNo){
?? ??? ?String newEquipmentNo = equipmentType + "00001";
?? ??? ?
?? ??? ?if(equipmentNo != null && !equipmentNo.isEmpty()){
?? ??? ??? ?int no = Integer.parseInt(equipmentNo);
?? ??? ??? ?int newEquipment = ++no;
?? ??? ??? ?newEquipmentNo = String.format(equipmentType + "%05d", newEquipment);
?? ??? ?}
?? ??? ?
?? ??? ?return newEquipmentNo;
?? ?}
?? ?public static void main(String[] args) {
?? ??? ?String equipmentNo = Test2.getNewEquipmentNo("SYXH", "00032");
?? ??? ?System.out.println("生成設(shè)備編號(hào)：" + equipmentNo);
?? ?}
}