SQL查询, 响应体临时字段报: Unknown column ‘data_json_map‘ in ‘field list‘

stjl.xyz

于 2025-05-21 14:34:55 发布

阅读量426

点赞数 2

分类专栏：芋道文章标签： java

本文链接：https://blog.csdn.net/weixin_43652507/article/details/148115492

版权

芋道专栏收录该内容

4 篇文章

订阅专栏

    @Override
    public AjaxResult list(AgentPageReqVO pageReqVO, Integer pageNo, Integer pageSize) {
        // 1. 查询数据库获取代理列表
        List<AgentDO> list = agentMapper.selectPage(pageReqVO).getList();

        // 如果结果为空，直接返回空分页结果
        if (CollectionUtils.isEmpty(list)) {
            return PaginationUtil.manualPaging(list, pageNo, pageSize);
        }

        // 创建JSON解析器
        ObjectMapper mapper = new ObjectMapper();

        // 2. 处理列表中的每个AgentDO对象
        list.stream().map(agent -> {
            // 检查dataJson字段是否有值
            if (!StringUtils.isEmpty(agent.getDataJson())) {
                try {
                    // 3. 将JSON字符串解析为Map对象
                    Map<String, Object> objectMap = mapper.readValue(
                            agent.getDataJson(),
                            new TypeReference<Map<String, Object>>() {}
                    );
                    // 4. 将解析后的Map设置到dataJsonMap属性
                    agent.setDataJsonMap(objectMap);
                } catch (Exception e) {
                    // 解析失败时设置为null
                    agent.setDataJsonMap(null);
                }
            }
            return null; // 这里返回null是因为map操作需要返回值，但实际不需要
        }).collect(Collectors.toList()); // 触发流操作执行

        // 5. 手动分页并返回结果
        return PaginationUtil.manualPaging(list, pageNo, pageSize);
    }

    default PageResult<AgentDO> selectPage(AgentPageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<AgentDO>()
                .eqIfPresent(AgentDO::getUserId, reqVO.getUserId())
                .eqIfPresent(AgentDO::getUserName, reqVO.getUserName())
                .eqIfPresent(AgentDO::getClzId, reqVO.getClzId())
                .likeIfPresent(AgentDO::getClzName, reqVO.getClzName())
                .eqIfPresent(AgentDO::getTitle, reqVO.getTitle())
                .eqIfPresent(AgentDO::getIntroduce, reqVO.getIntroduce())
                .eqIfPresent(AgentDO::getAvatar, reqVO.getAvatar())
                .eqIfPresent(AgentDO::getVisibleTenantIds, reqVO.getVisibleTenantIds())
                .eqIfPresent(AgentDO::getStatus, reqVO.getStatus())
                .eqIfPresent(AgentDO::getTemplateStatus, reqVO.getTemplateStatus())
                .eqIfPresent(AgentDO::getCreateWay, reqVO.getCreateWay())
                .eqIfPresent(AgentDO::getTop, reqVO.getTop())
                .eqIfPresent(AgentDO::getSort, reqVO.getSort())
                .eqIfPresent(AgentDO::getTemplateId, reqVO.getTemplateId())
                .eqIfPresent(AgentDO::getAppId, reqVO.getAppId())
                .eqIfPresent(AgentDO::getHint, reqVO.getHint())
                .eqIfPresent(AgentDO::getOpening, reqVO.getOpening())
                .eqIfPresent(AgentDO::getOpeningQuestion, reqVO.getOpeningQuestion())
                .eqIfPresent(AgentDO::getFollowup, reqVO.getFollowup())
                .eqIfPresent(AgentDO::getKnowledge, reqVO.getKnowledge())
                .eqIfPresent(AgentDO::getModel, reqVO.getModel())
                .eqIfPresent(AgentDO::getTool, reqVO.getTool())
                .eqIfPresent(AgentDO::getBackgroundImage, reqVO.getBackgroundImage())
                .eqIfPresent(AgentDO::getRoleCode, reqVO.getRoleCode())
                .eqIfPresent(AgentDO::getDeptId, reqVO.getDeptId())
                .likeIfPresent(AgentDO::getDeptName, reqVO.getDeptName())
                .betweenIfPresent(AgentDO::getCreateTime, reqVO.getCreateTime())
                .orderByDesc(AgentDO::getTop)
                .orderByDesc(AgentDO::getSort)
                .orderByDesc(AgentDO::getCreateTime));
    }

