maven
com.ibeetl
beetl-framework-starter
1.1.56.RELEASE
表结构
create table T_FILE
(
ID VARCHAR2(64) not null
primary key,
ADD_TIME DATE,
SERVER_PATH VARCHAR2(1000) default 1000,
SIZEE NUMBER,
HUMAN_SIZE VARCHAR2(50),
MD5 VARCHAR2(64)
)
实体类
@Data
@Table(name = "t_file")
public class RadFile {
@AssignID("uuid")
private String id;
private String md5;
private String savePath; // 文件路径->/{存储服务指定路径}/{当前时间}/{md5}.{文件后缀}
private Long sizee;
private String humanSize;
private TaskState state;
public RadFile(String md5) {
this.md5 = md5;
}
}
业务代码
RadFile radFile=new RadFile(md5);
radFile=radFileDao.templateOne(radFile);
System.out.println(radFile);
日志
┏━━━━━ Debug [radFile._gen_selectByTemplate_page] ━━━
┣ SQL: SELECT * FROM ( SELECT beeltT.*, ROWNUM beetl_rn FROM ( select * from DPCENTER.T_FILE where 1=1 and MD5=? ) beeltT WHERE ROWNUM ) WHERE beetl_rn >= ?
┣ 参数: ["0001", 2, 1]
┣ 位置: com.rad.file.server.radfil.api.service.impl.AttachmentService.addAttachment(AttachmentService.java:25)
┣ 时间: 11ms
┣ 结果: [0]
┗━━━━━ Debug [radFile._gen_selectByTemplate_page] ━━━
替换日志输出在工具中执行,是有结果的
SELECT *
FROM (SELECT
beeltT.*,
ROWNUM beetl_rn
FROM (select *
from DPCENTER.T_FILE
where 1 = 1 and MD5 = '0001') beeltT
WHERE ROWNUM < 2)
WHERE beetl_rn >= 1;