HQL的随笔记

最新推荐文章于 2025-08-22 13:08:41 发布

jiangxuchen

最新推荐文章于 2025-08-22 13:08:41 发布

阅读量617

点赞数

分类专栏： JavaEE 文章标签： string list dao

JavaEE 专栏收录该内容

35 篇文章

订阅专栏

  	@SuppressWarnings("unchecked")
	public void doService0401 () {

		TestDao dao = new TestDao();
		
		System.out.println("=================================================");

		List<Metadata> metadataList = dao.find("select new Metadata(id,metId) from Metadata");

		for (int i = 0; i < metadataList.size(); i++) {

			System.out.println(metadataList.get(i).getId());
			System.out.println(metadataList.get(i).getMetId());
			
		}
		
		System.out.println("=================================================");
		
		for(Metadata metadata : metadataList) {

			System.out.println((String)metadata.getId());   
			System.out.println((String)metadata.getMetId());   
		}
		
		System.out.println("=================================================");
		
		List<Map> metadatamapList = dao.find("select new map(id as id ,metId as metId) from Metadata");
		
		for (int i = 0; i < metadataList.size(); i++) {

			System.out.println(metadatamapList.get(i).get("id"));
			System.out.println(metadatamapList.get(i).get("metId"));
			
		}
		
		System.out.println("=================================================");
		
		List<List> metadataListList = dao.find("select new list(id,metId) from Metadata");
		
		for(List metadata : metadataListList) {

			System.out.println((String)metadata.get(0));   
			System.out.println((String)metadata.get(1));   
		}
		
		System.out.println("=================================================");
		
		Metadata pBean = new Metadata();
		pBean.setId("11");
		pBean.setMetId("22");
		List<Metadata> metadataList1 = dao.find("from Metadata as Metadata where id=:id and metId=:metId", pBean);
		
		for(Metadata metadata : metadataList1) {

			System.out.println((String)metadata.getId());   
			System.out.println((String)metadata.getMetId());   
		}
		
		System.out.println("=================================================");
		
		List<Metadata> metadataList2 = dao.find("from Metadata as Metadata where id=:id", "11", "id");
		
		for(Metadata metadata : metadataList2) {

			System.out.println((String)metadata.getId());   
			System.out.println((String)metadata.getMetId());   
		}
		
		System.out.println("=================================================");
		
		String [] pList = new String [2];
		String [] vList = new String [2];
		
		pList[0] = "id";
		pList[1] = "metId";
		
		vList[0] = "11";
		vList[1] = "22";	
		
		List<Metadata> metadataList3 = dao.find("from Metadata as Metadata where id=:id and metId=:metId", vList, pList);
		
		for(Metadata metadata : metadataList3) {

			System.out.println((String)metadata.getId());   
			System.out.println((String)metadata.getMetId());   
		}
		
		System.out.println("=================================================");
		
		ArrayList list = new ArrayList();
		
		list.add("11");
		list.add("22");
		
		List<Metadata> metadataList4 = dao.find("from Metadata as Metadata where id in (:id) ", list ,"id");
		
		for(Metadata metadata : metadataList4) {

			System.out.println((String)metadata.getId());   
			System.out.println((String)metadata.getMetId());   
		}
		
	}