mybatis xml sql

批量操作

/**
 * 批量删除/启用 禁用 (更新操作)
 *
 * @param examExt
 * @return
 */
int batchOperationWithUpdate(ExamExt examExt);


// 批量处理【启用/禁用/删除】
List <Integer> examIds;


<!-- 批量删除 / 启用 / 禁用 -->
<update id="batchOperationWithUpdate">
	UPDATE exam
	<set>
		<if test="delId!=null">
			del_id = #{delId},
		</if>
	</set>
	WHERE exam_id IN
	<foreach collection="examIds" item="item" separator="," open="(" close=")">
		#{item}
	</foreach>
</update>

<resultMap>来映射字段名和实体类属性名

<select id="getOrder" parameterType="int" resultMap="orderresultmap">
      select * from orders where order_id=#{id}
</select>
 
<resultMap type=”me.gacl.domain.order” id=”orderresultmap”>
    <!–用id属性来映射主键字段–>
     <id property=”id” column=”order_id”>
     <!–用result属性来映射非主键字段，property为实体类属性名，column为数据表中的属性–>
     <result property = “orderno” column =”order_no”/>
     <result property=”price” column=”order_price” />
</reslutMap>

自动生成的(主)键值

<insert id=”insertname” usegeneratedkeys=”true” keyproperty=”id”>
     insert into names (name) values (#{name})
</insert>

<insert id="insertJsonPaper">
	INSERT INTO TB_D_XMLPAPER( <include refid="jsonPaperField" /> )
	VALUES(#{jsoncontent},#{pr_title},getdate(),#{pr_type},#{pr_status},#{pr_desc})
	<selectKey resultType="Integer" keyProperty="pr_id">
		SELECT @@IDENTITY AS pr_id
	</selectKey>
</insert>

在mapper中如何传递多个参数

方法一：

// DAO层的函数
Public UserselectUser(String name,String area);

<select id="selectUser"resultMap="BaseResultMap">  
  select *  fromuser_user_t whereuser_name = #{0} anduser_area=#{1}   
</select>

方法二：

 
user selectuser(@param(“username”) string username,@param(“hashedpassword”) string hashedpassword); 


<select id=”selectuser” resulttype=”user”>
   select id, username, hashedpassword from some_table 
   where username = #{username} and hashedpassword = #{hashedpassword} 
</select>