參考hibernate11 hql基本查詢

HQLJDBCSQLHQL是Hibernate官方推薦的Hibernate查詢方式，它使用類似于SQL的查詢語言，是一種面向?qū)ο蟮牟樵冋Z言，使用HQLJDBCHQL獨(dú)立于數(shù)據(jù)庫，對(duì)不同的數(shù)據(jù)庫可以根據(jù)Hibernatedialect(方言)屬性的配置自動(dòng)生成不同的SQL語句執(zhí)行。1.訂單表:訂單表: 2HQLJDBCSQLHQLHibernate官方推薦的Hibernate查詢方式，它使用類似于SQL的查詢語HQLJDBCHQLHibernatedialect(方言)屬性的配置自動(dòng)生成不同的SQL語句執(zhí)行。1.圖書表:2.2.HibernateQueryQueryhibernatehqlSQLSQL 3publicstaticpublicstaticvoidmain(String[]args)SessionQueryquery=session.createQuery(hql);List<Categories>list=query.list();for(Categoriescategories:{;Stringhql="fromHQLfromCategories”其中CategoriesHQL也可以使用select關(guān)鍵字，select可以省略fromfromCategoriesasfrom selectcategoriefrom asselectcategoriefrom 4publicpublicstaticvoidmain(String[]args)SessionQueryquery=session.createQuery(hql);List<Categories>list=query.list();for(Categoriescategories:list){}}Stringhql="fromHQLFROM,fromFromHQL語句“fromCategories”其中CategoriesHQLfromfromCategoriesasfrom selectcategoriefrom asselectcategoriefrom publicpublicstaticvoidmain(String[]args)Sessionsession=Queryquery=session.createQuery(hql);List<Object[]>list=query.list();for(Object[]property:{;Stringhql="selectb.title,b.pricefromBooks都是一個(gè)Object類度就是2，數(shù)組的第都是一個(gè)Object類度就是2，數(shù)組的第 5publicpublicstaticvoidmain(String[]args)Sessionsession=Queryquery=session.createQuery(hql);List<Object[]>list=query.list();for(Object[]property:list){}}Stringhql="selectb.title,b.pricefromBooks上面的HQL語句中查詢了Bookstitle屬性和priceselect都是一個(gè)Object都是一個(gè)Object類度就是2，數(shù)組的第上面使用“？”作為參數(shù)的占位符，其值使用query對(duì)象的上面使用“？”作為參數(shù)的占位符，其值使用query對(duì)象的setXXX0JDBC17.publicpublicstaticvoidmain(String[]args)Sessionsession=Queryquery=session.createQuery(hql);List<Books>list=query.list();for(Books{Stringhql="selectbfromBooksbwhereb.titlelike=,<>,<,>,>=,<=,between….and…,notbetween…and….,in,notin,isnull,isnotpublicstaticvoidpublicstaticvoidmain(String[]args)Sessionsession=HibernateSessionFactory.getSession();Stringhql="fromBooksbwhereb.pricebetween?and?";Queryquery=session.createQuery(hql);query.setInteger(1,100);List<Books>list=query.list();for(Booksbook:list){ 6publicpublicstaticvoidmain(String[]args)Sessionsession=Queryquery=session.createQuery(hql);List<Books>list=query.list();for(Booksbook:list){}}Stringhql="selectbfromBooksbwhereb.titlelikeHQLwhereSQLwherewhere=,<>,<,>,>=,<=,between….and…,notbetween…and….,in,notin,isnull,isnotnull,HQL6.publicstaticvoidpublicstaticvoidmain(String[]args)Sessionsession=HibernateSessionFactory.getSession();Stringhql="fromBooksbwhereb.pricebetween?and?";Queryquery=session.createQuery(hql);query.setInteger(1,100);List<Books>list=query.list();for(Booksbook:list){}}在刪除對(duì)象時(shí)，執(zhí)行在刪除對(duì)象時(shí)，執(zhí)行9.8publicstaticvoidpublicstaticvoidmain(String[]args)Sessionsession=Queryquery=session.createQuery(hql);query.setInteger("secondPrice",100);List<Books>list=query.list();for(Books{8.publicpublicstaticvoidmain(String[]args)Stringhql="deleteUsersuwherelike'張%'";Transactiontx=session.beginTransaction(); 750100publicpublicstaticvoidmain(String[]args)Sessionsession=Queryquery=session.createQuery(hql);query.setInteger("secondPrice",100);List<Books>list=query.list();for(Booksbook:list){}}Stringhql="fromBooksbwhereb.pricebetween:firstPriceand8.publicpublicstaticvoidmain(String[]args)Stringhql="deleteUsersuwherelike'張%'";Transactiontx=session.beginTransaction();Queryquery=session.createQuery(hql);}publicpublicstaticvoidmain(String[]args)Stringhql="updateBooksbsetb.price=b.price*0.8";Transactiontx=session.beginTransaction();Queryquery=session.createQuery(hql);publicpublicstaticvoidmain(String[]args)Stringhql="selectavg(b.price)fromBooksb";Query其它聚合函數(shù)還有count(),sum(),max(),min().如果查詢的結(jié)果是一個(gè)唯一的值，則可以使用Query對(duì)象的uniqueResult（）方法執(zhí)行hql語句publicpublicstaticvoidmain(String[]args)Sessionsession=Stringhql="selectb.categories,avg(b.price)fromBooksbgroupbyb.categorieshavingavg(b.price)>50";Queryquery=session.createQuery(hql);for(Object[]obj:list)Categoriesc=(Categories)obj[0]; 8publicpublicstaticvoidmain(String[]args)Stringhql="updateBooksbsetb.price=b.price*0.8";Transactiontx=session.beginTransaction();Queryquery=session.createQuery(hql);}publicpublicstaticvoidmain(String[]args)Stringhql="selectavg(b.price)fromBooksb";QueryDoubleavgPrice=(Doublequery.uniqueResult();}其它聚合函數(shù)還有count(),sum(),max(),min().如果查詢的結(jié)果是一個(gè)唯一的值，則可以使用Query對(duì)象的uniqueResult（）方法執(zhí)行hql語句publicpublicstaticvoidmain(String[]args)Sessionsession=Stringhql="selectb.categories,avg(b.price)fromBooksbgroupbyb.categorieshavingavg(b.price)>50";Queryquery=session.createQuery(hql);List<Object[]>list=query.list();for(Object[]obj:list){Categoriesc=(Categories)obj[0];System.out.println(c.getName()+"\t"+obj[1]);}}上面查詢產(chǎn)生了一個(gè)集合，而集合中的每一個(gè)元素都是一個(gè)Object數(shù)組，Object數(shù)組的第一個(gè)元素是Categories類型的對(duì)象，第二個(gè)元素是平均價(jià)格。publicstaticpublicstaticvoidmain(String[]args)Stringhql="fromBooks";Queryquery=session.createQuery(hql);intpageSize=10;intindex=//起始位置(頁碼-1)*頁大小query.setFirstResult((index1*pageSize);//頁大小List<Books>list=query.list();for(Booksbooks:list){publicpublicstaticvoidmain(String[]args)Sessionsession=Stringhql="selectufromUsersuwhereunotin(selecto.usersfromOrderso)";Queryquery=session.createQuery(hql);List<Users>list=query.list();for(Usersuser:list){ 9上面查詢產(chǎn)生了一個(gè)集合，而集合中的每一個(gè)元素都是一個(gè)Object數(shù)組，Object數(shù)組的第一個(gè)元素是Categories類型的對(duì)象，第二個(gè)元素是平均價(jià)格。publicstaticpublicstaticvoidmain(String[]args