SpringMVC + MyBatis + Mysql + Redis(作为二级缓存)

知识点掌握了，还需要不断练习才能熟练运用。下面golang学习网给大家带来一个数据库开发实战，手把手教大家学习《SpringMVC + MyBatis + Mysql + Redis(作为二级缓存)》，在实现功能的过程中也带大家重新温习相关知识点，温故而知新，回头看看说不定又有不一样的感悟！

一、添加redis所需依赖
pom.xml

    
    org.springframework.dataspring-data-redis1.6.2.RELEASEredis.clientsjedis2.8.0

二、创建redis配置文件
redis.properties

# Redis settings
redis.host=127.0.0.1
redis.port=6379
redis.pass=
redis.maxIdle=300
redis.maxActive=600
redis.maxWait=1000
redis.timeout=10000
redis.testOnBorrow=true

三、创建Mybatis缓存实现类MybatisRedisCache

import org.apache.ibatis.cache.Cache;
import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;
import org.springframework.data.redis.connection.jedis.JedisConnection;
import org.springframework.data.redis.connection.jedis.JedisConnectionFactory;
import org.springframework.data.redis.serializer.JdkSerializationRedisSerializer;
import org.springframework.data.redis.serializer.RedisSerializer;
import redis.clients.jedis.exceptions.JedisConnectionException;
import java.util.concurrent.locks.ReadWriteLock;
import java.util.concurrent.locks.ReentrantReadWriteLock;


/**
 * @ClassName MybatisRedisCache
 * @Description: 使用redis作为Mybatis第二级缓存 创建缓存实现类MybatisRedisCache
 * @Author Jason
 * @Date 2020/4/7  14:56
 * @Version V1.0
 **/

public class MybatisRedisCache implements Cache
{
    private static final Logger logger = LogManager.getLogger(MybatisRedisCache.class);

    private static JedisConnectionFactory jedisConnectionFactory;

    private final String id;

    /**
     * The {@code ReadWriteLock}.
     */
    private final ReadWriteLock readWriteLock = new ReentrantReadWriteLock();

    public MybatisRedisCache(final String id) {
        if (id == null) {
            throw new IllegalArgumentException("Cache instances require an ID");
        }
        logger.debug("MybatisRedisCache:id=" + id);
        this.id = id;
    }

    @Override
    public void clear()
    {
        JedisConnection connection = null;
        try
        {
            connection = jedisConnectionFactory.getConnection();
            connection.flushDb();
            connection.flushAll();
        }
        catch (JedisConnectionException e)
        {
            e.printStackTrace();
        }
        finally
        {
            if (connection != null) {
                connection.close();
            }
        }
    }

    @Override
    public String getId()
    {
        return this.id;
    }

    @Override
    public Object getObject(Object key)
    {
        Object result = null;
        JedisConnection connection = null;
        try
        {
            connection = jedisConnectionFactory.getConnection();
            RedisSerializer

四、创建缓存转换中间类RedisCacheTransfer

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.redis.connection.jedis.JedisConnectionFactory;

/**
 * @ClassName RedisCacheTransfer
 * @Description: TODO 创建中间类RedisCacheTransfer，完成MybatisRedisCache.jedisConnectionFactory的静态注入
 * @Author Jason
 * @Date 2020/4/7  15:40
 * @Version V1.0
 **/
public class RedisCacheTransfer {
    @Autowired
    public void setJedisConnectionFactory(JedisConnectionFactory jedisConnectionFactory) {
        MybatisRedisCache.setJedisConnectionFactory(jedisConnectionFactory);
    }
}

五、spring.xml 引入redis配置

    classpath:jdbc.propertiesclasspath:redis.properties

六、mybatis配置缓存设置

七、mapper中启用二级缓存

    ....

八、Mybatis的二级缓存redis已完成配置，测试Demo自行编写
第一次测试结果!
未命中redis(即redis没有相关数据)到mysql数据库中查询

参考：亡羊补牢丶

以上就是《SpringMVC + MyBatis + Mysql + Redis(作为二级缓存)》的详细内容，更多关于mysql的资料请关注golang学习网公众号！