[mybatis reference] some snippet about mybatis #mybatis

mybatis jdbcType.md

• about date jdbcType

  #{beginDate,jdbcType=DATE} (no time of the day), or
  #{beginDate,jdbcType=TIMESTAMP} (if you need to include the time of the day).
  

And the Java parameter you want to apply should be of type:

java.sql.Date (date without time)
java.sql.Timestamp (timestamp)
java.util.Date (date and time).

• the Greater Than/Equal Operator and the Less Than/Equal Operators:

  ROWNUM >= 20
  ROWNUM <= 20