Java实现年份加5位流水码生成-优快云博客

本文链接：https://blog.youkuaiyun.com/weixin_46008522/article/details/123688174

本文介绍了如何在Java中生成包含年份和5位流水号的编码。首先讲解了编码位数的初始化，接着详细阐述了业务逻辑的实现过程，最后讨论了相关的SQL操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、初始化编码位数
private final static String FORMAT_CODE = "00000";
2、业务逻辑

public PmEmployeeInfoVo selectPmEmployeeInfoById(String id)
    {
        PmEmployeeInfoVo pmEmployeeInfoVo = new PmEmployeeInfoVo();
        PmEmployeeInfo pmEmployeeInfo = pmEmployeeInfoMapper.selectPmEmployeeInfoById(id);
        if (pmEmployeeInfo.getEmpCode() == null ||  "".equals(pmEmployeeInfo.getEmpCode())){
            String empCode = pmEmployeeInfoMapper.selectPmEmployeeInfoEmpCode();
            if(empCode == null){
                int count = 1; // 流水号
                DecimalFormat dft = new DecimalFormat(FORMAT_CODE);
                String code = dft.format(count); // 格式化为四位流水号 code: 0001
                Calendar calendar = Calendar.getInstance();
                int year = calendar.get(Calendar.YEAR);
                String str = String.valueOf(year).substring(2,4);
                String codeEnd = str + code;
                pmEmployeeInfo.setEmpCode(codeEnd);
            }else {
                String empCodeOne = pmEmployeeInfoMapper.selectPmEmployeeInfoEmpCode();
                int code = parseInt(empCodeOne)+1;
                String codeONe = String.valueOf(code);
                pmEmployeeInfo.setEmpCode(codeONe);
            }
        }

3、SQL

select MAX(emp_code) from pm_employee_info

生成年份+5位流水码