// 最基本的注解CRUD
public interface IUserDAO {

    @Select("select *from User")
    public List<User> retrieveAllUsers();

    //注意这里只有一个参数，则#{}中的标识符可以任意取
    @Select("select *from User where id=#{idss}")
    public User retrieveUserById(int id);

    @Select("select *from User where id=#{id} and userName like #{name}")
    public User retrieveUserByIdAndName(@Param("id")int id,@Param("name")String names);

    @Insert("INSERT INTO user(userName,userAge,userAddress) VALUES(#{userName},"
            + "#{userAge},#{userAddress})")
    public void addNewUser(User user);

    @Delete("delete from user where id=#{id}")
    public void deleteUser(int id);

    @Update("update user set userName=#{userName},userAddress=#{userAddress}"
            + " where id=#{id}")
    public void updateUser(User user);

}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.METHOD)
@Repeatable(Select.List.class)
public @interface Select {
    
    String[] value();

    String databaseId() default "";
    
    @Documented
    @Retention(RetentionPolicy.RUNTIME)
    @Target(ElementType.METHOD)
    @interface List {
        Select[] value();
    }

}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.METHOD)
@Repeatable(Insert.List.class)
public @interface Insert {
    
    String[] value();

    String databaseId() default "";

    @Documented
    @Retention(RetentionPolicy.RUNTIME)
    @Target(ElementType.METHOD)
    @interface List {
        Insert[] value();
    }

}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.METHOD)
@Repeatable(Update.List.class)
public @interface Update {

    String[] value();

    String databaseId() default "";

    @Documented
    @Retention(RetentionPolicy.RUNTIME)
    @Target(ElementType.METHOD)
    @interface List {
        Update[] value();
    }

}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.METHOD)
@Repeatable(Delete.List.class)
public @interface Delete {
    
    String[] value();

    String databaseId() default "";

    @Documented
    @Retention(RetentionPolicy.RUNTIME)
    @Target(ElementType.METHOD)
    @interface List {
        Delete[] value();
    }

}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.PARAMETER)
public @interface Param {
    /**
   * Returns the parameter name.
   *
   * @return the parameter name
   */
    String value();
}

@CacheNamespace(size=100)
public interface IBlogDAO {

    @SelectProvider(type = BlogSqlProvider.class, method = "getSql") 
    @Results(value ={ 
        @Result(id=true, property="id",column="id",javaType=Integer.class,jdbcType=JdbcType.INTEGER),
        @Result(property="title",column="title",javaType=String.class,jdbcType=JdbcType.VARCHAR),
        @Result(property="date",column="date",javaType=String.class,jdbcType=JdbcType.VARCHAR),
        @Result(property="authername",column="authername",javaType=String.class,jdbcType=JdbcType.VARCHAR),
        @Result(property="content",column="content",javaType=String.class,jdbcType=JdbcType.VARCHAR),
    }) 
    public Blog getBlog(@Param("id") int id);

    @SelectProvider(type = BlogSqlProvider.class, method = "getAllSql") 
    @Results(value ={ 
        @Result(id=true, property="id",column="id",javaType=Integer.class,jdbcType=JdbcType.INTEGER),
        @Result(property="title",column="title",javaType=String.class,jdbcType=JdbcType.VARCHAR),
        @Result(property="date",column="date",javaType=String.class,jdbcType=JdbcType.VARCHAR),
        @Result(property="authername",column="authername",javaType=String.class,jdbcType=JdbcType.VARCHAR),
        @Result(property="content",column="content",javaType=String.class,jdbcType=JdbcType.VARCHAR),
    }) 
    public List<Blog> getAllBlog();

    @SelectProvider(type = BlogSqlProvider.class, method = "getSqlByTitle") 
    @ResultMap(value = "sqlBlogsMap") 
    // 这里调用resultMap，这个是SQL配置文件中的,必须该SQL配置文件与本接口有相同的全限定名
    // 注意文件中的namespace路径必须是使用@resultMap的类路径
    public List<Blog> getBlogByTitle(@Param("title")String title);

    @InsertProvider(type = BlogSqlProvider.class, method = "insertSql") 
    public void insertBlog(Blog blog);

    @UpdateProvider(type = BlogSqlProvider.class, method = "updateSql")
    public void updateBlog(Blog blog);

    @DeleteProvider(type = BlogSqlProvider.class, method = "deleteSql")
    @Options(useCache = true, flushCache = false, timeout = 10000) 
    public void deleteBlog(int ids);

}

public class BlogSqlProvider {

    private final static String TABLE_NAME = "blog";

    public String getSql(Map<Integer, Object> parameter) {
        BEGIN();
        //SELECT("id,title,authername,date,content");
        SELECT("*");
        FROM(TABLE_NAME);
        //注意这里这种传递参数方式，#{}与map中的key对应，而map中的key又是注解param设置的
        WHERE("id = #{id}");
        return SQL();
    }

    public String getAllSql() {
        BEGIN();
        SELECT("*");
        FROM(TABLE_NAME);
        return SQL();
    }

