超详细的Mybatis注解开发整理（三）

最新推荐文章于 2022-12-19 10:08:00 发布
最新推荐文章于 2022-12-19 10:08:00 发布
阅读量263 收藏
点赞数
分类专栏： Android开发个人资源 转发资源 环境搭建 文章标签： java android studio android 接口规范
原文链接：https://blog.csdn.net/weixin_43883917/article/details/113830667
版权

mybatis 基于注解的二级缓存

在 SqlMapConfig.xml 中开启二级缓存支持

<span style="color:#000000"><code class="language-xml"><span style="color:#5c6370"><!--配置开启二级缓存--></span>
<span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"><</span>settings</span><span style="color:#999999">></span></span>
    <span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"><</span>setting</span> <span style="color:#d19a66">name</span><span style="color:#669900"><span style="color:#999999">=</span><span style="color:#999999">"</span>cacheEnabled<span style="color:#999999">"</span></span> <span style="color:#d19a66">value</span><span style="color:#669900"><span style="color:#999999">=</span><span style="color:#999999">"</span>true<span style="color:#999999">"</span></span><span style="color:#999999">/></span></span>
<span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"></</span>settings</span><span style="color:#999999">></span></span>
</code></span>

在持久层接口中使用注解配置二级缓存

<span style="color:#000000"><code class="language-java"><span style="color:#c678dd">package</span> com<span style="color:#999999">.</span>keafmd<span style="color:#999999">.</span>dao<span style="color:#999999">;</span>

<span style="color:#c678dd">import</span> com<span style="color:#999999">.</span>keafmd<span style="color:#999999">.</span>domain<span style="color:#999999">.</span>User<span style="color:#999999">;</span>
<span style="color:#c678dd">import</span> org<span style="color:#999999">.</span>apache<span style="color:#999999">.</span>ibatis<span style="color:#999999">.</span>annotations<span style="color:#999999">.</span>*<span style="color:#999999">;</span>
<span style="color:#c678dd">import</span> org<span style="color:#999999">.</span>apache<span style="color:#999999">.</span>ibatis<span style="color:#999999">.</span>mapping<span style="color:#999999">.</span>FetchType<span style="color:#999999">;</span>

<span style="color:#c678dd">import</span> java<span style="color:#999999">.</span>util<span style="color:#999999">.</span>List<span style="color:#999999">;</span>

<span style="color:#5c6370">/**
 * Keafmd
 *
 * @ClassName: IUserDao
 * @Description:
 * @author: 牛哄哄的柯南
 * @date: 2021-02-16 20:30
 */</span>

<span style="color:#5c6370">/**
 * 在mybatis中针对CRUD一共有四个注解
 * @Select @Insert @Update @Delete
 */</span>
