{"id":16154,"date":"2024-03-15T12:26:25","date_gmt":"2024-03-15T12:26:25","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-adding-multiple-data-in-mybatis\/"},"modified":"2025-08-07T00:38:51","modified_gmt":"2025-08-07T00:38:51","slug":"what-is-the-method-for-adding-multiple-data-in-mybatis","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-adding-multiple-data-in-mybatis\/","title":{"rendered":"What is the method for adding multiple data in MyBatis?"},"content":{"rendered":"

In MyBatis, a one-to-many relationship can be achieved by using two different methods to insert data.<\/p>\n

    \n
  1. To use nested queries:
    \nFirstly, define two corresponding query statements in the mapping file, one to query data from the main table, and one to query data from the subordinate table. Then, in the query statement of the main table, use a nested query to incorporate the query statement of the subordinate table, establishing a relationship between the primary key of the main table and the foreign key of the subordinate table. Finally, call the query statement of the main table within the business logic. MyBatis will automatically execute the nested query and map the results to nested objects.<\/li>\n
  2. The sample code is shown below:<\/li>\n
  3. \n
    \n
    \n SELECT *
    \n FROM sub_table
    \n WHERE main_table_id = #{id}
    \n<\/select><\/p>\n


    \n
    \n
    \n<\/resultMap><\/p>\n


    \n
    \n
    \n<\/resultMap><\/li>\n

  4. Invoke a query statement within the business logic.<\/li>\n
  5. Retrieve the data from the mainTable using the selectOne method with the parameter “getMainTableData” and the specified ID.<\/li>\n
  6. MyBatis will automatically execute nested queries and map the results to nested objects.<\/li>\n
  7. One alternative method is to use the association and collection tags in MyBatis. In the mapping file, the association tag defines the relationship between the main table and the secondary table, while the collection tag defines a collection for the secondary table. When querying the main table in the business logic, MyBatis will automatically execute the association query and map the results to associated objects.<\/li>\n
  8. The sample code is as follows:<\/li>\n
  9. Query statement for the main table:
    \n