hibernate部分问题总结

最新推荐文章于 2019-09-06 13:48:22 发布
最新推荐文章于 2019-09-06 13:48:22 发布
阅读量450 收藏
点赞数
分类专栏： hibernate
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wenzhihui_2010/article/details/9364691
版权
   /**  使用 Query.executeUpdate() 缓存中数据不同步 解决办法
     *  Table -> T1oo(id,name)
     * Table -> T2oo(id,avg,aid)
     * 外键 T1oo.id->T2oo.aid
     *  Session.createQuery("delete T1oo") ->  Query.executeUpdate() 
     */
     public  void testExecuteUpdate(){
        System.out.println( " \r\n\r\n********************ExecuteUpdate************************ " );
        T1oo t1oo  =   new  T1oo();
        t1oo.setName( " liukaiyi " );
        
        HibernateSessionFactory.closeSession();
        
        Session session  =  HibernateSessionFactory.currentSession();
    Transaction tr1  =  session.beginTransaction();
         // t1 成为 持久状态 一级缓存中 加载
        session.saveOrUpdate(t1oo); 
         // 直接一条语句删除T1oo，缓存无法同步
         // 一级缓存中还有 t1
        Query qu  =  session.createQuery( " delete T1oo " );
         try  {
            qu.executeUpdate();
        }  catch  (Exception e) {    
            System.out.println( " //err: 有级联 单使用 delete T1oo 还要delete T2oo.aid = T1oo.id// " );
            List list  =  session.createQuery( " from T1oo " ).list();
             for (Iterator it = list.iterator();it.hasNext();){
                Query t2qu  =  session.createQuery( " delete T2oo  where aid=:id " );
                t2qu.setInteger( " id " , ((T1oo)it.next()).getId().intValue());
                t2qu.executeUpdate();                
            }
            qu.executeUpdate();
        }
        
        tr1.commit();
        
    Transaction tr2  =  session.beginTransaction();
         // 这直接通过一级缓存中加载t2，但DB中以没有此条数据
        t1oo  =  (T1oo)session.load(T1oo. class ,t1oo.getId());
        t1oo.setName( " google " );
         try  {
            tr2.commit();    
        }  catch  (Exception e) {
            System.out.println( " //err: update(t1oo)->DB 中数据库中没有 t1oo // ");
        }
        

        System.out.println( "  一级缓存清空前  " +  session.get(T1oo. class ,t1oo.getId()) );
        session.evict(t1oo);
        System.out.println( "  一级缓存清空后  " +  session.get(T1oo. class ,t1oo.getId()) );
        
         // 不把t1oo id 为空，否则当在saveOrUpdate时候就会以为是游离态 update了
        t1oo.setId( null );
         // id=null insert 调用
        session.saveOrUpdate(t1oo);        
        tr2.commit();
        
    Transaction tr3  =  session.beginTransaction();
        session.delete(t1oo);
        tr3.commit();
        
        session.close();
        HibernateSessionFactory.closeSession();
        
    }
结果是：
********************ExecuteUpdate************************
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: delete from t1oo
//err: 有级联 单使用 delete T1oo 还要delete T2oo.aid = T1oo.id//
Hibernate: select t1oo0_.id as id, t1oo0_.name as name0_ from t1oo t1oo0_
Hibernate: delete from t2oo where aid=?
Hibernate: delete from t2oo where aid=?
Hibernate: delete from t2oo where aid=?
Hibernate: delete from t1oo
Hibernate: update t1oo set name=? where id=?
//err: update(t1oo)->DB 中数据库中没有 t1oo //
 一级缓存清空前 hbn.bean.T1oo@287
Hibernate: select t1oo0_.id as id0_, t1oo0_.name as name0_0_ from t1oo t1oo0_ where t1oo0_.id=?
 一级缓存清空后 null
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: delete from t1oo where id=?
 
