jackson/fastjson、mybatis、mysql date/datatime/timestamp、java Date/Timestamp关系详解

第一种方法：
JSON.DEFFAULT_DATE_FORMAT = "yyyy-MM-dd";
String str = JSON.toJSONString(user,SerializerFeature.WriteDateUseDateFormat);

第二种方法：

<code>JSON.toJSONStringWithDateFormat(date, "yyyy-MM-dd HH:mm:ss.SSS")</code>

=================<br>Timestamp对应MySQL的datetime类型

Timestamp对应MySQL的timestamp类型Date会对应mysql的date类型<em id="__mceDel"><span class="tag"><<span class="tag-name">result <span class="attribute">column=<span class="attribute-value">"modified_date" <span class="attribute">jdbcType=<span class="attribute-value">"TIMESTAMP" <span class="attribute">property=<span class="attribute-value">"modified_date" <span class="attribute">javaType=<span class="attribute-value">"java.sql.Timestamp" <span class="tag">/>  </span></span></span></span></span></span></span></span></span></span></span></em>

<em id="__mceDel"><em id="__mceDel"><span class="tag"><<span class="tag-name">result <span class="attribute">column=<span class="attribute-value">"date" <span class="attribute">jdbcType=<span class="attribute-value">"DATE" <span class="attribute">property=<span class="attribute-value">"date" <span class="attribute">javaType=<span class="attribute-value">"java.util.Date" <span class="tag">/><br>字段标明：#{modified_date,jdbcType=TIMESTAMP}、#{date,jdbcType=DATE}<br><br>具体可参考：https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-type-conversions.html</span></span></span></span></span></span></span></span></span></span></span></em></em>

jackson/fastjson、mybatis、mysql date/datatime/timestamp、java Date/Timestamp关系详解

标签：知识库   类型   code   serial   app   用户   datetime   情况   obj