myBatis使用全注解小结

将最近工作中，使用到的myBatis注解方式的数据库操作总结一下

1.User model

Public class User{
    Private int id;
    Private int gid;
    Private int age;
    Private String sex;

    Getter and Setter ...
}

2.Group model

Public class Group{
    Private int id;
    Private List<User>  userList;

    Getter and Setter ...
}

3.根据id查询User对象

 

@Select(“select * from user where id = #{id}”)
Public User getUser(@Param("id") int id)

 

4.Update User

@Update(“update user set age = #{age} where id = #{id}”)
Public int updateUser(@Param("id") int id,@Param("age") int age);

5.删除User

@Delete(“delete from user where id = #{id}”)
Public int deleteUser(@Param("id") int id)

对象方式
@Delete(“delete from user where id = #{id}”)
Public int deleteUser(User user)

6.Insert User

@Insert(“insert into user(age,sex) values(#{age},#{sex})”)
Public int insertUser(User user)

7.获取group list

@Select(“select * from group”)
@Results(value = {
            @Result(id = true,property = "id",column = "id"),
            @Result(property = "userList",column = "id",javaType = List.class,many = @Many(select = "getUserList"))
    })
Public List<Group> getGroupList();

@Select("select * from user where gid = #{id}")
public List<User> getUserList(@Param("id") int id);

8.获取插入id

 

@Insert("insert into user(age,sex) values(#{age},#{sex})")
@SelectKey(statement = "select LAST_INSERT_ID() as id",keyProperty="id",resultType = Integer.class, before = false)
public int addWallApp(User user);

注：id在返回的user对象中

 

 

9. 待补充