网站首页 编程技术 正文

太坑了，mybatis注解一对多，id没了

2023-04-12编程技术247250

@Select("SELECT *, id nodes FROM QUESTION_PO WHERE ID=#{id}")

    @Results({

            @Result(property = "nodeList", column = "nodes",

                    many = @Many(select = "com.doit.majorproject.mapper.QuestionMapper.getNodeListById")),

            @Result(property = "user", column = "userId",

                    one = @One(select = "com.doit.majorproject.mapper.QuestionMapper.getUserById")),

            @Result(property = "project", column = "projectId",

                    one = @One(select = "com.doit.majorproject.mapper.QuestionMapper.getProjectById")),

            @Result(property = "typeList", column = "typeIds",

                    many = @Many(select = "com.doit.majorproject.mapper.QuestionMapper.getTypeByIds"))

    })

    QuestionCh getByIdFeach(@Param("id") Long id);
@Select("SELECT * FROM QUESTION_NODE_PO d WHERE d.questionId = #{id}")

    QuestionNodeCh getNodeListById(@Param("id") Long id);

太坑了，如果不多查一个字段来存放id，而是在column里直接填id，查询出来的结果里，就没有id这个字段了，id这个字段就会变成nodeList这个字段

太坑了，mybatis注解一对多，id没了的相关教程结束。

本文地址：https://www.ufcn.cn/tutorials/2453654.html

如非特殊说明，本站内容均来自于网友自主分享，概不代表本站观点，如有任何问题我们都将在收到反馈后的第一时间进行处理！