MyBatis的注解

原创

pyzheng 2023-03-21 00:22:36 ©著作权

文章标签 java ide List SQL 文章分类 Python 后端开发

©著作权归作者所有：来自51CTO博客作者pyzheng的原创作品，请联系作者获取转载授权，否则将追究法律责任

基于注解的mybatis和spring整合:[url]http://huangmin001.iteye.com/blog/1185806[/url]
[color=red]这个文章说的很详细,很值得一看[/color].

Mapper中注解（Annotation）的使用示例:[url]http://puras.cn/mybatis-annotation-example[/url]

Mapper：

public interface RoleMapper {
    final String SELECT_ALL = "SELECT * FROM nap_roles";
    final String SELECT_BY_ID = "SELECT * FROM nap_roles WHERE id=#{id}";
    final String INSERT = "INSERT INTO nap_roles(name, description, ctime, mtime) VALUES(#{name}, #{description}, #{creationTime}, #{modifiedTime})";
    final String UPDATE = "UPDATE nap_roles SET name=#{name}, description=#{description}, mtime=#{modifiedTime} WHERE id=#{id}";
    final String DELETE = "DELETE FROM nap_roles WHERE id=#{id}";
    final String SELECT_BY_PAGE_BEGIN = "SELECT * FROM nap_roles";
    final String SELECT_BY_PAGE_END = " limit #{startPosition}, #{maxResult}";
    final String COUNT = "SELECT COUNT(id) FROM nap_roles WHERE 1=1 ";

    @Insert(INSERT)
    @Options(useGeneratedKeys = true, keyProperty = "id")
    void create(Role role);

    @Update(UPDATE)
    void update(Role role);

    @Delete(DELETE)
    void delete(Long id);

    @Select(SELECT_ALL)
    @Results(value = {
            @Result(property="id"),
            @Result(property="name"),
            @Result(property="description"),
            @Result(property="creationTime", column="ctime"),
            @Result(property="modifiedTime", column="mtime")
    })
    List findAll();

    @SelectProvider(type = RoleProvider.class, method = "findByPage")
    @Results(value = {
            @Result(property="id"),
            @Result(property="name"),
            @Result(property="description"),
            @Result(property="creationTime", column="ctime"),
            @Result(property="modifiedTime", column="mtime")
    })
    List findByPage(Map params);

    @Select(SELECT_BY_ID)
    @Results(value = {
            @Result(property="id"),
            @Result(property="name"),
            @Result(property="description"),
            @Result(property="creationTime", column="ctime"),
            @Result(property="modifiedTime", column="mtime")
    })
    Role findById(Long id);

    @SelectProvider(type = RoleProvider.class, method = "getCount")
    int getCount(Role role);

    @Select(COUNT)
    int count();
}