myBatis应用总结

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；