selectPage查询结果: 

Cause: java.sql.SQLSyntaxErrorException: Unknown column 'data_json_map' in 'field list'

问题分析与解决方案

问题原因

在 AgentDO 实体类中定义了 dataJsonMap 字段，它是一个临时字段用于存储解析后的 JSON 数据，不需要持久化到数据库。但在 SQL 查询中自动包含了这个字段，导致数据库报错 Unknown column 'data_json_map'。

解决方案

方法一：使用 `@TableField(exist = false)` 注解

在 AgentDO 类中，为 dataJsonMap 字段添加注解，明确表示它不是数据库字段：

@TableField(exist = false)  // 表示这不是数据库字段
private Map<String, Object> dataJsonMap;

{
    "msg": "操作成功",
    "code": 0,
    "data": {
        "total": 4,
        "list": [
            {
                "createTime": 1747803847000,
                "updateTime": 1747803847000,
                "creator": "1",
                "updater": "1",
                "deleted": false,
                "id": 12,
                "userId": 1,
                "userName": "admin",
                "clzId": null,
                "clzName": null,
                "title": "天气预报",
                "introduce": "我是天气预报的好帮手",
                "avatar": null,
                "visibleTenantIds": "[]",
                "status": 1,
                "templateStatus": 1,
                "createWay": null,
                "top": 0,
                "sort": 0,
                "templateId": "cd50493b-3222-4665-a08f-363595df4b35",
                "appId": "f64c6f9e-b21c-4b46-abc2-64cf3cdef9b9",
                "hint": null,
                "opening": null,
                "openingQuestion": null,
                "followup": null,
                "knowledge": null,
                "model": null,
                "tool": null,
                "backgroundImage": null,
                "roleCode": null,
                "deptId": 103,
                "deptName": "研发部门",
                "tenantId": 1,
                "tenantName": "企业租户",
                "scope": 1,
                "dataJsonMap": {
                    "pre_prompt": "string",
                    "opening_statement": "string",
                    "suggested_questions": [
                        "string"
                    ],
                    "suggested_questions_after_answer": {
                        "enabled": true
                    },
                    "dataset_configs": {
                        "datasets": {
                            "datasets": [
                                {
                                    "dataset": {
                                        "enabled": true,
                                        "id": "0828c38c-05e6-4b18-b065-d1a89d1dfdd2"
                                    }
                                }
                            ]
                        },
                        "reranking_enable": true,
                        "reranking_mode": "string",
                        "reranking_model": {
                            "reranking_model_name": "string",
                            "reranking_provider_name": "string"
                        },
                        "retrieval_model": "string",
                        "top_k": 0
                    },
                    "model": {
                        "completion_params": {
                            "stop": [

                            ]
                        },
                        "mode": "string",
                        "name": "string",
                        "provider": "string"
                    },
                    "agent_mode": {
                        "enabled": true,
                        "max_iteration": 0,
                        "prompt": "string",
                        "strategy": "string",
                        "tools": [
                            {
                                "enabled": true,
                                "notAuthor": true,
                                "provider_id": "string",
                                "provider_name": "string",
                                "provider_type": "string",
                                "tool_label": "string",
                                "tool_name": "string",
                                "tool_parameters": {
                                    "prompt": "string",
                                    "timestamp": "string",
                                    "traceId": "string"
                                }
                            }
                        ]
                    },
                    "background_image": "string"
                }
            }
        ]
    }
}

一线网资源-全网一站式平台