Mybatis 注解开发

mybatis3.4.0 开始加入了@Mapper注解,目的就是为了不再写mapper映射文件

@Select("select * from tb_user where id = #{id}")
User selectUserById(Integer id);

@Delete("delete from tb_user where id = #{id}")
int deleteUserById(Integer id);

@Update("update tb_user set username = #{username}, password = #{password} where id = #{id}")
int updateUserById(User user);

@Insert("insert into tb_user(username, password) values(#{username}, #{password})")
int insertUser(User user);

@Select("select * from tb_user")
List<User> selectAllUser();

@Select("select * from tb_user where username like #{username}")
@Results({
        @Result(property = "username", column = "username"),
        @Result(property = "password", column = "password")
})
List<User> selectUserByUsernameLike(String username);

最后更新于

这有帮助吗?