场景:
指令表t_record:id,content
用户表t_user_zlb:id,name,mobile
用户指令表t_user_record:id,userId,recordId
此时,需要查询以下内容
代码如下
0. vo类
@Data
@ToString
public class UserRecordVo {
@ApiModelProperty("ID")
private Long id;
/** 网格指令记录id */
@ApiModelProperty("网格指令记录id")
private Long recordId;
/** 浙里办用户ID */
@ApiModelProperty("浙里办用户ID")
private Long userId;
/** 浙里办用户ID */
@ApiModelProperty("浙里办用户姓名")
private String loginName;
/** 浙里办用户ID */
@ApiModelProperty("浙里办用户电话")
private String mobile;
/** 状态(0未查收,1已查收) */
@ApiModelProperty("状态(0未查收,1已查收)")
private Integer status;
}
1. controller
/**
* 查询用户-网格指令记录关联列表
*/
@ApiOperation("用户-网格指令关联列表")
//@PreAuthorize("@ss.hasPermi('partybuild:userRecord:list')")
@GetMapping("/list")
public TableDataInfo list(Long recordId)
{
startPage();
List<UserRecordVo> list = userRecordService.find(recordId);
System.out.println(list);
return getDataTable(list);
}
2. service
public interface UserRecordService extends IService<UserRecord>
{
List<UserRecordVo> find(Long recordId);
}
3. impl
@Service
public class UserRecordServiceImpl extends ServiceImpl<UserRecordMapper, UserRecord> implements UserRecordService
{
@Autowired
private UserRecordMapper userRecordMapper;
@Override
public List<UserRecordVo> find(Long recordId) {
return userRecordMapper.find(recordId);
}
}
4. mapper
public interface UserRecordMapper extends BaseMapper<UserRecord>
{
List<UserRecordVo> find(@Param("recordId") Long recordId);
}
5. xml
<select id="find" parameterType="Long" resultType="com.ruralfuture.domain.vo.UserRecordVo">
select
t_user_record.id,
t_user_record.record_id,
t_user_record.user_id,
t_user_zlb.login_name,
t_user_zlb.mobile,
t_user_record.status
from
t_user_record, t_user_zlb
where
t_user_record.record_id = #{recordId}
and
t_user_record.user_id = t_user_zlb.id
</select>