使用mysql实现redis

表结构

CREATE TABLE `bus_k_v_data` (
  `k` varchar(512) NOT NULL COMMENT ' k',
  `v` tinytext COMMENT 'v',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `ttl` bigint(20) DEFAULT NULL COMMENT '存活时间单位秒',
  PRIMARY KEY (`k`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

## 实体
@Data
@TableName(value = "bus_k_v_data")
public class KVData implements Serializable {
    /**
     * k
     */
    @TableId(value = "k", type = IdType.INPUT)
    private String k;

    /**
     * v
     */
    @TableField(value = "v")
    private String v;

    /**
     * 创建时间
     */
    @TableField(value = "create_time")
    private LocalDateTime createTime;

    /**
     * ttl
     */
    @TableField(value = "ttl")
    private Long ttl;

    private static final long serialVersionUID = 1L;
}
xml
<?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.xs.job.mapper.KVDataMapper">

  <select id="getVByKey" resultType="java.lang.String">
      SELECT IF
                 (
                         ttl = - 1,
                         v,
                         IF
                             (TIMESTAMPDIFF(SECOND, create_time, NOW()) &lt; ttl, v, NULL)) AS r
      FROM bus_k_v_data
      WHERE k = #{key}
  </select>

  <insert id="setVByKey">
    INSERT INTO `bus_k_v_data` ( `k`, `v`, `create_time`, `ttl`)
    VALUES
    (  #{key}, #{value}, NOW() , #{ttl})
    ON DUPLICATE KEY UPDATE v =  #{value},
    create_time = NOW(),
    ttl = #{ttl};
  </insert>
</mapper>