java - How to map one-to-many in Mybatis

Question

For example, there is an entity class {code...} I originally wrote this, but it was wrong T0T, how should I map the content to List&lt;String&gt; {code...}

伊谢尔伦 · Answer

mybatis determines the set mapping relationship based on the tag. If you must use your table, you can map it like this

ringa_lee · Answer

The original poster should have one missing table here, which is the question table.

With the question table, the definition of DTO should be like this.

public class QuestionDTO {
     int questionId;
     String questionDesc;
     List answers; // Answers of the question
     int created; // 创建时间
     int updated; // 更新时间
}

public class AnswerDTO{ //一个回复的类，一个问题可能会有多个回复
    int id;
    int questionId; // 问题id
    String content; // 答案内容
    int created; // 创建时间
    int updated; // 更新时间
}

At this time, there are many related query solutions for mybatis, I will attach a link.

Mybatis related query (nested query)

There is a lot of information online about mybatis related queries. You can search more.

One last suggestion, it is best not to perform related queries. The data assembly logic is placed in the code, which facilitates future DB transformation. Because as the amount of data increases, the performance of related queries is poor, and it is not easy to transform the sub-database and sub-tables. However, this is all based on the large growth of the business. At present, it would be good if the poster starts to cultivate this awareness.

给我你的怀抱 · Answer

The mapping of table fields to complex object fields can be done using a custom TypeHandler.
eg:
Mapping of json fields to Java classes in MyBatis
http://www.cnblogs.com/watery...