mybatis零配置，@Select或者SelectProvider如何复用查询列

Question

*Mapper.xml中的用法

  <sql id="Base_Column_List" >
    c_bh, c_mc, d_fbrq, d_ssrq, d_create, d_update
  </sql>
  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
    select 
   <include refid="Base_Column_List" />
    from t_fl
    where c_bh = #{cBh,jdbcType=VARCHAR}
  </select>

mybatis零配置，@Select或者SelectProvider如何复用查询列，达到上边xml中的效果？

Answer 1

 public interface UserMapper {
     @SelectProvider(type = SqlProvider.class, method = "selectUser")
     @ResultMap("userMap")
     public User getUser(long userId);
}

 public class SqlProvider {
     public String selectUser(long userId) {
         return "select * from user where userId=" + userId;
     }
 }