<span style="color:#999999">@CacheNamespace</span><span style="color:#999999">(</span>blocking <span style="color:#669900">=</span> <span style="color:#56b6c2">true</span><span style="color:#999999">)</span> <span style="color:#5c6370">//mybatis 基于注解方式实现配置二级缓存 *这里*</span>
<span style="color:#c678dd">public</span> <span style="color:#c678dd">interface</span> IUserDao <span style="color:#999999">{</span>

    <span style="color:#5c6370">/**
     * 查询所有用户
     * @return
     */</span>
    <span style="color:#999999">@Select</span><span style="color:#999999">(</span><span style="color:#669900">"select * from user"</span><span style="color:#999999">)</span>
    <span style="color:#999999">@Results</span><span style="color:#999999">(</span>id<span style="color:#669900">=</span><span style="color:#669900">"userMap"</span><span style="color:#999999">,</span>value<span style="color:#669900">=</span><span style="color:#999999">{</span>
            <span style="color:#999999">@Result</span><span style="color:#999999">(</span>id <span style="color:#669900">=</span> <span style="color:#56b6c2">true</span><span style="color:#999999">,</span>column <span style="color:#669900">=</span> <span style="color:#669900">"id"</span><span style="color:#999999">,</span>property <span style="color:#669900">=</span> <span style="color:#669900">"userId"</span><span style="color:#999999">)</span><span style="color:#999999">,</span>
            <span style="color:#999999">@Result</span><span style="color:#999999">(</span>column <span style="color:#669900">=</span> <span style="color:#669900">"id"</span><span style="color:#999999">,</span>property <span style="color:#669900">=</span> <span style="color:#669900">"userId"</span><span style="color:#999999">)</span><span style="color:#999999">,</span>
            <span style="color:#999999">@Result</span><span style="color:#999999">(</span>column <span style="color:#669900">=</span> <span style="color:#669900">"username"</span><span style="color:#999999">,</span>property <span style="color:#669900">=</span> <span style="color:#669900">"userName"</span><span style="color:#999999">)</span><span style="color:#999999">,</span>
            <span style="color:#999999">@Result</span><span style="color:#999999">(</span>column <span style="color:#669900">=</span> <span style="color:#669900">"sex"</span><span style="color:#999999">,</span>property <span style="color:#669900">=</span> <span style="color:#669900">"userSex"</span><span style="color:#999999">)</span><span style="color:#999999">,</span>
            <span style="color:#999999">@Result</span><span style="color:#999999">(</span>column <span style="color:#669900">=</span> <span style="color:#669900">"birthday"</span><span style="color:#999999">,</span>property <span style="color:#669900">=</span> <span style="color:#669900">"userBirthday"</span><span style="color:#999999">)</span><span style="color:#999999">,</span>
            <span style="color:#999999">@Result</span><span style="color:#999999">(</span>property <span style="color:#669900">=</span> <span style="color:#669900">"accounts"</span> <span style="color:#999999">,</span>column <span style="color:#669900">=</span> <span style="color:#669900">"id"</span><span style="color:#999999">,</span>
                    many <span style="color:#669900">=</span> <span style="color:#999999">@Many</span><span style="color:#999999">(</span>select <span style="color:#669900">=</span> <span style="color:#669900">"com.keafmd.dao.IAccountDao.findAccountByUid"</span><span style="color:#999999">,</span>
                            fetchType <span style="color:#669900">=</span> FetchType<span style="color:#999999">.</span>LAZY<span style="color:#999999">)</span><span style="color:#999999">)</span>

    <span style="color:#999999">}</span><span style="color:#999999">)</span>
    List<span style="color:#61aeee"><span style="color:#999999"><</span>User<span style="color:#999999">></span></span> <span style="color:#61aeee">findAll</span><span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">;</span>


    <span style="color:#5c6370">/**
     * 根据id查询用户
     * @param userId
     * @return
     */</span>
    <span style="color:#999999">@Select</span><span style="color:#999999">(</span><span style="color:#669900">"select * from user where id=#{id}"</span><span style="color:#999999">)</span>
    <span style="color:#5c6370">//@ResultMap(value={"userMap"})</span>
    <span style="color:#999999">@ResultMap</span><span style="color:#999999">(</span><span style="color:#669900">"userMap"</span><span style="color:#999999">)</span>
    User <span style="color:#61aeee">findById</span><span style="color:#999999">(</span>Integer userId<span style="color:#999999">)</span><span style="color:#999999">;</span>

    <span style="color:#5c6370">/**
     * 根据用户名称模糊查询
     * @param username
     * @return
     */</span>
    <span style="color:#999999">@Select</span><span style="color:#999999">(</span><span style="color:#669900">"select * from user where username like #{username}"</span><span style="color:#999999">)</span> <span style="color:#5c6370">//占位符</span>
    <span style="color:#999999">@ResultMap</span><span style="color:#999999">(</span><span style="color:#669900">"userMap"</span><span style="color:#999999">)</span>
    List<span style="color:#61aeee"><span style="color:#999999"><</span>User<span style="color:#999999">></span></span> <span style="color:#61aeee">findByName</span><span style="color:#999999">(</span>String username<span style="color:#999999">)</span><span style="color:#999999">;</span>


<span style="color:#999999">}</span>
</code></span>

编写测试二级缓存的测试类

<span style="color:#000000"><code class="language-java"><span style="color:#c678dd">package</span> com<span style="color:#999999">.</span>keafmd<span style="color:#999999">.</span>test<span style="color:#999999">;</span>

<span style="color:#c678dd">import</span> com<span style="color:#999999">.</span>keafmd<span style="color:#999999">.</span>dao<span style="color:#999999">.</span>IUserDao<span style="color:#999999">;</span>
<span style="color:#c678dd">import</span> com<span style="color:#999999">.</span>keafmd<span style="color:#999999">.</span>domain<span style="color:#999999">.</span>User<span style="color:#999999">;</span>
<span style="color:#c678dd">import</span> org<span style="color:#999999">.</span>apache<span style="color:#999999">.</span>ibatis<span style="color:#999999">.</span>io<span style="color:#999999">.</span>Resources<span style="color:#999999">;</span>
<span style="color:#c678dd">import</span> org<span style="color:#999999">.</span>apache<span style="color:#999999">.</span>ibatis<span style="color:#999999">.</span>session<span style="color:#999999">.</span>SqlSession<span style="color:#999999">;</span>
<span style="color:#c678dd">import</span> org<span style="color:#999999">.</span>apache<span style="color:#999999">.</span>ibatis<span style="color:#999999">.</span>session<span style="color:#999999">.</span>SqlSessionFactory<span style="color:#999999">;</span>
<span style="color:#c678dd">import</span> org<span style="color:#999999">.</span>apache<span style="color:#999999">.</span>ibatis<span style="color:#999999">.</span>session<span style="color:#999999">.</span>SqlSessionFactoryBuilder<span style="color:#999999">;</span>
<span style="color:#c678dd">import</span> org<span style="color:#999999">.</span>junit<span style="color:#999999">.</span>After<span style="color:#999999">;</span>
<span style="color:#c678dd">import</span> org<span style="color:#999999">.</span>junit<span style="color:#999999">.</span>Before<span style="color:#999999">;</span>
<span style="color:#c678dd">import</span> org<span style="color:#999999">.</span>junit<span style="color:#999999">.</span>Test<span style="color:#999999">;</span>

<span style="color:#c678dd">import</span> java<span style="color:#999999">.</span>io<span style="color:#999999">.</span>InputStream<span style="color:#999999">;</span>
<span style="color:#c678dd">import</span> java<span style="color:#999999">.</span>util<span style="color:#999999">.</span>List<span style="color:#999999">;</span>

