Shulou(Shulou.com)05/31 Report--

This article mainly explains "java rolling loading how to achieve", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "java rolling loading how to achieve" it!

Paging loading is usually suitable for the client, usually in order to prevent a return from causing the client to crash, so drop-down loading is more used. in order to prevent data duplication, it is recommended to use a unique identity id.

Ordinary pull-down loading mode

For ordinary drop-down loading, we usually deal with it in the following steps:

1 the number of requests passed by the client and the id or time of the last piece of data of the last request (if it is the first request, it may not be passed)

2 the back end is arranged in a certain order according to the id or time requested by the terminal, and a fixed number is returned to the terminal. Thus, the terminal can be guaranteed to get the correct data each time.

Core sql query statement

SELECT * FROM admin WHERE id < 10000 ORDER BY id DESC LIMIT 1, size

Specifically defined data structure

# API address / scroll/list

# request method HTTP GET

# input parameter {"size": 10 size control / request size "id": 1 / / return data the last id} # output parameter # successful

{"flag": 1, "result": {"hasMore": ture, / / whether there is more data "total": 68, "list": [{"id": 1, / / file Id "desc": "description", / / can be empty "name": "David"}, {"id": 2 / / File Id "desc": "description", / / can be empty "name": "Tom"},...]}}

# failed {"flag": 0, "result": "error message"}

How to handle paging loading that contains a specific conditional order

For example, if the project requires that the already topped data be arranged at the front of all data (of course, the id of the topped data may be relatively small), then you need to sort by top, sort by id, and then query the data (for query data, you have to deal with it differently according to different conditions).

Core sql query statement

SELECT * FROM admin WHERE # if (idled null & & state==2) ((id < 21 AND state=2) OR statecraft 2) # elseif (idled null & & stateful null 2) id < 23 ORDER BY FIELD (state,2) DESC, id DESC LIMIT 1, size

Specifically defined data structure

# # API address

/ scroll/ List```

# # request method HTTP GET

# # input parameter {"size": 10 size control / request size "id": 1 / / return the last id of the data. The first request does not need to pass "state": 2 / / return the status information of the last data. The first request does not need to be passed} # # output parameter # # successful {"flag": 1, "result": {"hasMore": ture, / / whether there is more data "total": 68, "list": [{"id": 1, / / file Id "desc": "description", / / can be empty "name": "David" "state": 1}, {"id": 2, / / File Id "desc": "description", / / can be empty "name": "Tom", "state": 2},...]}} # # failed {"flag": 0, "result": "error message"} Thank you for reading The above is the content of "how to achieve java rolling loading". After the study of this article, I believe you have a deeper understanding of how to achieve java rolling loading, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.