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>