利用SqlMap拼装Sql语句
private Date registerTime=null;
public Date getRegisterTime() {
return registerTime;
}
public void setRegisterTime(Date registerTime) {
this.registerTime = registerTime;
}在XML中:
insert into
.....
values
....
<isNotEmpty property="registerTime">
,#registerTime#
</isNotEmpty>
.....具体set的时候:
XXX dto = new XXX();
dto.setRegisterTime(new Date());本来插入的数据库的时间格式应该是yyyy-MM-dd HH:mm:ss的
现在时间时间格式为:04 8 2011 2:23PM这个要怎么改呢?
private Date registerTime=null;
public Date getRegisterTime() {
return registerTime;
}
public void setRegisterTime(Date registerTime) {
this.registerTime = registerTime;
}在XML中:
insert into
.....
values
....
<isNotEmpty property="registerTime">
,#registerTime#
</isNotEmpty>
.....具体set的时候:
XXX dto = new XXX();
dto.setRegisterTime(new Date());本来插入的数据库的时间格式应该是yyyy-MM-dd HH:mm:ss的
现在时间时间格式为:04 8 2011 2:23PM这个要怎么改呢?
插入数据库的格式就会变成这种类型啊:04 8 2011 2:23PM
dto.setRegisterTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse("2011-02-02 00:00:00"));
插入数据库的还是:
02 2 2011 12:00AM