生成一定规律的编码：SH20030001

/**
 * Created by HELKA072 on 2020/3/9.
 */
@Repository("boJobDao")
public class BoJobDaoImpl extends BaseDaoImpl<BoJob,String> {

    /**
     * 查找到最新的jobNo
     *
     * @param jobNoHead JobNo前缀分公司代码年月共6位（SH2001）
     * @return JobNoCount
     */
    public Object getJobNoCount(String jobNoHead) {

        String sql = "SELECT MAX(JobNoCount) maxJobNoCount FROM `bo_job` ";

        List<Object> params = new ArrayList<>();

        if (Optional.ofNullable(jobNoHead).isPresent()) {
            sql += " WHERE JobNoHead = ?";
            params.add(jobNoHead);
        }
        SQLQuery sqlQuery = getCurSession().createSQLQuery(sql);
        for (int i = 0; i < params.size(); i++) {
            sqlQuery.setParameter(i, params.get(i));
        }

        return sqlQuery.uniqueResult();
    }
}

/**
 * Created by HELKA072 on 2020/3/9.
 */
public interface BoJobService extends BaseService<BoJob,String> {
    /**
     * 生成最新JobNo
     * 例:SH 20 01 0001
     * SH二位分公司代码（JobNoCode),当成参数传过来(有可能是SH,BJ,NB,HK,.....)
     * 20二位年份，
     * 01二位月，
     * 0001四位编号，最后四位超过4位变五位，如查出来最后是SH20019999新的Job为SH200110000(变9位了)
     * @param JobNoCode：公司编号前缀，如：SH
     * @return 最新的JobNo
     */
    public String getNewJobNo(String JobNoCode);
}

/**
 * Created by HELKA072 on 2020/3/9.
 */
@Service("boJobService")
public class BoJobServiceImpl extends BaseServiceImpl<BoJobDaoImpl,BoJob,String> implements BoJobService {

    @Autowired
    private BoJobDaoImpl boJobDao;

    @Override
    public String getNewJobNo(String JobNoCode) {

        //JobNoCode不存在
        if (!Optional.ofNullable(JobNoCode).isPresent()) {
            return null;
        }

        Date date = new Date();
        //获得年份后两位
        String year = new SimpleDateFormat("yy", Locale.CHINESE).format(date);
        //获得月份后两位
        String month = new SimpleDateFormat("MM", Locale.CHINESE).format(date);

        //拼接jobNoHead
        String jobNoHead = JobNoCode + year + month;

        Object jobNoCountObject = boJobDao.getJobNoCount(jobNoHead);
        //如果数据不存在这个以jobNoHead开头的jobNo，则jobNoCount为 0
        int jobNoCount = jobNoCountObject != null ? (Integer) jobNoCountObject : 0;
        int newJobNoCount = jobNoCount + 1;

        String newJobNoCountStr = String.valueOf(newJobNoCount);

        //增加程序效率
        StringBuilder jobNoCountBuilder = new StringBuilder(newJobNoCountStr);

        //如果该数值是一个4/5位的字符串，则不用处理
        //如果该数值是一个小于4位的字符串，转为一个4位的字符串
        for (int i = newJobNoCountStr.length(); i < 4; i++) {
            jobNoCountBuilder.insert(0, "0");
//            newJobNoCountStr = "0" + newJobNoCountStr;
        }

        //拼接jobNo
        String jobNo = jobNoHead + jobNoCountBuilder.toString();

        return jobNo;
    }
}

/**
 * @author cxy
 * @version 1.0
 * @date 2020/3/27 11:10
 */

@Transactional
@Rollback(false)
@RunWith(SpringJUnit4ClassRunner.class)//使用Spring Test组件进行单元测试
@ContextConfiguration(locations={"classpath:spring/applicationContext.xml","classpath:spring/spring-business.xml","classpath:spring/spring-redis.xml","classpath:spring/springmvc-servlet.xml"})
public class BoJobServiceImplTest {

    @Autowired
    BoJobServiceImpl boJobService;

    @Test
    public void getNewJobNo() {
        String sh = boJobService.getNewJobNo("BJ");
        System.out.println(sh);
//        Assert.assertEquals(sh , "666");
    }
}