有关Hibernate的查询

从连接数据库开始

    1.1写一个实体类：

package com.zking.entity;

import java.util.HashSet;
import java.util.Set;

public class Product {
        private int product_no;         
        private String product_name;        
        private int product_price;

        public Product(String product_name, int product_price) {
            super();
            this.product_name = product_name;
            this.product_price = product_price;
        }
        public Product() {
            super();
            // TODO Auto-generated constructor stub
        }

        public int getProduct_no() {
            return product_no;
        }
        public void setProduct_no(int product_no) {
            this.product_no = product_no;
        }
        public String getProduct_name() {
            return product_name;
        }
        public void setProduct_name(String product_name) {
            this.product_name = product_name;
        }
        public int getProduct_price() {
            return product_price;
        }
        public void setProduct_price(int product_price) {
            this.product_price = product_price;
        }       
}

1.2映射实体类和数据库建立关系：

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2017-8-23 13:41:33 by Hibernate Tools 3.5.0.Final -->
<hibernate-mapping>
    <class name="com.zking.entity.Product" table="PRODUCT">
        <id name="product_no" type="int">
            <column name="PRODUCT_NO" />
            <generator class="native" />
        </id>
        <property name="product_name" type="java.lang.String">
            <column name="PRODUCT_NAME" />
        </property>
        <property name="product_price" type="int">
            <column name="PRODUCT_PRICE" />
        </property>

    </class>
</hibernate-mapping>

1.3连接数据库

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.connection.password">123</property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/stu</property>
        <property name="hibernate.connection.username">root</property>

        <mapping resource="com/zking/entity/Product.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

1.4拿到session进行数据库的查询

package com.zking.util;

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

public class DBHerple {

    private  static Configuration configuration;
    private static SessionFactory factory;

    static{
         configuration=  new Configuration().configure();
          factory= configuration.buildSessionFactory();
    }

    public void setTransaction(TextTransaction transaction){
        Session  session= factory.openSession();
        Transaction action= session.beginTransaction();
        transaction.Transaction(session);
        action.commit();
        session.close();

    }

    public  static interface TextTransaction{
        public void Transaction(Session session);
    }
}

1.session.createQuery(“”) HQL查询

实现DBHerple 的方法进行查询：

package com.zking.text;

import java.util.List;

import org.hibernate.Session;
import org.junit.Test;

import com.zking.entity.Category;
import com.zking.entity.Product;
import com.zking.util.DBHerple;
import com.zking.util.DBHerple.TextTransaction;

public class OneManyTest {
            public void add(){
                 DBHerple dbHerple=new DBHerple();
                 dbHerple.setTransaction(new TextTransaction() {
                    public void Transaction(Session session) {
                    //对象导航查询 ：   可以查询其他数据库里和他有关的一切数据 （前提是他们建立了关系  我这里只写了一个类对象进行演示，暂时不能使用他请见谅）
                         /* List<Product> list=session.createQuery("from Product p where p.category.category_id=9").list();
                            for (Product product : list) {
                                System.out.println(product.getProduct_no()+"    /"+product.getProduct_name());
                            }*/
                    //查询这个数据库里的所有信息
                         /* List<Product> list=session.createQuery("from Product where product_name='ThinkPad X60'").list();
                            for (Product products : list) {
                                System.out.println(products.getCategory().getCategory_name());
                            }*/
                    //根据条件查询
                    /*List<Product> list=session.createQuery("from Product p where   product_price between 100 and 300 and p.category.category_name='电视盒'").list();
                        for (Product product : list) {
                            System.out.println(product.getProduct_name());
                        }*/
                    //添加
                    /*Product product=new Product("布娃娃", 688);
                        session.save(product);*/

                    //分页查询
                        int pageNo=2;
                        int pageSize=2;
                        List<Product > product=session.createQuery("from Product ").setFirstResult((pageNo-1)*pageSize).setMaxResults(pageSize).list();
                        for (Product products: product) {
                            System.out.println(products);
                        }
                   //查询某一列
                    List<String> names=session.createQuery("select product_name from Product ").list();
                    for (String string : names) {
                        System.out.println(string);
                    }
                  //构造查询
                    List<Product > product=session.createQuery("select new Product (product_name ,product_price) from Product ").list();
                    for (Product products: product) {
                        System.out.println(products);
                    }
            //聚合函数 (sum , count , max , age ,min).....还有其他肯多查询就不一一列出来了这些基本常用的就这些
    }
                });
            }
}

2.session.createCriteria() QBC查询 现在已经过时了，基本不用 简单的查询一下：

package com.zking.text;

import java.util.List;
import java.util.Set;

import org.hibernate.Session;
import org.junit.Test;

import com.zking.entity.Product;
import com.zking.entity.Supply;
import com.zking.util.DBHerple;
import com.zking.util.DBHerple.TextTransaction;

public class PartTwoTest {

            @Test
            public void parTest(){
                DBHerple dbHerple=new DBHerple();
                dbHerple.setTransaction(new TextTransaction() {
                    public void Transaction(Session session) {
                        //查询所有
                        session.createCriteria("类对象（所查询的那个对象）");
                    }
                });
            }
}

3.session.createSqlQuery() 原生态查询Hibernate本就是全封装重量集查询 这中方式在做项目当中都看不见