![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiI0gTMx81dsQWZ4lmZf1GLlpXazVmcvwFciV2dsQXYtJ3bm9CX9s2RkBnVHFmb1clWvB3MaVnRtp1XlBXe0xCMy81dvRWYoNHLwEzX5xCMx8FesU2cfdGLwMzX0xiRGZkRGZ0Xy9GbvNGLpZTY1EmMZVDUSFTU4VFRR9Fd4VGdsYTMfVmepNHLrJXYtJXZ0F2dvwVZnFWbp1zczV2YvJHctM3cv1Ce-cmbw5SN2gDMyMjZzgjN1AjYiVTMzYzX3UTMwcTM1AzLclDMyIDMy8CXn9Gbi9CXzV2Zh1WavwVbvNmLvR3YxUjLyM3Lc9CX6MHc0RHaiojIsJye.png)
文章目錄
- 一、腳本部分
- 1. 表結構
- 2. 函數
- 二、代碼部分
- 2.1. xml
- 2.2. 接口
- 2.3. api接口
- 2.4. api執行個體
- 2.5. 控制層
- 三、測試
- 3.1. 效果圖
一、腳本部分
1. 表結構
有注釋
-- Create table
create table LDMAXNO
(
NOTYPE VARCHAR2(17) not null,
NOLIMIT VARCHAR2(12) not null,
MAXNO INTEGER not null
);
-- Add comments to the table
comment on table LDMAXNO
is '産生最大的流水号,所有的号碼從1開始';
-- Add comments to the columns
comment on column LDMAXNO.NOTYPE
is '含義描述:1、号碼類型';
comment on column LDMAXNO.NOLIMIT
is '含義描述:1、号碼限制條件';
comment on column LDMAXNO.MAXNO
is '含義描述:1、目前最大值';
-- Create/Recreate primary, unique and foreign key constraints
alter table LDMAXNO
add constraint PK_LDMAXNO primary key (NOTYPE, NOLIMIT);
2. 函數
function CreateMaxNos(cNoType in ldmaxno.notype%type,
cNoLimit in ldmaxno.nolimit%type)
return integer is
pragma autonomous_transaction;
tMaxNo integer := 0; --初始化指派等于0,定義傳回變量
begin
--最大數加1
update LDMaxNo
set MaxNo = MaxNo + 1
where NoType = cNoType
and NoLimit = cNoLimit
Returning MaxNo Into tMaxNo; --取出最大數
If (Sql%Notfound) then
--第一次向資料庫中插入最大數為 1 的記錄
Insert Into LDMaxNo
(NOTYPE, NOLIMIT, MAXNO)
values
(cNoType, cNoLimit, 1);
tMaxNo := 1;
End If;
commit;
return(tMaxNo); --傳回結果
end CreateMaxNos;
二、代碼部分
2.1. xml
DullMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.gblfy.business.mapper.DullMapper">
<select id="getMaxNo" resultType="java.lang.String">
select createmaxno(#{cNoType},#{cNoLength}) from dual
</select>
</mapper>
2.2. 接口
DullMapper.java
package com.gblfy.business.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
public interface DullMapper extends BaseMapper {
/**
* 功能:産生指定長度的流水号,一個号碼類型一個流水
* @param cNoType 流水号的類型
* @param cNoLength 流水号的長度
* @return 傳回産生的流水号碼
*/
String getMaxNo(@Param("cNoType") String cNoType, @Param("cNoLength") int cNoLength);
}
2.3. api接口
package com.gblfy.business.service;
public interface SysMaxNoService {
/**
* 功能:産生指定長度的流水号,一個号碼類型一個流水
*
* @param cNoType 流水号的類型
* @param cNoLength 流水号的長度
* @return 傳回産生的流水号碼
*/
String createMaxNo(String cNoType, int cNoLength);
}
2.4. api執行個體
;
import com.gblfy.business.mapper.DullMapper;
import com.gblfy.business.service.SysMaxNoService;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import java.math.BigInteger;
@Service
public class SysMaxNoServiceImpl implements SysMaxNoService {
private final static Logger logger = LoggerFactory.getLogger(SysMaxNoServiceImpl.class);
@Resource
private DullMapper dullMapper;
/**
* 功能:産生指定長度的流水号,一個号碼類型一個流水
*
* @param cNoType 流水号的類型
* @param cNoLength 流水号的長度
* @return 傳回産生的流水号碼
*/
@Override
public String createMaxNo(String cNoType, int cNoLength) {
if ((cNoType == null) || (cNoType.trim().length() <= 0) ||
(cNoLength <= 0)) {
logger.info("NoType長度錯誤 {} NoLength錯誤", cNoType, cNoLength);
return null;
}
cNoType = cNoType.toUpperCase();
String tReturn = "";
String cNoLimit = "SN";
BigInteger tMaxNo = new BigInteger("0");
tReturn = cNoLimit;
try {
String result = dullMapper.getMaxNo(cNoType, cNoLength);
tMaxNo = new BigInteger(result);
} catch (Exception e) {
e.printStackTrace();
logger.info("生成流水号出現異常,請核實!");
}
String tStr = tMaxNo.toString();
//将生成的流水号進行加工處理
tStr = LCh(tStr, "0", cNoLength);
tReturn = tStr.trim();
return tReturn;
}
/**
* 将生成的流水号進行加工處理
* <p>
* 1.判斷是否滿足指定長度,如果不滿足前面用0來補位
* 2.将生成的流水号進行去空格處理
* 3.将最終的流水号進行字元串拼接
* </P>
*
* @param sourString
* @param cChar
* @param cLen
* @return
*/
private String LCh(String sourString, String cChar, int cLen) {
int tLen = sourString.length();
int i, iMax;
String tReturn = "";
if (tLen >= cLen) {
return sourString;
}
//1.判斷是否滿足指定長度,如果不滿足前面用0來補位
iMax = cLen - tLen;
for (i = 0; i < iMax; i++) {
tReturn += cChar;
}
//2.将生成的流水号進行去空格處理
//3.将最終的流水号進行字元串拼接
tReturn = tReturn.trim() + sourString.trim();
return tReturn;
}
}
2.5. 控制層
package com.gblfy.business.controller;
import com.gblfy.business.service.SysMaxNoService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
/**
* 生成指定類型+位數的流水号
*
* @Author gblfy
* @Date 2022-05-16 20:13
**/
@RestController
public class SysMaxNoController {
@Autowired
private SysMaxNoService maxNoService;
/**
* 生成指定類型+位數的流水号
*
* @param cNoType
* @param cNoLength
* @return
*/
@GetMapping("/generate/serial/number")
public String generateSerialNumber(@RequestParam(name = "cNoType", required = false, defaultValue = "cNoType") String cNoType,
@RequestParam int cNoLength) {
return maxNoService.createMaxNo(cNoType, cNoLength);
}
}
三、測試
3.1. 效果圖
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiI0gTMx81dsQWZ4lmZf1GLlpXazVmcvwFciV2dsQXYtJ3bm9CX9s2RkBnVHFmb1clWvB3MaVnRtp1XlBXe0xCMy81dvRWYoNHLwEzX5xCMx8FesU2cfdGLwMzX0xiRGZkRGZ0Xy9GbvNGLpZTY1EmMZVDUSFTU4VFRR9Fd4VGdsYTMfVmepNHLrJXYtJXZ0F2dvwVZnFWbp1zczV2YvJHctM3cv1Ce-cmbw5SN2gDMyMjZzgjN1AjYiVTMzYzX3UTMwcTM1AzLclDMyIDMy8CXn9Gbi9CXzV2Zh1WavwVbvNmLvR3YxUjLyM3Lc9CX6MHc0RHaiojIsJye.png)