Java implementation of post-top features

In the table that stores the records, add a column that controls the properties of the record, such as adding a kind column
The meaning of each value: 1 Normal 3 top

When the administrator is pinned, set the value of the corresponding record's kind column to 3

When the page is displayed, the SQL statement takes precedence over the kind column, sorted in descending order, so that the pinned record (that is, Kind=3 's record) is always displayed at the top.

Add a field in the database set its high-level top-level and order by level and date

Build a Istop field value of 0,1 (1 is pinned)
SELECT * from Table ORDER by Istop Desc,pubtime desc

Java implementation of post-top features