Get Load 区别 ：

 /** Get Load 区别 (在commit前要 session.flush())
     * Table -> T1oo(id,name)
     * 1.如果未能发现符合条件的记录，get方法返回null，而load方法会抛出异常
     * 2.Load方法可返回实体的代理类实例，而get方法永远直接返回实体类。
     * 3.load方法可以充分利用内部缓存和二级缓存中的现有数据，而get方法则仅仅在内部缓存中进行数据查找，
     *             如没有发现对应数据，将越过二级缓存，直接调用SQL完成数据读取。
     */
    public void testGetLoad() throws Exception {
        System.out.println("\r\n\r\n********************Get<>Load************************");
        Session session = HibernateSessionFactory.currentSession();
    //  数据准备
        T1oo t1oo = new T1oo();
        t1oo.setName("liu");
    Transaction t1 = session.beginTransaction();
        session.saveOrUpdate(t1oo);
        // 为什么这会错？
        //session.evict(t1oo);
        //session.flush();
        t1.commit();
        session.evict(t1oo);
   
    Transaction t2 = session.beginTransaction();
        System.out.println("一级缓存是否有t1oo(load)->"+session.contains(t1oo));
        //这时候t1oo为 CGlib生成的代理类
        t1oo = (T1oo)session.load(T1oo.class,t1oo.getId());
        System.out.println(" 延迟加载出现：select.. t1oo0_.id=? 表的其他属性加载 ");
        t1oo.setName("load list");
        //后在 update
        t2.commit();
        session.evict(t1oo);
       
    Transaction t3 = session.beginTransaction();
        System.out.println("一级缓存是否有t1oo(get)->"+session.contains(t1oo));
        //这时候t1oo为 CGlib生成的代理类
        t1oo = (T1oo)session.get(T1oo.class,t1oo.getId());
        System.out.println(" 没有延迟加载出现");
        t1oo.setName("get list");
        //后在 update
        t3.commit();   
        session.evict(t1oo);
       
    Transaction tr3 = session.beginTransaction();
        session.delete(t1oo);
        tr3.commit();
       
        session.close();
        HibernateSessionFactory.closeSession();
       
    }
结果
********************Get<>Load************************
Hibernate: insert into t1oo (name, id) values (?, ?)
一级缓存是否有t1oo(load)->false
 延迟加载出现：select.. t1oo0_.id=? 表的其他属性加载
Hibernate: select t1oo0_.id as id0_, t1oo0_.name as name0_0_ from t1oo t1oo0_ where t1oo0_.id=?
Hibernate: update t1oo set name=? where id=?
一级缓存是否有t1oo(get)->false
Hibernate: select t1oo0_.id as id0_, t1oo0_.name as name0_0_ from t1oo t1oo0_ where t1oo0_.id=?
 没有延迟加载出现
Hibernate: update t1oo set name=? where id=?
Hibernate: select t2ooset0_.aid as aid1_, t2ooset0_.id as id1_, t2ooset0_.id as id0_, t2ooset0_.avg as avg1_0_, t2ooset0_.aid as aid1_0_ from t2oo t2ooset0_ where t2ooset0_.aid=?
Hibernate: delete from t1oo where id=?

