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>