hibernate3 动态查询，关联关系

大配置：

<?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="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
    <property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
    <property name="connection.username">scott</property>
    <property name="connection.password">1234</property>
    <!--SQL dialect SQL方言 缺少hibernate不行-->
    <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
        <!--在控制台打印sql-->
    <property name="show_sql">true</property>
    <!-- 自动构建表结构 如果是creat 先delete在创建 如果是update 自动更新表结构 -->
    <property name="hbm2ddl.auto">update</property>
       <!-- 关联小配置-->
        <!--<mapping resource="bdqn/entity/Cat.xml"/>
        <mapping resource="bdqn/entity/Dept.xml"/>-->
        <mapping resource="bdqn/entity/dynamic/Emp.xml"></mapping>
    </session-factory>
</hibernate-configuration>




案例要求：







小配置：
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"
        >

<!--native根据底层数据库做选着-->
<hibernate-mapping package="bdqn.entity.dynamic" >
    <class name="Emp" table="Emp" schema="scott" >
        <id name="empno" column="empno">
            <generator class="native"/>
        </id>
        <property name="ename"/>
        <property name="sal"/>
        <property name="job"/>
        <property name="mgr"/>
        <property name="deptno"/>
        <property name="comm"/>
        <property name="hiredate"/>
    </class>
</hibernate-mapping>

编写单测：

import bdqn.entity.dynamic.Emp;
import bdqn.entity.dynamic.viewmodel.Empcondition;
import bdqn.util.hibernateutil;
import org.hibernate.Hibernate;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.query.Query;
import org.junit.Before;
import org.junit.Test;

import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;


public class test03 {
    Configuration cfg;
    SessionFactory factory;
    Session session;
     Transaction tx;
     @Before
    public void show(){
         cfg=new Configuration().configure();
         factory=cfg.buildSessionFactory();
         session=factory.openSession();
         tx=session.beginTransaction();
     }
动态查询：
     @Test
    public void show2() throws Exception{
     String sql="from Emp where1==1";
         Empcondition conditon=new Empcondition();
         conditon.setSal(1000);
         conditon.setJob("CLERK");
         SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
         Date formdate=sdf.parse("1984-04-01");
         conditon.setFromhiredate(formdate);
         Date todate=sdf.parse("1985-09-09");
         conditon.setEndhiredate(todate);
         StringBuffer buffer=new StringBuffer();
         if (conditon.getJob()!=null){
             buffer.append(" and job=:job");
         }
         if (conditon.getSal()!=null){
             buffer.append(" and sal >:sal");
         }
         if (conditon.getFromhiredate()!=null){
             buffer.append(" and hiredate>=:hiredate");
         }
         if (conditon.getEndhiredate()!=null){
             buffer.append(" and hiredate<=:hiredate");
         }
         Query query=session.createQuery(buffer.toString());
         query.setProperties(conditon);
         List<Emp> list=query.list();
         for (Emp emp:list){
             System.out.println(emp.getEname());
         }
    }
    @Test
    public void show3(){
        String sql="from Emp order by empno";
        Query query=session.createQuery(sql);
        int pageIndex=2;
        int pageSize=3;
        query.setFirstResult((pageIndex-1)*pageSize);
        query.setMaxResults(pageSize);
        List<Emp> list=query.list();
        for (Emp emp:list){
            System.out.println(emp.getEname());
        }

    }

//多对一 关联关系 准备Emp，Dept   小配置
@Test
public void show4(){
    Emp emp=session.get(Emp.class,1);
    System.out.println(emp.getEmpname());
    System.out.println(emp.getDept().getDeptname());
}

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"
        >
<!--native根据底层数据库做选着-->
<hibernate-mapping package="bdqn.manytoone" >
    <class name="Dept" table="Dept"  schema="scott">
        <id name="deptno" column="deptno">
            <generator class="native"/>
        </id>
        <property name="deptname"/>
    </class>
</hibernate-mapping>

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"
        >
<!--native根据底层数据库做选着-->
<hibernate-mapping package="bdqn.manytoone" >
    <class name="Emp" table="Emp"  schema="scott">
        <id name="empno" column="empno">
            <generator class="native"/>
        </id>
        <property name="empname" column="EMPNO"/>
        <many-to-one name="dept" column="deptno" class="Dept"></many-to-one>
    </class>
</hibernate-mapping>

}

编写hibernate工具类：

package bdqn.util;

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

/**
 * hibernate工具类
 */
public class hibernateutil {
    private static ThreadLocal<Session> tl;
    private  static Configuration cfg;
    private static SessionFactory factory;
    static{
        tl=new ThreadLocal<Session>();
        cfg=new Configuration().configure();
        factory=cfg.buildSessionFactory();
    }
    public Session getSession(){
        //是否存在环境变量
        Session session=tl.get();
       //是否存在session
       if (session==null){
           session=factory.openSession();
           tl.set(session);
       }
        return session;
    }
}