2019獨(dú)角獸企業(yè)重金招聘Python工程師標(biāo)準(zhǔn)>>>

Person類中包含有MyEvent這個(gè)類?

public class Person{private Long id;private String name;private MyEvent myEvent; }

一、HQL from語(yǔ)句?

1、結(jié)果類型：List<Person>

from Person 或者 from Person as p from Person as p where p.myEvent.title = :title 注意：hibernate3.2.3之前總是對(duì)的。?hibernate3.2.3之后如果myEvent是普通屬性或關(guān)聯(lián)的實(shí)體也是對(duì)的，如果myEvent是一個(gè)集合會(huì)出異常?因此hibernate推薦使用下面的方式： select p from Person as p inner join p.myEvent as e where e.title = :title

2、結(jié)果類型 List<Person,Event>

from Person as p inner join p.myEvent as event where event.title = : title 注：查詢出來(lái)是：是一個(gè)集合，集合元素是Person,myEvent組成的數(shù)組。?結(jié)果類型： List<Person,Event>? from Person as p left outer join p.myEvent as event where event.title = : title

注意：查詢出來(lái)是：是一個(gè)集合，集合元素是Person,myEvent組成的數(shù)組。?
? ? ? ? ? ?結(jié)果類型： List<Person,Event>

from Person as p right outer join p.myEvent as event where event.title = : title from Person as p full join p.myEvent as event where event.title = : title

第二：HQL select語(yǔ)句?

1、結(jié)果類型:? List<String>?

select p.name from Person as p

2、結(jié)果類型：List<Object[String,Person]>

select p.name,p from Person as p

3、結(jié)果類型：List<String,String>

select new List(p.name,p.address) from Person as p

4、結(jié)果類型：List<ClassTest>

select new ClassTest(p.name,p.address) from Person as p

? ?注意：前提ClassTest 類有兩個(gè)參數(shù)的構(gòu)造器。?

5、結(jié)果類型：List<map<String,String>>

select new map(p.name as personName) from Person as p

?

轉(zhuǎn)載于:https://my.oschina.net/u/1754093/blog/707074

總結(jié)

以上是生活随笔為你收集整理的hibernate select语句返回的类型的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。