基于注解的mybatis和spring整合:http://huangmin001.iteye.com/blog/1185806
这个文章说的很详细,很值得一看.
Mapper中注解（Annotation）的使用示例:http://puras.cn/mybatis-annotation-example
Mapper：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 |
Java代码 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(); } |
在使用比较复杂的SQL时，会用到各种Provider来处理。
虽然都改用Annotation了，但还有些地方不是特别的爽。
1、ResultMap，不知道怎么来定义一个对象，所有的都引用一个；
2、所有的SQL都写到JAVA里了，修改起来，也是件麻烦事。
