hibernate3学习笔记(九) Query及HQL - 编程入门网

hibernate3学习笔记(九) Query及HQL

示例代码如下：

1.package com.hb3.pack_01;2.3.import java.util.Iterator;4.import java.util.List;5.
6.import org.hibernate.Query;7.import org.hibernate.Session;8.import org.hibernate.SessionFactory;9.import org.hibernate.Transaction;10.import org.hibernate.cfg.Configuration;11.
12.import com.hb3.pack_01.model.User;13.import com.hb3.pack_01.model.UserBak;14.
15.public class BusinessService {16.
17.    public static void main(String[] args) {18.19.        Configuration config = new Configuration().configure();20.        SessionFactory sessionFactory = config.buildSessionFactory();21.        Session session = sessionFactory.openSession();22.23.        Query query = session.createQuery("from com.hb3.pack_01.model.User user order by user.age desc, user.name");//[== from User]
24.        printUserInfo(query.list());25.26.        query = session.createQuery("select new com.hb3.pack_01.model.UserBak(user.name, user.age) from User as user");27.        Iterator<?> iterator = query.list().iterator();28.        System.out.println("class_name \t\t name/age");29.        while (iterator.hasNext()) {30.            UserBak userbak = (UserBak) iterator.next();31.            System.out.println(userbak.getClz() + " \t " + userbak.getName() + "/" + userbak.getAge());32.        }33.34.        query = session.createQuery("select upper(user.name) from User as user where (user.age/2 >= ?) and (user.age is not null)");35.        query.setInteger(0, 13);36.        List<?> names = query.list();37.        iterator =  names.iterator();38.        while(iterator.hasNext()) {39.            System.out.println(iterator.next());40.        }41.42.        query = session.createQuery("select user.name, user.age from User as user where user.age > :minAge");43.        query.setInteger("minAge", 25);44.        names = query.list();45.        iterator =  names.iterator();46.        while(iterator.hasNext()) {47.            Object[] obj = (Object[]) iterator.next();48.            System.out.println(obj[0] + "\t" + obj[1]);49.        }50.51.        query = session.getNamedQuery("com.hb3.pack_01.model.User.QueryUser");52.        query.setInteger("minAge", 25);53.        printUserInfo(query.list());54.55.        Transaction tx= session.beginTransaction();56.        query = session.createQuery("update User set age=24 where name=''chenyan''");57.        query.executeUpdate();58.        tx.commit();59.
60.        tx= session.beginTransaction();61.        query = session.createQuery("delete User where name=''yaobin''");62.        query.executeUpdate();63.        tx.commit();64.65.        session.close();66.        sessionFactory.close();67.    }68.69.    public static void printUserInfo(List<?> users){70.71.        Iterator<?> iterator = users.iterator();72.       

凌众科技专业提供服务器租用、服务器托管、企业邮局、虚拟主机等服务，公司网站：http://www.lingzhong.cn 为了给广大客户了解更多的技术信息，本技术文章收集来源于网络,凌众科技尊重文章作者的版权，如果有涉及你的版权有必要删除你的文章，请和我们联系。以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢!