jackblack369
12/20/2018 - 2:19 AM

[mybatis reference] some snippet about mybatis #mybatis

[mybatis reference] some snippet about mybatis #mybatis

mybatis jdbcType.md
content_copyfile_download
  • Rendered
  • Source
  • 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