ssh多表联合查询 jsp显示出现问题
现在我想多表联合查询,然后把每个表中的某一个字段显示在jsp页面,望高手指导
biz
String hql = "from GoodsXtype x,GoodsXxtype xx where xx.goodsXtype.goodsXtypeId = x.goodsXtypeId";
System.out.println("hql============================"+hql);
List goodsType_alList = this.getDao().list(hql);
return goodsType_alList;
Form
private GoodsType goodsType = new GoodsType();
private GoodsXtype goosXtype = new GoodsXtype();
private GoodsXxtype goodsXxtype = new GoodsXxtype();
三个都有get()set的方法了
jsp页面
<div class="main-cd_c">
<div class="main-cd_ctitle">
<p><a href="#">${g.goodsType.goodsTypeName}</a></p>
<img src="images/xian-7.gif" />
</div>
<p style="float:left; width:83px; line-height:25px;"><font color="#56af00">${g.goosXtype.goodsXname}</font></p>
<ul>
<li><a href="#">${g.goodsXxtype.goodsXxname}</a></li>
</ul>
<img src="images/hx-1.gif" />
</div>
</logic:iterate>
现在老是显示不了,还出错
错误信息如下:
严重: Servlet.service() for servlet jsp threw exception
java.lang.NumberFormatException: For input string: "goodsType"......等等