日期和时间分为两个字段
实体属性为
privateDateoccurDate;
private
Date
occurTime
;
mybaits映射文件
<
result
column
=
"OCCUR_DATE"
property
=
"occurDate"
jdbcType
=
"DATE"
/>
<
result
column
=
"OCCUR_TIME"
property
=
"occurTime"
jdbcType
=
"TIME"
/>
数据库表字段设计
日期和时间放在一个字段里面
实体属性为
private
Date
impDateTime
;
mybaits映射文件
<
result
column
=
"IMP_DATE_TIME"
jdbcType
=
"TIMESTAMP"
property
=
"impDateTime"
/>
数据库表字段设计
ps:如果这IMP_DATE_TIME长度设计成6位,会造成字段除了日期和时间这些信息还会在后面加6个0