Hibernate4学习笔记(三)： 使用HQL语句从数据库检索数据

日期：2016-7-19

内容： 使用HQL语句从数据库检索数据

1、使用HQL语句从数据库检索数据：在不带检索条件的情况下检索数据；

//使用HQL语句从数据库检索数据:不带任何检索条件@Testpublic void queryDataFromDataBaseNoCondition(){//加载Hibernate的配置对象Configuration config = new Configuration().configure();//创建服务注册对象ServiceRegistry serviceRegistry = new ServiceRegistryBuilder().applySettings(config.getProperties()).buildServiceRegistry();//创建sessionFactorySessionFactory sessionFactory = config.buildSessionFactory(serviceRegistry);//创建session对象Session session = sessionFactory.getCurrentSession();//创建事务对象(开启事务)Transaction tx = session.beginTransaction();//HQL语句String hql1 = "from Users";//检索数据Query query = session.createQuery(hql1);//执行检索List list = query.list();Iterator itor = list.listIterator();//循环打印检索出来的数据while(itor.hasNext()){Users users = (Users)itor.next();System.out.println("用户名: "+users.getUsername()+"   "+"密码: "+users.getPassword()+"\n");}}

2、检索结果显示：

INFO: HHH000232: Schema update completeHibernate:     select        users0_.id as id5_,        users0_.address as address5_,        users0_.birthday as birthday5_,        users0_.email as email5_,        users0_.password as password5_,        users0_.phone as phone5_,        users0_.sex as sex5_,        users0_.username as username5_     from        user_info users0_用户名: yuashanshan   密码: yuashanshan用户名: luoting   密码: luoting..123用户名: 刘德华   密码: liudehjua..123用户名: 张学友   密码: zhangxueyou用户名: feiyuqing   密码: feiyuqing..123用户名: wangbaoqiang   密码: wangbaoqiang..456

完成数据检索记录操作。