DEV Community

ts5432
ts5432

Posted on

Implement Paging,Top N and All query using JooqTemplate

@Service
public class UserService {
    @Autowired
    private JooqTemplate jt;
    // Retrieve results from different queries based on various LimitRanges
    // Paging query LimitRange.of(param.getLimit(), param.getOffset())
    // TopN query LimitRange.of(param.getLimit())
    // Full Query LimitRange.all()
    public LimitResult<user> selectUser(UserParam param,LimitRange range){
        List<condition> conditions=jt.conditions(jt.orOne("name","nick_name%");
        return jt.query("user_table",User.class,conditions,Arrays.asList(F("birthday").desc()),range);
    }
Enter fullscreen mode Exit fullscreen mode

Is it simple?

Top comments (0)