mybatis 一对多

最新推荐文章于 2024-05-30 10:30:00 发布

whynote314

最新推荐文章于 2024-05-30 10:30:00 发布

阅读量150

点赞数

分类专栏： web 数据库

本文链接：https://blog.csdn.net/whynote314/article/details/103297346

版权

web 同时被 2 个专栏收录

8 篇文章 0 订阅

订阅专栏

数据库

3 篇文章 0 订阅

订阅专栏

注解形式

	@Select("SELECT * from GIS_BUILDING")
	@Results(id = "BuildingDTO",
	value = {@Result(column = "ID", property = "id"),
			@Result(column = "NAME", property = "name"),
			@Result(column = "NAME_ALPHABET", property = "nameAlphabet"),
			@Result(column = "MAP_ID", property = "mapId"),
			@Result(column = "MAP_X", property = "mapX"),
			@Result(column = "MAP_Y", property = "mapY"),
			@Result(column = "MAP_Z", property = "mapZ"),
			@Result(column = "ID", property = "floor", javaType = List.class, many = @Many(select = "com.nsitd.pms.db.mapper.GisMapMapper.findMapsByBuildId")) })
	List<BuildingDTO> selectAllBuildingDTO();