hibernate 鐨刢reateSQLQuery鐨勫嚑绉嶇敤娉?杞

hibernate 鐨刢reateSQLQuery鐨勫嚑绉嶇敤娉?杞?
鍏抽敭瀛? hibernate
浣跨敤SQLQuery
瀵瑰師鐢烻QL鏌ヨ?鎵ц?鐨勬帶鍒舵槸閫氳繃SQLQuery鎺ュ彛杩涜?鐨勶紝閫氳繃鎵ц?Session.createSQLQuery()鑾峰彇杩欎釜鎺ュ彛銆傛渶绠?鍗曠殑鎯呭喌涓嬶紝鎴戜滑鍙?互閲囩敤浠ヤ笅褰㈠紡锛?
List cats = sess.createSQLQuery( " select * from cats " ).addEntity(Cat. class ).list();
杩欎釜鏌ヨ?鎸囧畾浜?
SQL鏌ヨ?瀛楃?涓?
鏌ヨ?杩斿洖鐨勫疄浣?
杩欓噷锛岀粨鏋滈泦瀛楁?鍚嶈?鍋囪?涓轰笌鏄犲皠鏂囦欢涓?寚鏄庣殑瀛楁?鍚嶇浉鍚屻?傚?浜庤繛鎺ヤ簡澶氫釜琛ㄧ殑鏌ヨ?锛岃繖灏卞彲鑳介?犳垚闂??锛屽洜涓哄彲鑳藉湪澶氫釜琛ㄤ腑鍑虹幇鍚屾牱鍚嶅瓧鐨勫瓧娈点?備笅闈㈢殑鏂规硶灏卞彲浠ラ伩鍏嶅瓧娈靛悕閲嶅?鐨勯棶棰?
List cats = sess.createSQLQuery( " select {cat.*} from cats cat " ).addEntity( " cat " , Cat. class ).list();
杩欎釜鏌ヨ?鎸囧畾浜?
SQL鏌ヨ?璇?彞锛屽畠甯︿竴涓?崰浣嶇?锛屽彲浠ヨ?Hibernate浣跨敤瀛楁?鐨勫埆鍚?
鏌ヨ?杩斿洖鐨勫疄浣擄紝鍜屽畠鐨凷QL琛ㄧ殑鍒?悕.
addEntity()鏂规硶灏哠QL琛ㄧ殑鍒?悕鍜屽疄浣撶被鑱旂郴璧锋潵锛屽苟涓旂‘瀹氭煡璇㈢粨鏋滈泦鐨勫舰鎬併??
addJoin()鏂规硶鍙?互琚?敤浜庤浇鍏ュ叾浠栫殑瀹炰綋鍜岄泦鍚堢殑鍏宠仈.
List cats = sess.createSQLQuery(
" select {cat.*}, {kitten.*} from cats cat, cats kitten where kitten.mother = cat.id " )
.addEntity( " cat " , Cat. class )
.addJoin( " kitten " , " cat.kittens " )
.list();
鍘熺敓鐨凷QL鏌ヨ?鍙?兘杩斿洖涓?涓?畝鍗曠殑鏍囬噺鍊兼垨鑰呬竴涓?爣閲忓拰瀹炰綋鐨勭粨鍚堜綋銆?

Double max = (Double) sess.createSQLQuery( " select max(cat.weight) as maxWeight from cats cat " ).addScalar( " maxWeight " , Hibernate.DOUBLE);.uniqueResult();

闄ゆ?涔嬪?锛屼綘杩樺彲浠ュ湪浣犵殑hbm鏂囦欢涓?弿杩扮粨鏋滈泦鏄犲皠淇℃伅锛屽湪鏌ヨ?涓?娇鐢ㄣ??

List cats = sess.createSQLQuery(" select {cat.*}, {kitten.*} from cats cat, cats kitten where kitten.mother = cat.id " ).setResultSetMapping( " catAndKitten " ).list();

鍛藉悕SQL鏌ヨ?
鍙?互鍦ㄦ槧灏勬枃妗ｄ腑瀹氫箟鏌ヨ?鐨勫悕瀛?鐒跺悗灏卞彲浠ヨ薄璋冪敤涓?涓?懡鍚嶇殑HQL鏌ヨ?涓?鏍风洿鎺ヨ皟鐢ㄥ懡鍚峉QL鏌ヨ?.鍦ㄨ繖绉嶆儏鍐典笅,鎴戜滑涓?闇?瑕佽皟鐢╝ddEntity()鏂规硶.
< sql - query name = " persons " >
< return alias = " person " class = " eg.Person " />
Select person.NAME AS {person.name},person.AGE AS {person.age},person.SEX AS {person.sex} FROM PERSON person Where person.NAME LIKE :namePattern
</ sql - query >List people = sess.getNamedQuery( " persons " ).setString( " namePattern " , namePattern)
.setMaxResults( 50 )
.list();