    public String getSqlByTitle(Map<String, Object> parameter) {
        String title = (String) parameter.get("title");
        BEGIN();
        SELECT("*");
        FROM(TABLE_NAME);
        if (title != null)
            WHERE(" title like #{title}");
        return SQL();
    }

    public String insertSql() {
        BEGIN();
        INSERT_INTO(TABLE_NAME);
        VALUES("title", "#{title}");
        //  VALUES("title", "#{tt.title}");
        //这里是传递一个Blog对象的，如果是利用上面tt.方式，则必须利用Param来设置别名
        VALUES("date", "#{date}");
        VALUES("authername", "#{authername}");
        VALUES("content", "#{content}");
        return SQL();
    }

    public String deleteSql() {
        BEGIN();
        DELETE_FROM(TABLE_NAME);
        WHERE("id = #{id}");
        return SQL();
    }

    public String updateSql() {
        BEGIN();
        UPDATE(TABLE_NAME);
        SET("content = #{content}");
        WHERE("id = #{id}");
        return SQL();
    }
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.icanci.IBlogDAO">
    <resultMap type="Blog" id="sqlBlogsMap">
        <id property="id" column="id"/>
        <result property="title" column="title"/>
        <result property="authername" column="authername"/>
        <result property="date" column="date"/>
        <result property="content" column="content"/>
    </resultMap> 
</mapper>

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.METHOD)
@Repeatable(SelectProvider.List.class)
public @interface SelectProvider {

    Class<?> value() default void.class;

    // 提供的类
    Class<?> type() default void.class;

    // 提供的方法
    String method() default "";

    /**
   * @return A database id that correspond this provider
   * @since 3.5.5
   */
    String databaseId() default "";

    /**
   * The container annotation for {@link SelectProvider}.
   * @author Kazuki Shimizu
   * @since 3.5.5
   */
    @Documented
    @Retention(RetentionPolicy.RUNTIME)
    @Target(ElementType.METHOD)
    @interface List {
        SelectProvider[] value();
    }

}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.METHOD)
@Repeatable(InsertProvider.List.class)
public @interface InsertProvider {

    /**
   * Specify a type that implements an SQL provider method.
   *
   * @return a type that implements an SQL provider method
   * @since 3.5.2
   * @see #type()
   */
    // 提供的类
    Class<?> value() default void.class;

    Class<?> type() default void.class;

    // 提供的方法
    String method() default "";

    /**
   * @return A database id that correspond this provider
   * @since 3.5.5
   */
    String databaseId() default "";

    /**
   * The container annotation for {@link InsertProvider}.
   * @author Kazuki Shimizu
   * @since 3.5.5
   */
    @Documented
    @Retention(RetentionPolicy.RUNTIME)
    @Target(ElementType.METHOD)
    @interface List {
        InsertProvider[] value();
    }

}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.METHOD)
@Repeatable(UpdateProvider.List.class)
public @interface UpdateProvider {

    /**
   * Specify a type that implements an SQL provider method.
   *
   * @return a type that implements an SQL provider method
   * @since 3.5.2
   * @see #type()
   */
    Class<?> value() default void.class;

    // 类的类型
    Class<?> type() default void.class;

    // 方法的值
    String method() default "";

    /**
   * @return A database id that correspond this provider
   * @since 3.5.5
   */
    String databaseId() default "";

    /**
   * The container annotation for {@link UpdateProvider}.
   * @author Kazuki Shimizu
   * @since 3.5.5
   */
    @Documented
    @Retention(RetentionPolicy.RUNTIME)
    @Target(ElementType.METHOD)
    @interface List {
        UpdateProvider[] value();
    }

}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.METHOD)
@Repeatable(DeleteProvider.List.class)
public @interface DeleteProvider {

    /**
   * Specify a type that implements an SQL provider method.
   *
   * @return a type that implements an SQL provider method
   * @since 3.5.2
   * @see #type()
   */
    Class<?> value() default void.class;

    // 类型
    Class<?> type() default void.class;

    // 方法
    String method() default "";

    /**
   * @return A database id that correspond this provider
   * @since 3.5.5
   */
    String databaseId() default "";

    /**
   * The container annotation for {@link DeleteProvider}.
   * @author Kazuki Shimizu
   * @since 3.5.5
   */
    @Documented
    @Retention(RetentionPolicy.RUNTIME)
    @Target(ElementType.METHOD)
    @interface List {
        DeleteProvider[] value();
    }

}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.METHOD)
public @interface Results {
 
    // resultMap 的id
    String id() default "";

    // Result 数组
    Result[] value() default {};
}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.METHOD)
@Repeatable(Results.class)
public @interface Result {
    // 是否是id字段
    boolean id() default false;

    // 列名
    String column() default "";

    // java类中的属性
    String property() default "";

    /**
   * Return the java type for this argument.
   *
   * @return the java type
   */
    Class<?> javaType() default void.class;

    /**
   * Return the jdbc type for column that map to this argument.
   *
   * @return the jdbc type
   */
    JdbcType jdbcType() default JdbcType.UNDEFINED;

    // TypeHandler 处理器
    Class<? extends TypeHandler> typeHandler() default UnknownTypeHandler.class;

