在jsp前后台传递时间数据中,时间数据的转换
首先是数据的设计,可以看到cardcreatetime和cardupdatetime是datetime类型
CREATE TABLE `usercard` (
`cardid` int(10) NOT NULL AUTO_INCREMENT,
`cardbinfoid` int(10) NOT NULL,
`cardtitle` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`cardadmin` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`cardcreatetime` datetime NOT NULL,
`cardupdatetime` datetime NOT NULL,
`cardcontent` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`cardtotal` int(255) NOT NULL DEFAULT 0,
PRIMARY KEY (`cardid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;
在后台model的创建时,字段和字段类型为如下
private int cardid;
private int cardbinfoid;
private String cardtitle;
private String cardadmin;
private Date cardcreatetime;
private Date cardupdatetime;
private String cardcontent;
private int cardtotal;
private Block block;
经过后台Mybatis的数据操作,获取到的cardcreatetime和cardupdatetime值为CST类型的
Sun Apr 14 16:19:20 CST 2019
Sun Apr 14 16:17:54 CST 2019
Sun Apr 14 16:17:38 CST 2019
Sun Apr 14 16:15:58 CST 2019
Sun Apr 14 16:15:04 CST 2019
Thu Apr 11 14:50:36 CST 2019
由于后台是Mybatis写的,就直接在页面对数据进行修改
在页面最上方引入fmt
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
然后在要转换格式的地方把
${card.cardcreatetime}
替换为
<fmt:formatDate type="both" dateStyle="medium" timeStyle="medium" value="${card.cardcreatetime}" />
结果为:
2019-4-14 16:19:20