diff --git a/src/main/resources/Group.hbm.xml b/src/main/resources/Group.hbm.xml index 8e0333c..aac9a9b 100644 --- a/src/main/resources/Group.hbm.xml +++ b/src/main/resources/Group.hbm.xml @@ -14,7 +14,6 @@ - diff --git a/src/main/resources/Request.hbm.xml b/src/main/resources/Request.hbm.xml index 4adea89..b08773b 100644 --- a/src/main/resources/Request.hbm.xml +++ b/src/main/resources/Request.hbm.xml @@ -14,7 +14,6 @@ - diff --git a/src/test/java/hibernateTest/models/NativeApiIllustrationTest.java b/src/test/java/hibernateTest/models/NativeApiIllustrationTest.java index c9c97c3..1576d8e 100644 --- a/src/test/java/hibernateTest/models/NativeApiIllustrationTest.java +++ b/src/test/java/hibernateTest/models/NativeApiIllustrationTest.java @@ -29,6 +29,8 @@ import hibernateTest.entities.Event; import hibernateTest.entities.Group; import hibernateTest.entities.Request; +import org.hibernate.Criteria; +import org.hibernate.criterion.Restrictions; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.boot.MetadataSources; @@ -76,17 +78,30 @@ session.beginTransaction(); session.save( new Event( "Our very first event!", new Date() ) ); session.save( new Event( "A follow up event", new Date() ) ); - session.save( new Group("111", "http://test1", "famiry", "011" ) ); + session.save( new Group("111", "http://test1", "family", "011" ) ); session.save( new Group("222", "http://test2", "friend", "022" ) ); session.save( new Request("111", "http://test01", "1999.01.01", "011", "ice", "1999.04.10",011)); - session.save( new Request("222", "http://test01", "1999.01.01", "022", "milk", "1999.04.10",011)); + session.save( new Request("222", "http://test02", "1999.02.02", "033", "milk", "1999.04.10",011)); + session.save( new Request("333", "http://test03", "1999.03.03", "033", "ice", "1999.04.10",011)); + session.getTransaction().commit(); + session.close(); + + // read and delete a request + session = sessionFactory.openSession(); + session.beginTransaction(); + //http://a4dosanddos.hatenablog.com/entry/2015/03/21/135421 + //createCriteriaは非推奨。別の方法があるのか? + Criteria criteria = session.createCriteria(Request.class).add(Restrictions.eq("rId", (long)222)); + Request editRequest = (Request) criteria.uniqueResult(); + if(editRequest != null){ + session.delete(editRequest); + } session.getTransaction().commit(); session.close(); // now lets pull events from the database and list them session = sessionFactory.openSession(); session.beginTransaction(); - List result = session.createQuery( "from Event" ).list(); for ( Event event : (List) result ) { System.out.println( "Event (" + event.getDate() + ") : " + event.getTitle() ); @@ -99,7 +114,6 @@ for ( Request request : (List) requestResult ) { System.out.println( "Request (" + request.getrId() + ") : " + request.getUri() + ": " + request.getDate() + ": " + request.isDone()); } - session.getTransaction().commit(); session.close(); } diff --git a/src/test/resources/Event.hbm.xml b/src/test/resources/Event.hbm.xml index bceae94..047e592 100644 --- a/src/test/resources/Event.hbm.xml +++ b/src/test/resources/Event.hbm.xml @@ -14,7 +14,7 @@ - + diff --git a/src/test/resources/Group.hbm.xml b/src/test/resources/Group.hbm.xml index 4576193..7a4a298 100644 --- a/src/test/resources/Group.hbm.xml +++ b/src/test/resources/Group.hbm.xml @@ -14,7 +14,6 @@ - diff --git a/src/test/resources/Request.hbm.xml b/src/test/resources/Request.hbm.xml index 4184b20..d41866b 100644 --- a/src/test/resources/Request.hbm.xml +++ b/src/test/resources/Request.hbm.xml @@ -14,7 +14,6 @@ -