mysql ibatis_mysql +ibatis

1.返回插入ID

a.xml

insert into

KLC_QUESTION

(QUESTION_TITLE,QUESTION_DESC,STATUS,MODIFIER,CREATOR,GMT_CREATE,GMT_MODIFY,ANONYMOUS)

values

(#questionTitle#,#questionDesc#,1,#modifier#,#creator#,now(),now(),#anonymous#)

resultClass="int" type="post" keyProperty="id" >

select LAST_INSERT_ID() as value

b. java 类操作

public int insert(KlcQuestion klcQuestion) {

return

(Integer) this.getSqlMapClientTemplate().insert("KlcQuestion.insert",

klcQuestion);

}

2. ibatis result select 使用

id="dataApiDetailMap">

column="id"/>

column="name"/>

column="description"/>

column="dataOwner"/>

column="dataType"/>

column="dataId"/>

property="dpList" select="dataApiDetailProperty.getDetailTagByDId"

column="id" />

property="tagList" select="dataApiDetailTag.getDetailTagByDId"

column="id"/>

3.ibatis iterate 使用

parameterClass="java.util.Map">

SELECT

DISTINCT(DATA_OWNER)

FROM DATA_API_DETAIL

WHERE STATUS = 1

prepend="AND" property="idList">

prepend="CATEGORY_ID IN" property="idList" conjunction="," open="("

close=")" >

#idList[]#

原文：http://www.cnblogs.com/Snowflake/p/3620915.html