mybatis 时间查询 between

MyBatis supports the usage of the BETWEEN operator for time queries. You can use it to query for records within a specific time range. Here's an example of how you can use BETWEEN in a MyBatis XML mapper file:

<select id="selectRecordsBetweenDates" parameterType="java.util.Map" resultType="YourResultType">
  SELECT * FROM your_table
  WHERE your_date_column BETWEEN #{startDate} AND #{endDate}
</select>

In the above example, `your_table` is the name of your database table and `your_date_column` represents the column that stores the date or time values. The `startDate` and `endDate` parameters are used to specify the date range.

When calling this query in your Java code using MyBatis, you need to pass a `Map` parameter that contains the `startDate` and `endDate` values. Here's an example:

Map<String, Object> parameterMap = new HashMap<>();
parameterMap.put("startDate", startDateTime);
parameterMap.put("endDate", endDateTime);

YourResultType result = sqlSession.selectOne("selectRecordsBetweenDates", parameterMap);

Make sure to replace `YourResultType` with the actual result type you expect from the query. Also, adjust the SQL query and parameter names to match your specific database schema.

By using the BETWEEN operator in MyBatis, you can easily query for records within a specific time range based on your requirements.