@Mapper 和 @Repository注解区别
1、使用@mapper后,不需要在spring配置中设置扫描地址,通过mapper.xml里面的namespace属性对应相关的mapper类,spring将动态的生成Bean后注入到ServiceImpl中。
2、@repository则需要在Spring中配置扫描包地址,然后生成dao层的bean,之后被注入到ServiceImpl中
建表:drop table ims_user.t_ims_busi_access_flow cascade constraints;
/*==============================================================*/
/* Table: ims_user.t_ims_busi_access_flow */
/*==============================================================*/
create table ims_user.t_ims_busi_access_flow
(
access_id VARCHAR2(32) not null,
access_model VARCHAR2(1),
busi_type VARCHAR2(16),
order_type VARCHAR2(16),
order_no VARCHAR2(32),
plat_code VARCHAR2(32),
status VARCHAR2(1),
create_time DATE,
update_time DATE,
remark CLOB,
constraint PK_T_IMS_BUSI_ACCESS_FLOW primary key (access_id)
);
comment on column ims_user.t_ims_busi_access_flow.access_id is'对接流水号';
comment on column ims_user.t_ims_busi_access_flow.access_model is'对接类型(0:接入,1:接出)';
comment on column ims_user.t_ims_busi_access_flow.busi_type is'业务类型(收发货)';
comment on column ims_user.t_ims_busi_access_flow.order_type is'订单类型(logistics:物流单)';
comment on column ims_user.t_ims_busi_access_flow.order_no is'业务订单号';
comment on column ims_user.t_ims_busi_access_flow.plat_code is'平台编码';
comment on column ims_user.t_ims_busi_access_flow.status is'对接状态(0:失败,1:成功,2:超时)';
comment on column ims_user.t_ims_busi_access_flow.create_time is'创建时间';
comment on column ims_user.t_ims_busi_access_flow.update_time is'修改时间';
comment on column ims_user.t_ims_busi_access_flow.remark is'备注';