Mybatis摘要

常青树

　　001、属性关联(single)

public class Student()
{
private String name;
private Grade grade;
//getter/setter Method;
}
public class Grade()
{
private String gradeName;
//getter/setter Method;
}

<select id="loadStudent"  resultType="Student">
select
a.* ,
b.gradeName as "grade.gradeName"
from tb_student a
inner join tb_grade b
</select>
　　002、  #{customerServiceUserName,jdbcType=VARCHAR}
　　003、批量删除
　　public void deleteAll(List<Integer> list);//删除

<delete id="deleteAll" >  
DELETE from qy_exchangepl   
WHERE exchangeplid in  
<foreach item="item" index="index" collection="list"   
open="(" separator="," close=")">  
#{item}  
</foreach>  
</delete>  
　　005、批量插入

//批量插入orderdetail表
public void batchInserOrderDetail(List<OrderDetail> list);

<insert id="batchInserOrderDetail" parameterType="java.util.List">
INSERT INTO orderdetail
(porduct )
VALUES
<foreach collection="list" item="detail" index="index" separator=",">
(#{detail.porduct}})
</foreach>
</insert >
　　006、mybatis单参数查询

<select id="selectMaterial" parameterType="String" resultType="String">
select t.subject_id from teach_material t where t.id=#{material_id}
</select>