<span style="color:#5c6370">/**
 * Keafmd
 *
 * @ClassName: SecondLevelCatchTest
 * @Description: 二级缓存测试
 * @author: 牛哄哄的柯南
 * @date: 2021-02-16 23:37
 */</span>
<span style="color:#c678dd">public</span> <span style="color:#c678dd">class</span> SecondLevelCatchTest <span style="color:#999999">{</span>
    <span style="color:#c678dd">private</span> InputStream in<span style="color:#999999">;</span>
    <span style="color:#c678dd">private</span> SqlSessionFactory factory<span style="color:#999999">;</span>

    <span style="color:#999999">@Before</span>
    <span style="color:#c678dd">public</span> <span style="color:#c678dd">void</span> <span style="color:#61aeee">init</span><span style="color:#999999">(</span><span style="color:#999999">)</span> <span style="color:#c678dd">throws</span> Exception<span style="color:#999999">{</span>
        in <span style="color:#669900">=</span> Resources<span style="color:#999999">.</span><span style="color:#61aeee">getResourceAsStream</span><span style="color:#999999">(</span><span style="color:#669900">"SqlMapConfig.xml"</span><span style="color:#999999">)</span><span style="color:#999999">;</span>
        factory <span style="color:#669900">=</span> <span style="color:#c678dd">new</span> SqlSessionFactoryBuilder<span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">.</span><span style="color:#61aeee">build</span><span style="color:#999999">(</span>in<span style="color:#999999">)</span><span style="color:#999999">;</span>
    <span style="color:#999999">}</span>

    <span style="color:#999999">@After</span>
    <span style="color:#c678dd">public</span> <span style="color:#c678dd">void</span> <span style="color:#61aeee">destory</span><span style="color:#999999">(</span><span style="color:#999999">)</span> <span style="color:#c678dd">throws</span> Exception<span style="color:#999999">{</span>


        in<span style="color:#999999">.</span><span style="color:#61aeee">close</span><span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">;</span>
    <span style="color:#999999">}</span>


    <span style="color:#999999">@Test</span>
    <span style="color:#c678dd">public</span> <span style="color:#c678dd">void</span> <span style="color:#61aeee">testFindOne</span><span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">{</span>
        SqlSession session <span style="color:#669900">=</span> factory<span style="color:#999999">.</span><span style="color:#61aeee">openSession</span><span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">;</span>
        IUserDao userDao <span style="color:#669900">=</span> session<span style="color:#999999">.</span><span style="color:#61aeee">getMapper</span><span style="color:#999999">(</span>IUserDao<span style="color:#999999">.</span><span style="color:#c678dd">class</span><span style="color:#999999">)</span><span style="color:#999999">;</span>
        User user <span style="color:#669900">=</span> userDao<span style="color:#999999">.</span><span style="color:#61aeee">findById</span><span style="color:#999999">(</span><span style="color:#98c379">55</span><span style="color:#999999">)</span><span style="color:#999999">;</span>
        System<span style="color:#999999">.</span>out<span style="color:#999999">.</span><span style="color:#61aeee">println</span><span style="color:#999999">(</span>user<span style="color:#999999">)</span><span style="color:#999999">;</span>

        session<span style="color:#999999">.</span><span style="color:#61aeee">close</span><span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">;</span><span style="color:#5c6370">//释放一级缓存</span>

        SqlSession session1 <span style="color:#669900">=</span> factory<span style="color:#999999">.</span><span style="color:#61aeee">openSession</span><span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">;</span><span style="color:#5c6370">//再次打开session</span>
        IUserDao userDao1 <span style="color:#669900">=</span> session1<span style="color:#999999">.</span><span style="color:#61aeee">getMapper</span><span style="color:#999999">(</span>IUserDao<span style="color:#999999">.</span><span style="color:#c678dd">class</span><span style="color:#999999">)</span><span style="color:#999999">;</span>

        User user2 <span style="color:#669900">=</span> userDao1<span style="color:#999999">.</span><span style="color:#61aeee">findById</span><span style="color:#999999">(</span><span style="color:#98c379">55</span><span style="color:#999999">)</span><span style="color:#999999">;</span>
        System<span style="color:#999999">.</span>out<span style="color:#999999">.</span><span style="color:#61aeee">println</span><span style="color:#999999">(</span>user2<span style="color:#999999">)</span><span style="color:#999999">;</span>

        System<span style="color:#999999">.</span>out<span style="color:#999999">.</span><span style="color:#61aeee">println</span><span style="color:#999999">(</span>user<span style="color:#669900">==</span>user2<span style="color:#999999">)</span><span style="color:#999999">;</span>
    <span style="color:#999999">}</span>


<span style="color:#999999">}</span>
</code></span>

不开启二级缓存配置的运行结果：

