Goods物品表,photo物品照片表,一个物品对应5张照片
双向关联映射已经做好了,查goods的时候用的criteria条件查询
怎么在查 所有的 goods的时候,同时把每个goods对应的一张photo也查出来 ?
贴代码了,太多了,不爱看的不看吧,高手们帮我看一下,我应该怎么写代码,才能在后台和页面取得photoName。
就是html代码部分我要<img src='../images/<s:property value="photos"/>拿到photoName,这里怎么改才能正确显示图片,怎么做呢?
问题已经解决,更新代码了。
html代码
- <form id="searchForm" name="searchForm" action="retrieveGoodsAction_retrieveAllGoods">
- <s:hidden name="frontGoodsQueryCriteria.sortHelper.colIndex" id="index" value="0"></s:hidden>
- <s:hidden name="frontGoodsQueryCriteria.sortHelper.colName" id="colName" value="goodsId"></s:hidden>
- <s:hidden name="frontGoodsQueryCriteria.sortHelper.sortedType" id="colType" value="asc"></s:hidden>
- <s:hidden name="page.pageNo" value="1"></s:hidden>
-
- 省略提交按钮
- <s:iterator value="page.content" id="l">
-
- <li> 0
- <div class="pro_disp pro_104px">
- <a href='retrieveGoodsAction_retrieveGoodsById?goodsId=<s:property value="goodsId"></a>' target="_blank">
- <img src='../imagesGoods/<s:iterator value="photos"><s:property value="photoName"/></s:iterator>' alt="图片不正确" />
- </a>
- </div>
- <b class="p_overflow">
- <a href='retrieveGoodsAction_retrieveGoodsById?goodsId=<s:property value="goodsId"></a>' target="_blank" title='<s:property value="goodsName"/>'>
- <s:property value="goodsName"/>
- </a>
- </b>
-
-
- </li>
-
- </s:iterator>
- </form>
action代码
- public class RetrieveGoodsAction extends BaseAction{
-
- private Integer cateId;
- private Integer goodsId;
-
- private List<Goods> lgoods;
- private Set<Photo> photos = new HashSet<Photo>(0);
-
-
-
- Page page = new Page();
-
- private GoodsQueryCriteria frontGoodsQueryCriteria=
- new GoodsQueryCriteria(new SortHelper("goodsId"));
-
-
-
-
-
-
- public String retrieveAllGoods() throws Exception{
-
- page = fgmi.goodsInfoByPage(page, frontGoodsQueryCriteria);
- Iterator itr = page.getContent().iterator();
- while(itr.hasNext()){
- Goods goods = (Goods) itr.next();
- photos = goods.getPhotos();
- System.out.println( "物品名称:" + goods.getGoodsName());
- Iterator it = goods.getPhotos().iterator();
- while(it.hasNext()){
- Photo ph =(Photo)it.next();
- System.out.println("图片名:" + ph.getPhotoName());
- }
-
- System.out.println("---------111++++++++==");
- }
- if(page != null){
- return "retrieveSuccess";
- }
- return ERROR;
- }
-
- public Integer getCateId() {
- return cateId;
- }
- public void setCateId(Integer cateId) {
- this.cateId = cateId;
- }
- public Integer getGoodsId() {
- return goodsId;
- }
- public void setGoodsId(Integer goodsId) {
- this.goodsId = goodsId;
- }
- public List<Goods> getLgoods() {
- return lgoods;
- }
- public void setLgoods(List<Goods> lgoods) {
- this.lgoods = lgoods;
- }
-
- public Page getPage() {
- return page;
- }
-
- public void setPage(Page page) {
- this.page = page;
- }
-
- public GoodsQueryCriteria getFrontGoodsQueryCriteria() {
- return frontGoodsQueryCriteria;