Set 集合的识别：
    /** Set 集合的识别
     * Table -> T1oo(id,name)
     * Table -> T2oo(id,avg,aid)
     * 外键 T1oo.id->T2oo.aid
     * T1oo  <set name="t2ooSet" inverse="false" cascade = "all"  >
     * T2oo  <many-to-one name="t1oo" column="aid" class="T1oo" />
     * cascade='insert' 是一定要的
     *     当 T1oo没有 inverse="true" 主动权的时候，要双项关联
     *     t1oo.getT2ooSet().add(t2oo1);
     *    t1oo.getT2ooSet().add(t2oo2);
     *    t2oo1.setT1oo(t1oo);
     *    t2oo2.setT1oo(t1oo);
     *  要不后sql为：
     *  Hibernate: insert into t2oo (avg, aid, id) values (?, ?, ?)
     *    Hibernate: insert into t2oo (avg, aid, id) values (?, ?, ?)
     *    +----+-----+------+
     *    | id | avg | aid  |
     *    +----+-----+------+
     *    |  1 |  24 | NULL |
     *    |  2 |  23 | NULL |
     *    +----+-----+------+
     *    当 T1oo有 inverse="false"主动权的时候
     *  t1oo.getT2ooSet().add(t2oo1);
     *    t1oo.getT2ooSet().add(t2oo2);
     *  Sql语句为：
     *  Hibernate: insert into t1oo (name, id) values (?, ?)
     *    Hibernate: insert into t2oo (avg, aid, id) values (?, ?, ?)
     *    Hibernate: insert into t2oo (avg, aid, id) values (?, ?, ?)
     *    Hibernate: update t2oo set aid=? where id=?
     *    Hibernate: update t2oo set aid=? where id=?
     *    |  3 |  24 |   12 |
     *    |  4 |  23 |   12 |
     *    +----+-----+------+
    */
    public void testSet(){
        System.out.println("\r\n\r\n********************Set************************");
        T1oo t1oo = new T1oo();
        t1oo.setName("list");
       
        T2oo t2oo1 = new T2oo(); t2oo1.setAvg(new Integer(23));
        T2oo t2oo2 = new T2oo(); t2oo2.setAvg(new Integer(24));
       
       
        Session session = HibernateSessionFactory.currentSession();
        Transaction tr1 = session.beginTransaction();
        session.save(t1oo);
        t1oo = (T1oo) session.load(T1oo.class,t1oo.getId());
        t1oo.setT2ooSet(new HashSet()) ;
        t1oo.getT2ooSet().add(t2oo1);
        t1oo.getT2ooSet().add(t2oo2);
        
        System.out.println( t1oo.getT2ooSet().size()+"" );       
        tr1.commit();
       
        System.out.println();
        T2oo t2oo3 = new T2oo(); t2oo3.setAvg(new Integer(25));
        T1oo t1oo2 = new T1oo(); t1oo2.setName("mz");
        t2oo3.setT1oo(t1oo2);
       
        Transaction tr2 = session.beginTransaction();
        session.save(t2oo3);
        try {
            tr2.commit();   
        } catch (Exception e) {
            System.out.println("//err: 没有主动权 cascade = 'all' 不可以级联save t1oo   //");
        }
        session.close();
        HibernateSessionFactory.closeSession();
    }
   
结果是：
********************Set************************
2
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: insert into t2oo (avg, aid, id) values (?, ?, ?)
Hibernate: insert into t2oo (avg, aid, id) values (?, ?, ?)
Hibernate: update t2oo set aid=? where id=?
Hibernate: update t2oo set aid=? where id=?
//err: 没有主动权 cascade = 'all' 不可以级联save t1oo   //

inverse 使用
说明约定-如：
1.表属性 :T1oo->id,name
          T2oo->id,avg,aid( 外键 ),version
2.代码过程是：Save->t1oo对象(T1oo 外键 T2oo)
        T1oo t1oo = new T1oo();
        t1oo.setName("xx");       
        t1oo.setT2ooSet(new HashSet());
        T2oo t2oo2 = new T2oo(24);
        //t2oo2.setT1oo(t1oo); (在下面的本用例表中的第3属性 )
        t1oo.getT2ooSet().add(t2oo2); (在下面的本用例表中的第2属性 )
        session.save(t1oo);
3.本例表使用：
T1oo.hbm.xml ->
        <set name="t2ooSet" inverse="true" cascade = "all"  > (在下面的本用例表中的第1，2属性 )
            <key column="aid"/>
            <one-to-many class="T2oo"/>
        </set>
T2oo.hbm.xml ->
        <many-to-one name="t1oo" column="aid"  class="T1oo" cascade="all" /> (在下面的本用例表中的第1，2属性 )
结合上面说明得表为：
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  | all   |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+
4.执行 Hibernate语句 ：
    Hibernate: insert into t1oo (name, id) values (?, ?)
    Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
5.结果为：
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  2 |  24 | NULL |       0 | //主要就是看 aid属性
+----+-----+------+---------+
1 row in set (0.00 sec)