<span style="color:#000000"><code class="language-java"><span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">119</span> <span style="color:#98c379">320</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG ansaction<span style="color:#999999">.</span>jdbc<span style="color:#999999">.</span>JdbcTransaction  <span style="color:#669900">-</span> Opening JDBC Connection
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">509</span> <span style="color:#98c379">710</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG source<span style="color:#999999">.</span>pooled<span style="color:#999999">.</span>PooledDataSource  <span style="color:#669900">-</span> Created connection <span style="color:#98c379">85445963.</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">510</span> <span style="color:#98c379">711</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG ansaction<span style="color:#999999">.</span>jdbc<span style="color:#999999">.</span>JdbcTransaction  <span style="color:#669900">-</span> Setting autocommit to <span style="color:#56b6c2">false</span> on JDBC Connection <span style="color:#999999">[</span>com<span style="color:#999999">.</span>mysql<span style="color:#999999">.</span>jdbc<span style="color:#999999">.</span>JDBC4Connection<span style="color:#999999">@517cd4b</span><span style="color:#999999">]</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">514</span> <span style="color:#98c379">715</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG m<span style="color:#999999">.</span>keafmd<span style="color:#999999">.</span>dao<span style="color:#999999">.</span>IUserDao<span style="color:#999999">.</span>findById  <span style="color:#669900">-</span> <span style="color:#669900">==</span><span style="color:#669900">></span>  Preparing<span style="color:#669900">:</span> select <span style="color:#669900">*</span> from user where id<span style="color:#669900">=</span><span style="color:#669900">?</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">551</span> <span style="color:#98c379">752</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG m<span style="color:#999999">.</span>keafmd<span style="color:#999999">.</span>dao<span style="color:#999999">.</span>IUserDao<span style="color:#999999">.</span>findById  <span style="color:#669900">-</span> <span style="color:#669900">==</span><span style="color:#669900">></span> Parameters<span style="color:#669900">:</span> <span style="color:#61aeee">55</span><span style="color:#999999">(</span>Integer<span style="color:#999999">)</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">633</span> <span style="color:#98c379">834</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG m<span style="color:#999999">.</span>keafmd<span style="color:#999999">.</span>dao<span style="color:#999999">.</span>IUserDao<span style="color:#999999">.</span>findById  <span style="color:#669900">-</span> <span style="color:#669900"><=</span><span style="color:#669900">=</span>      Total<span style="color:#669900">:</span> <span style="color:#98c379">1</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">634</span> <span style="color:#98c379">835</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG o<span style="color:#999999">.</span>IAccountDao<span style="color:#999999">.</span>findAccountByUid  <span style="color:#669900">-</span> <span style="color:#669900">==</span><span style="color:#669900">></span>  Preparing<span style="color:#669900">:</span> select <span style="color:#669900">*</span> from account where uid <span style="color:#669900">=</span> <span style="color:#669900">?</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">634</span> <span style="color:#98c379">835</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG o<span style="color:#999999">.</span>IAccountDao<span style="color:#999999">.</span>findAccountByUid  <span style="color:#669900">-</span> <span style="color:#669900">==</span><span style="color:#669900">></span> Parameters<span style="color:#669900">:</span> <span style="color:#61aeee">55</span><span style="color:#999999">(</span>Integer<span style="color:#999999">)</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">635</span> <span style="color:#98c379">836</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG o<span style="color:#999999">.</span>IAccountDao<span style="color:#999999">.</span>findAccountByUid  <span style="color:#669900">-</span> <span style="color:#669900"><=</span><span style="color:#669900">=</span>      Total<span style="color:#669900">:</span> <span style="color:#98c379">0</span>
User<span style="color:#999999">{</span>userId<span style="color:#669900">=</span><span style="color:#98c379">55</span><span style="color:#999999">,</span> userName<span style="color:#669900">=</span><span style="color:#669900">'mybatis annotation'</span><span style="color:#999999">,</span> userAddress<span style="color:#669900">=</span><span style="color:#669900">'null'</span><span style="color:#999999">,</span> userSex<span style="color:#669900">=</span><span style="color:#669900">'男'</span><span style="color:#999999">,</span> userBirthday<span style="color:#669900">=</span>Tue Feb <span style="color:#98c379">16</span> <span style="color:#98c379">22</span><span style="color:#669900">:</span><span style="color:#98c379">15</span><span style="color:#669900">:</span><span style="color:#98c379">36</span> CST <span style="color:#98c379">2021</span><span style="color:#999999">}</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">635</span> <span style="color:#98c379">836</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG ansaction<span style="color:#999999">.</span>jdbc<span style="color:#999999">.</span>JdbcTransaction  <span style="color:#669900">-</span> Resetting autocommit to <span style="color:#56b6c2">true</span> on JDBC Connection <span style="color:#999999">[</span>com<span style="color:#999999">.</span>mysql<span style="color:#999999">.</span>jdbc<span style="color:#999999">.</span>JDBC4Connection<span style="color:#999999">@517cd4b</span><span style="color:#999999">]</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">636</span> <span style="color:#98c379">837</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG ansaction<span style="color:#999999">.</span>jdbc<span style="color:#999999">.</span>JdbcTransaction  <span style="color:#669900">-</span> Closing JDBC Connection <span style="color:#999999">[</span>com<span style="color:#999999">.</span>mysql<span style="color:#999999">.</span>jdbc<span style="color:#999999">.</span>JDBC4Connection<span style="color:#999999">@517cd4b</span><span style="color:#999999">]</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">636</span> <span style="color:#98c379">837</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG source<span style="color:#999999">.</span>pooled<span style="color:#999999">.</span>PooledDataSource  <span style="color:#669900">-</span> Returned connection <span style="color:#98c379">85445963</span> to pool<span style="color:#999999">.</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">636</span> <span style="color:#98c379">837</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG ansaction<span style="color:#999999">.</span>jdbc<span style="color:#999999">.</span>JdbcTransaction  <span style="color:#669900">-</span> Opening JDBC Connection
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">636</span> <span style="color:#98c379">837</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG source<span style="color:#999999">.</span>pooled<span style="color:#999999">.</span>PooledDataSource  <span style="color:#669900">-</span> Checked out connection <span style="color:#98c379">85445963</span> from pool<span style="color:#999999">.</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">636</span> <span style="color:#98c379">837</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG ansaction<span style="color:#999999">.</span>jdbc<span style="color:#999999">.</span>JdbcTransaction  <span style="color:#669900">-</span> Setting autocommit to <span style="color:#56b6c2">false</span> on JDBC Connection <span style="color:#999999">[</span>com<span style="color:#999999">.</span>mysql<span style="color:#999999">.</span>jdbc<span style="color:#999999">.</span>JDBC4Connection<span style="color:#999999">@517cd4b</span><span style="color:#999999">]</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">636</span> <span style="color:#98c379">837</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG m<span style="color:#999999">.</span>keafmd<span style="color:#999999">.</span>dao<span style="color:#999999">.</span>IUserDao<span style="color:#999999">.</span>findById  <span style="color:#669900">-</span> <span style="color:#669900">==</span><span style="color:#669900">></span>  Preparing<span style="color:#669900">:</span> select <span style="color:#669900">*</span> from user where id<span style="color:#669900">=</span><span style="color:#669900">?</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">637</span> <span style="color:#98c379">838</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG m<span style="color:#999999">.</span>keafmd<span style="color:#999999">.</span>dao<span style="color:#999999">.</span>IUserDao<span style="color:#999999">.</span>findById  <span style="color:#669900">-</span> <span style="color:#669900">==</span><span style="color:#669900">></span> Parameters<span style="color:#669900">:</span> <span style="color:#61aeee">55</span><span style="color:#999999">(</span>Integer<span style="color:#999999">)</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">639</span> <span style="color:#98c379">840</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG m<span style="color:#999999">.</span>keafmd<span style="color:#999999">.</span>dao<span style="color:#999999">.</span>IUserDao<span style="color:#999999">.</span>findById  <span style="color:#669900">-</span> <span style="color:#669900"><=</span><span style="color:#669900">=</span>      Total<span style="color:#669900">:</span> <span style="color:#98c379">1</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">641</span> <span style="color:#98c379">842</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG o<span style="color:#999999">.</span>IAccountDao<span style="color:#999999">.</span>findAccountByUid  <span style="color:#669900">-</span> <span style="color:#669900">==</span><span style="color:#669900">></span>  Preparing<span style="color:#669900">:</span> select <span style="color:#669900">*</span> from account where uid <span style="color:#669900">=</span> <span style="color:#669900">?</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">641</span> <span style="color:#98c379">842</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG o<span style="color:#999999">.</span>IAccountDao<span style="color:#999999">.</span>findAccountByUid  <span style="color:#669900">-</span> <span style="color:#669900">==</span><span style="color:#669900">></span> Parameters<span style="color:#669900">:</span> <span style="color:#61aeee">55</span><span style="color:#999999">(</span>Integer<span style="color:#999999">)</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">31</span><span style="color:#669900">:</span><span style="color:#98c379">32</span><span style="color:#999999">,</span><span style="color:#98c379">642</span> <span style="color:#98c379">843</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG o<span style="color:#999999">.</span>IAccountDao<span style="color:#999999">.</span>findAccountByUid  <span style="color:#669900">-</span> <span style="color:#669900"><=</span><span style="color:#669900">=</span>      Total<span style="color:#669900">:</span> <span style="color:#98c379">0</span>
User<span style="color:#999999">{</span>userId<span style="color:#669900">=</span><span style="color:#98c379">55</span><span style="color:#999999">,</span> userName<span style="color:#669900">=</span><span style="color:#669900">'mybatis annotation'</span><span style="color:#999999">,</span> userAddress<span style="color:#669900">=</span><span style="color:#669900">'null'</span><span style="color:#999999">,</span> userSex<span style="color:#669900">=</span><span style="color:#669900">'男'</span><span style="color:#999999">,</span> userBirthday<span style="color:#669900">=</span>Tue Feb <span style="color:#98c379">16</span> <span style="color:#98c379">22</span><span style="color:#669900">:</span><span style="color:#98c379">15</span><span style="color:#669900">:</span><span style="color:#98c379">36</span> CST <span style="color:#98c379">2021</span><span style="color:#999999">}</span>
<span style="color:#56b6c2">false</span>

