HQL语句的练习！

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import po.Me;
public class Test {
public static void main(String[] args) {
Configuration cfg = new Configuration().configure("hibernate-cfg.xml");
SessionFactory sess = cfg.buildSessionFactory();// 都是先达成会话协议，然后开始会话！
Session session = sess.openSession();
Query query = session.createQuery("from Me");
List list = query.list();
for (int i = 0; i < list.size(); i++) {
Me m = (Me)list.get(i);
System.out.println(m.getName());
}
session.close();
sess.close();
}
}

[color=brown]select name ,zhiye from Me 情况下的练习；[/color]
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

import po.Me;

public class Test {

public static void main(String[] args) {
Configuration cfg = new Configuration().configure("hibernate-cfg.xml");
SessionFactory sess = cfg.buildSessionFactory();// 都是先达成会话协议，然后开始会话！
Session session = sess.openSession();
Query query = session.createQuery("select name ,zhiye from Me");
List list = query.list();
for (int i = 0; i < list.size(); i++) {
[color=darkblue] Object[] o = (Object[])list.get(i);[/color]
String io=(String)o[0];
String is=(String)o[1];
System.out.println(is);
System.out.println(io);
}
session.close();
sess.close();
}
}
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

import po.Me;

public class Test {

public static void main(String[] args) {
Configuration cfg = new Configuration().configure("hibernate-cfg.xml");
SessionFactory sess = cfg.buildSessionFactory();// 都是先达成会话协议，然后开始会话！
Session session = sess.openSession();
//Query query = session.createQuery("from Me where id>=1 and id<=2");
//Query query = session.createQuery("from Me where id between 1 and 2");
//Query query = session.createQuery("from Me where name is not null");
//Query query = session.createQuery("select count (*) ,m.zhiye from Me m group by zhiye");
Transaction ts= session.beginTransaction();
ts.begin();
// Query query = session.createQuery("update Me set name ='ttttttt' where id =3");
//Query query = session.createQuery("delete Me where id =3");\
/* query.executeUpdate();
ts.commit();*/
// Query query = session.createQuery("select name from Me order by id desc ");
Query query = session.createQuery("select count (name),avg(id),m. zhiye from Me m group by m. zhiye having avg(id) >=4");
List list = query.list();
for(int i= 0 ;i<list.size();i++){
Object[] a = (Object[]) list.get(i);
System.out.println( a[0]+" "+ a [1]+" "+ a[2]) ;
}
session.close();
sess.close();
// List list = query.list();
/*
* for (int i = 0; i < list.size(); i++) { Object [] a = (Object[])
* list.get(i); String name =(String) a[0]; System.out.println(name); }
*/
/*
* for(int i = 0 ; i<list.size();i++){ Object []a = (Object[])
* list.get(i);//对象数组；
*
* System.out.println(a[0]); }
*/
/* System.out.println(list); */
}
}
在delete ，update 的时候要用到事务！select 不用，sum() mix() min()count()avg();