MBatis-plus：架构使用

（1）简单搭建方式

Mapper层

@Mapper
public interface HospitalSetMapper extends BaseMapper<HospitalSet> {
}

Service层接口

public interface HospitalSetService extends IService<HospitalSet> {
}

Service实现类

@Service
public class HospitalSetServiceImpl extends ServiceImpl<HospitalSetMapper, HospitalSet> implements HospitalSetService {
}

注意：原来service调用mappe需要把mapper注入到service，但是我们继承了ServiceImpl，里面已经帮助我们完成了注入，直接使用BaseMapper完成调用

Controller层

@RestController
@RequestMapping("/admin/hosp/hospitalSet")
public class HospitalSetController {
    @Autowired
    private HospitalSetService hospitalSetService;
}

在MyBatis-Plus不仅在Mapper中给我们封装了方法，在Service也进行了封装，在写代码是会非常的方便，直接通过controller去掉service中的方法，很方便的实现对数据库的操作

（2）复杂搭建方式

Mapper层

public interface AppUserMapper extends BaseMapper<AppUser> {
}

Service层接口

public interface BaseService<T> extends IService<T> {
}

实现类BaseServiceImpl

@Slf4j          继承了ServiceImpl，里面已经帮助我们完成了注入BaseMapper
public class BaseServiceImpl<M extends BaseMapper<T>, T extends Object> extends ServiceImpl<M, T> implements BaseService<T>{                                                               
}

业务层公共接口

public interface IAppUserService extends BaseService<AppUser> {
}

业务层实现类AppUserServiceImpl

@Service        
public class AppUserServiceImpl extends BaseServiceImpl<AppUserMapper, AppUser>          
                                                      implements IAppUserService {
}

Controller层

@Slf4j
@Api(tags="App用户")
@RestController
@RequestMapping("/bus/user")
public class AppUserController extends BaseController<AppUser, IAppUserService> {
@Autowired
private IAppUserService appUserService;

}

（3）MyBatis-Plus分页接口代码

Controller接口
@AutoLog(value = "用户管理-分页列表查询")
@ApiOperation(value = "App用户-分页列表查询", notes = "App用户-分页列表查询")
@GetMapping(value = "/list")
public Result queryPageList(AppUserReq appUserReq, @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
                            @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize) {
    Page<AppUserRes> page = new Page<>(pageNo, pageSize);
    IPage<AppUserRes> pageList = appUserService.queryPageList(page, appUserReq);
    return Result.ok(pageList);
}

Service接口 

public interface IAppUserService extends BaseService<AppUser> {

      IPage<AppUserRes> queryPageList(IPage<AppUserRes> page, AppUserReq appUserReq);
}

实现类：

@Service
public class AppUserServiceImpl extends BaseServiceImpl<AppUserMapper, AppUser> implements IAppUserService {
@Override
public IPage<AppUserRes> queryPageList(IPage<AppUserRes> page, AppUserReq appUserReq) {
    Map<String, Object> reqParam = new HashMap<>();
    reqParam.put("companyName", appUserReq.getCompanyName());
    reqParam.put("userMobile", appUserReq.getPhone());
IPage<AppUserRes> resultList = this.baseMapper.queryPage(page, reqParam);
    return resultList;
}

Mapper接口

public interface AppUserMapper extends BaseMapper<AppUser> {

      IPage<AppUserRes> queryPage(IPage<AppUserRes>  page, @Param(value = "p")          Map<String, Object> reqParam);

}

Mapper.xml：写sql

<selectid="queryPage"parameterType="map" resultType="com.hyit.platform.modules.business.user.vo.AppUserRes">
     select
        id,
        user_name,
        company_name,
        phone user_mobile,
        user_type,
        company_review_type companyReviewType,
        user_level,
        company_name companyName,
        locked,
        signup_time signupTime
      from app_user
    <include refid="whereNewsinfo_plus"/>
</select>