<select id="getApplicationByRoleCode" resultType="platform.appframe.entity.AfaApplication" parameterType="java.lang.String" >

   select distinct   <include refid="Application_Base_Column_List" />

      from afa_application a

      left join afa_auth_function b

    on a.app_id = b.app_id

     where b.party_code =#{roleCode}

  </select>

    <select id="getMenusByRoleCodes" resultMap="afaAppMenuMap">

        SELECT

        <include refid="Base_Column_List" />

          FROM AFA_APP_MENU

          WHERE MENU_CODE IN

                  (SELECT a.FUNC_CODE

                       FROM AFA_APP_FUNCTION A

                      INNER JOIN AFA_AUTH_FUNCTION B

                         ON A.FUNC_CODE = B.FUNC_CODE

                      WHERE B.PARTY_CODE in

        <foreach collection="roleCodes" item="roleCode" index="index" open="(" separator="," close=")">

              #{roleCode}

        </foreach>

        <if test="appId!=null">

           AND A.APP_ID = #{appId}

        </if>

        )

    </select>

public interface AfaAppMenuMapper extends Mapper<AfaAppMenu> {

    public List<AfaAppMenu> getMenusByRoleCodes(@Param("roleCodes")List<String> roleCodes,@Param("appId")String appId);

}

public Page<AfaAppMenu> queryAfaAppMenuPage(@Param("searcher")Searcher searcher,@Param("page")Page<AfaAppMenu> page);

    <select id="queryAfaAppMenuPage" resultMap="afaAppMenuMap">

        SELECT

        <include refid="Base_Column_List" />

         FROM AFA_APP_MENU

        <trim prefix="where"  prefixOverrides="and |or">

            <if test="searcher != null and searcher.__QUERYCON != null">

                ${searcher.__QUERYCON}

            </if>

        </trim>

        ORDER BY SORT_NO ASC

    </select>

 @Transient

    private String context;

    public String getMenuAppId() {

        return menuAppId;

    }

    public void setMenuAppId(String menuAppId) {

        this.menuAppId = menuAppId;

    }

<result column="CONTEXT" jdbcType="VARCHAR" property="context" />

方式一：List<String>方式 
    <foreach collection="roleCodes" item="roleCode" index="index" open="(" separator="," close=")">

         #{roleCode}

    </foreach>

方式二：List<object>方式
    <foreach  item="func" index="index" collection="appfunc" open="(" separator="," close=")">

        #{func.funcCode}

    </foreach>

添加前后缀：

        <trim prefix="where"  prefixOverrides="and |or">

            <if test="searcher != null and searcher.__QUERYCON != null">

                ${searcher.__QUERYCON}

            </if>

        </trim>

判断等于某个字符串：

        <if test="appId!='app_menu_id'">

           AND A.APP_ID = #{appId}

        </if>

  定义：
  <sql id="Application_Base_Column_List">

    a.APP_ID,a.APP_NAME,a.APP_TYPE,a.IS_OPEN,a.CONTEXT,a.IP,a.PORT,a.PROTOCOL,a.APP_DESC,a.TENANT_ID,a.LOGOUT_URL,a.LAST_MODIFY_TIME

  </sql>
  使用：
  <include refid="Application_Base_Column_List"/>

方式一：通过concat添加%：

WHERE FUNC_CODE LIKE CONCAT('%',#{key},'%') OR FUNC_NAME LIKE CONCAT('%',#{key},'%') 

方式二：通过$添加%：
where org_name like '%${orgName}%'