MyBabitsXML中遍历以及插入语句返回ID

1、插入语句返回成功ID 

Mybatis技术学习，更多知识请访问https://www.itkc8.com

Java代码  

1. <selectKey keyProperty="id" resultType="int" order="AFTER">  
2.          </selectKey> -->  
3.          <!-- insert into wm_index_billing(title,publish_time,image_url) values(${title} , ${publishTime} , ${imageUrl})  

2、循环遍历 

 

Java代码  

1. <select id="getServiceTypeList" parameterType="com....entity.PreCreatebillrelationEntity" resultMap="preServiceTypeEntity">  
2.          select * from v_pre_servicetype where ID in   
3.          <foreach item="item"  collection="list" index="index" open="(" separator="," close=")">    
4.                 #{item.serviceId}  
5.          </foreach>  
6.      </select>  

serviceId为PreCreatebillrelationEntity中的属性 

3、在插入一条数据后返回该条数据的主键ID 

 

Java代码  

1. <insert id="saveActivity" parameterType="com.....entity.mobile.Activity" useGeneratedKeys="true" keyProperty="id">  
2.     INSERT INTO   
3.     TSM_ACTIVITY(NAME,SUMMARY,BEGIN_DATE,END_DATE,THUMBNAIL_URL,DISTINCT_URL,DEPLOY_DATE,TOP_DATE,STATUS)   
4.     VALUES(#{name},#{summary},#{beginDate},#{endDate},#{thumbnailUrl},#{distinctUrl},#{deployDate},#{topDate},#{status})  
5. </insert>  

在insert标签中添加属性useGeneratedKeys="true" keyProperty="id" 
keyProperty的值为实体类中的主键属性

 

Mybatis技术学习，更多知识请访问https://www.itkc8.com