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>
页:
[1]