1、初始数据
@Test public void test01() { Session session = null; try { session = HibernateUtil.getSessionFactory().openSession(); session.beginTransaction(); for (int i = 0; i < 100; i++) { book entity = new book(); entity.setBookCode("book-code-" + i); entity.setBookname("book-name" + i); entity.setPrice(i); session.save(entity); } session.getTransaction().commit(); } catch (HibernateException e) { e.printStackTrace(); } finally { if (session != null) session.close(); } }
2、查询对象
@Test public void test02() { Session session = null; // form 对象名 非 表名 String sql = " from book "; try { session = HibernateUtil.getSessionFactory().openSession(); Query query = session.createQuery(sql); List list = (List ) query.list(); for (book b : list) { System.out.println(b); } } catch (HibernateException e) { e.printStackTrace(); } finally { if (session != null) session.close(); } }
3、查询单字段
@Test public void test03() { /* * 查询单字段 */ Session session = null; String sql = " select bookname from book "; try { session = HibernateUtil.getSessionFactory().openSession(); Query query = session.createQuery(sql); List list = (List ) query.list(); for (String b : list) { System.out.println(b); } } catch (HibernateException e) { e.printStackTrace(); } finally { if (session != null) session.close(); } }
4、查询指定字段
@Test public void test04() { /* * 查询多字段,且指定条数Object[] */ Session session = null; String sql = " select bookname,bookCode from book "; try { session = HibernateUtil.getSessionFactory().openSession(); Query query = session.createQuery(sql); // 指定5条 query.setMaxResults(5); List list = (List ) query.list(); for (Object[] b : list) { System.out.println(b[0] + "," + b[1]); } } catch (HibernateException e) { e.printStackTrace(); } finally { if (session != null) session.close(); } }
5、返回Map对象
@Test public void test05() { /* * 查询多字段,且指定Map */ Session session = null; String sql = " select new Map(bookname,bookCode) from book "; try { session = HibernateUtil.getSessionFactory().openSession(); Query query = session.createQuery(sql); query.setMaxResults(5); List
6、序列化参数
6.1、
@Test public void test06() { Session session = null; String sql = " select bookname,bookCode from book where book_id>:book_id and price>:price"; try { session = HibernateUtil.getSessionFactory().openSession(); Query query = session.createQuery(sql); query.setInteger("book_id", 5); query.setDouble("price", 5); // Hibernate: select book0_.bookname as col_0_0_, book0_.bookCode as // col_1_0_ from t_book book0_ where book0_.book_id>? and // book0_.price>? List list = (List ) query.list(); for (Object[] b : list) { System.out.println(b[0] + "," + b[1]); } } catch (HibernateException e) { e.printStackTrace(); } finally { if (session != null) session.close(); } }
6.2、
@Test public void test07() { Session session = null; String sql = " select bookname,bookCode from book where book_id>:book_id and price>:price"; try { session = HibernateUtil.getSessionFactory().openSession(); Query query = session.createQuery(sql); query.setInteger(0, 5); query.setDouble(1, 5); // Hibernate: select book0_.bookname as col_0_0_, book0_.bookCode as // col_1_0_ from t_book book0_ where book0_.book_id>? and // book0_.price>? List list = (List ) query.list(); for (Object[] b : list) { System.out.println(b[0] + "," + b[1]); } } catch (HibernateException e) { e.printStackTrace(); } finally { if (session != null) session.close(); } }
7、执行SQL
@Test public void test08_jdbc() { Session session = null;//Rhythmk String sql = " select bookCode,bookname from t_book where book_id>? and price>?"; try { session = HibernateUtil.getSessionFactory().openSession(); SQLQuery query = session.createSQLQuery(sql); query.setInteger(0, 5); query.setDouble(1, 5); List list = (List ) query.list(); for (Object[] b : list) { System.out.println(b[0] + "," + b[1]); } } catch (HibernateException e) { e.printStackTrace(); } finally { if (session != null) session.close(); } }} http://pan.baidu.com/s/1hqGDNq0