Mapper CRUD 接口
1. selectById
@Test
void testSelectById ( ) {
ActivityType activityType = activityTypeMapper. selectById ( 9 ) ;
System. out. println ( "activityType = " + activityType) ;
}
2. selectOne
@Test
void testSelectOne ( ) {
ActivityType activityType = activityTypeMapper. selectOne ( new QueryWrapper < ActivityType> ( ) . eq ( "id" , 9 ) ) ;
System. out. println ( "activityType = " + activityType) ;
}
3. selectBatchIds
@Test
void testSelectBatchIds ( ) {
ArrayList< Integer> ids = new ArrayList < > ( ) ;
ids. add ( 9 ) ;
ids. add ( 11 ) ;
List< ActivityType> activityTypes = activityTypeMapper. selectBatchIds ( ids) ;
activityTypes. forEach ( System. out: : println) ;
}
4. selectList
@Test
void testSelectList ( ) {
List< ActivityType> activityTypeList = activityTypeMapper. selectList ( new QueryWrapper < ActivityType> ( ) . gt ( "id" , 9 ) ) ;
activityTypeList. forEach ( System. out: : println) ;
}
5.selectByMap
@Test
void testSelectByMap ( ) {
HashMap< String, Object> map = new HashMap < > ( ) ;
map. put ( "id" , 10 ) ;
List< ActivityType> activityTypes = activityTypeMapper. selectByMap ( map) ;
activityTypes. forEach ( System. out: : println) ;
}
6. selectMaps
@Test
void testSelectMaps ( ) {
List< Map< String, Object> > mapList = activityTypeMapper. selectMaps ( new QueryWrapper < ActivityType> ( ) . gt ( "id" , 8 ) ) ;
mapList. forEach ( System. out: : println) ;
}
7. selectObjs
@Test
void testSelectObjs ( ) {
List< Object> objectList = activityTypeMapper. selectObjs ( new QueryWrapper < ActivityType> ( ) . likeLeft ( "name" , "1" ) . gt ( "id" , 8 ) ) ;
objectList. forEach ( System. out: : println) ;
}
8.selectPage
@Test
void testSelectPage ( ) {
Page< ActivityType> activityTypePage = new Page < > ( ) ;
activityTypePage. setSize ( 3 ) ;
activityTypePage. setCurrent ( 1 ) ;
Page< ActivityType> typePage = activityTypeMapper. selectPage ( activityTypePage, new QueryWrapper < ActivityType> ( ) . gt ( "id" , 0 ) ) ;
typePage. getRecords ( ) . forEach ( System. out: : println) ;
}
9.selectMapsPage
@Test
void testSelectMapsPage ( ) {
Page< Map< String, Object> > mapPage = new Page < > ( ) ;
mapPage. setSize ( 3 ) ;
mapPage. setCurrent ( 1 ) ;
Page< Map< String, Object> > mapsPage = activityTypeMapper. selectMapsPage ( mapPage, new QueryWrapper < ActivityType> ( ) . gt ( "id" , 0 ) ) ;
mapsPage. getRecords ( ) . forEach ( System. out: : println) ;
}
10.selectCount
@Test
void testSelectCount ( ) {
Integer count = activityTypeMapper. selectCount ( new QueryWrapper < ActivityType> ( ) . notLike ( "name" , "1" ) ) ;
System. out. println ( "count = " + count) ;
}
11.update
@Test
void testUpdate ( ) {
ArrayList< Integer> ids = new ArrayList < > ( ) ;
ids. add ( 9 ) ;
ids. add ( 11 ) ;
ActivityType activityType = new ActivityType ( ) ;
activityType. setName ( "666" ) ;
int id = activityTypeMapper. update ( activityType, new QueryWrapper < ActivityType> ( ) . in ( "id" , ids) ) ;
System. out. println ( "id = " + id) ;
}
12.updateById
@Test
void testUpdateById ( ) {
ActivityType activityType = new ActivityType ( ) ;
activityType. setId ( 9 ) ;
activityType. setName ( "999" ) ;
int updateById = activityTypeMapper. updateById ( activityType) ;
System. out. println ( "updateById = " + updateById) ;
}
13.deleteByMap
@Test
void testDeleteByMap ( ) {
Map< String, Object> map = new HashMap < > ( ) ;
map. put ( "Name" , "222" ) ;
int count = activityTypeMapper. deleteByMap ( map) ;
System. out. println ( "count = " + count) ;
}
14.deleteBatchIds
@Test
void testDeleteBatchIds ( ) {
List< Integer> ids = new ArrayList < > ( ) ;
ids. add ( 9 ) ;
ids. add ( 11 ) ;
int count = activityTypeMapper. deleteBatchIds ( ids) ;
System. out. println ( "count = " + count) ;
}
15.deleteById
@Test
void testDeleteById ( ) {
int count = activityTypeMapper. deleteById ( 9 ) ;
System. out. println ( "count = " + count) ;
}
16.delete
@Test
void testDelete ( ) {
int delete = activityTypeMapper. delete ( new QueryWrapper < ActivityType> ( ) . eq ( "Name" , "111" ) ) ;
System. out. println ( "delete = " + delete) ;
}
17.insert
@Test
void testInsert ( ) {
ActivityType activityType = new ActivityType ( ) ;
activityType. setName ( "111" ) ;
activityType. setAddTime ( new Date ( ) ) ;
activityType. setAddMenId ( 0 ) ;
activityType. setIsDel ( false ) ;
activityType. setAddTimeStr ( "" ) ;
int insert = activityTypeMapper. insert ( activityType) ;
System. out. println ( "insert = " + insert) ;
}