mysql> select * from t1oo; // 因为 T1oo总是可以 Save 下面就不再提了
+----+------+
| id | name |
+----+------+
|  2 | xx   |
+----+------+
1 row in set (0.00 sec)
可改项：
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | 可改4 | 可改2  |          |          |
+-------+-------+-------+           |   可改1  |
| t2oo  |       | 可改3 |           |          |
+-------+-------+-------+----------+----------+
 
主本:
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  | all   |          |          |
+-------+-------+-------+  true    |  true    |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  1 |  24 |    1 |       0 |
+----+-----+------+---------+
1 row in set (0.00 sec)

改1
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  | all   |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  1 |  24 | NULL|       0 |
+----+-----+------+---------+
1 row in set (0.00 sec)
改2
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  |       |          |          |
+-------+-------+-------+  true    |  true    |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Empty set (0.00 sec)
改2  改1
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  |       |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Empty set (0.00 sec)

改3
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  | all   |          |          |
+-------+-------+-------+  true    |  true    |
| t2oo  |       |       |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  1 |  24 |    1 |       0 |
+----+-----+------+---------+
1 row in set (0.00 sec)
改3 改2
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  |       |          |          |
+-------+-------+-------+  true    |  true    |
| t2oo  |       |       |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Empty set (0.00 sec)

改3 改1
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  | all   |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       |       |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  1 |  24 | NULL |       0 |
+----+-----+------+---------+
1 row in set (0.00 sec)
改3 改2 改1
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  |       |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       |       |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Empty set (0.00 sec)
改4
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | false | all   |          |          |
+-------+-------+-------+  true    |  true    |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
Hibernate: update t2oo set aid=? where id=?
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  1 |  24 |    1 |       0 |
+----+-----+------+---------+
1 row in set (0.02 sec)
改4 改1
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | false | all   |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
Hibernate: update t2oo set aid=? where id=?
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  1 |  24 |    1 |       0 |
+----+-----+------+---------+
1 row in set (0.00 sec)
改4 改2
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | false |       |          |          |
+-------+-------+-------+  true    |  true    |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: update t2oo set aid=? where id=?
Empty set (0.00 sec)
改4 改3
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | false | all   |          |          |
+-------+-------+-------+  true    |  true    |
| t2oo  |       |       |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
Hibernate: update t2oo set aid=? where id=?
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  1 |  24 |    1 |       0 |
+----+-----+------+---------+
1 row in set (0.00 sec)
改4 改3 改2
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | false |       |          |          |
+-------+-------+-------+  true    |  true    |
| t2oo  |       |       |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: update t2oo set aid=? where id=?
Empty set (0.00 sec)
改4 改1 改2
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | false |       |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: update t2oo set aid=? where id=?
Empty set (0.00 sec)

改4 改1 改3
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | false |  all  |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       |       |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
Hibernate: update t2oo set aid=? where id=?
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  1 |  24 |    1 |       0 |
+----+-----+------+---------+
1 row in set (0.02 sec)
改4 改3 改2 改1
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | false |       |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       |       |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: update t2oo set aid=? where id=?
Empty set (0.00 sec)

环境:
     private  SessionFactory sessionFactory;
     protected   void  setUp()  throws  Exception {
         super .setUp();
         // 利用java反射得到 HibernateSessionFactory ->
         // private  static org.hibernate.SessionFactory sessionFactory;
         // 要模拟 并发 要 HibernateSessionFactory 得出的 有 threadLocal 不行
         // 要 
        HibernateSessionFactory.currentSession();
        HibernateSessionFactory.closeSession();
        Field field  =  HibernateSessionFactory. class .getDeclaredField( " sessionFactory " );
        field.setAccessible( true );
        sessionFactory  =  (SessionFactory) field.get(HibernateSessionFactory. class );
    }
     protected   void  tearDown()  throws  Exception {
         super .tearDown();
    }
