mybatis应用总结
1.对象,映射和数据库字段的关系
对象:
public String id;
public String pId;
public String name; // 名称
public boolean open=false;
public String file;
public Boolean isParent;
映射:
<resultMap type="ZTreeNode" id="ZTreeNodeResult">
<id property="id" column="id" />
<result property="pId" column="pId" />
<result property="name" column="name" />
<result property="file" column="file" />
</resultMap>
注意:
1、这里映射不需要所有字段都映射出来
2、property要与column设置一致
实际sql:
select id,name,subarea_id as pId from ${_qrefix}substation where subarea_id in
<foreach collection="list" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
order by subarea_id,name asc
2、传递多个参数的处理方法
要用mybatis中的注解:
public List<ZTreeNode> queryBaysByVidAndStId(@Param("vol_id")String vol_id, @Param("st_id")String st_id);
3、参数传递list,sql中的处理方法
select id,name,subarea_id as pId from ${_qrefix}substation where subarea_id in
<foreach collection="list" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
order by subarea_id,name asc
采用foreach进行处理
4、oracle中判断某个参数是否为空
xxx is null //不能用xxx = null;