MyBatis注解开发

目录

1.常用注解

2.使用xml配置开发

3.使用注解开发

4.MyBatis的注解实现复杂映射开发

4.1一对一查询

4.2一对多查询

4.3多对多查询

1.常用注解

• @Insert：实现新增
• @Update：实现更新
• @Delete：实现删除
• @Select：实现查询
• @Result：实现结果集封装
• @Results：可以与@Result一起使用，封装多个结果集
• @One：实现一对一结果集封装
• @Many：实现一对多结果集封装

2.使用xml配置开发

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.caoyan.mapper.UserMapper">
    <!-- 增 -->
    <insert id="save" parameterType="user">
        insert into user values(#{id},#{username},#{password},#{birthday})
    </insert>
    <!-- 删 -->
    <delete id="delete" parameterType="int">
        delete from user where id=#{id}
    </delete>
    <!-- 改 -->
    <update id="update" parameterType="user">
        update user set username=#{username},password=#{password},birthday=#{birthday} where id=#{id}
    </update>
    <!-- 根据id查 -->
    <select id="findById" parameterType="int" resultType="user">
        select * from user where id=#{id}
    </select>
    <!-- 查询所有 -->
    <select id="findAll" resultType="user">
        select * from user
    </select>
</mapper>

    <!-- 加载映射文件 -->
    <mappers>
        <mapper resource="com/caoyan/mapper/UserMapper.xml"/>
    </mappers>

3.使用注解开发

package com.caoyan.mapper;

import java.util.List;

import com.caoyan.domain.User;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

public interface UserMapper {
    @Insert("insert into user values(#{id},#{username},#{password},#{birthday})")
    public void save(User user);

    @Update("update user set username=#{username},password=#{password},birthday=#{birthday} where id=#{id}")
    public void update(User user);

    @Delete("delete from user where id=#{id}")
    public void delete(int id);

    @Select("select * from user where id=#{id}")
    public User findById(int id);

    @Select("select * from user")
    public List<User> findAll();
}

    <!-- 加载映射关系 -->
    <mappers>
        <!-- 指定接口所在的包 -->
        <package name="com.caoyan.mapper" />
    </mappers>

4.MyBatis的注解实现复杂映射开发

注解	说明
@Results	代替的是标签<resultMap>该注解中可以使用单个@Result注解，也可以使用@Result集合。使用格式：@Results（{@Result(),@Result()}）或@Results(@Result())
@Result	代替了<id>标签和<result>标签 @Result中属性介绍 column：数据库的列名 property：需要装配的属性名 one：需要使用的@one注解（@Result（one=@one）（）） many：需要使用的@Many注解（@Result（many=@many）（））

4.1一对一查询

package com.caoyan.mapper;

import java.util.List;

import com.caoyan.domain.Order;
import com.caoyan.domain.User;

import org.apache.ibatis.annotations.One;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

public interface OrderMapper {
    // @Select("select *,o.id oid from orders o, user u where o.uid=u.id")
    // @Results({
    // @Result(column = "oid", property = "id"),
    // @Result(column = "ordertime", property = "ordertime"),
    // @Result(column = "total", property = "total"),
    // @Result(column = "uid", property = "user.id"),
    // @Result(column = "username", property = "user.username"),
    // @Result(column = "password", property = "user.password")
    // })
    @Select("select * from orders")
    @Results({
            @Result(column = "oid", property = "id"),
            @Result(column = "ordertime", property = "ordertime"),
            @Result(column = "total", property = "total"),
            @Result(property = "user", // 要封装的属性名称
                    column = "uid", // 根据哪个字段去查询user表的数据
                    javaType = User.class, // 要封装的实体类型
                    // select属性代表查询哪个接口的方法获得数据
                    one = @One(select = "com.caoyan.mapper.UserMapper.findById"))
    })
    public List<Order> findAll();
}

4.2一对多查询

    @Select("select * from orders where uid=#{uid}")
    public List<Order> findByUid(int uid);

    @Select("select *from user")
    @Results({
            @Result(id = true, column = "id", property = "id"),
            @Result(column = "username", property = "username"),
            @Result(column = "password", property = "password"),
            @Result(property = "orderList", column = "id", javaType = List.class, many = @Many(select = "com.caoyan.mapper.OrderMapper.findByUid"))
    })
    public List<User> findUserAndOrderAll();

package com.caoyan.test;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

import com.caoyan.domain.User;
import com.caoyan.mapper.UserMapper;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Before;
import org.junit.Test;

public class MyBatisTest3 {
    private UserMapper userMapper;

    @Before
    public void before() throws IOException {
        InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
        SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        SqlSession sqlSession = sessionFactory.openSession(true);
        userMapper = sqlSession.getMapper(UserMapper.class);
    }

    @Test
    public void testFindAll() {
        List<User> userList = userMapper.findUserAndOrderAll();
        for (User user : userList) {
            System.out.println(user);
        }
    }

}

4.3多对多查询

package com.caoyan.mapper;

import java.util.List;

import com.caoyan.domain.Role;

import org.apache.ibatis.annotations.Select;

public interface RoleMapper {
    @Select("select * from sys_user_role ur,sys_role r where ur.roleId=r.id and ur.userId=#{uid}")
    public List<Role> findByUid(int uid);
}

    @Select("select * from user")
    @Results({
            @Result(id = true, column = "id", property = "id"),
            @Result(column = "username", property = "username"),
            @Result(column = "password", property = "password"),
            @Result(property = "roleList", column = "id", javaType = List.class, many = @Many(select = "com.caoyan.mapper.RoleMapper.findByUid"))
    })
    public List<User> findUserAndRoleAll();

package com.caoyan.test;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

import com.caoyan.domain.User;
import com.caoyan.mapper.UserMapper;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Before;
import org.junit.Test;

public class MyBatisTest4 {
    private UserMapper userMapper;

    @Before
    public void before() throws IOException {
        InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
        SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        SqlSession sqlSession = sessionFactory.openSession(true);
        userMapper = sqlSession.getMapper(UserMapper.class);
    }

    @Test
    public void testFindAll() {
        List<User> userList = userMapper.findUserAndRoleAll();
        for (User user : userList) {
            System.out.println(user);
        }
    }

}