博客好长时间没有更新技术文章了,今天还是回归一下老本行,给博客带动点更新率,这文章写的关于iBATIS一对多关联查询,觉的iBATIS的一对多关联查询比hibernate 要好处一点。
1.定义主表的类
private String breed_id; // 品种关联
private String file_id; // 图片关联id
private List breedlist = new ArrayList();
注意 breedlist 这个变量要和<result property="breedlist" column="id" select="wmf.auth.FlowerQiYe.breedlist"/>要对应
其实关键就在select="wmf.auth.FlowerQiYe.breedlist" 这行代码
2。编写iBATIS配置文件
<typeAlias alias="qiyeClass" type="com.dameng.wmf.auth.domain.FlowersQiYe" />
<typeAlias alias="breedClass" type="com.dameng.wmf.auth.domain.Breed" />
<resultMap id="qiyeMap" class="qiyeClass">
<result property="id" column="id" />
<result property="qeyi_name" column="qeyi_name" />
<result property="area" column="area" />
<result property="phone" column="phone" />
<result property="breedlist" column="id" select="wmf.auth.FlowerQiYe.breedlist"/>
</resultMap>
<select id="breedlist" resultMap="qiyeMap"
parameterClass="java.lang.String">
select * from wmf_breed where pid=#id#
</select>
注意这行代码返回结果要是Map
3.前台展示代码:
<table class="food_maintd" cellspacing="0" cellpadding="0">
<tr>
<th style="width:200px;">企业名称</th>
<th style="width:350px;">经营品种及价格</th>
<th style="width:200px;">地 址</th>
<th style="width:230px;">电话·联系人</ths>
</tr>
#foreach($obj in $obj_list.getPage())
<tr>
<td><a href="#">$!obj.qeyi_name</a></td>
<td><div align="left" style="margin-left:10px;">
#foreach($breed in $!obj.breedlist)
<span >品种</span>:$!breed.fare<p>
<span >
价格</span>:$!breed.price</span>
<p>
<span >特征</span>:$!breed.trait </p>
#end
</div>
</td>
<td>$!obj.area</td>
<td>$!obj.phone</td>
</tr>
#end
</table>
iBATIS的一对多关联查询
最新推荐文章于 2022-11-22 21:58:29 发布