    // 一对一注解
    One one() default @One;

    // 一对多注解
    Many many() default @Many;
}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target({})
public @interface One {
    
    //列前缀
    String columnPrefix() default "";

    // 结果集映射
    String resultMap() default "";

    // 已经映射的语句的全限定名
    String select() default "";

    // 加载类型
    FetchType fetchType() default FetchType.DEFAULT;

}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target({})
public @interface Many {
   
    // 列前缀
    String columnPrefix() default "";

    // 结果集
    String resultMap() default "";

    // select 语句
    String select() default "";

    // 加载类型
    FetchType fetchType() default FetchType.DEFAULT;

}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.METHOD)
public @interface ResultMap {
    // 结果集
    String[] value();
}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.METHOD)
public @interface ResultType {

    // 返回值类型
    Class<?> value();
}

@Documented
@Retention(RetentionPolicy.RUNTIME)
// Mapper类上
@Target(ElementType.TYPE)
public @interface CacheNamespace {

    // 负责存储的 cache 实现类
    Class<? extends Cache> implementation() default PerpetualCache.class;

    // 负责过期的实现类
    Class<? extends Cache> eviction() default LruCache.class;

    // 清空缓存的频率 0  代表不清空
    long flushInterval() default 0;

    // 缓存容器大小
    int size() default 1024;

    // 是否序列化
    boolean readWrite() default true;

    // 是否阻塞
    boolean blocking() default false;

    // Property数组
    Property[] properties() default {};

}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target({})
public @interface Property {

    // 属性名
    String name();
    // 值
    String value();
}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.TYPE)
public @interface CacheNamespaceRef {

    /**
   * Returns the namespace type to reference a cache (the namespace name become a FQCN of specified type).
   *
   * @return the namespace type to reference a cache
   */
    Class<?> value() default void.class;

    /**
   * Returns the namespace name to reference a cache.
   *
   * @return the namespace name
   * @since 3.4.2
   */
    // 指向的命名空间
    String name() default "";
}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.METHOD)
@Repeatable(Options.List.class)
public @interface Options {
    /**
   * The options for the {@link Options#flushCache()}.
   * The default is {@link FlushCachePolicy#DEFAULT}
   */
    enum FlushCachePolicy {
        /** <code>false</code> for select statement; <code>true</code> for insert/update/delete statement. */
        DEFAULT,
        /** Flushes cache regardless of the statement type. */
        TRUE,
        /** Does not flush cache regardless of the statement type. */
        FALSE
    }

    // 是否使用缓存
    boolean useCache() default true;

    // 刷新缓存的策略
    FlushCachePolicy flushCache() default FlushCachePolicy.DEFAULT;

    // 结果类型
    ResultSetType resultSetType() default ResultSetType.DEFAULT;

    // 语句类型
    StatementType statementType() default StatementType.PREPARED;

    // 加载数量
    int fetchSize() default -1;

    // 超时时间
    int timeout() default -1;

    // 是否生成主键
    boolean useGeneratedKeys() default false;

    // 主键再 java类中的属性
    String keyProperty() default "";

    // 主键再数据库的字段
    String keyColumn() default "";

    // 结果集
    String resultSets() default "";

    /**
   * @return A database id that correspond this options
   * @since 3.5.5
   */
    // 数据库id
    String databaseId() default "";

    /**
   * The container annotation for {@link Options}.
   * @author Kazuki Shimizu
   * @since 3.5.5
   */
    @Documented
    @Retention(RetentionPolicy.RUNTIME)
    @Target(ElementType.METHOD)
    @interface List {
        Options[] value();
    }

}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.METHOD)
@Repeatable(SelectKey.List.class)
public @interface SelectKey {
    /**
   * Returns an SQL for retrieving a key value.
   *
   * @return an SQL for retrieving a key value
   */
    String[] statement();

    // java 对象的属性
    String keyProperty();

    // 列名
    String keyColumn() default "";

    // 在插入语句执行前，还是执行后
    boolean before();

    // 返回值类型
    Class<?> resultType();

    /**
   * Returns the statement type to use.
   *
   * @return the statement type
   */
    StatementType statementType() default StatementType.PREPARED;

    /**
   * @return A database id that correspond this select key
   * @since 3.5.5
   */
    String databaseId() default "";

    /**
   * The container annotation for {@link SelectKey}.
   * @author Kazuki Shimizu
   * @since 3.5.5
   */
    @Documented
    @Retention(RetentionPolicy.RUNTIME)
    @Target(ElementType.METHOD)
    @interface List {
        SelectKey[] value();
    }

}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.METHOD)
public @interface MapKey {

    // 键名
    String value();
}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.METHOD)
public @interface Flush {
}

@Documented
@Inherited
@Retention(RetentionPolicy.RUNTIME)
@Target({ ElementType.TYPE, ElementType.METHOD, ElementType.FIELD, ElementType.PARAMETER })
public @interface Mapper {
  // Interface Mapper
}

@Documented
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.METHOD)
public @interface Lang {

    // 驱动类
    Class<? extends LanguageDriver> value();
}