Structuring Session‑Based Scene Data with MyBatis in Java

In a typical business scenario a single sessionId can correspond to multiple sceneId / sceneName pairs, but the original JSON returned a List<SceneVO> where each element duplicated the same sessionId .

To make the data structure clearer for the front‑end, the sessionId is extracted to the outer level and the scenes are placed inside a sceneList array.

{
  "data": {
    "sessionId": "jksadhjksd",
    "sceneList": [
      {"sceneId":"NDJWKSDSJKDKED","sceneName":"场景1"},
      {"sceneId":"KLJSDJKLSDFALK","sceneName":"场景2"},
      {"sceneId":"KERFJKOVDJKDSS","sceneName":"场景3"}
    ]
  }
}

The Java entity classes are defined as follows:

public class SceneVO {
    private String sessionId;
    private List
sceneList;
    // getters and setters omitted
}

public class SubSceneVO {
    private String sceneId;
    private String sceneName;
    // getters and setters omitted
}

A custom MyBatis mapper interface and its XML mapping handle the one‑to‑many relationship:

public interface BusinessScenesCustomMapper {
    SceneVO selectBySessionId(String sessionId);
}
SELECT session_id, scene_id, scene_name
        FROM your_table
        WHERE session_id = #{sessionId,jdbcType=VARCHAR}

The service layer simply delegates to the mapper:

public interface SceneService {
    /** Get scene information for a given session */
    SceneVO getScenesInfo(String sessionId);
}

@Service
public class SceneServiceImpl implements SceneService {
    @Resource
    private BusinessScenesCustomMapper businessScenesCustomMapper;

    @Override
    public SceneVO getScenesInfo(String sessionId) {
        return businessScenesCustomMapper.selectBySessionId(sessionId);
    }
}

Finally, a REST controller exposes the data through an endpoint:

@RestController
public class SceneController {
    @Resource
    private SceneService sceneService;

    @GetMapping("/getScenesInfo")
    public ResModel getScenesInfo(String sessionId) {
        SceneVO sceneVO = sceneService.getScenesInfo(sessionId);
        return ResModel.ok(sceneVO);
    }
}