jpa @Query使用原生sq并且使用ifl多表查询并封装数据为Map，后台打印为TupleBackedMap@29088d3d

左外连接查询，好像不能直接转为自定义可以接受的对象，最好用map接受。用Object接受只含有返回的值，没有对应属性，用object返回的和Map返回的形式相同，它是java.lang.Object;@3792fed8，转为数据请往下看。

注意：在原生sql中使用if语句判断是否为空用时，’‘代表null。例如 and if(?3 !=’’,u.catelog_name =?3,1=1)"

@Query(nativeQuery = true, value = "select u.catelog_name as catelog_name ,u.user_id as user_id,d.companyname as companyname,d.user_name as user_name," +
            " d.image_path as image_path,d.sex as sex,u.director_users_id as director_users_id,d.phone_number as phone_number,d.email as email,d.director_id as director_id" +
            " from aoa_director_users as u left join aoa_director as d on d.director_id = u.director_id" +
            " where u.user_id=?1 and u.director_id is not null AND u.is_handle=1" +
            " AND if(?2 !='ALL%',d.pinyin LIKE ?2,1=1) AND if(?3 !='' ,u.catelog_name =?3,1=1)" +
            " order by u.catelog_name ")
    Page<Map> allDirector(Long userId, String pinyin, String outtype, String baseKey, Pageable pageable);

调用

Pageable pageable= PageRequest.of(0,10);
Page<Map> all = directorUserDao.allDirector(1L, "ALL%", null, null, pageable);
System.out.println(all.getContent());
System.out.println(all.getContent().get(0).get("catelog_name"));
        //如果直接从all.getContent()取值，控制台打印为null

返回的Map值在后台控制台打印结果为

[org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap@1516f497, org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap@6c4e11d0, org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap@29088d3d, org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap@3284de45, org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap@5390862e, org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap@4fccdd1d, org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap@22c0c0bc]
null

这种值直接返回给前台，从前台能直接取出对应Key的Value的值。但是如果还需要对返回数据进行操作，直接取值是去不出来，由于从网上没有找到怎么取值的方法，自己苦思冥想出来的一个方法，先转为JSON，在转为对应的对象。

<dependency>
	<groupId>com.alibaba</groupId>
	<artifactId>fastjson</artifactId>
	<version>1.2.58</version>
</dependency>

String s = JSONObject.toJSONString(all.getContent());
List<OutAddress> list = JSONObject.parseArray(s, OutAddress.class);
for (OutAddress outAddress:list){
	System.out.println(outAddress);
}

结果就能转为相应的VO类进行数据操作了。

OutAddress(catelog_name=null, user_id=1, companyname=517小分队, user_name=xuxu, image_path=null, sex=男, director_users_id=39, phone_number=18899887766, email=asdf@163.com, director_id=9)
OutAddress(catelog_name=, user_id=1, companyname=辣条有限公司+百度, user_name=张奇风, image_path=null, sex=女, director_users_id=5, phone_number=18899999900, email=1899999@qq.com, director_id=5)