每日知识存档

1、写一个线程安全的单例模式(利用内部类)

public class Singleton {
    private static class LazyHolder {
        private static final Singleton INSTANCE = new Singleton();
    }

    private Singleton() {
        
    }

    public static final Singleton getInstance() {
        return LazyHolder.INSTANCE;
    }

}

2、按月统计数据

SELECT
    DATE_FORMAT(created, '%Y%m') AS created,
    count(1) AS count
FROM
    user
GROUP BY

    DATE_FORMAT(created, '%Y%m')

3、mybatis缓存

1、mybatis默认不开启二级缓存

2、以下设置开启二级缓存

    <settings>

        <setting name="cacheEnabled" value="true"/>
    </settings>