时间类型TimeStamp前后台处理操作

妖狐艹你老母 2022-02-28 04:58 311阅读 0赞

前言：因为想要页面显示年月日时分秒，所以我用的是timestamp类型，效果如下：

![20190324193312867.png][]

之后点击保存，数据库效果如下：

![20190324193438350.png][]

首先：我们的entity如下：可知用的是timestamp类型

![20190324193816361.png][]

前台页面为：注意type类型为datetime-local

![20190324194517543.png][]

1：现在开始处理如何把数据库的timestamp类型显示到页面

mybatis的xml主要内容为：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JveXdjeA_size_16_color_FFFFFF_t_70][]

后台获取代码为：这里用的是ajax获取数据，所以使用responsebody

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JveXdjeA_size_16_color_FFFFFF_t_70 1][]

js代码主要为：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JveXdjeA_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JveXdjeA_size_16_color_FFFFFF_t_70 3][]

//用于timestamp类型显示到input类型为Datetime-Local页面上
    function formatterDatetimeLocalToPage(hm,format){
        var now = new Date(hm);
    //拼装完整日期格式
        var today = now.getFullYear() + "-" + fix((now.getMonth() + 1),2) + "-" + fix(now.getDate(),2)
            + "T" + fix(now.getHours(),2) + ":" + fix(now.getMinutes(),2);
        return today;
    }
    
    function fix(num, length) {
        return ('' + num).length < length ? ((new Array(length + 1)).join('0') + num).slice(-length) : '' + num;
    }

2：现在开始处理如何把页面type类型为datetime-local时间数据传递到后台修改进数据库中

js代码主要为:

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JveXdjeA_size_16_color_FFFFFF_t_70 4][]

![2019032420245617.png][]

//用于input类型为Datetime-Local的值传递到后台对象中的timestamp类型字段
    function formatterDatetimeLocalToApprication(formData,datetimeLocalName){
        var date=formData.get(datetimeLocalName);
        var n=date.split("T");
        date= n[0]+" "+n[1]+":00";
        formData.delete(datetimeLocalName);
        formData.append(datetimeLocalName, date);
        return formData;
    }

后台代码为：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JveXdjeA_size_16_color_FFFFFF_t_70 5][]

mybatis的xml主要内容为：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JveXdjeA_size_16_color_FFFFFF_t_70 6][]

总结：其实主要内容为js的代码，只需调用即可。

[20190324193312867.png]: /images/20220228/36ad439081894e93ad1ebae8f0db9cc0.png
[20190324193438350.png]: /images/20220228/cd3751ead7164041a9d2142ba94233af.png
[20190324193816361.png]: /images/20220228/795edf27ab664b40aaa6f1ae7b84f0e0.png
[20190324194517543.png]: /images/20220228/115a404984b446f5b79282d475d9bbe7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JveXdjeA_size_16_color_FFFFFF_t_70]: /images/20220228/3e43225a2afe45fcb32322d232bdc834.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JveXdjeA_size_16_color_FFFFFF_t_70 1]: /images/20220228/2d50e55ebfbd4212a4042cbf11c4a657.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JveXdjeA_size_16_color_FFFFFF_t_70 2]: /images/20220228/1f50d6ae178e41bb8b2e19bbb24d17a2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JveXdjeA_size_16_color_FFFFFF_t_70 3]: /images/20220228/0ed94d74e40e400b88115291fdf5411c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JveXdjeA_size_16_color_FFFFFF_t_70 4]: /images/20220228/7a04827d87b84e789629c4bc83c0deae.png
[2019032420245617.png]: /images/20220228/a15c8735d5434f5bb7fa84c8cfe913bc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JveXdjeA_size_16_color_FFFFFF_t_70 5]: /images/20220228/0c54515c170d4a24a9e2f00c8ae5b5f5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JveXdjeA_size_16_color_FFFFFF_t_70 6]: /images/20220228/7c0a20b7c8bd4f1b95308c4b0e8f61f0.png