Hibernate3 Learning Notes (ix) query and HQL

The sample code is as follows:

 1.package com.hb3.pack_01; 


 2. 


 3.import Java.util.Iterator; 


 4.import java.util.List; 


 5. 6.import Org.hibernate.Query; 


 7.import org.hibernate.Session; 


 8.import org.hibernate.SessionFactory; 


 9.import org.hibernate.Transaction; 


 10.import org.hibernate.cfg.Configuration; 


 11. 12.import Com.hb3.pack_01.model. User; 


 13.import Com.hb3.pack_01.model. Userbak; 


 14. 15.public class Businessservice {


 16. public static void Main (string[] args) {


 18. 


 19. Configuration config = new Configuration (). Configure (); 


 20. Sessionfactory sessionfactory = Config.buildsessionfactory (); 


 21. Session session = Sessionfactory.opensession (); 


 22. 


query = Session.createquery ("from Com.hb3.pack_01.model.        User User order BY user.age Desc, user.name ");//[== from user] 24. Printuserinfo (Query.list ()); 


 25. 


 26. query = Session.createquery ("Select New Com.hb3.pack_01.model.") Userbak (User.Name, user.age) from user as user); 


 27. Iterator<?> iterator = Query.list (). iterator (); 


 28. System.out.println ("Class_name \t\t name/age"); 


 29. while (Iterator.hasnext ()) {


 30. Userbak Userbak = (userbak) iterator.next (); 


 31. System.out.println (USERBAK.GETCLZ () + "T" + userbak.getname () + "/" + userbak.getage ()); 


 32. } 


 33. 


 34. query = Session.createquery ("Select Upper (User.Name) from user as user where" (USER.AGE/2 >=?) and (User.age is not null)); 


 35. Query.setinteger (0, 13); 


list<?> names = Query.list (); 


 37. iterator = Names.iterator (); 


 38. while (Iterator.hasnext ()) {


 39. System.out.println (Iterator.next ()); 


 40. } 


 41. 


 42. query = Session.createquery ("Select User.Name, user.age from user as user where User.age >: Minage"); 


 43. Query.setinteger ("Minage", 25); 


 44. names = Query.list (); 


 45. iterator = Names.iterator (); 


 46. while (Iterator.hasnext ()) {


 47. object[] obj = (object[]) iterator.next (); 


 48. System.out.println (Obj[0] + "T" + obj[1]); 


 49. } 


 50. 


 51. query = Session.getnamedquery ("Com.hb3.pack_01.model.") User.queryuser "); 


 52. Query.setinteger ("Minage", 25); 


Printuserinfo (Query.list ()); 


 54. 


 55. Transaction tx= session.begintransaction (); 


 56. query = Session.createquery ("Update User set age=24 where name= ' Chenyan '"); 


 57. Query.executeupdate (); 


 58. Tx.commit (); 


 59. tx= session.begintransaction (); 


 61. query = session.createquery ("Delete User where name= ' Yaobin '"); 


 62. Query.executeupdate (); 


 63. Tx.commit (); 


 64. 


 65. Session.close (); 


 66. Sessionfactory.close (); 


 67. } 


 68. 


 69. public static void Printuserinfo (list<?> users) {


 70. 


 71. Iterator<?> iterator = Users.iterator (); 


 72. SYSTEM.OUT.PRINTLN ("ID \ t name/age"); 


while (Iterator.hasnext ()) {


 74. User user = (user) iterator.next (); 


 75. System.out.println (User.getid () + "T" + user.getname () + "/" + user.getage ()); 


 76. } 


 77. } 


 78.}