mybatis注解开发

增删改查

@Select、@Insert、@Update、@Delete

批量插入

java @Insert("<script>" + "insert into user_info(name,age) values " + " <foreach collection = 'list' item='user' separator=','>" + " (#{user.name},#{user.age})" + " </foreach>"+ "</script>") public void addUsers(List<User> users);

一对一

```java // 一个订单属于一个用户 public class Order { private int id; private double total; private User user; }

public class User { private int id; private String username; private String password; } ```

java public interface OrderMapper { @Results({ @Result(id=true,property = "id",column = "id"), @Result(property = "total",column = "total"), @Result(property = "user",column = "uid", one = @One(select = "cn.ccb.mapper.UserMapper.findById")) }) @Select("select * from orders") List<Order> findAll(); }

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

一对多

```java // 一个用户有多个爱好 public class UserInfoHobby { private String id; private String name; private Integer age;

private List<UserHobby> hobbyList;  // 用户爱好

}

public class UserHobby { private String id; private String userId; // 用户账号 private String hobby; } ```

```java // 查询用户信息及爱好(一对多) @Results(id = "userInfoAndHobby", value = { @Result(property = "id", column = "userId",id = true), @Result(property = "name", column = "name"), @Result(property = "age", column = "age"), @Result(property = "hobbyList", column = "userId", many = @Many(select = "cn.ccb.mapper.HelloMapper.getUserHobby"))}) @Select("select id AS userId, name AS name ,age AS age from user_info where id =#{uid}") public List getUserInfoAndHobby(Integer uid);

// 查询用户爱好 @Select("select * from userinfohobby where user_id = #{uid}") public List getUserHobby(Integer uid); ```

列名映射

java <resultMap id="userMap" type="cn.ccb.SysUser"> <id property="id" column="id"/> <result property="userName" column="user_name"/> <result property="userPassword" column="user_password"/> </resultMap>

java @Results(id="",value={ @Result(property = "id", column = "id", id = true), @Result(property = "roleName", column = "role_name"), @Result(property = "enabled", column = "enabled"), @Result(property = "createBy", column = "create_by"), @Result(property = "createTime", column = "create_time")}) @Select("SELECT id,role_name WHERE id = #{id}") SysUser selectById(Long id);

• @Result对应着xml中的result标签

• @Results对应xml中的resultMap标签，id 唯一标识这段映射，以便复用

• 引用@Results：

  java @ResultMap(value = "userMap") @Select("SELECT * FROM user") List<User> selectAll();

相关文章： https://juejin.cn/post/6844904017085071368 https://juejin.cn/post/7120033114998439944#heading-22