【MyBatis】一步到位完成sql语句与接口方法的映射——注解开发

简单的CURD

注解	说明
@Insert	增
@Delete	删
@Update	改
@Select	查

加载映射关系：

之前在核心配置文件(sqlMapConfig.xml)中加载了映射配置文件(xxxMapper.xml)， 其实质是加载映射关系。现在可以完全删除映射配置文件，在核心配置文件直接加载接口(配置类)即可。

<!-- 加载映射关系 -->
<mappers>
    <mapper class="com.samarua.mapper.UserMapper"/>
</mappers>

简单的注解开发：

也就是说，之前是使用namespace+id+parameterType+resultType间接实现映射的，现在在方法上写注解，一步到位！！！

com.samarua.mapper.UserMapper接口
-------------------------------------------------------------------------------------------
public interface UserMapper {

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

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

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

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

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

}

 
 
 

多表查询

注解	说明	说明
@Results	代替了resultMap标签	内部有多个@Result
@Result	代替类result/id标签	依旧通过column和property实现匹配映射
@One	代替了association标签	进行一次对方的子查询
@Many	代替了collection标签	进行一次对方的子查询

理解：

xml多表查询的思路是，查询出一张大表，然后对查询结果进行字段与属性的对应匹配

注解多表查询的思路是，查一张主表即可，然后以查询结果中的某个字段作为参数再查一次(这个子查询往往用的是"别人"的接口方法)

 

A）一个订单只属于一个用户（1:1）

第一种写法：

com.samarua.mapper.OrderMapper接口
-------------------------------------------------------------------------------------------
public interface OrderMapper {

    @Select("select * from orders o, users 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"),
            @Result(column = "birthday", property = "user.birthday")
    })
    public List<Order> findOrderAndUser();
    
}

第二种写法：

com.samarua.mapper.OrderMapper接口
-------------------------------------------------------------------------------------------
public interface OrderMapper {

    @Select("select * from orders")
    @Results({
            @Result(column = "id", property = "id", id = true),
            @Result(column = "ordertime", property = "ordertime"),
            @Result(column = "total", property = "total"),
            @Result(column = "uid", property = "user",
                    javaType = User.class,
                    one = @One(select = "com.samarua.mapper.UserMapper.findById")
            )
    })
    public List<Order> findOrderAndUser();
    
}

com.samarua.mapper.UserMapper接口
-------------------------------------------------------------------------------------------
public interface UserMapper {

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

}

 

B）一个用户同时拥有多个订单（1:n）

com.samarua.mapper.UserMapper接口
-------------------------------------------------------------------------------------------
public interface UserMapper {

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

}

com.samarua.mapper.OrderMapper接口
-------------------------------------------------------------------------------------------
public interface OrderMapper {

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

}

 

C）一个用户拥有多个角色，多个用户也可能是同一个角色（m:n）

com.samarua.mapper.UserMapper接口
-------------------------------------------------------------------------------------------
public interface UserMapper {

    @Select("select * from users")
    @Results({
            @Result(column = "id", property = "id", id = true),
            @Result(column = "username", property = "username"),
            @Result(column = "password", property = "password"),
            @Result(column = "birthday", property = "birthday"),
            @Result(column = "id", property = "roleList",
                    javaType = List.class,
                    many = @Many(select = "com.samarua.mapper.RoleMapper.findRolesByUid")
            )
    })
    public List<User> findUserAndRoles();

}

com.samarua.mapper.RoleMapper接口
-------------------------------------------------------------------------------------------
public interface RoleMapper {

    @Select("select * from user_role_relation ur, roles r where ur.roleId = r.id and ur.userId = #{uid}")
    public List<Role> findRolesByUid(int uid);

}

 
 
 
 

 
 
 
 

 
 
 
 

More >_<