Spring Data Jpa @Query 使用JDBC和原生语句中返回Map的区别

1. 使用原生语句时

	/**
     * 根据id List集合 找到对应id的总需求
     * @param idList {@code List<Integer>} id List集合
     * @return {@code List<Map<String, String>>} id，totalDemend映射集合
     */
    @Query(value = "SELECT pj.`id`, COUNT(s.`id`) as totalDemend\n" +
            "FROM zt_project pj\n" +
            "INNER JOIN zt_projectproduct pp\n" +
            "ON pj.`id` = pp.project\n" +
            "INNER JOIN zt_story s\n" +
            "ON pp.product = s.product\n" +
            "WHERE pj.id in (:idList)\n" +
            "GROUP BY pj.id", nativeQuery = true)
    List<Map<String, String>> getIdAndTotalDemend(@Param("idList") List<Integer> idList);

此时返回的key为我们要查找的列名，比如上面代码中的idtotalDemend，或者下图中红色的部分：

示例

// 使用List<Map>接收原生sql查询后返回的数据
@Query(value = "select a.id as uid,a.name,a.token,b.id as aid,b.address,b.door from user a l