Hibernate的查询语句



查询对象1中的用户名 ，查询属性
@Test
public void testQueryUser1(){
// TODO Auto-generated method stub
SessionFactory sf = null;
Session session = null;
Transaction ts = null;
try {
  sf = HibernateUtil.getSessionFactory();
session = sf.getCurrentSession();
ts = session.beginTransaction();
Query query = session.createQuery("select u1.username from User u1");
List usernames = query.list();
for(int i=0;i<usernames.size();i++)
{
String username =(String)usernames.get(i);
System.out.println(i+"--"+username);
}
ts.commit();
} catch (HibernateException e) {
// TODO Auto-generated catch block
if(ts != null)
{
ts.rollback();
}
e.printStackTrace();
}
}
//查询2   简单查询
@Test
public void testQueryUser2(){
// TODO Auto-generated method stub
SessionFactory sf = null;
Session session = null;
Transaction ts = null;
try {
  sf = HibernateUtil.getSessionFactory();
session = sf.getCurrentSession();
ts = session.beginTransaction();
Query query = session.createQuery("from User");
List users = query.list();
for(int i=0;i<users.size();i++)
{
User user =(User)users.get(i);
System.out.println(i+"--"+user);
}


ts.commit();
} catch (HibernateException e) {
// TODO Auto-generated catch block
if(ts != null)
{
ts.rollback();
}
e.printStackTrace();
}
}
//实例化查询
@Test
public void testQueryUser3(){
// TODO Auto-generated method stub
SessionFactory sf = null;
Session session = null;
Transaction ts = null;
try {
  sf = HibernateUtil.getSessionFactory();
session = sf.getCurrentSession();
ts = session.beginTransaction();
Query query = session.createQuery("select new User(u.username,u.password) from User as u");
    List<User> users=query.list();
    for (User user : users) {
System.out.println(user.getUsername()+"的密码是："+user.getPassword());
}
  /*  for(int i=0;i<users.size();i++)
    {
User user =(User)users.get(i);
System.out.println(user.getUsername()+"的密码为:"+user.getPassword());
   }
*/
ts.commit();
} catch (HibernateException e) {
// TODO Auto-generated catch block
if(ts != null)
{
ts.rollback();
}
e.printStackTrace();
}
}
//子查询
@Test
public void testQueryUser4(){
// TODO Auto-generated method stub
SessionFactory sf = null;
Session session = null;
Transaction ts = null;
try {
  sf = HibernateUtil.getSessionFactory();
session = sf.getCurrentSession();
ts = session.beginTransaction();
Query query = session.createQuery("from User u where u.username='ddd'");
List users = query.list();
for(int i=0;i<users.size();i++)
{
User user =(User)users.get(i);
System.out.println(user.getUsername()+"的密码为:"+user.getPassword());
}
ts.commit();
} catch (HibernateException e) {
// TODO Auto-generated catch block
if(ts != null)
{
ts.rollback();
}
e.printStackTrace();
}
}
//统计查询
@Test
public void testQueryUser5(){
// TODO Auto-generated method stub
SessionFactory sf = null;
Session session = null;
Transaction ts = null;
try {
  sf = HibernateUtil.getSessionFactory();
session = sf.getCurrentSession();
ts = session.beginTransaction();
Query query = session.createQuery("select avg(u.age) from User u");
Number average =(Number)query.uniqueResult();
System.out.println("平均年龄为："+average);
ts.commit();
} catch (HibernateException e) {
// TODO Auto-generated catch block
if(ts != null)
{
ts.rollback();
}
e.printStackTrace();
}
}