日期:2016-7-19
内容: 使用HQL语句从数据库检索数据
1、使用HQL语句从数据库检索数据:在不带检索条件的情况下检索数据;
//使用HQL语句从数据库检索数据:不带任何检索条件
@Test
public void queryDataFromDataBaseNoCondition()
{
//加载Hibernate的配置对象
Configuration config = new Configuration().configure();
//创建服务注册对象
ServiceRegistry serviceRegistry = new ServiceRegistryBuilder().applySettings(config.getProperties()).buildServiceRegistry();
//创建sessionFactory
SessionFactory 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 complete
Hibernate:
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
完成数据检索记录操作。