ibatis3 关联查询，<association/> coumn添加多列条件

<resultMap type="themeFormatBean" id="themeFormatMap"><id column="THFORMAT_ID" property="thFormatId"  /><result column="THTYPE_TH_ID" property="thId"  /><result column="THTYPE_HEIGHT" property="thHeight"  /><result column="THTYPE_WIDTH" property="thWidth"  /><result column="TH_BG_ID" property="thBgId"  /><result column="THTYPE_RSPACE" property="thRSpace"  /><result column="THTYPE_CSPACE" property="thCSpace"  /><result column="THTYPE_TXT_HEIGHT" property="thTxtHeight"  javaType="int" jdbcType="INTEGER" /><result column="THTYPE_TXT_WIDTH" property="thTxtWidth"  javaType="int" jdbcType="INTEGER"/><result column="THTYPE_TXT_X" property="thTxtX"  /><result column="THTYPE_TXT_Y" property="thTxtY"  /><!--<result column="TH_URL" property="thUrl"  />--><result column="TH_FONTID" property="thFontId"  /><result column="TH_FONTSIZE" property="thFontSize"  /><result column="TH_FONTCOLOR" property="thFontColor"  /><result column="TH_ISDEFAULT" property="thIsDefault"/><association property="thUrl" column="{themeIndex=TH_BG_ID,width=THTYPE_WIDTH,height=THTYPE_HEIGHT}"  select="getUrlByBgId"></association></resultMap>

<select id="getUrlByBgId" parameterType="com.contentlib.beans.bussiness.ThemeByIndex" resultType="String">??SELECT MATERIAL_URL FROM ctt_material_standard? WHERE MATERIAL_ID = #{themeIndex} ???and MATERIAL_WIDTH=#{width} and MATERIAL_HEIGHT=#{height}?</select>

?<association property="thUrl" column="{themeIndex=TH_BG_ID,width=THTYPE_WIDTH,height=THTYPE_HEIGHT}"
select="getUrlByBgId"></association>
colum 通过{}添加多列条件查询

在select语句中解析传入sql语句，在网上找了一下，自己摸索了一下，发现居然可以这样子用。。。

java类：

public class ThemeByIndex {private String themeIndex;private int width;private int height;public String getThemeIndex() {return themeIndex;}public void setThemeIndex(String themeIndex) {this.themeIndex = themeIndex;}public int getWidth() {return width;}public void setWidth(int width) {this.width = width;}public int getHeight() {return height;}public void setHeight(int height) {this.height = height;}}

?