mybatis的sql标记的使用

数据库：

create table INSURANCE_PRODUCT
(
  product_code  VARCHAR2(32) not null,
  product_name  NVARCHAR2(20),
  product_type  VARCHAR2(1),
  validate_date VARCHAR2(8)
)
;
alter table INSURANCE_PRODUCT
  add constraint PK primary key (PRODUCT_CODE);

insert into INSURANCE_PRODUCT (product_code, product_name, product_type, validate_date)
values ("01001", "牙刷", "1", "20150819");
insert into INSURANCE_PRODUCT (product_code, product_name, product_type, validate_date)
values ("01002", "毛巾", "1", "20150818");
insert into INSURANCE_PRODUCT (product_code, product_name, product_type, validate_date)
values ("01003", "脸盆", "1", "20150817");
insert into INSURANCE_PRODUCT (product_code, product_name, product_type, validate_date)
values ("02001", "手机", "2", "20150820");
insert into INSURANCE_PRODUCT (product_code, product_name, product_type, validate_date)
values ("02002", "笔记本", "2", "20150821");
insert into INSURANCE_PRODUCT (product_code, product_name, product_type, validate_date)
values ("02003", "ipad", "2", "20150822");
insert into INSURANCE_PRODUCT (product_code, product_name, product_type, validate_date)
values ("03001", "苹果", "3", "20150101");
insert into INSURANCE_PRODUCT (product_code, product_name, product_type, validate_date)
values ("03002", "香蕉", "3", "20150102");
insert into INSURANCE_PRODUCT (product_code, product_name, product_type, validate_date)
values ("03003", "梨子", "3", "20150103");
insert into INSURANCE_PRODUCT (product_code, product_name, product_type, validate_date)
values ("04001", "衣服", "4", "20150808");
commit;

create table INSURANCE_PRODUCT
(
  produc