参考hibernate11 hql基本查询

HQLJDBCSQLHQL是Hibernate官方推荐的Hibernate查询方式，它使用类似于SQL的查询语言，是一种面向对象的查询语言，使用HQLJDBCHQL独立于数据库，对不同的数据库可以根据Hibernatedialect(方言)属性的配置自动生成不同的SQL语句执行。1.订单表:订单表: 2HQLJDBCSQLHQLHibernate官方推荐的Hibernate查询方式，它使用类似于SQL的查询语HQLJDBCHQLHibernatedialect(方言)属性的配置自动生成不同的SQL语句执行。1.图书表:2.2.HibernateQueryQueryhibernatehqlSQLSQL 3publicstaticpublicstaticvoidmain(String[]args)SessionQueryquery=session.createQuery(hql);List<Categories>list=query.list();for(Categoriescategories:{;Stringhql="fromHQLfromCategories”其中CategoriesHQL也可以使用select关键字，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都是一个Object类度就是2，数组的第都是一个Object类度就是2，数组的第 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都是一个Object都是一个Object类度就是2，数组的第上面使用“？”作为参数的占位符，其值使用query对象的上面使用“？”作为参数的占位符，其值使用query对象的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){}}在删除对象时，执行在删除对象时，执行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其它聚合函数还有count(),sum(),max(),min().如果查询的结果是一个唯一的值，则可以使用Query对象的uniqueResult（）方法执行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();}其它聚合函数还有count(),sum(),max(),min().如果查询的结果是一个唯一的值，则可以使用Query对象的uniqueResult（）方法执行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]);}}上面查询产生了一个集合，而集合中的每一个元素都是一个Object数组，Object数组的第一个元素是Categories类型的对象，第二个元素是平均价格。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上面查询产生了一个集合，而集合中的每一个元素都是一个Object数组，Object数组的第一个元素是Categories类型的对象，第二个元素是平均价格。publicstaticpublicstaticvoidmain(String[]args