java 生成序列号

最新推荐文章于 2024-08-09 03:44:06 发布

IT的鱼

最新推荐文章于 2024-08-09 03:44:06 发布

阅读量3.4k

点赞数

分类专栏： JAVA

本文链接：https://blog.csdn.net/qq_32521313/article/details/103968603

版权

JAVA 专栏收录该内容

112 篇文章 0 订阅

订阅专栏

/**
    序列号
*/
CREATE TABLE IF NOT EXISTS T_OWS_CSP_CERTIFICATION_SEQ(
    ID VARCHAR (64) NOT NULL PRIMARY KEY,
    YEAR CHAR(4) NOT NULL,
    SEQ INTEGER,
    CREATE_TIME INTEGER
);

 private synchronized String getWono() throws Exception {
        Integer year = Calendar.getInstance().get(Calendar.YEAR);
        Map<String, Object> p = new HashMap<>();
        p.put("YEAR", year.toString());
        Map<String, Object> seqMap = masterDao.findOne2Map(R.T_OWS_CSP_CERTIFICATION_SEQ, p, null);
        Integer index = 1;
        if (seqMap == null) {
            seqMap = new HashMap<>();
            seqMap.put("YEAR", year.toString());
            seqMap.put("CREATE_TIME", System.currentTimeMillis());
        } else {
            index = (Integer) seqMap.get("SEQ");
            index++;
            seqMap.put("SEQ", index);
        }
        seqMap.put("SEQ", index);
        masterDao.saveOrUpdate(R.T_OWS_CSP_CERTIFICATION_SEQ, seqMap);
        return year.toString() + StringUtils.leftPad(index.toString(), 4, "0");
    }