Process finished with exit code <span style="color:#98c379">0</span>
</code></span>

开启二级缓存配置的运行结果：

<span style="color:#000000"><code class="language-java"><span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">29</span><span style="color:#669900">:</span><span style="color:#98c379">23</span><span style="color:#999999">,</span><span style="color:#98c379">197</span> <span style="color:#98c379">373</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG ansaction<span style="color:#999999">.</span>jdbc<span style="color:#999999">.</span>JdbcTransaction  <span style="color:#669900">-</span> Opening JDBC Connection
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">29</span><span style="color:#669900">:</span><span style="color:#98c379">23</span><span style="color:#999999">,</span><span style="color:#98c379">605</span> <span style="color:#98c379">781</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG source<span style="color:#999999">.</span>pooled<span style="color:#999999">.</span>PooledDataSource  <span style="color:#669900">-</span> Created connection <span style="color:#98c379">500179317.</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">29</span><span style="color:#669900">:</span><span style="color:#98c379">23</span><span style="color:#999999">,</span><span style="color:#98c379">606</span> <span style="color:#98c379">782</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG ansaction<span style="color:#999999">.</span>jdbc<span style="color:#999999">.</span>JdbcTransaction  <span style="color:#669900">-</span> Setting autocommit to <span style="color:#56b6c2">false</span> on JDBC Connection <span style="color:#999999">[</span>com<span style="color:#999999">.</span>mysql<span style="color:#999999">.</span>jdbc<span style="color:#999999">.</span>JDBC4Connection<span style="color:#999999">@1dd02175</span><span style="color:#999999">]</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">29</span><span style="color:#669900">:</span><span style="color:#98c379">23</span><span style="color:#999999">,</span><span style="color:#98c379">617</span> <span style="color:#98c379">793</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG m<span style="color:#999999">.</span>keafmd<span style="color:#999999">.</span>dao<span style="color:#999999">.</span>IUserDao<span style="color:#999999">.</span>findById  <span style="color:#669900">-</span> <span style="color:#669900">==</span><span style="color:#669900">></span>  Preparing<span style="color:#669900">:</span> select <span style="color:#669900">*</span> from user where id<span style="color:#669900">=</span><span style="color:#669900">?</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">29</span><span style="color:#669900">:</span><span style="color:#98c379">23</span><span style="color:#999999">,</span><span style="color:#98c379">668</span> <span style="color:#98c379">844</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG m<span style="color:#999999">.</span>keafmd<span style="color:#999999">.</span>dao<span style="color:#999999">.</span>IUserDao<span style="color:#999999">.</span>findById  <span style="color:#669900">-</span> <span style="color:#669900">==</span><span style="color:#669900">></span> Parameters<span style="color:#669900">:</span> <span style="color:#61aeee">55</span><span style="color:#999999">(</span>Integer<span style="color:#999999">)</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">29</span><span style="color:#669900">:</span><span style="color:#98c379">23</span><span style="color:#999999">,</span><span style="color:#98c379">777</span> <span style="color:#98c379">953</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG m<span style="color:#999999">.</span>keafmd<span style="color:#999999">.</span>dao<span style="color:#999999">.</span>IUserDao<span style="color:#999999">.</span>findById  <span style="color:#669900">-</span> <span style="color:#669900"><=</span><span style="color:#669900">=</span>      Total<span style="color:#669900">:</span> <span style="color:#98c379">1</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">29</span><span style="color:#669900">:</span><span style="color:#98c379">23</span><span style="color:#999999">,</span><span style="color:#98c379">781</span> <span style="color:#98c379">957</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG o<span style="color:#999999">.</span>IAccountDao<span style="color:#999999">.</span>findAccountByUid  <span style="color:#669900">-</span> <span style="color:#669900">==</span><span style="color:#669900">></span>  Preparing<span style="color:#669900">:</span> select <span style="color:#669900">*</span> from account where uid <span style="color:#669900">=</span> <span style="color:#669900">?</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">29</span><span style="color:#669900">:</span><span style="color:#98c379">23</span><span style="color:#999999">,</span><span style="color:#98c379">782</span> <span style="color:#98c379">958</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG o<span style="color:#999999">.</span>IAccountDao<span style="color:#999999">.</span>findAccountByUid  <span style="color:#669900">-</span> <span style="color:#669900">==</span><span style="color:#669900">></span> Parameters<span style="color:#669900">:</span> <span style="color:#61aeee">55</span><span style="color:#999999">(</span>Integer<span style="color:#999999">)</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">29</span><span style="color:#669900">:</span><span style="color:#98c379">23</span><span style="color:#999999">,</span><span style="color:#98c379">782</span> <span style="color:#98c379">958</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG o<span style="color:#999999">.</span>IAccountDao<span style="color:#999999">.</span>findAccountByUid  <span style="color:#669900">-</span> <span style="color:#669900"><=</span><span style="color:#669900">=</span>      Total<span style="color:#669900">:</span> <span style="color:#98c379">0</span>
User<span style="color:#999999">{</span>userId<span style="color:#669900">=</span><span style="color:#98c379">55</span><span style="color:#999999">,</span> userName<span style="color:#669900">=</span><span style="color:#669900">'mybatis annotation'</span><span style="color:#999999">,</span> userAddress<span style="color:#669900">=</span><span style="color:#669900">'null'</span><span style="color:#999999">,</span> userSex<span style="color:#669900">=</span><span style="color:#669900">'男'</span><span style="color:#999999">,</span> userBirthday<span style="color:#669900">=</span>Tue Feb <span style="color:#98c379">16</span> <span style="color:#98c379">22</span><span style="color:#669900">:</span><span style="color:#98c379">15</span><span style="color:#669900">:</span><span style="color:#98c379">36</span> CST <span style="color:#98c379">2021</span><span style="color:#999999">}</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">29</span><span style="color:#669900">:</span><span style="color:#98c379">23</span><span style="color:#999999">,</span><span style="color:#98c379">790</span> <span style="color:#98c379">966</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG ansaction<span style="color:#999999">.</span>jdbc<span style="color:#999999">.</span>JdbcTransaction  <span style="color:#669900">-</span> Resetting autocommit to <span style="color:#56b6c2">true</span> on JDBC Connection <span style="color:#999999">[</span>com<span style="color:#999999">.</span>mysql<span style="color:#999999">.</span>jdbc<span style="color:#999999">.</span>JDBC4Connection<span style="color:#999999">@1dd02175</span><span style="color:#999999">]</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">29</span><span style="color:#669900">:</span><span style="color:#98c379">23</span><span style="color:#999999">,</span><span style="color:#98c379">791</span> <span style="color:#98c379">967</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG ansaction<span style="color:#999999">.</span>jdbc<span style="color:#999999">.</span>JdbcTransaction  <span style="color:#669900">-</span> Closing JDBC Connection <span style="color:#999999">[</span>com<span style="color:#999999">.</span>mysql<span style="color:#999999">.</span>jdbc<span style="color:#999999">.</span>JDBC4Connection<span style="color:#999999">@1dd02175</span><span style="color:#999999">]</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">29</span><span style="color:#669900">:</span><span style="color:#98c379">23</span><span style="color:#999999">,</span><span style="color:#98c379">791</span> <span style="color:#98c379">967</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG source<span style="color:#999999">.</span>pooled<span style="color:#999999">.</span>PooledDataSource  <span style="color:#669900">-</span> Returned connection <span style="color:#98c379">500179317</span> to pool<span style="color:#999999">.</span>
<span style="color:#98c379">2021</span><span style="color:#669900">-</span><span style="color:#98c379">02</span><span style="color:#669900">-</span><span style="color:#98c379">17</span> <span style="color:#98c379">03</span><span style="color:#669900">:</span><span style="color:#98c379">29</span><span style="color:#669900">:</span><span style="color:#98c379">23</span><span style="color:#999999">,</span><span style="color:#98c379">800</span> <span style="color:#98c379">976</span>    <span style="color:#999999">[</span>           main<span style="color:#999999">]</span> DEBUG        com<span style="color:#999999">.</span>keafmd<span style="color:#999999">.</span>dao<span style="color:#999999">.</span>IUserDao  <span style="color:#669900">-</span> Cache Hit Ratio <span style="color:#999999">[</span>com<span style="color:#999999">.</span>keafmd<span style="color:#999999">.</span>dao<span style="color:#999999">.</span>IUserDao<span style="color:#999999">]</span><span style="color:#669900">:</span> <span style="color:#98c379">0.5</span>
User<span style="color:#999999">{</span>userId<span style="color:#669900">=</span><span style="color:#98c379">55</span><span style="color:#999999">,</span> userName<span style="color:#669900">=</span><span style="color:#669900">'mybatis annotation'</span><span style="color:#999999">,</span> userAddress<span style="color:#669900">=</span><span style="color:#669900">'null'</span><span style="color:#999999">,</span> userSex<span style="color:#669900">=</span><span style="color:#669900">'男'</span><span style="color:#999999">,</span> userBirthday<span style="color:#669900">=</span>Tue Feb <span style="color:#98c379">16</span> <span style="color:#98c379">22</span><span style="color:#669900">:</span><span style="color:#98c379">15</span><span style="color:#669900">:</span><span style="color:#98c379">36</span> CST <span style="color:#98c379">2021</span><span style="color:#999999">}</span>
<span style="color:#56b6c2">false</span>