悲观锁:
     /**  悲观锁问题 线程模拟 并发
     * Table -> T1oo(id,name)
     *     +----+------+
     *    | id | name |
     *    +----+------+
     *    |  4 | xx1  |
     *    +----+------+
      */
     public   void  ctestLock()  throws  Exception {
         //  insert test Data 测试数据
        Session seInsert  =  sessionFactory.openSession();
        Transaction tr  =  seInsert.beginTransaction();
        T1oo testUse  =  testUse  =   new  T1oo();
        testUse.setName( " liukaiyi_test " );
        seInsert.save(testUse);
        tr.commit();
        System.out.println(  " **************Test Use Bean : insert******************* "  );
        seInsert.close();
        Integer testId  =  testUse.getId();
       
        //并发模拟
        Session session1  =  sessionFactory.openSession();
        Session session2  =  sessionFactory.openSession();
       
         final  Transaction tr1  =  session1.beginTransaction();
        Transaction tr2  =  session2.beginTransaction();
       
        Query qu1  =  session1.createQuery( "  from T1oo t1oo where t1oo.name='liukaiyi_test' " );
        Query qu2  =  session2.createQuery( "  from T1oo t1oo where t1oo.name='liukaiyi_test' " );
       
        //加悲观锁
        qu1.setLockMode( " t1oo " ,LockMode.UPGRADE);
         final  Object bean1  =  qu1.uniqueResult();
        Object bean2  =  qu2.uniqueResult();
        T1oo t1oo2  =  (T1oo)bean2;
       
        t1oo2.setName( " run1 " );
       
         new  Thread(
                 new  Runnable(){
                     public   void  run()  {
                         try  {
                            System.out.println(  " ********解锁准备********* "  );
                            Thread.sleep( 10 * 1000 );
                            T1oo t1oo1  =  (T1oo)bean1;
                            t1oo1.setName( " run2 " );
                            tr1.commit();
                            System.out.println(  " ********解锁成功t********* "  );
                        }  catch  (InterruptedException e) {e.printStackTrace();}
                    }
                }
        ).start();
        / /这里会 等待十秒后 tr1解锁 /
        tr2.commit();
       
        session1.close();
        session2.close();
       
       
         //  delete Test Date 删除测试数据
        Session seDelete  =  sessionFactory.openSession();
        Transaction trD  =  seDelete.beginTransaction();
        Object obj  =  seDelete.createQuery( "  from T1oo t where t.id=:id  " ).
                        setInteger( " id " ,testId.intValue()).
                        uniqueResult();
        seDelete.delete(obj);
        trD.commit();
        System.out.println(  " **************Test Use Bean : delete************** "  );
        seDelete.close();
    }
乐观锁:
     /**  乐观锁问题
     * Table -> T1oo(id,name)
     * T2oo.hbn.xml <class> +> optimistic-lock="version"
     * id下面 +> <version name="version" type="integer" column="version" />
     *    +---------+---------+------+
     *    | Field   | Type    | Null |
     *    +---------+---------+------+
     *    | id      | int(11) |      |
     *    | avg     | int(11) |      |
     *    | aid     | int(11) | YES  |
     *    | version | int(11) | YES  |
     *    +---------+---------+------+
     *  注意：要在数据库中多加一列
     *  mysql> alter table T2OO add version int;
      */
     public   void  testOpLock() throws  Exception{
        //添加测试数据
        Session session  =  sessionFactory.openSession();
        Transaction trI  =  session.beginTransaction();
        Connection conn  =  session.connection();
        T2oo t2oo  =   new  T2oo();
        T1oo t1oo  = new  T1oo( " t1ooOpLock " );
        t1oo.setT2ooSet( new  HashSet());
        t2oo.setAvg( new  Integer( 23 ));   
        t2oo.setT1oo(t1oo);
        t1oo.getT2ooSet().add(t2oo);
        session.save(t2oo);
        trI.commit();
        session.clear();
        session.close();
        //并发模拟
        Session se1  =  sessionFactory.openSession();
        Session se2  =  sessionFactory.openSession();
       
        Transaction tr1  =  se1.beginTransaction();
        Transaction tr2  =  se2.beginTransaction();
       
        T1oo obj1  =  (T1oo)se1.load(T1oo. class , new  Integer( 1 ));
        T1oo obj2  =  (T1oo)se2.load(T1oo. class , new  Integer( 1 ));
       
        ((T2oo)obj1.getT2ooSet().iterator().next()).setAvg( new  Integer( 9 ));
        ((T2oo)obj2.getT2ooSet().iterator().next()).setAvg( new  Integer( 10 ));
               
        tr1.commit();
       
         try  {
            tr2.commit();
        }  catch  (Exception e) {
            se2.clear();
            tr2.commit();
             // tr2报错
        } finally {
            se1.close();
            se2.close();
        }
       
       
        //测试数据删除
        Session dele  =  sessionFactory.openSession();
        Transaction tr  =  dele.beginTransaction();
        dele.delete(obj1);
        tr.commit();
        dele.close();
       
        HibernateSessionFactory.closeSession();
    }

 
