<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)論排行榜

    主站蜘蛛池模板: 蜜臀亚洲AV无码精品国产午夜.| 国产va免费精品| 暖暖免费在线中文日本| 波多野结衣久久高清免费| 亚洲图片在线观看| 成人免费视频一区二区| 好先生在线观看免费播放 | 亚洲AV综合色区无码一区爱AV| 国产亚洲欧美在线观看| 18禁美女黄网站色大片免费观看| 亚洲日韩VA无码中文字幕| 亚洲人成电影网站色www| 91精品国产免费久久国语蜜臀 | 免费av片在线观看网站| 亚洲av片一区二区三区| 亚洲影院天堂中文av色| 蜜臀AV免费一区二区三区| 亚洲精品tv久久久久久久久 | 亚洲国产成人99精品激情在线| 国产精品区免费视频| 久久久无码精品亚洲日韩软件| 亚洲AV成人精品一区二区三区 | 精品久久洲久久久久护士免费| 亚洲欧洲日韩国产| 久久久久免费看黄a级试看| 国产亚洲AV手机在线观看| 边摸边吃奶边做爽免费视频99 | 精品国产污污免费网站入口在线 | 午夜国产精品免费观看| 久久亚洲AV无码精品色午夜| a在线观看免费网址大全| 亚洲中文字幕无码爆乳av中文| 国内成人精品亚洲日本语音 | 无码国产精品一区二区免费vr| 亚洲线精品一区二区三区影音先锋| 国产成人亚洲精品播放器下载 | 亚洲VA中文字幕无码一二三区| 巨胸喷奶水视频www免费视频| 亚洲精品无码久久不卡| 色噜噜狠狠色综合免费视频| 日韩激情淫片免费看|