Process finished with exit code <span style="color:#98c379">0</span>
</code></span>

效果很明显，开启使用二级缓存时第二次并没有发起查询，证明使用的就是二级缓存。

QY’UniverseSpace
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
超详细的Mybatis注解开发整理（一）
QY'UniverseSpace的博客
02-19 183
Mybatis注解开发 mybatis的常用注解 使用 Mybatis 注解实现基本 CRUD 项目目录结构 编写实体类 使用注解方式开发持久层接口 编写 SqlMapConfig.xml 配置文件 编写测试代码 使用注解实现复杂关系映射开发 复杂关系映射的注解说明 项目目录 使用注解实现一对一复杂关系映射及立即加载 添加 User 实体类及 Account 实体类 添加账户的持久层接口并使用注解配置 添加用户的持久层接口并使用注解配置 测试一对一关联及立即加载 使用注解实.
插入时出现MyBatisSystemException: nested exception is
hushuai1559的博客
12-13 1586
检查完xml文件没错后，还是出现错误 org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'outTradeNo' not found. Available parameters are [video_order, param1] at org.mybatis.spring.MyBatisExceptionTranslator
MyBatis项目集成时出现错误Caused by: java.lang.ClassNotFoundException: org.apache.ibatis.logging.LogFactory
qq_51347243的博客
10-03 1173
Caused by: java.lang.ClassNotFoundException: org.apache.ibatis.logging.LogFactory
mybatis-plus团队新作：mybatis-mate 轻松搞定数据权限
Java团长的博客
11-06 984
点击关注公众号，实用技术文章及时了解0、简介mybatis-mate 为 mp 企业级模块，支持分库分表，数据审计、数据敏感词过滤（AC算法），字段加密，字典回写（数据绑定），数据权限，表...
MybatisPlus使用中遇到如下错误的 解决方式
热门推荐
诗水人间
11-10 14万+
============================ CONDITIONS EVALUATION REPORT ============================ Positive matches: ----------------- AopAutoConfiguration matched: - @ConditionalOnProperty (spring.a...
MyBatis使用注解开发实现步骤解析
08-18
MyBatis使用注解开发实现步骤解析 MyBatis是一个流行的持久层框架，它提供了两种方式来开发映射语句，一种是使用XML文件，另一种是使用注解。使用注解开发可以减少配置文件的数量，提高开发效率，但需要注意一些...
MyBatis使用注解开发实现过程详解
08-19
主要介绍了MyBatis使用注解开发实现过程详解,文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下
mybatis学习笔记之mybatis注解配置详解
08-28
本文通过示例代码，展示了 MyBatis 的注解配置的使用方法，并对常用的 MyBatis 注解进行了详细的解释。通过本文的学习，读者可以更好地理解 MyBatis 的注解配置，并应用于实际项目中。 MyBatis 的注解配置提供了一...
struts2 + spring + mybatis 注解开发
05-19
Struts2、Spring和Mybatis是Java Web开发中常见的三大框架，它们的组合应用极大地提升了开发效率和代码的可维护性。在这个项目中，我们利用Struts2作为表现层框架，Spring3.0作为控制层和持久层的管理工具，而...
Mybatis系列教程Mybatis注解开发共9页.pdf
11-19
Mybatis系列教程Mybatis注解开发共9页.pdf.zip
mybatis plus 3.2.1破解版
11-10
mybatis plus 3.2.1破解版 mybatis plus 3.2.1破解版 mybatis plus 3.2.1破解版
报错记录_SpringBoot整合MyBatis
qq_62636613的博客
05-13 679
在使用SpringBoot整合MyBatis时出现的报错 最开始以为是Mapper接口、xml、Controller、Service其中一个写错了 最后看到了这个： Property 'configuration' and 'configLocation' can not specified with together 结果发现是因为配置yml时同时使用了config-location与configuration（具体原因尚不清楚） 具体如下： mybatis: config-loca..
Cannot load configuration class: org.mybatis.spring.boot.autoconfigure.MybatisAutoConfiguration
wang_he_qing的博客
10-24 2万+
当启动时报错，查看错误信息，如Cannot load configuration class: org.mybatis.spring.boot.autoconfigure.MybatisAutoConfiguration 就是无法加载配置类mybatis，为什么无法加载，就需要去看pom文件的mybatis依赖有没有写错，以及版本 mybatis的3.4.0及以上版本只支持mybatis-sp...
在整合springboot和Mybatis-plus时的一个小坑而已
qq_51705526的博客
01-22 8558
一个小坑: Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter. Registered plugin: 'com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor@4f281aaf' Property 'mapperLocations' was not specified. 可能是因为你的类写错了,比如本来就该是一
mybatis插入的字符串主键变成了0？
haoweng4800的博客
12-19 532
记录一个神奇的事情，之前没这么用过。本来我插入的字符主键 000000，结果插入的SQL显示 0。离谱不？ 直接说原因，我插入的主键本来有值，但sql写了主键赋值的操作。就是下面这句话。但是这是mybatis反向生成的，没想到会出问题。 <selectKey resultType="java.lang.String" keyProperty="snNo" order="BEFORE"...
mybatis-plus 团队新作 mybatis-mate 轻松搞定数据权限
隔壁老瓦的专栏
10-06 1830
一、主要功能 字典绑定 字段加密 数据脱敏 表结构动态维护 数据审计记录 数据范围（数据权限） 数据库分库分表、动态据源、读写分离、数据库健康检查自动切换。 二、使用 2.1 依赖导入 Spring Boot 引入自动依赖注解包 <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-mate-starter</artifactId> <
【MyBatis入门】第一次接触MyBatis遇到的错误、原因及解决方案
YundyCinnamon的博客
01-25 622
报错①：MapperRegistry不知道UserDao、报错②：找不到UserMapper.xml、报错③：1 字节的 UTF-8 序列的字节 1 无效。问题的具体描述、原因及解决方案。
Mybatis 读取时间类型数据时间值读出值00:00:00问题解决
Ep流苏的博客
09-08 1696
MySQL 中的时间类型有 Date、DateTime、Timestamp等，对应 Java 类型的 Date 或 Java 1.8 后的 LocalDate/LocalDateTime。 而在写 SQL 进行字段关系映射时，需要指定对应的 jdbcType，当指定的类型不正确时，可能导致数据的不一致性。 <resultMap id="BaseResultMap" type="io.zsy.model.EquityTransactionInfo"> <id column="demo
mybatis注解开发
最新发布
04-07
MyBatis注解开发是一种使用注解来替代MyBatis XML配置文件的方式。使用注解可以简化开发，提高开发效率，减少代码量。下面介绍一些常用的MyBatis注解及其使用方法： 1. @Select 用于配置SELECT语句，可以直接在...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值