sqlserver中的datetime类型对应问题,数据库数据如下:
name time
5555 2000-03-30 10:07:10.010
66666 2000-03-20 10:07:10.100
Model类字段映射文件结果
|
|
|
|
|
Model类字段 |
映射文件 |
执行结果 |
|
Time time; |
<property name="time" column="time" type="time" /> OR <property name="time" column="time" /> |
[name=5555 , time=10:07:10]
[name=66666 , time=10:07:10] |
|
java.utils.Date time |
<property name="time" column="time" /> |
[name=5555 , time=2000-03-30 10:07:10.01]
[name=66666 , time=2000-03-20 10:07:10.1] |
|
java.utils.Date time |
<property name="time" column="time" type="date" /> |
[name=5555 , time=2000-03-30]
[name=66666 , time=2000-03-20] |
|
java.sql.Date time |
<property name="time" column="time" /> OR <property name="time" column="time" type="date" /> |
[name=5555 , time=2000-03-30]
[name=66666 , time=2000-03-20] |
|
Timestamp time |
<property name="time" column="time" type="timestamp" /> OR <property name="time" column="time" /> |
[name=5555 , time=2000-03-30 10:07:10.01]
[name=66666 , time=2000-03-20 10:07:10.1] |