<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    Java學(xué)習(xí)

    java,spring,structs,hibernate,jsf,ireport,jfreechart,jasperreport,tomcat,jboss -----本博客已經(jīng)搬家了,新的地址是 http://www.javaly.cn 如果有對(duì)文章有任何疑問(wèn)或者有任何不懂的地方,歡迎到www.javaly.cn (Java樂(lè)園)指出,我會(huì)盡力幫助解決。一起進(jìn)步

     

    HQL語(yǔ)句的語(yǔ)法

    1.from子句
    from Person
    表明從Person持久化類(lèi)中選出全部的實(shí)例。
    推薦:from Person as p

    2.select子句
    select p.name from Person as p
    select p.name.firstName from Person as p
    select new list(p.name, p.address) from Person as p
    select new ClassTest(p.name, p.address) from Person as p (有前提)
    select p.name as personName from Person as p
    select new map(p.name as personName) from Person as p (與new map()結(jié)合更普遍)

    3.聚集函數(shù)
    avg,count,max,min,sum
    select count(*) from Person
    select max(p.age) from Person as p
    select p.name || "" || p.address from Person as p

    4.多態(tài)查詢(xún)
    from Person as p
    from java.lang.Object o
    from Named as n

    5.where子句
    from Person where name like "tom%"
    from Person as p where p.name like "tom%"
    from Cat cat where cat.mate.name like "kit%"
    select * from cat_table as table1 cat_table as table2 where table1.mate =
    table2.id and table1.name like "kit%"
    from Foo foo where foo.bar.baz.customer.address.city like "fuzhou%"
    from Cat cat, Cat rival where cat.mate = rival.mate
    select cat, mate
    from Cat cat, Cat mate
    where cat.mate = mate
    from Cat as cat where cat.id = 123
    from Cat as cat where cat.mate.id = 69
    from Person as person
    where person.id.country = 'AU'
    and person.id.medicareNumber = 123456
    from Account as account
    where account.owner.id.country = 'AU'
    and account.owner.id.medicareNumber = 123456
    from Cat cat where cat.class = DomesticCat
    from Account as a where a.person.name.firstName like "dd%" // 正確
    from Account as a where a.person.name like "dd%" // 錯(cuò)誤

    6.表達(dá)式
    from DomesticCat cat where cat.name between 'A' and 'B'
    from DomesticCat cat where cat.name in ('Foo', 'Bar', 'Baz')
    from DomesticCat cat where cat.name not between 'A' and 'B'
    from DomesticCat cat where cat.name not in ('Foo', 'Bar', 'Baz')
    from DomesticCat cat where cat.name is null
    from Person as p where p.address is not null
    true 1, false 0
    from Cat cat where cat.alive = true
    from Cat cat where cat.kittens.size > 0
    from Cat cat where size(cat.kittens) > 0
    from Calendar cal where maxelement(cal.holidays) > current date
    from Order order where maxindex(order.items) > 100
    from Order order where minelement(order.items) > 10000
    //操作集合元素
    select mother from Cat as mother, Cat as kit
    where kit in elements(foo.kittens)
    //p的name屬性等于集合中某個(gè)元素的name屬性
    select p from NameList list, Person p
    where p.name = some elements(list.names)
    //操作集合元素
    from Cat cat where exists elements(cat.kittens)
    from Player p where 3 > all elements(p.scores)
    from Show show where 'fizard' in indices(show.acts)
    //items是有序集合屬性,items[0]代表第一個(gè)元素
    from Order order where order.items[0].id = 1234
    //holidays是map集合屬性,holidays[national day]是代表其中第一個(gè)元素
    select person from Person person, Calendar calendar
    where calendar.holidays['national day'] = person.birthDay
    and person.nationality.calendar = calendar
    //下面同時(shí)使用list集合和map集合屬性
    select item from Item item, Order order
    where order.items[order.deliveredItemIndices[0]] = item and order.id = 11
    select item from Item item, Order order
    where order.items[maxindex(order.items)] = item and order.id = 11

    select item from Item item, Order order
    where order.items[size(order.items) - 1] = item

    select cust
    from Product prod,
    Store store
    inner join store.customers cust
    where prod.name = 'widget'
    and store.location.name in ['Melbourne', 'Sydney']
    and prod = all elements(cust.currentOrder.lineItems)

    SELECT cust.name, cust.address, cust.phone, cust.id, cust.current_order
    FROM customers cust,
    stores store,
    locations loc,
    store_customers sc,
    product prod
    WHERE prod.name = 'widget'
    AND store.loc_id = loc.id
    AND loc.name IN ('Melbourne', 'Sydney')
    AND sc.store_id = store.id
    AND sc.cust_id = cust.id
    AND prod.id = ALL(
    SELECT item.prod_id
    FROM line_items item, orders o
    WHERE item.order_id = o.id
    AND cust.current_order = o.id
    )

    7.order by子句
    from Person as p
    order by p.name, p.age
    from Person as p
    order by p.name asc, p.age desc

    8.group by子句
    select cat.color, sum(cat.weight), count(cat)
    from Cat cat
    group by cat.color
    //select后出現(xiàn)的id處出現(xiàn)在group by之后,而name屬性則出現(xiàn)在聚集函數(shù)中
    select foo.id, avg(name), max(name)
    from Foo foo join foo.names name
    group by foo.id

    select cat.color, sum(cat.weight), count(cat)
    from Cat cat
    group by cat.color
    having cat.color in (eg.Color.TABBY, eg.Color.BLACK)

    select cat
    from Cat cat
    join cat.kittens kitten
    group by cat
    having avg(kitten.weight) > 100
    order by count(kitten) asc, sum(kitten.weight) desc

    9.子查詢(xún)
    from Cat as fatcat
    where fatcat.weight > (select avg(cat.weight) from DomesticCat cat)

    from Cat as cat
    where not (cat.name, cat.color) in (
    select cat.name, cat.color from DomesticCat cat
    )

    10.fetch關(guān)鍵字
    from Person as p join p.scores

    from Document fetch all properties order by name
    from Document doc fetch all properties where lower(doc.name) like '%cat%'

     11.執(zhí)行hql
              String hql ="update ContentReply contentReply set active = false where contentReply.id =:replyId";
            getSession().createQuery(hql).setString("replyId", replyId).executeUpdate();


    posted on 2008-10-20 15:39 找個(gè)美女做老婆 閱讀(991) 評(píng)論(0)  編輯  收藏


    只有注冊(cè)用戶(hù)登錄后才能發(fā)表評(píng)論。


    網(wǎng)站導(dǎo)航:
     

    導(dǎo)航

    統(tǒng)計(jì)

    公告

    本blog已經(jīng)搬到新家了, 新家:www.javaly.cn
     http://www.javaly.cn

    常用鏈接

    留言簿(6)

    隨筆檔案

    文章檔案

    搜索

    最新評(píng)論

    閱讀排行榜

    評(píng)論排行榜

    主站蜘蛛池模板: 一区二区在线免费观看| 花蝴蝶免费视频在线观看高清版| 无人在线观看免费高清| 亚洲线精品一区二区三区影音先锋 | 国产无遮挡又黄又爽免费网站| xvideos亚洲永久网址| 免费看黄福利app导航看一下黄色录像 | 青娱乐免费在线视频| 亚洲国产精品xo在线观看| 黄色网址免费大全| 亚洲一区二区精品视频| 亚洲AV无码成人专区| 久久不见久久见免费影院| 亚洲国产AV无码专区亚洲AV | 亚洲hairy多毛pics大全| 久久青草91免费观看| 亚洲精品视频免费看| 青青久在线视频免费观看| 亚洲性无码一区二区三区| 国产高清在线免费| 国产亚洲精品美女久久久久久下载| 精品无码人妻一区二区免费蜜桃| 免费萌白酱国产一区二区| 永久免费精品影视网站| 免费观看亚洲人成网站| 97超高清在线观看免费视频| 亚洲国产精品一区二区三区久久 | 97国产免费全部免费观看| 亚洲熟妇无码一区二区三区| 亚洲第一视频在线观看免费| 国产在线精品免费aaa片| 亚洲午夜在线一区| 国产乱子伦精品免费女| 东方aⅴ免费观看久久av| 亚洲AV无码成人专区| 国产综合精品久久亚洲| 国产黄在线播放免费观看| 亚洲综合自拍成人| 国产精品公开免费视频| 暖暖在线视频免费视频| 亚洲heyzo专区无码综合|