PackageCom.imooc.model;Importjava.util.List;ImportJava.util.Map;ImportOrg.hibernate.Query;Importorg.hibernate.Session;ImportOrg.junit.After;ImportOrg.junit.Before;Importorg.junit.Test;Importcom.imooc.util.HibernateSessionFactory; Public classSellertest {PrivateSession session =NULL; @Test Public voidtestselectclauseself () {String hql= "Select New Seller (s.name,s.tel,s.address) from Seller S"; Query Query=session.createquery (HQL); List<Seller> sellers =query.list (); for(Seller seller:sellers) {System.out.println ("Name:" +seller.getname ()); System.out.println ("Tel:" +Seller.gettel ()); System.out.println ("Address:" +seller.getaddress ()); }} @Test Public voidTestselectclausemap () {String hql= "Select New Map (s.name,s.tel,s.address) from Seller S"; Query Query=session.createquery (HQL); List<Map> maps =query.list (); for(Map map:maps) {System.out.println ("Name:" +map.get ("0")); System.out.println ("Tel:" +map.get ("1")); System.out.println ("Address:" +map.get ("2")); }} @Test Public voidtestselectclauselist () {String hql= "Select New List (s.name,s.tel,s.address) from Seller S"; Query Query=session.createquery (HQL); List<List> lists =query.list (); for(List list:lists) {System.out.println ("Name:" +list.get (0)); System.out.println ("Tel:" +list.get (1)); System.out.println ("Address:" +list.get (2)); } } /** 1.name 2.tel 3.address 4.star*/@Test Public voidTestselectclauseobjectarray () {String hql= "Select S.name from Seller S"; Query Query=session.createquery (HQL); List<Object> list =query.list (); for(Object obj:list) {System.out.println ("Name:" +obj); } } /*** New Object * @Description:*/@Test Public voidTestselectmap () {String hql= "Select New Map (S.name as Name,s.tel as Tel) from Seller S"; Query Query=session.createquery (HQL); List<Map<String,Object>> list =query.list (); for(Map<string, object>map:list) {System.out.println (Map.get ("Name") + "" +map.get ("tel")); } }/*** Test from sentence * @Description:*/@Test Public voidTestfromclause () {String hql= "From Seller S"; Query Query=session.createquery (HQL); List<Seller> sellers =query.list (); for(Seller seller:sellers) {System.out.println ("Name:" +seller.getname ()); } } /*** Use list to pass inside parameters * @Description:*/@Test Public voidTestlistfromclause () {String hql= "Select New List (S.name,s.tel) from Seller S"; Query Query=session.createquery (HQL); List<List<Object>> list=query.list (); for(list<object>list2:list) { for(Object object:list2) {System.out.println (object); } } }/***//When the value here can only be one time in the collection of the list should be set to Object * @Description: Created is the role of the DISTINCT keyword * DISTINCT this keyword added to the inside can be removed duplicate content*/@Test Public voidtestlistfromdistict () {String hql= "SELECT Distinct c.sex from Customer as C"; Query Query=session.createquery (HQL); List<Object> list=query.list (); for(Object object:list) {System.out.println (object); }} @Before Public voidSetUp ()throwsException {Session=hibernatesessionfactory.getcurrentsession (); } @After Public voidTearDown ()throwsException {session.close (); }}
Select and from sentences in a HQL statement