How to sort by time by MyBatis

This article introduces the relevant knowledge of "how to sort MyBatis by time". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

MyBatis sorts test code by time ActivityReadExample readExample = new ActivityReadExample (); readExample.setOrderByClause ("create_time desc"); ActivityReadExample.Criteria criteria1 = readExample.createCriteria (); criteria1.andActivityIdEqualTo (activity.getId ()); List reads = activityReadMapper.selectByExample (readExample); sorting code readExample.setOrderByClause ("create_time desc"); MyBatis time sorting problem

The create_time field is of type DateTime in the data

The corresponding member variable type in the entity class after reverse engineering is Date.

The time sort code is

Test results:

The timing is out of order.

Solution method

1. Create fields of type varchar in the database, generate String type after reverse engineering, insert the database with new Date () in the java business layer, and then use

Example1.setOrderByClause ("create_time desc")

Sorting can be achieved.

2. Use the primary key (id) to sort, instead of time sorting.

This is the end of the content of "how to sort MyBatis by time". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!