hibernate 简单复习

log.error("你妹！");
		Session session = HibernateUtil.currentSession();
		BookInfo bookInfo = (BookInfo) session.get(BookInfo.class, 74);
		System.out.println("get=>" + bookInfo.getBookAnthor());


		BookInfo bookInfoLoad = (BookInfo) session.load(BookInfo.class, 74);
		System.out.println("load=>" + bookInfoLoad.getBookAnthor());


		BookInfo bookInfoGet = (BookInfo) session.get(BookInfo.class, 74);
		System.out.println("在get=>" + bookInfoGet.getBookAnthor());


		// ++++++++++++++++++++++++++++++++++++++++++++++++++++
		session.clear();
		BookInfo bookInfoLoadTwo = (BookInfo) session.load(BookInfo.class, 74);
		System.out.println("session.clear();在load=>"
				+ bookInfoLoadTwo.getBookAnthor());


		BookInfo bookInfoGetTwo = (BookInfo) session.get(BookInfo.class, 74);
		System.out.println("session.clear();在get=>"
				+ bookInfoGetTwo.getBookAnthor());


		// +++++++++++++++++++++++++++++++++++++++++++++++++++
		java.util.List<BookInfo> list = session.createQuery(
				"From BookInfo as bookInfo").list();
		System.out.println("createQuery:" + list.size());


		// many to one
		BookInfo bookInfoLoadManyToOne = (BookInfo) session.load(
				BookInfo.class, 74);
		System.out.println("ManyToOne;在load=>"
				+ bookInfoLoadManyToOne.getBookCategory().getName());


		// BookCategory
		// BookCategory bookCategory=(BookCategory)
		// session.get(BookCategory.class,
		// bookInfoLoadManyToOne.getBookCategory().getId());
		// System.out.println("BookCategory;get=>"+bookCategory.getBookInfos().size());


		// Depatment


		Department department = new Department();


		System.out.println(UUID.randomUUID().toString());


		Transaction transaction = session.beginTransaction();
		transaction.begin();
		// department.setObjectId(UUID.randomUUID().toString());
		department.setName("部门01");


		HashSet<Department> set = new HashSet<Department>();
		Department department2 = new Department();
		department2.setpDepartment(department);
		department2.setName("子部门01");
		// department2.setObjectId(UUID.randomUUID().toString());
		set.add(department2);


		department.setDepartments(set);
		session.save(department);
		session.flush();
		transaction.commit();


		// 列表查询
		// String hql="from BookInfo as book where book.bookName=:name";
		// Query query=session.createQuery(hql);
		// query.setString("name", "aa");
		// List<BookInfo> bookInfos=query.list();
		// for (BookInfo info : bookInfos) {
		// System.out.println(info.getBookName());
		// }


		String hql = "from BookInfo as book where book.bookName=?";
		Query query = session.createQuery(hql);
		query.setString(0, "aa");
		List<BookInfo> bookInfos = query.list();
		for (BookInfo info : bookInfos) {
			System.out.println(info.getBookName());
		}


		Criteria criteria = session.createCriteria(BookInfo.class);
		// criteria.add(Restrictions.eq("bookName", "放风筝的人"));// eq:= gt > lt <
		// or // 或
		criteria.add(Restrictions.like("bookName", "%%"));


		List<BookInfo> bookInfos2 = criteria.list();
		for (BookInfo bookInfo2 : bookInfos2) {
			System.out.println(bookInfo2.getBookName());
		}


		// 动态分离查询 分离业务和DAO
		DetachedCriteria detachedCriteria = DetachedCriteria
				.forClass(BookInfo.class);
		detachedCriteria.add(Restrictions.like("bookName", "%%"));
		Criteria criteria2 = detachedCriteria.getExecutableCriteria(session);
		List<BookInfo> bookInfos3 = criteria2.list();
		for (BookInfo bookInfo2 : bookInfos3) {
			System.out.println(bookInfo2.getBookName());
		}


		BookInfo bookInfo2 = new BookInfo();
		bookInfo2.setBookName("情商");
		// 例子查询
		List<BookInfo> bookInfos4 = session.createCriteria(BookInfo.class)
				.add(Example.create(bookInfo2)).list();
		for (BookInfo demo : bookInfos4) {
			System.out.println(demo.getBookName());
		}
		
		//sql查询
		Query query2=session.createSQLQuery("select * from BookInfo").addEntity(BookInfo.class);
		List<BookInfo> bookInfos5=query2.list();
		for (BookInfo demo : bookInfos5) {
			System.out.println(demo.getBookName());
		}
		
		//分页查询
		Query query3= session.createQuery("from BookInfo");
		query3.setMaxResults(8);//设置一页多少数据
		query3.setFirstResult(0);
		List<BookInfo> bookInfos6=query3.list();
		for (BookInfo bookInfo3 : bookInfos6) {
			System.out.println(bookInfo3.getBookAnthor());
		}
		Query query4= session.createQuery("select count(*) from BookInfo");
	 Object object=	query4.uniqueResult();
		System.out.println(object.toString());