<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.1.1</version>
</dependency>
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
<version>4.1.1</version>
</dependency>
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.tryonce.page.PageParam;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.StringUtils;
public class AppBookInfoServiceImpl extends ServiceImpl<AppBookInfoMapper, AppBookInfo> implements AppBookInfoService {
@Override
public IPage<AppBookInfo> getPage(PageParam<AppBookInfoQuery> pageParam) {
Page<AppBookInfo> platformPage = new Page<>(pageParam.getCurrent(), pageParam.getPageSize());
QueryWrapper<AppBookInfo> qw = new QueryWrapper<>();
AppBookInfoQuery appBookInfoQuery = pageParam.getCondition();
if (null != appBookInfoQuery) {
if (null != appBookInfoQuery.getId()) {
qw.eq("id", appBookInfoQuery.getId());
}
}
qw.orderByAsc("book_order");
return this.page(platformPage, qw);
}
}
mapper
public interface TestMapper extends BaseMapper<Test> {
@Select("select * from test where user_code = #{userCode} ")
IPage<Test> selectPage(@Param("page") Page page, @Param("userCode") String userCode);
}
service
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.tryonce.entity.Test;
import com.tryonce.mapper.TestMapper;
import com.tryonce.page.PageParam;
import com.tryonce.service.TestService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
@Slf4j
@Service
public class TestServiceImpl extends ServiceImpl<TestMapper, Test> implements TestService {
@Resource
private TestMapper testMapper;
@Override
public IPage<Test> getPage(PageParam<Test> pageParam) {
Page<Test> platformPage = new Page<>(pageParam.getCurrent(), pageParam.getPageSize());
testMapper.selectPage(platformPage, pageParam.getCondition().getUserCode());
return platformPage;
}
}