wenzhihui_2010
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Hibernate面试题部分汇总集合
11-13
Hibernate面试题部分汇总集合Hibernate面试题部分汇总集合
spring data jpa查询语句中，出现数据库关键字冲突异常
追梦i赤子心的博客
04-03 1282
错误 Hibernate: select order0_.id as id1_0_, order0_.amount as amount2_0_, order0_.buyer_address as buyer_ad3_0_, order0_.buyer_mobile as buyer_mo4_0_, order0_.buyer_name as buyer_na5_0_, order0_.buyer_openid as buyer_op6_0_, order0_.create_time as create_t7
Hibernate之HQL
weixin_45346741的博客
09-06 111
Hibernate之HQL1 什么是hql2 hql和sql区别/异同3 hql的基本知识4 查询全部and连接查询5 处理返回的结果集6 hql中使用占位符7 创建BookDao.java方法类8 创建测试方法HqlTest.java类9 测试结果 1 什么是hql HQL是Hibernate Query Language的缩写 2 hql和sql区别/异同 HQL SQL 类名...
Hibernate: select count(employee0_.id) as col_0_0_ from Employee employee0_ where 0=1
蔡茂的博客
04-27 2201
Hibernate: select count(employee0_.id) as col_0_0_ from Employee employee0_ where 0=1 高级查询除了为空无法查询出数据，看了Hibernate的底层sql语句有一个where 0=1 后来发现时定制规则的时候出错 原代码 @Override public Specification createSp...
Hibernate懒加载急加载我们需要注意的问题
cd_cd的专栏
12-28 1838
1、显而易见的概念懒加载——也被称为延迟加载，它在查询的时候不会立刻访问数据库，而是返回代理对象，当真正去使用对象的时候才会访问数据库。急加载——就是只要我们实体做了关联，全部一次性执行完所有的SQL语句2、@OneToMany ****默认为懒加载**** @Test public void find(){ Session s= sessionFactory.
Hibernate性能优化
yaguanzhou2014的专栏
01-14 620
Hibernate性能优化
kingbaseV8 hibernate jdbc 驱动
10-13
总结来说，这个压缩包包含了不同版本的Hibernate核心库以及可能的KingbaseV8 JDBC驱动和方言实现，这些组件使得开发者能够利用Hibernate框架高效地在Java应用中操作KingbaseV8数据库。在实际项目中，需要根据项目...
hibernate的大部分的工具类
10-30
总结来说，这个压缩包中的工具类覆盖了Hibernate的多个方面，包括初始化设置、数据验证、分页处理以及HQL查询的优化。它们是后端开发中的重要组成部分，特别是对于涉及持久层操作的项目，这些工具类将极大地增强代码...
2022年Hibernate常见面试题汇总.doc
11-11
以上只是部分核心知识点，面试时还可能涉及性能优化、事务隔离级别、缓存策略配置、实体关系映射（E-R Mapping）、N+1查询问题、懒加载和即时加载的使用场景等更深入的内容。理解并熟练应用这些知识点对于任何...
hibernate执行外部sql
最新发布
04-07
在IT行业中，数据库操作是应用程序开发的核心部分，而Hibernate和MyBatis作为两个流行的Java持久层框架，都提供了与数据库交互的能力。本篇文章将详细探讨如何利用Hibernate来执行外部SQL文件，实现类似于MyBatis的...
hibernate抓取策略学习
王勇霞 信息技术提高班九期
02-27 4110
一、hibernate抓取策略概述     Hibernate抓取策略（fetching strategy）是指：当应用程序需要在（Hibernate实体对象图的）关联关系间进行导航的时候， Hibernate如何获取关联对象的策略。抓取策略可以在O/R映射的元数据中声明，也可以在特定的HQL 或条件查询（Criteria Query）中重载声明。     需要注意的是：hibernate的抓
Hibernate中的三种查询HQL、Criteria、Sql学习（三）
mingxin95的博客
06-20 1623
这篇随笔将会记录hql的常用的查询语句，为日后查看提供便利。在这里通过定义了两个类，Type Type来做测试， Type与Type是一对多的关系，这里仅仅贴出这两个bean的属性代码： Type类： private static final long serialVersionUID = 1L; private int id; private String name;
显示出Hibernate查询语句的绑定参数值
wangshfa的专栏
07-17 9755
在使用 Hibernate 进行数据库操作的时候可以显示出所执行的 SQL 语句，相信用 Hibernate 的兄弟姐妹们都知道怎么设置。就设置 hibernate.show_sql  或者 show_sql 属性为 true 就行，在 hibernate.cfg.xml 或者与 Spring 集成时配置在 Spring 的配置文件中。再就是要让显示的 SQL 语句是格式化的，就配置 hibern
java之hibernate之加载策略和抓取策略
weixin_30768661的博客
07-19 109
1.加载策略：指hibernate查询数据时，采用什么样的方式将数据写入内存。Hibernate中提供了两种方式来加载数据：懒加载和即时加载。 2.懒加载又称延迟加载，指使用hiberante API查询数据时，不会立即将数据写入内存。而是等到真正使用数据时才会发出sql语句，到数据中查询数据。 3.即时加载：指使用hibernate API查询数据时，会立即发出sql语句，查询数据...
hibernate实体实现hashcode与equals方法
vincent
09-02 2445
为什么Hibernate建议你的实体类实现hashCode和equals方法？ 因为Hibernate使用了一级和二级缓存，很多查询为了提高效率Hibernate都会先从缓存中进行查找，然后再从数据库进行查找。而HashCode是唯一的，所以这样避免数据操作出现数据混淆的可能，而equals的作用是对比Hibernate缓存中数据是否一致。 看看Hibernate in action，有三种
hibernate中identity和increment区别
vincent
08-27 2320
identity:由底层数据库生成标识符identity是由数据库自己生成的，但这个主键必须设置为自增长，前提条件是低层数据库支持自动增长字段类型   increment:由hibernate管理主键，自动以递增的方式生成标识符，每次增量为1其在每次插入前取得一个当前最大的id+１作为主键，该主键必须为Integer类型 附： assigned   主键
ssh三大框架，三层架构 整合测试！完整分页代码
vincent
07-16 1377
源码下载：http://download.csdn.net/detail/wenzhihui_2010/5763749
关于Struts2 +hibernate 3+spring中的报错 1 Caused by: java.lang.NoSuchMethodError
vincent
10-15 1052
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Invocation of init method
Hibernate中的fetch, lazy, outer-join，inverse和cascade作用
vincent
05-28 798
1.fetch，outer-join 和 lazy 主要用于级联查询(select) 而 inverse和cascade主要用于级联增加，删除，修改(sava-update,delete)。    lazy是延时的意思，如果lazy=true，那么就是说数据库中关联子表的信息在hibernate容器启动的时候不会加载，而是在你真正的访问到字表非标识字段的时候，才会去加载。 反之，如果lazy
Hibernate 3.6 中文文档指南
"Hibernate 3.6 中文文档知识点总结" **Hibernate 概述** Hibernate 是一个基于 Java 的关系型持久层框架，提供了一个更加简洁和高效的方式来访问和操作关系型数据库。 Hibernate 通过将 Java 对象与数据库表之间...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值