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

最新推荐文章于 2024-04-13 02:38:21 发布
最新推荐文章于 2024-04-13 02:38:21 发布
阅读量186 收藏 1
点赞数
分类专栏： Android开发个人资源 转发资源 环境搭建 文章标签： 编辑器 android studio android java 深度学习
原文链接：https://blog.csdn.net/weixin_43883917/article/details/113830667
版权

Mybatis注解开发

 

mybatis的常用注解

注解说明
@Insert实现新增
@Delete实现删除
@Update实现更新
@Select实现查询
@Result实现结果集封装
@Results可以与@Result 一起使用，封装多个结果集
@ResultMap实现引用@Results 定义的封装
@One实现一对一结果集封装
@Many实现一对多结果集封装
@SelectProvider实现动态 SQL 映射
@CacheNamespace实现注解二级缓存的使用

使用 Mybatis 注解实现基本 CRUD

项目目录结构

在这里插入图片描述

编写实体类

User：

<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>domain<span style="color:#999999">;</span>

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

<span style="color:#5c6370">/**
 * Keafmd
 *
 * @ClassName: User
 * @Description: User实体类
 * @author: 牛哄哄的柯南
 * @date: 2021-02-16 20:28
 */</span>
<span style="color:#c678dd">public</span> <span style="color:#c678dd">class</span> User <span style="color:#c678dd">implements</span> Serializable <span style="color:#999999">{</span>
    <span style="color:#c678dd">private</span> Integer id<span style="color:#999999">;</span>
    <span style="color:#c678dd">private</span> String username<span style="color:#999999">;</span>
    <span style="color:#c678dd">private</span> String address<span style="color:#999999">;</span>
    <span style="color:#c678dd">private</span> String sex<span style="color:#999999">;</span>
    <span style="color:#c678dd">private</span> Date birthday<span style="color:#999999">;</span>

    <span style="color:#c678dd">public</span> Integer <span style="color:#61aeee">getId</span><span style="color:#999999">(</span><span style="color:#999999">)</span> <span style="color:#999999">{</span>
        <span style="color:#c678dd">return</span> id<span style="color:#999999">;</span>
    <span style="color:#999999">}</span>

    <span style="color:#c678dd">public</span> <span style="color:#c678dd">void</span> <span style="color:#61aeee">setId</span><span style="color:#999999">(</span>Integer id<span style="color:#999999">)</span> <span style="color:#999999">{</span>
        <span style="color:#c678dd">this</span><span style="color:#999999">.</span>id <span style="color:#669900">=</span> id<span style="color:#999999">;</span>
    <span style="color:#999999">}</span>

    <span style="color:#c678dd">public</span> String <span style="color:#61aeee">getUsername</span><span style="color:#999999">(</span><span style="color:#999999">)</span> <span style="color:#999999">{</span>
        <span style="color:#c678dd">return</span> username<span style="color:#999999">;</span>
    <span style="color:#999999">}</span>

    <span style="color:#c678dd">public</span> <span style="color:#c678dd">void</span> <span style="color:#61aeee">setUsername</span><span style="color:#999999">(</span>String username<span style="color:#999999">)</span> <span style="color:#999999">{</span>
        <span style="color:#c678dd">this</span><span style="color:#999999">.</span>username <span style="color:#669900">=</span> username<span style="color:#999999">;</span>
    <span style="color:#999999">}</span>

    <span style="color:#c678dd">public</span> String <span style="color:#61aeee">getAddress</span><span style="color:#999999">(</span><span style="color:#999999">)</span> <span style="color:#999999">{</span>
        <span style="color:#c678dd">return</span> address<span style="color:#999999">;</span>
    <span style="color:#999999">}</span>

    <span style="color:#c678dd">public</span> <span style="color:#c678dd">void</span> <span style="color:#61aeee">setAddress</span><span style="color:#999999">(</span>String address<span style="color:#999999">)</span> <span style="color:#999999">{</span>
        <span style="color:#c678dd">this</span><span style="color:#999999">.</span>address <span style="color:#669900">=</span> address<span style="color:#999999">;</span>
    <span style="color:#999999">}</span>

    <span style="color:#c678dd">public</span> String <span style="color:#61aeee">getSex</span><span style="color:#999999">(</span><span style="color:#999999">)</span> <span style="color:#999999">{</span>
        <span style="color:#c678dd">return</span> sex<span style="color:#999999">;</span>
    <span style="color:#999999">}</span>

    <span style="color:#c678dd">public</span> <span style="color:#c678dd">void</span> <span style="color:#61aeee">setSex</span><span style="color:#999999">(</span>String sex<span style="color:#999999">)</span> <span style="color:#999999">{</span>
        <span style="color:#c678dd">this</span><span style="color:#999999">.</span>sex <span style="color:#669900">=</span> sex<span style="color:#999999">;</span>
    <span style="color:#999999">}</span>

    <span style="color:#c678dd">public</span> Date <span style="color:#61aeee">getBirthday</span><span style="color:#999999">(</span><span style="color:#999999">)</span> <span style="color:#999999">{</span>
        <span style="color:#c678dd">return</span> birthday<span style="color:#999999">;</span>
    <span style="color:#999999">}</span>

    <span style="color:#c678dd">public</span> <span style="color:#c678dd">void</span> <span style="color:#61aeee">setBirthday</span><span style="color:#999999">(</span>Date birthday<span style="color:#999999">)</span> <span style="color:#999999">{</span>
        <span style="color:#c678dd">this</span><span style="color:#999999">.</span>birthday <span style="color:#669900">=</span> birthday<span style="color:#999999">;</span>
    <span style="color:#999999">}</span>

    <span style="color:#999999">@Override</span>
    <span style="color:#c678dd">public</span> String <span style="color:#61aeee">toString</span><span style="color:#999999">(</span><span style="color:#999999">)</span> <span style="color:#999999">{</span>
        <span style="color:#c678dd">return</span> <span style="color:#669900">"User{"</span> <span style="color:#669900">+</span>
                <span style="color:#669900">"id="</span> <span style="color:#669900">+</span> id <span style="color:#669900">+</span>
                <span style="color:#669900">", username='"</span> <span style="color:#669900">+</span> username <span style="color:#669900">+</span> <span style="color:#669900">'\''</span> <span style="color:#669900">+</span>
                <span style="color:#669900">", address='"</span> <span style="color:#669900">+</span> address <span style="color:#669900">+</span> <span style="color:#669900">'\''</span> <span style="color:#669900">+</span>
                <span style="color:#669900">", sex='"</span> <span style="color:#669900">+</span> sex <span style="color:#669900">+</span> <span style="color:#669900">'\''</span> <span style="color:#669900">+</span>
                <span style="color:#669900">", birthday="</span> <span style="color:#669900">+</span> birthday <span style="color:#669900">+</span>
                <span style="color:#669900">'}'</span><span style="color:#999999">;</span>
    <span style="color:#999999">}</span>
<span style="color:#999999">}</span>
</code></span>

