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. 待補充

 

myBatis使用全註解小結