spring-data-jpa 如何用@Query多表查询,返回map
@Query("select s.userid,s.playeddury,s.courseid,s.videoid,l.name as videoname,l.clicknum,l.uploadtime,l.downloadnum,l.imahttppath,l.vidhttppath,l.recommend from AppStudyRecodTable s,LoadVideoTable l where s.userid = ? and l.id = s.videoid")
public List<Map<String,Object>> findByUserid(int userid);
我连查了两张表,但是返回值是什么,平时返回值都是定义好的Entiry,但是连表了,就不可能返回Entity了。
于是我返回了List<Map<>>,但是结果并不理想。返回如下
{
"errormsg": "成功",
"data": [
[
1000,
"23",
2,
8,
"敲鼓",
5,
"2016-12-13 04:35:19\n",
0,
"http://1608k8d317.iask.in:80/1480667720159-c100.png",
"http://1608k8d317.iask.in:80/1480667718639-[陈二G的YN人生2]第01集_hd.mp4",
"0"
],
[
1000,
"45",
1,
4,
"税务232",
1,
"2016-12-02 04:35:19",
0,
"http://1608k8d317.iask.in:80/1480667720159-c100.png",
"http://1608k8d317.iask.in:80/1480667718639-[陈二G的YN人生2]第01集_hd.mp4",
"0"
]
],
"errorcode": "0"
}
这是一个list啊,没有map对应的key,如何让他返回map,map的key是select s.userid,s.playeddury,中的userid?望高手指点