JavaEE 之 Habernate

1.Habernate

　　a.定义：Hibernate是一个开放源代码的对象关系映射框架，它对JDBC进行了非常轻量级的对象封装，它将POJO（简单java对象，即javabean）与数据库表建立映射关系，是一个全自动的ORM框架

　　b.ORM：对象关系映射（Object Relation Mapping）

2.使用：

　　a.在SRC下建hibernate.cfg.xml

<?xml version='1.0' encoding='UTF-8'?>

<!DOCTYPE hibernate-configuration PUBLIC

          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"

          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

    <session-factory>

        <property name="connection.url">

            jdbc:mysql://localhost:3306/j116

        </property>

        <property name="connection.username">root</property>

        <property name="connection.password">admin</property>

        <property name="connection.driver_class">

            com.mysql.jdbc.Driver

        </property>

        <property name="dialect">

            org.hibernate.dialect.MySQLDialect

        </property>

        <property name="show_sql">true</property>

        <property name="format_sql">true</property>

        <mapping resource="com/wode/pojo/User.hbm.xml" />

    </session-factory>

</hibernate-configuration>

　　b.建User的映射配置User.hbm.xml

<?xml version="1.0" encoding="utf-8"?>

<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"

"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>

    <class name="com.wode.pojo.User" table="users">

        <id name="userId" column="user_id" type="integer">

            <generator class="native"></generator>

        </id>

        <property name="userName" column="user_name" type="string"></property>

        <property name="userPwd" column="user_pwd" type="string"></property>

        <property name="userType" column="user_type" type="int"></property>

    </class>

</hibernate-mapping>

　　c.使用

        User u=new User();

        u.setUserName("test");

        u.setUserPwd("test");

        u.setUserType(1);

        Configuration cfg=new Configuration();

        cfg.configure();//加载hibernateConfiguration

        ServiceRegistry registry=new ServiceRegistryBuilder().applySettings(cfg.getProperties()).buildServiceRegistry();

        SessionFactory factory=cfg.buildSessionFactory(registry);

        Session session=factory.openSession();

        Transaction tx=session.beginTransaction();

        session.save(u);

        tx.commit();

        session.close();

3.增删查改

　　a.增

session.save(u);

　　b.删

session.delete(u);    //需要设置User的Id

　　c.查

//方法一：hql

Query query = session.createQuery("from User");

List<User> list=query.list();

//方法二：sql

Query query =session.createSQLQuery("select * from users").addEntity(User.class);

List<User> list=query.list();

//方法三：单个对象

User u=(User) session.load(User.class, 1);//延迟加载

User u=(User) session.get(User.class, 1);

　　d.改

//方法一

User u = (User) session.get(User.class, 1);

u.setUserPwd("123456");

session.beginTransaction().commit();

//方法二（没set的属性将自动设为空，不建议使用）

User u = new User();

u.setUserId(1);

u.setUserPwd("123456");

session.update(u);

session.beginTransaction().commit();

4.查询拓展

　　a.分页查询

        Query query = session.createQuery("from User");

        //当前页

        int currentPage = 1;

        //一页多少条

        int pageSize = 5;

        query.setFirstResult((currentPage-1)*pageSize);

        query.setMaxResults(pageSize);

        List<User> list = query.list();

        for(User u : list){

            System.out.println(u.getUserName()+" "+u.getUserPwd());

        }

　　b.聚合函数

Query query=session.createQuery("select count(*) from Course");

　　c.模糊查询

//Query query = session.createQuery("from User u where u.userName like ?");

//query.setString(0, "%z%");

Query query = session.createQuery("from User u where u.userName like :name");

query.setString("name", "%z%");

List<User> list = query.list();

　　d.不用session的方式

Query query=session.createQuery("delete  Course c where c.courseName =wa ");

int =query.executeUpdate()

5.一对多

　　a.在Many方xml中配置　

<many-to-one name="dept" class="com.wode.entity.Dept" column="deptNo" lazy="false" fetch="join"/>

　　b.在One方xml中配置

<set name="emps"  lazy="false" fetch="join"  cascade="all">

            <key column="deptNo"></key>

            <one-to-many class="com.wode.entity.Emp"/>

</set>

　　c.级联添加

        Dept dept = new Dept();

        dept.setDeptNo(40);

        dept.setDname("销售部");

        dept.setLoc("红瓦寺");

        Emp emp = new Emp();

        emp.setEmpno(9527);

        emp.setEname("若湖");

        ...

        emp.setDept(dept);

        Emp emp2 = new Emp();

        emp2.setEmpno(9528);

        emp2.setEname("江瑕");

        ...

        emp2.setDept(dept);

        Set<Emp> emps = new HashSet<Emp>();

        emps.add(emp);

        emps.add(emp2);

        dept.setEmps(emps);

        session.save(dept);

        session.beginTransaction().commit();

　　d.级联删除

        Dept dept = (Dept) session.get(Dept.class, 40);

        session.delete(dept);

        session.beginTransaction().commit();

　　e.通过Dept删除某个Emp

        Dept dept = (Dept) session.get(Dept.class, 40);

        Set<Emp> emps = dept.getEmps();

        Iterator<Emp> it = emps.iterator();

        while(it.hasNext()){

            if(it.next().getEname().equals("江瑕")){

                it.remove();

            }

        }

        session.beginTransaction().commit();

　　f.查找所有的Dept以及所有Dept里面的Emp

        List<Dept> depts = session.createQuery("select distinct(d) from Dept d join fetch d.emps").list();

        for(Dept dept : depts){

            System.out.println(dept.getDname());

            for(Emp emp : dept.getEmps()){

                System.out.println(emp.getEname());

            }

        }

6.多对多

　　a.配置xml

     <set name="courses" table="t_s_fk">

            <key column="sId"></key>

            <many-to-many class="Course" column="cId"></many-to-many>

        </set>

　　b.添加（近增加相互之间的关系）

        Student stu = (Student) session.get(Student.class, 3);

        Course course1 = (Course) session.get(Course.class, 1);

        Course course2 = (Course) session.get(Course.class, 3);

        stu.getCourses().add(course1);

        stu.getCourses().add(course2);

        session.beginTransaction().commit();

　　c.通过科目名称查找选了这门课程的学生

        Course course = (Course) session.get(Course.class, 1);

        Set<Student> stus = course.getStus();

        for(Student stu : stus){

            System.out.println(stu.getStuName());

        }

7.注解方式

　　a.将 <mapping resource="com/wode/pojo/Emp.hbm.xml" /> 改为 <mapping class="com.wode.pojo.Emp" />

　　b.标注方法参考Spring Data JPA

8.二级缓存

　　a.在src下创建ehcache.xml

　　b.在hibernate.cfg.xml中配置

        <property name="cache.use_second_level_cache">true</property>

        <property name="cache.use_query_cache">true</property>

        <property name="hibernate.cache.region.factory_class">org.hibernate.cache.ehcache.EhCacheRegionFactory</property>

　　c. 在Bean的映射配置xml中配置

 <cache usage="read-only" region="sampleCache1"/>

　　d.若使用的是注解则加@注解

@Cache(usage = CacheConcurrencyStrategy.READ_ONLY)

9.Habernate在Spring中的使用

　　a.在web.xml及applicationContext.xml中配置相应配置

　　b.使用：

    @Autowired

    @Qualifier("sessionFactory")

    private SessionFactory sessionFactory;

    @Override

    public void addUser(User user) {

        // TODO Auto-generated method stub

        Session session = sessionFactory.getCurrentSession();

        session.save(user);

    }

巴特西

JavaEE 之 Habernate

最新文章

热门文章