hibernate中HQL语句

淩亂°似流年 2022-07-24 07:29 206阅读 0赞

package test;
    
    import entity.Commodity;
    import entity.Customer;
    import entity.Seller;
    import org.hibernate.Query;
    import org.hibernate.Session;
    import org.hibernate.Transaction;
    import util.HibernateUtil;
    
    import java.util.List;
    import java.util.Map;
    
    /**
     * Created by raid on 2016/5/15.
     */
    public class SellerLogic {
    
        private Session session = null;
        private Transaction transaction = null;
    
        public SellerLogic() {
            session = HibernateUtil.getSession();
            transaction = session.beginTransaction();
        }
    
        /**
         * 查询所有
         */
        public void testSeller() {
            String hql = " from Seller";
            Query query = session.createQuery(hql);
            List<Seller> sellers = query.list();
            for (Seller seller : sellers) {
                System.out.println(seller);
            }
            transaction.commit();
        }
    
        /**
         * 使用别名
         */
        public void testSelectClauseObjectArray() {
            String hql = " select s.name,s.tel,s.address,s.star from Seller s ";
    
            Query query = session.createQuery(hql);
            List<Object[]> list = query.list();
            for (Object[] objs : list) {
                System.out.println("name:" + objs[0]);
                System.out.println("tel:" + objs[1]);
                System.out.println("address:" + objs[2]);
                System.out.println("star:" + objs[3]);
            }
        }
    
        /**
         * 查询记录使用List来包装
         */
        public void testSelectClauseList() {
            String hql = "select new list(s.name,s.tel,s.address) from Seller s ";
            Query query = session.createQuery(hql);
            List<List> lists = query.list();
            for (List list : lists) {
                System.out.println("name : " + list.get(0));
                System.out.println("tel : " + list.get(1));
                System.out.println("address : " + list.get(2));
            }
            transaction.commit();
        }
    
        /**
         * 查询记录使用map来表示
         */
        public void testSelectClauseMap() {
            String hql = "select new map(s.name as name,s.tel as tel,s.address as address) from Seller s ";
            Query query = session.createQuery(hql);
            List<Map<String, Object>> maps = query.list();
            for (Map<String, Object> map : maps) {
                System.out.println("name:" + map.get("name"));
                System.out.println("tel:" + map.get("tel"));
                System.out.println("address:" + map.get("address"));
            }
        }
    
        /**
         * 查询记录使用本身对象来表示，这里要注意的是对象必须有这样的构造方法
         */
        public void testSelectClauseSelf() {
            String hql = "select new Seller(s.name,s.tel,s.address) from Seller s ";
            Query query = session.createQuery(hql);
            List<Seller> sellers = query.list();
            for (Seller seller : sellers) {
                System.out.println("name:" + seller.getName());
                System.out.println("tel:" + seller.getTel());
                System.out.println("address:" + seller.getAddress());
            }
    
        }
    
        /**
         * 查询独一无二
         */
        public void testDistinct() {
            String hql = "select distinct c.sex from Customer c";
            Query query = session.createQuery(hql);
            List<Object> list = query.list();
            for (Object obj : list) {
                System.out.println(obj);
            }
        }
    
        /**
         * 条件查询
         */
        public void testWhere1() {
            String hql = " from Commodity c where c.price>400";
            Query query = session.createQuery(hql);
            List<Commodity> commodities = query.list();
            for (Commodity c : commodities) {
                System.out.println("name:" + c.getName());
                System.out.println("price:" + c.getPrice());
            }
        }
    
        /**
         * 条件查询
         */
        public void testWhere2() {
            String hql = " from Commodity c where c.description <> null "; //<> 为不是null,如果是is那么就是null
            Query query = session.createQuery(hql);
            List<Commodity> commodities = query.list();
            for (Commodity c : commodities) {
                System.out.println("name:" + c.getName());
                System.out.println("description:" + c.getDescription());
            }
        }
    
        public void testWhere3() {
            String hql = " from Customer c where c.age not in(20,40)"; //in表示在范围内，not in表示不在范围内
            Query query = session.createQuery(hql);
            List<Customer> customers = query.list();
            for (Customer customer : customers) {
                System.out.println("name:" + customer.getName());
                System.out.println("age:" + customer.getAge());
            }
        }
    
        /**
         * 条件查询
         */
        public void testWhere4() {
            String hql = " from Customer c where c.age not between 20 and 40";
            Query query = session.createQuery(hql);
            List<Customer> customers = query.list();
            for (Customer customer : customers) {
                System.out.println("name:" + customer.getName());
                System.out.println("age:" + customer.getAge());
            }
        }
    
        /**
         * 模糊查询
         */
        public void testWhere5() {
            String hql = " from Customer c where c.name like '张_'";
            Query query = session.createQuery(hql);
            List<Customer> customers = query.list();
            for (Customer customer : customers) {
                System.out.println("name:" + customer.getName());
                System.out.println("age:" + customer.getAge());
            }
        }
    
        /**
         * 查询一条记录
         */
        public void testWhere6() {
            String hql = " from Customer c where c.name = '张三'";
            Query query = session.createQuery(hql);
            Customer c = (Customer) query.uniqueResult();
            System.out.println(c.getName());
        }
    
    }