JAVA简单生成流水号，自动生成顺序编号

JAVA简单生成流水号，自动生成顺序编号,前后端调用示例

    public AjaxJson syncWareHouse(String id){
        AjaxJson ajaxJson=new AjaxJson();
        try {
            String sql = "select supplier_code from oct_ldg_supplier_access where supplier_code like 'GYS%' order by supplier_code desc limit 1";
            Map<String,Object> oneCodeMap = systemService.findOneForJdbc(sql);
            String Number="GYS001";
            if(!CollectionUtils.isEmpty(oneCodeMap)){
                String oneCode = (String) oneCodeMap.get("supplier_code");
                int intNumber = Integer.parseInt(oneCode.substring(3));
                intNumber++;
                 Number = String.valueOf(intNumber);
                for (int i = 0; i < 3; i++){
                     Number = Number.length() < 3 ? "0" + Number : Number;
                }
                 Number = "GYS"  + Number;
            }else{
                 Number = "GYS"  + "001";
            }
            String codeSql="update oct_ldg_supplier_access set supplier_code = '"+Number+"' where id = '"+id+"'";
            commonService.executeSql(codeSql);
            Map<String,Object> data = new HashMap<>();
            data.put("oneCode", Number);
            ajaxJson.setAttributes(data);
            ajaxJson.setObj(data);
        } catch (Exception e) {
            ajaxJson.setSuccess(false);
            logger.error("供应商入库申请单同步失败:"+e.getMessage());
        }

        return ajaxJson;
    }

前端代码如下

var afterSubmitYes = function(){
    var formid=$("input[name='olsa.id']").val();
    if (typeof(flow_NodeId) !="undefined" && flow_NodeId == 'lastsid') {
        var _url = "ldgSupplierController.do?getSupplierCode&id="+formid;
        $.post(_url);
    }
};