mapper:
import com. cmbchina . cpc . regul atory. App;
import com. cmbchina. cpc . regulatory . constant . CpcConstant ;
import com. cmbchina. cpc regulatory . const ant RegulatoryConstants;
import com. cmbchina. cpc regul atory . monthly .entity MonthlyReleaseEntity;
import com. cmbchina . cpc .regul atory .monthly . mapper.MonthlyReleaseMapper;import com. cmbchina . cpc . regulatory. util . Fileutil;
import lombok . extern. slf4j.Slf4j;import org. junit . BeforeClass ;import org . junit. Test;
import org. junit . runner . RunWith;
import org . springframework . beans . factory . annotation . Autowired;import org . springframework. boot . test . context . SpringBootTest;
import org . springframework . test . annotation . Rollback;
import org . springfr amework . test . context . junit4. SpringRunner;
import org. springframework. transaction. annotation. Transactional ;
import java . util .HashMap ;import java .util.List;import java . util . Map;
import static org. junit . Assert . assertEquals;
@Rundith(SpringRunner.class)
@SpringBootTest(classes . App.class)
public class МоnthlуRеlеаѕеМарреrТеѕt{
private static final int ENTITIES_SIZE =1;
//测试数据
private static List<MonthlyReleaseEntity> entities ;
@Autowired
private MonthlyReleaseMapper monthlyReleaseMapper;
@BeforeClass
public static void init() (
String str .=Fileutil.resolveJsonFileToString( path:“json/MonthlyReleaseList.json”
entities . =JsonUtil..toList(str, MonthlyReleaseEntity,class);
}
//插入一条数据
@Test
@Rollback //回滚
@Transactional //事务
public void insertOne() {
assertEquals(ENTITIES_SIZE, entities.size());
Integer result = monthlyReleaseHapper . insertOne(entitiesget(0));assertEquals(new Integer( value: 1),result);
}
//更新一条数据
@Test
@Rollback
@Transactional
public void updateOne() {
MonthlyReleaseEntity insertEntity -=entities.get(0);monthlyReleaseMapper.insert0ne( insertEntity);
String testInfoType .="201911150001";
insertEntity.setMonthlyNumber(testInfoType);monthlyReleaseMapper.update0ne (insertEntity);
MonthlyReleaseEntity selectEntity =new MonthlyReleaseEntity();selectEntity .setSeqId( insertEntity.getSeqId() );
selectEntity = monthlyReleaseMapper .selectOne(selectEntity);
assertEquals(testInfoType, selectEntity. getMonthlyNumber());}
//删除
@Test
@Rollback
@Transactional(rollbackFor=Exception.class)public void delete0ne() {
MonthlyReleaseEntity insertEntity .=entities. get(0);monthlyReleaseMapper .insertOne( insertEntity);
MonthlyReleaseEntity deleteEntity .=new MonthlyReleaseEntity();deleteEntity.,setDelFlag(RegulatoryConstants.IS_DEL_Y);
deleteEntity.setSeqId(insertEntity.getSeqId());
IdeleteEntity.setVersion( insertEntity.getVersion());
monthlyReleaseMapper.updateOne(deleteEntity);
MonthlyReleaseEntity selectEntity =- new MonthlyReleaseEntity();selectEntity.setSeqId( insertEntity.getSeqId() );
selectEntity = monthlyReleaseMapper.selectone(selectEntity)
assertEquals(RegulatoryConstants.IS_DEL_Y, selectEntity.getDelFlag):}
@Test
@Rollback /回滚
@Transactionalpublic void selectAll() {
// 1.播入
for (MonthlyReleaseEntity InsertEntity: entities) {MonmonthlyReleaseMapper.insertone(insertEntity);
//查询
Map<String, Object> filterMap =new Hashap<>();filterMap.put((Constant.DEL_FLAG,String.valueof(RegulatoryConstants.IS_DEL_Y);
filterMap.put(("monthlyNumber","201911150001");List<MonthlyReleaseEntity> entities=monthlyReleaseMapper.selectAll(filterMap);
//“3.验证数据
assertEquals(ENTITIES_SIZE, entities.size()):}
service:
@RunWith( SpringRunner .class)
@SpringBootTest(classes - App.class)
@S1f4j
public class MonthlyReleaseServiceTest {
//测试数据
private static List<MonthlyReleaseEntity> entities;
@Autowired
private MonthlyService monthlyService;
@Autowired
private BatchOperationService batchOperationService;
@BeforeClass
public static void init() {
1从文件中淒取測試数据
@RunWith( SpringRunner .class)
@SpringBootTest(classes - App.class)@S1f4j
public class MonthlyReleaseServiceTest {
1渕試数据
private static List<MonthlyReleaseEntity> entities;@Autowired
private MonthlyService monthlyService;@Autowired
private BatchoperationService batchOperationService;
@BeforeClass
public static void init() {
//从文件中淒取測試数据
String str .=Fileutil.resolveJsonFileToString( path:“json/MonthlyReleaseList.json”
entities . =JsonUtil..toList(str, MonthlyReleaseEntity,class);
}
//测试service 查询单条
@Test
@Rollback
@Transactionalpublic void selectOne() {
//1.插入
MonthlyReleaseEntity insertEntity = etities.get(0);monthlyService.insertOne(insertEntity);
//2.查询
MonthlyReleaseEntity selectEntity = new MonthlyReleaseEntity();
selectEntity.setSeqId( "MON201911150000009");
selectEntity=monthlyService.selectOne(selectEntity);3.验证数据
assertNotNull(selectEntity);assertEquals(insertEntity.getMonthlyNumber(),selectEntity.getMonthlyNumber());
}
//测试service插入
@Test
@Transactional
@Rollback
public void insert() (
assertEquals( expected:1,entites.seze());
Integer result -=monthlyService.insertOne(entites.get(0));assertEquals(new Integer( value: 1), result);
}
//测试service查询
@Test
@Transactional
@Rollback
public void selectAll() (
batchOperationService.batchooeration(entities, ((sqlsession, entity) ->sqlSessiion.insert( statement:"com.cmbchina.cpc.regulatory.monthlyReleaseMapper.insert() ;?????
Map<String.,Object> filterMap = new HashMap<>();
filterHap.put("monthlyNumber ,"1000");List<MonthlyReleaseEntity> entities =monthlyService.selectAll(filrerMap);
assertEquals(expected:1,entities.size());}
//分页查询
@Test
@Transactional
@Rollback
public void selectPage() l
int pageNo =1;
int pageSize=1;
int totalCount =1
batchOperationservice.batchoperation(entites, ((sqlsession, entity) ->sq1session
.insert( statement:"com.mbchina..cpc.regulatory.monthly.mapper..MonthlyReleasemapper.insertone". entites);????
Map<String. Object> filtertMap .=new HashMap<>();filterMap-put("monthlyNumber- "1000");
//查询条件
QueryCondition queryCondition = neu QueryConditlon();queryCondition.setPageNo(pageNo);
queryCondition.setPageSize(pageSize);
queryCondition.setFilterMap(filterMap);
Pagination<MonthiyReleaseEntity> pagenation=monthlyService.selectPage(queryConfition);
assertEquals(pageNo,pagination.getPageNum());assertEquals(pageSize,pagination.getPageSize());
assertEquals(pageSize,pagination.getList().size());
assertEquals(totalCount,pagination.getTotalCount());
}
//service更新
@Test
@Transactional
@Rollback
public vold updateOne() (
//1.插入
batchOperationservice.batchoperation(entites, ((sqlsession, entity) ->sq1session
.insert( statement:"com.mbchina..cpc.regulatory.monthly.mapper..MonthlyReleasemapper.insertone". entites);
//2.更新
String seqId = "mon589955566666" ;String testValue="896325";
MonthlyReleaseEntity updateEntity .=new MonthlyReleaseEntity();
updateEntity.setMonthlyNumber(testValue);
updateEntity.setSeqId(seqId);updateEntity.setVersion(1);
MonthyService.updateOne(updateEntity);//3.查询
MonthlyReleaseEntity selectEntity= new MonthlyReleaseEntity();
selectEntity.setSeqId(seqId);
selectEntity=monthlyService.selectOne(selectEntity);
//4.验证
assertEquals(testValue,selectEntity.getMonthlyNumber());
}
//service删除
@Test
@Transactional
@Rollback
public void deleteone() t
userProfile user=neu UserProfile();user.setUserId("000001")
userProfileutils.save(user);
MonthlyReleaseEntity entity .=entities.get(0);monthlyService.insertOne(entity);
MonthlyReleaseDTO monthlyReleaseDTO =new MonthlyReleaseDTO();
BeanUtils.copyProperties(entity,monthlyReleaseDTO);
Integer result =monthlyService.delete(monthlyReleaseDTO);
assertEquols(new Integer( value: 1), result);}
Controller: