/**

* HQL查詢的一個例子

*/

public static void hql()

{

Session s = null;

try

{

s = HibernateUtil.getSeesion();

//final String hql = "from User as u where u.name=?";

final String hql = "from User as u where u.name=:name";

final Query query = s.createQuery(hql);

//query.setString(0, "北京市"); //從0開始

query.setString("name", "北京市");

final List list = query.list();

for (final User u : list)

{

System.out.println(u.getName());

}

}

finally

{

if (s != null)

{

s.close();

}

}

System.out.println("HQL完成");

}

HibernateUtil工具類

package dao;

import org.hibernate.Session;

import org.hibernate.SessionFactory;

import org.hibernate.cfg.Configuration;

/**

* 這是一個工具類, 快速取得session

*

*/

public class HibernateUtil

{

static SessionFactory sessionFactory = null;

static

{

final Configuration cfg = new Configuration();

cfg.configure(); //路徑可以改變

sessionFactory = cfg.buildSessionFactory();

}

public static SessionFactory getSessionFactory()

{

return sessionFactory;

}

/**

* 取得session

*

* @return session

*/

public static Session getSeesion()

{

return sessionFactory.openSession();

}

}

/**

* HQL 分頁查詢

*/

public static void page()

{

Session s = null;

try

{

s = HibernateUtil.getSeesion();

final String hql = " from User "; //User是類名

final Query q = s.createQuery(hql);

q.setFirstResult(0); //從第0條開始

q.setMaxResults(10); //取出10條

final List list = q.list();

for (final User u : list)

{

System.out.println(u.getId() + " " + u.getName());

}

}

finally

{

s.clear();

}

}

分享到：

2009-02-28 10:30

瀏覽 10598

評論

1 樓

zzjess

2016-08-09

贊

?

?