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);
最后更新于
这有帮助吗?