Skynet

???? /** ?使用?Query.executeUpdate()?緩存中數(shù)據(jù)不同步?解決辦法
?????*??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?成為?持久狀態(tài)?一級(jí)緩存中?加載
????????session.saveOrUpdate(t1oo);?
???????? // 直接一條語(yǔ)句刪除T1oo，緩存無(wú)法同步
???????? // 一級(jí)緩存中還有?t1
????????Query?qu? = ?session.createQuery( " delete?T1oo " );
???????? try ?{
????????????qu.executeUpdate();
????????}? catch ?(Exception?e)?{????
????????????System.out.println( " //err:?有級(jí)聯(lián)?單使用?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();
???????? // 這直接通過(guò)一級(jí)緩存中加載t2，但DB中以沒(méi)有此條數(shù)據(jù)
????????t1oo? = ?(T1oo)session.load(T1oo. class ,t1oo.getId());
????????t1oo.setName( " google " );
???????? try ?{
????????????tr2.commit();????
????????}? catch ?(Exception?e)?{
????????????System.out.println( " //err:?update(t1oo)->DB?中數(shù)據(jù)庫(kù)中沒(méi)有?t1oo?// " );
????????}
????????

????????System.out.println( " ?一級(jí)緩存清空前? " + ?session.get(T1oo. class ,t1oo.getId())?);
????????session.evict(t1oo);
????????System.out.println( " ?一級(jí)緩存清空后? " + ?session.get(T1oo. class ,t1oo.getId())?);
????????
???????? // 不把t1oo?id?為空，否則當(dāng)在saveOrUpdate時(shí)候就會(huì)以為是游離態(tài)?update了
????????t1oo.setId( null );
???????? // id=null?insert?調(diào)用
????????session.saveOrUpdate(t1oo);????????
????????tr2.commit();
????????
????Transaction?tr3? = ?session.beginTransaction();
????????session.delete(t1oo);
????????tr3.commit();
????????
????????session.close();
????????HibernateSessionFactory.closeSession();
????????
????}