关于若依框架相信各位都不陌生,不过常见的问题可能就是说上传组件的图片显示问题,以及在表关联时候如何查询并显示,下面就是笔者为之记录,方便查询。
1、关于图片显示
图片显示比较简单,只需要在需要显示的位置增加formatter函数
{
field: 'activityImage',
title: '活动海报',
formatter: function (value, row, index) {
return '<img src="' + value + '" width="150" height="100">';
}
},
2、多表关联查询
- 根据mybatis首先编写级联,在查询的resultMap中加入级联
<association property="comCommunity" javaType="ComCommunity">
<id property="communityId" column="community_id"></id>
<result property="communityName" column="community_name"/>
</association>
2.编写级联的sql,注意后面条件的id值不要写反,一定要保证后面的有值
<sql id="selectComActivityVo">
select * from com_activity as ca left join com_community as com on com.community_id=ca.activity_community_id
</sql>
- 在实体类中添加该级联的实体,并生成get、set
@Excel(name = "活动简介")
private String activityDescription;
/** 活动状态 */
@Excel(name = "活动状态")
private Integer activityStatus;
private ComCommunity comCommunity;
public ComCommunity getComCommunity() {
return comCommunity;
}
- 先对查询显示进行改造
4. 对于新增的controller进行改造
/**
* 新增activity
*/
@GetMapping("/add")
public String add(ModelMap modelMap, ComCommunity comCommunity)
{
List<ComCommunity> comCommunities = comCommunityService.selectComCommunityList(comCommunity);
modelMap.put("list",comCommunities);
return prefix + "/add";
}
对前台的新增页面进行改写:
<div class="form-group">
<label class="col-sm-3 control-label is-required">所属社团:</label>
<div class="col-sm-8">
<select name="activityCommunityId" class="form-control">
<option th:each="list : ${list}" th:value="${list.communityId}" th:text="${list.communityName}"></option>
</select>
</div>
</div>
同样对于修改
/**
* 修改activity
*/
@RequiresPermissions("system:activity:edit")
@GetMapping("/edit/{activityId}")
public String edit(@PathVariable("activityId") Integer activityId, ModelMap mmap,ComCommunity comCommunity)
{
ComActivity comActivity = comActivityService.selectComActivityByActivityId(activityId);
mmap.put("comActivity", comActivity);
List<ComCommunity> comCommunities = comCommunityService.selectComCommunityList(comCommunity);
mmap.put("list",comCommunities);
return prefix + "/edit";
}
html跟新增相同