CREATE TABLE `replenish_order_approval_record` ( `id` bigint NOT NULL AUTO_INCREMENT, `rep_record_id` bigint NOT NULL DEFAULT '0' COMMENT '补单申请记录ID', `reason` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '审批批语', `operator` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '审核人', `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '备注', `approval_node` int NOT NULL DEFAULT '0' COMMENT '审批节点', `status` int NOT NULL DEFAULT '0' COMMENT '审核状态,0待审核,1已同意,2驳回', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, KEY `index_rep_record_id` (`rep_record_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='补单审批记录';根据表结构生成java实体类、持久层,业务类,并添加注释
时间: 2024-03-31 10:38:04 浏览: 95
好的,根据您提供的表结构,以下是对应的Java实体类、持久层和业务类,并添加了注释。
Java实体类:
```java
/**
* 补单审批记录
*/
public class ReplenishOrderApprovalRecord {
private Long id; // 主键ID
private Long repRecordId; // 补单申请记录ID
private String reason; // 审批批语
private String operator; // 审核人
private String remark; // 备注
private Integer approvalNode; // 审批节点
private Integer status; // 审核状态,0待审核,1已同意,2驳回
private Date createTime; // 创建时间
private Date updateTime; // 更新时间
// getter和setter方法
}
```
持久层:
```java
@Repository
public interface ReplenishOrderApprovalRecordMapper {
/**
* 新增补单审批记录
*/
int insert(ReplenishOrderApprovalRecord record);
/**
* 根据ID查询补单审批记录
*/
ReplenishOrderApprovalRecord selectById(Long id);
/**
* 更新补单审批记录
*/
int update(ReplenishOrderApprovalRecord record);
/**
* 根据补单申请记录ID查询补单审批记录
*/
List<ReplenishOrderApprovalRecord> selectByRepRecordId(Long repRecordId);
}
```
业务类:
```java
@Service
public class ReplenishOrderApprovalRecordService {
@Autowired
private ReplenishOrderApprovalRecordMapper replenishOrderApprovalRecordMapper;
/**
* 新增补单审批记录
*/
public int add(ReplenishOrderApprovalRecord record) {
return replenishOrderApprovalRecordMapper.insert(record);
}
/**
* 根据ID查询补单审批记录
*/
public ReplenishOrderApprovalRecord getById(Long id) {
return replenishOrderApprovalRecordMapper.selectById(id);
}
/**
* 更新补单审批记录
*/
public int update(ReplenishOrderApprovalRecord record) {
return replenishOrderApprovalRecordMapper.update(record);
}
/**
* 根据补单申请记录ID查询补单审批记录
*/
public List<ReplenishOrderApprovalRecord> getByRepRecordId(Long repRecordId) {
return replenishOrderApprovalRecordMapper.selectByRepRecordId(repRecordId);
}
}
```
希望以上代码对您有所帮助。
阅读全文