@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);
}
Is it simple?
Top comments (0)