1.API
@ResponseBody
@GetMapping("/selectKnowledgeByUserId")
@ApiOperation(value = "根据登录用户id查询名下知识章节点")
@Logging(title = "根据登录用户id查询名下知识章节点", describe = "根据登录用户id查询名下知识章节点", type = BusinessType.QUERY)
public Result selectKnowledgeByUserId() {
SysUser currentUserObj = (SysUser) SecurityUtil.currentUserObj();
List<SysUserSettingDto> sysUserSettingDtos = iSysUserSettingsService.selectKnowledgeByUserId(currentUserObj.getUserId());
return success(sysUserSettingDtos);
}
2.service
List<SysUserSettingDto> selectKnowledgeByUserId(String userId);
@Override
public List<SysUserSettingDto> selectKnowledgeByUserId(String userId) {
return sysUserSettingsMapper.selectKnowledgeByUserId(userId);
}
3.SQL语句
List<SysUserSettingDto> selectKnowledgeByUserId(String userId);
<!-- 结果集 -->
<resultMap id="SysUserSettingsDto" type="com.cms.modules.bus.domain.dto.SysUserSettingDto">
<result property="moduleName" column="module_name"></result>
<!--一对多-->
<collection property="appKnowledgeTrees" ofType="com.cms.modules.bus.domain.AppKnowledgeTree">
<result property="treeId" column="TREE_ID"/>
<result property="treeName" column="TREE_NAME"/>
<result property="moduleId" column="MODULE_ID"/>
<result property="parentId" column="PARENT_ID"/>
<result property="treePath" column="TREE_PATH"/>
</collection>
</resultMap>
<!-- 查询个人名下所有的知识点-->
<select id="selectKnowledgeByUserId" parameterType="String" resultMap="SysUserSettingsDto">
SQL语句
</select>
4.实体类
import com.cms.modules.bus.domain.AppKnowledgeTree;
import lombok.Data;
import java.util.List;
@Data
public class SysUserSettingDto {
private String moduleName;
private List<AppKnowledgeTree> appKnowledgeTrees;
private String treeName;
private String knowledgeName;
private String parentId;
private String fileName;
}