使用注解方式开发持久层接口

IUserDao：

<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>Delete<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>Insert<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>Select<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>Update<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:#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>
    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">/**
     * 保存用户
     * @param user
     */</span>
    <span style="color:#999999">@Insert</span><span style="color:#999999">(</span><span style="color:#669900">"insert into user(username,address,sex,birthday)values(#{username},#{address},#{sex},#{birthday})"</span><span style="color:#999999">)</span>
    <span style="color:#c678dd">void</span> <span style="color:#61aeee">saveUser</span><span style="color:#999999">(</span>User user<span style="color:#999999">)</span><span style="color:#999999">;</span>

    <span style="color:#5c6370">/**
     * 更新用户
     * @param user
     */</span>
    <span style="color:#999999">@Update</span><span style="color:#999999">(</span><span style="color:#669900">"update user set username=#{username},sex=#{sex},birthday=#{birthday},address=#{address} where id=#{id}"</span><span style="color:#999999">)</span>
    <span style="color:#c678dd">void</span> <span style="color:#61aeee">updateUser</span><span style="color:#999999">(</span>User user<span style="color:#999999">)</span><span style="color:#999999">;</span>

    <span style="color:#5c6370">/**
     * 删除用户
     * @param userId
     */</span>
    <span style="color:#999999">@Delete</span><span style="color:#999999">(</span><span style="color:#669900">"delete from user where id=#{id}"</span><span style="color:#999999">)</span>
    <span style="color:#c678dd">void</span> <span style="color:#61aeee">deleteUser</span><span style="color:#999999">(</span>Integer userId<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>
    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:#5c6370">//@Select("select * from user where username like #{username}") //占位符</span>
    <span style="color:#999999">@Select</span><span style="color:#999999">(</span><span style="color:#669900">"select * from user where username like '%${value}%'"</span><span style="color:#999999">)</span>  <span style="color:#5c6370">//字符串拼接</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:#5c6370">/**
     * 查询总数量
     * @return
     */</span>
    <span style="color:#999999">@Select</span><span style="color:#999999">(</span><span style="color:#669900">"select count(*) from user"</span><span style="color:#999999">)</span>
    <span style="color:#c678dd">int</span> <span style="color:#61aeee">findTotal</span><span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">;</span>

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

通过注解方式，就不需要再去编写 UserDao.xml 映射文件了。

编写 SqlMapConfig.xml 配置文件

SqlMapConfig.xml：

<span style="color:#000000"><code class="language-xml"><span style="color:#5c6370"><?xml version="1.0" encoding="UTF-8"?></span>
<span style="color:#61aeee"><!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd"></span>
<span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"><</span>configuration</span><span style="color:#999999">></span></span>
    <span style="color:#5c6370"><!--引入外部配置文件--></span>
    <span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"><</span>properties</span> <span style="color:#d19a66">resource</span><span style="color:#669900"><span style="color:#999999">=</span><span style="color:#999999">"</span>jdbcConfig.properties<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>properties</span><span style="color:#999999">></span></span>
    <span style="color:#5c6370"><!--配置别名--></span>
    <span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"><</span>typeAliases</span><span style="color:#999999">></span></span>
        <span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"><</span>package</span> <span style="color:#d19a66">name</span><span style="color:#669900"><span style="color:#999999">=</span><span style="color:#999999">"</span>com.keafmd.domain<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>typeAliases</span><span style="color:#999999">></span></span>
    <span style="color:#5c6370"><!--配置环境--></span>
    <span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"><</span>environments</span> <span style="color:#d19a66">default</span><span style="color:#669900"><span style="color:#999999">=</span><span style="color:#999999">"</span>mysql<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>environment</span> <span style="color:#d19a66">id</span><span style="color:#669900"><span style="color:#999999">=</span><span style="color:#999999">"</span>mysql<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>transactionManager</span> <span style="color:#d19a66">type</span><span style="color:#669900"><span style="color:#999999">=</span><span style="color:#999999">"</span>JDBC<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>transactionManager</span><span style="color:#999999">></span></span>
            <span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"><</span>dataSource</span> <span style="color:#d19a66">type</span><span style="color:#669900"><span style="color:#999999">=</span><span style="color:#999999">"</span>POOLED<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>property</span> <span style="color:#d19a66">name</span><span style="color:#669900"><span style="color:#999999">=</span><span style="color:#999999">"</span>driver<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>${jdbc.driver}<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>property</span><span style="color:#999999">></span></span>
                <span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"><</span>property</span> <span style="color:#d19a66">name</span><span style="color:#669900"><span style="color:#999999">=</span><span style="color:#999999">"</span>url<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>${jdbc.url}<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>property</span><span style="color:#999999">></span></span>
                <span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"><</span>property</span> <span style="color:#d19a66">name</span><span style="color:#669900"><span style="color:#999999">=</span><span style="color:#999999">"</span>username<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>${jdbc.username}<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>property</span><span style="color:#999999">></span></span>
                <span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"><</span>property</span> <span style="color:#d19a66">name</span><span style="color:#669900"><span style="color:#999999">=</span><span style="color:#999999">"</span>password<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>${jdbc.password}<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>property</span><span style="color:#999999">></span></span>
            <span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"></</span>dataSource</span><span style="color:#999999">></span></span>
        <span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"></</span>environment</span><span style="color:#999999">></span></span>
    <span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"></</span>environments</span><span style="color:#999999">></span></span>
    <span style="color:#5c6370"><!--指定带有注解的dao接口所在位置--></span>
    <span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"><</span>mappers</span><span style="color:#999999">></span></span>
        <span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"><</span>package</span> <span style="color:#d19a66">name</span><span style="color:#669900"><span style="color:#999999">=</span><span style="color:#999999">"</span>com.keafmd.dao<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>package</span><span style="color:#999999">></span></span>
    <span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"></</span>mappers</span><span style="color:#999999">></span></span>
<span style="color:#e06c75"><span style="color:#e06c75"><span style="color:#999999"></</span>configuration</span><span style="color:#999999">></span></span>
</code></span>

编写测试代码

AnnotationCRUDTest：

<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>Date<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: AnnotationCRUDTest
 * @Description: 注解开发CRUD测试
 * @author: 牛哄哄的柯南
 * @date: 2021-02-16 21:05
 */</span>
<span style="color:#c678dd">public</span> <span style="color:#c678dd">class</span> AnnotationCRUDTest <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:#c678dd">private</span> SqlSession session<span style="color:#999999">;</span>
    <span style="color:#c678dd">private</span> IUserDao userDao<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>
        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>
        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>
    <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>
        session<span style="color:#999999">.</span><span style="color:#61aeee">commit</span><span style="color:#999999">(</span><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>
        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">testSave</span><span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">{</span>
        User user <span style="color:#669900">=</span> <span style="color:#c678dd">new</span> User<span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">;</span>
        user<span style="color:#999999">.</span><span style="color:#61aeee">setUsername</span><span style="color:#999999">(</span><span style="color:#669900">"mybatis annotation"</span><span style="color:#999999">)</span><span style="color:#999999">;</span>
        user<span style="color:#999999">.</span><span style="color:#61aeee">setAddress</span><span style="color:#999999">(</span><span style="color:#669900">"北京"</span><span style="color:#999999">)</span><span style="color:#999999">;</span>

        userDao<span style="color:#999999">.</span><span style="color:#61aeee">saveUser</span><span style="color:#999999">(</span>user<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">testUpdate</span><span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">{</span>
        User user <span style="color:#669900">=</span> <span style="color:#c678dd">new</span> User<span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">;</span>
        user<span style="color:#999999">.</span><span style="color:#61aeee">setId</span><span style="color:#999999">(</span><span style="color:#98c379">55</span><span style="color:#999999">)</span><span style="color:#999999">;</span>
        user<span style="color:#999999">.</span><span style="color:#61aeee">setUsername</span><span style="color:#999999">(</span><span style="color:#669900">"mybatis annotation"</span><span style="color:#999999">)</span><span style="color:#999999">;</span>
        user<span style="color:#999999">.</span><span style="color:#61aeee">setAddress</span><span style="color:#999999">(</span><span style="color:#669900">"北京"</span><span style="color:#999999">)</span><span style="color:#999999">;</span>
        user<span style="color:#999999">.</span><span style="color:#61aeee">setSex</span><span style="color:#999999">(</span><span style="color:#669900">"男"</span><span style="color:#999999">)</span><span style="color:#999999">;</span>
        user<span style="color:#999999">.</span><span style="color:#61aeee">setBirthday</span><span style="color:#999999">(</span><span style="color:#c678dd">new</span> Date<span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">)</span><span style="color:#999999">;</span>

        userDao<span style="color:#999999">.</span><span style="color:#61aeee">updateUser</span><span style="color:#999999">(</span>user<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">testDelete</span><span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">{</span>
        userDao<span style="color:#999999">.</span><span style="color:#61aeee">deleteUser</span><span style="color:#999999">(</span><span style="color:#98c379">54</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>
        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>
    <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">testFindByName</span><span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">{</span>
        <span style="color:#5c6370">//List<User> users = userDao.findByName("%Keafmd%");</span>
        List<span style="color:#61aeee"><span style="color:#999999"><</span>User<span style="color:#999999">></span></span> users <span style="color:#669900">=</span> userDao<span style="color:#999999">.</span><span style="color:#61aeee">findByName</span><span style="color:#999999">(</span><span style="color:#669900">"Keafmd"</span><span style="color:#999999">)</span><span style="color:#999999">;</span>
        <span style="color:#c678dd">for</span> <span style="color:#999999">(</span>User user <span style="color:#669900">:</span> users<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>
        <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">testFindTotal</span><span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">{</span>
       <span style="color:#c678dd">int</span> total <span style="color:#669900">=</span> userDao<span style="color:#999999">.</span><span style="color:#61aeee">findTotal</span><span style="color:#999999">(</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>total<span style="color:#999999">)</span><span style="color:#999999">;</span>
    <span style="color:#999999">}</span>
<span style="color:#999999">}</span>
</code></span>

使用注解实现复杂关系映射开发

实现复杂关系映射之前我们可以在映射文件中通过配置<resultMap>来实现，在使用注解开发时我们需要借助@Results 注解，@Result 注解，@One 注解，@Many 注解。

复杂关系映射的注解说明

@Results 注解
代替的是标签<resultMap>
该注解中可以使用单个@Result 注解，也可以使用@Result 集合
@Results（{@Result（），@Result（）}）或@Results（@Result（））

@Resutl 注解
代替了<id> 标签和<result>标签
@Result 中的属性介绍：

@Result 中的属性介绍
id是否是主键字段
column数据库的列名
property需要装配的属性名
one需要使用的@One 注解（@Result（one=@One）（）））
many需要使用的@Many 注解（@Result（many=@many）（）））

@One 注解（一对一）
代替了<assocation>标签，是多表查询的关键，在注解中用来指定子查询返回单一对象。
@One 注解属性介绍：
select 指定用来多表查询的 sqlmapper
fetchType 会覆盖全局的配置参数 lazyLoadingEnabled。
使用格式：@Result(column=" “,property=”",one=@One(select=""))

@Many 注解（多对一）
代替了<collection>标签,是是多表查询的关键，在注解中用来指定子查询返回对象集合。
注意：聚集元素用来处理“一对多”的关系。需要指定映射的 Java 实体类的属性，属性的 javaType（一般为 ArrayList）但是注解中可以不定义。
使用格式：@Result(property="",column="",many=@Many(select=""))

项目目录

在这里插入图片描述

 

QY’UniverseSpace
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
mybatis注解-一对多
zhaojialu888的博客
03-29 663
目录 数据库表 数据库表： 1、category_ 插入数据： 建表sql： USE mybatistest1; CREATE TABLE category_ ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(32) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCR...
05-Mybatis注解开发（Mybatis系列终结篇）
助你成为一名优秀的全栈工程师！
12-09 905
Mybatis是一款非常好用的持久层框架，用它的使用包括基本CRUD操作、复杂SQL、 .延迟加载、缓存等。但是XML配置开发的方式相对比较繁琐。本文详细记录了Mybatis的注解开发方式，欢迎小伙伴们围观学习。
MyBatis注解开发详解
weixin_61034310的博客
03-12 819
MyBatis可以使用简单的XML或注解来配置和映射原始类型、接口和Java POJO（Plain Old Java Objects，普通的Java对象）为数据库中的记录。当然，注解方式并不完全替代XML配置方式，两者可以混合使用，根据项目的实际情况选择最适合的配置方式。Spring Boot提供了自动配置的功能，你只需要添加相应的依赖和配置，Spring Boot就会为你自动配置好MyBatis。在MyBatis中，注解提供了一种更加简洁和直观的方式来配置SQL语句，而无需编写大量的XML配置文件。
Mybatis常用的注解
qq_40414855的博客
08-17 3791
Mybatis常用的注解 MyBatis的常用注解以及简单使用 １.普通映射 @Select("select * from mybatis_Student where id=#{id}") public Student getStudent(int id); @Insert("insert into mybatis_Student (name, age, remark, pic,grade...
MyBatis：常用的注解
m0_52331159的博客
03-08 2523
【代码】MyBatis：常用的注释。
MyBatis使用注解开发实现步骤解析
08-18
MyBatis是一个流行的持久层框架，它提供了两种方式来开发映射语句，一种是使用XML文件，另一种是使用注解。使用注解开发可以减少配置文件的数量，提高开发效率，但需要注意一些使用注意事项。 在MyBatis中，使用...
Mybatis系列教程Mybatis注解开发共9页.pdf
11-19
【标题】"Mybatis系列教程Mybatis注解开发共9页.pdf" 提供的是一个关于Mybatis框架注解开发的教程，重点在于讲解如何在Mybatis中使用注解进行数据库操作。Mybatis是一个轻量级的Java持久层框架，它允许开发者通过...
MyBatis使用注解开发实现过程详解
08-19
主要介绍了MyBatis使用注解开发实现过程详解,文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下
mybatis学习笔记之mybatis注解配置详解
08-28
本文通过示例代码，展示了 MyBatis 的注解配置的使用方法，并对常用的 MyBatis 注解进行了详细的解释。通过本文的学习，读者可以更好地理解 MyBatis 的注解配置，并应用于实际项目中。 MyBatis 的注解配置提供了一...
Mybatis注解开发源代码下载
03-19
在Mybatis中，注解开发是一种便捷的编程方式，允许开发者在实体类和Mapper接口上直接使用注解，而无需XML配置文件。本资源提供了Mybatis注解开发的源代码，便于学习和理解。 在JavaEE开发中，Mybatis的注解支持可以...
mybatisDemo（一个简单的mybatis注解开发的配置源码）.zip
07-08
idea的一个demo，里面包含了一个测试方法。------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mybatis 注解+配置文件方式完整例子
02-26
mybatis 注解+配置文件方式完整例子 包含数据库的sql文件. 所有方法都有注解, 很明了.不知道为啥这个所需积分竟然逐步增长了，描述文字也50起步了。。
MyBatis中的常用注解
weixin_51495453的博客
11-24 2095
在MyBatis中,一些SQL语句例如(select * from 表名;delete from 表名)等等,这些SQL语句比较简单,没有那些复杂的关联关系,但是在不用注解的情况下,要执行这些方法的话就要从DAO层,Mapper映射文件两个方面进行实现,这些步骤在我们MyBatis中可以使用注解进行简化;接下来就介绍我们常用的增删改查标签 @Insert @Update @Delete @Select 上面的这些注解中的每一个代表了执行的真实SQL。它们每一个都使用字符串数组(或单独的字符串)。如果传递的是
Mybatis注解开发（超详细）
最新发布
2401_84152126的博客
04-13 1017
后记总结一下这三次面试下来我的经验是：一定不要死记硬背，要理解原理，否则面试官一深入就会露馅！代码能力一定要注重，尤其是很多原理性的代码（之前两次让我写过Node中间件，Promise.all，双向绑定原理，被虐的怀疑人生）！尽量从面试官的问题中表现自己知识的深度与广度，让面试官发现你的闪光点！多刷面经！
MyBatis注解
舞鹤白沙编码日志
05-28 549
1.MyBatis常用注解 这几年来注解开发越来越流行，Mybatis也可以使用注解开发方式，这样我们就可以减少编写 Mapper映射文件了。我们先围绕一些基本的CRUD来学习，再学习复杂映射多表操作。 @Insert：实现新增，代替了<insert></insert> @Delete：实现删除，代替了<delete></delete> @Update：实现更新，代替了<update></update> @Select：实现查.
常用Mybatis注解
好好学习天天向上
04-20 3311
1、@MapperScan 1.作用 为了集成Spring而写的注解。该注解主要是扫描某个包目录下的Mapper，将Mapper接口类交给Spring进行管理。 2.使用位置 在Springboot启动类上面添加 @SpringBootApplication(exclude = {DataSourceAutoConfiguration.class, FlywayAutoConfiguration.class}) @MapperScan("com.luckyframe.project.*.*.mapper")
Mybatis_注解开发超详细讲解
康康要加油的博客
03-06 3836
文章目录一、Mybatis 注解的使用二、 使用注解完成查询1、查询所有用户1.1、 修改 UsersMapper 接口1.2、 创建测试类2、注解式开发时的参数传递2.1、 顺序传参法2.2、 POJO 传参法2.3、 Map 传参法三、使用注解完成DML操作1、实现添加用户操作1.1、修改UsersMapper接口1.2、创建测试类2、实现用户更新操作2.1、修改UsersMapper接口2.2、创建测试类3、实现删除用户操作3.1、修改UsersMapper接口3.2、创建测试类四、 注解开发中的动态
基于注解的mybatis和spring整合
chaojihuangmin的专栏
10-07 513
ibatis改名为mybatis已经将近一年了，mybatis3也发布了，但是相关的开发文档却很少，查阅了官方的使用指南，也是说的模糊不清，一笔带过，尤其是注解部分，只是列举了注解种类，却没有对应的例子，因此可能会给某些兄弟使用mybatis注解带来困惑，我想就我微薄的知识想对mybatis注解的使用以及和spring整合谈谈自己的看法，也希望大家猛烈的指正我的错误。 首先当然得下载myba...
mybatis collection
weixin_44617188的博客
09-03 3881
eg: SELECT * FROM user_info WHERE (USERNAME,AGE) IN ((‘张三’,‘26’),(‘李四’,‘58’),(‘王五’,‘27’),…-----建议做if test="xxxx！=null and xxxx.size()>0"的校验，比较严谨。-----建议做if test="xxxx！=null and xxxx.length()>0"的校验，比较严谨。=null and xxxx.size()>0"的校验，比较严谨。第一种：获取Map的键值对。
mybatis注解开发一对一
05-13
MyBatis 注解开发一对一关系可以使用 `@One` 注解和 `@Result` 注解来实现。 首先，我们需要在父实体类中添加一个子实体类的属性。比如，我们有一个 User 实体类和一个 Order 实体类，它们之间是一对一的关系，那么...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值