[Java]如何把当前时间插入到数据库

[Java]如何把当前时间插入到数据库

1.在orderDao.java中

/** 设置订单*/
public void setOrder(Order order){

Date time = new Date(System.currentTimeMillis());
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String current = sdf.format(time);
order.setReceivedata(current);

this.sqlSessionTemplate.update("setOrder",order);
}

2.在orderMapper.xml中

insert into ORDERS (

ID,

OUTSETSTATIONID,
DESTSTATIONID,
ORDERSTATUS,

VEHICLEID,
RECEIVEDATA,
GOODSNAME,

GOODSNUMBER,
GOODSTYPEID,
GOODSTOTALWEIGHT,

GOODSTOTALVOLUME,
TOTALFARE,
SENDERNAME,

SENDERMOBILEPHONE,
SENDERADDRESS,
SENDERZIPCODE,

ADDRESSEENAME,
ADDRESSEEMOBILEPHONE,
ADDRESSEEADDRESS,

ADDRESSEEZIPCODE,
REMARK,
WAY_ID

)values(

{id},

{outsetstationid},

{deststationid},

'已发货',

{vehicleid},

to_date(#{receivedata},'yyyy-mm-dd hh24:mi:ss'),
#{goodsname},

{goodsnumber},

{goodstypeid},

{goodstotalweight},

{goodstotalvolume},

{totalfare},

{sendername},

{sendermobilephone},

{senderaddress},

{senderzipcode},

{addresseename},

{addresseemobilephone},

{addresseeaddress},

{addresseezipcode},

{remark},

)