亲宝软件园·资讯

展开

Java时间轴 怎样通过Java实现时间轴过程解析

lightbc 人气:0

这篇文章主要介绍了如何通过Java实现时间轴过程解析,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下

1.需要添加FastJson的依赖处理数据。

<dependency>
   <groupId>com.alibaba</groupId>
   <artifactId>fastjson</artifactId>
   <version>1.2.47</version>
</dependency>

2.创建测试数据库和表。

3.创建entity、dao、service、controller各层,可以使用EasyCode快速生成(之前博客有教程),然后增减代码。

entity

private static final long serialVersionUID = 423496079020131231L;
  
  private Integer id;

  @JSONField(format = "yyyy-MM-dd HH:mm:ss")
  private Date time;
  
  private String content;


  public Integer getId() {
    return id;
  }

  public void setId(Integer id) {
    this.id = id;
  }

  public Date getTime() {
    return time;
  }

  public void setTime(Date time) {
    this.time = time;
  }

  public String getContent() {
    return content;
  }

  public void setContent(String content) {
    this.content = content;
  }

dao

  /**
   * 获取所有数据
   * @return
   */
  List<Info> getAllData();

service

  /**
   * 获取所有数据
   * @return
   */
  List<Info> getAllData();

serviceimpl

@Resource
  private InfoDao infoDao;

  /**
   * 获取所有数据
   * @return
   */
  public List<Info> getAllData(){
    return this.infoDao.getAllData();
  }

controller

@Resource
  private InfoDao infoDao;

  /**
   * 获取所有数据
   * @return
   */
  public List<Info> getAllData(){
    return this.infoDao.getAllData();
  }

mapper

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.dao.InfoDao">

  <resultMap type="com.example.entity.Info" id="InfoMap">
    <result property="id" column="id" jdbcType="INTEGER"/>
    <result property="time" column="time" jdbcType="TIMESTAMP"/>
    <result property="content" column="content" jdbcType="VARCHAR"/>
  </resultMap>

  <!-- 查询所有数据 -->
  <select id="getAllData" resultMap="InfoMap">
    select * from ideatest.info order by time desc
  </select>

</mapper>

4.前端js、css、html文件编写。

html

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <title>时间轴</title>
  <link rel="stylesheet" href="../static/css/tl.css"/>
  <script type="text/javascript" src="../static/jquery-3.4.1.js"></script>
  <script src="../static/js/tl.js"></script>
</head>
<body>
<div class="container">
  <div class="time-line">
  </div>
</div>
</body>
</html>

css

* {
  margin: 0;
  padding: 0;
}

.container {
  margin: 20px;
}

.container .time-line {
  position: relative;
  width: 0;
  border-right: 1px gray dashed;
}

.container .square {
  position: absolute;
  width: 10px;
  height: 10px;
  margin-left: -5px;
  background-color: gray;
}

.container .square .time {
  position: absolute;
  width: 300px;
  height: 30px;
  margin-top: -10px;
  margin-left: 20px;
  line-height: 30px;
}

.container .square .content {
  position: absolute;
  width: 300px;
  height: 60px;
  margin-top: 20px;
  margin-left: 20px;
  line-height: 60px;
}

js

$.ajax({
  url: "/info/getAllData",
  type: "GET",
  success: function(data) {
    success(data);
  }
});

function success(data) {
  var result = JSON.parse(data);
  $(".container .time-line").css({
    "height": result.length * 100 + "px"
  });
  for (var i = 0; i < result.length; i++) {
    var childNode = "<div class='square' style='top:" + i * 100 + "px'>" +
      "<div class='time'>"+result[i].time+"</div>" +
      "<div class='content'>" + result[i].content + "</div>" +
      "</div>";
    $(".container .time-line").append(childNode);
  }
}

Ps:因为数据库的时区问题,所以可在数据库的连接URL后添加如下参数:

serverTimezone=Hongkong

5.效果展示

加载全部内容

相关教程
猜你喜欢
用户评论