Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.61 KB | None | 0 0
  1. <class name="Event" table="event">
  2. <id name="oid" type="long" column="oid">
  3. <generator class="increment">
  4. <param name="initial_value">1</param>
  5. </generator>
  6. </id>
  7. <property name="address">
  8. <column name="address"/>
  9. </property>
  10. <property name="date">
  11. <column name="date"/>
  12. </property>
  13. <list name="fights" cascade="all">
  14. <key column="eventOid"></key>
  15. <index column="type"></index>
  16. <one-to-many class="Fight"/>
  17. </list>
  18. </class>
  19.  
  20. public Event getEvtByDateAddress(String _date, String _address)
  21. {
  22. try
  23. {
  24. if(!session.isOpen())
  25. {
  26. session = HibernateUtil.getSessionFactory().openSession();
  27. }
  28. session.beginTransaction();
  29. Criteria criteria = session.createCriteria(Event.class);
  30. criteria.add(Restrictions.eq("date", _date));
  31. criteria.add(Restrictions.eq("address", _address));
  32. Event evt = (Event)criteria.uniqueResult();
  33. if (evt==null)
  34. {
  35. return null;
  36. }
  37. else
  38. {
  39. return evt;
  40. }
  41. }
  42. catch(Exception e)
  43. {
  44. return null;
  45. }
  46. }
  47.  
  48. public int updateEvent(Event _event)
  49. {
  50. try
  51. {
  52. if(!session.isOpen())
  53. {
  54. session = HibernateUtil.getSessionFactory().openSession();
  55. }
  56. Event tmpEvent=new Event();
  57. if((tmpEvent=this.getEvtByDateAddress(_event.getDate(), _event.getAddress()))!=null)
  58. {
  59. tmpEvent.setFights(_event.getFights());
  60. Transaction tx =session.beginTransaction();
  61. session.update(tmpEvent);
  62. session.flush();
  63. tx.commit();
  64. session.close();
  65. return 0;
  66. }
  67. else
  68. {
  69. return -1;
  70. }
  71. }
  72. catch(Exception e){
  73. return -254;
  74. }
  75. }
  76.  
  77. oid boxer1Oid boxer2Oid eventOid type
  78. 1 1 3 N N
  79. 2 2 4 N N
  80. 3 5 6 N N
  81. 4 7 8 N N
  82. 5 1 2 1 0
  83. 6 3 4 1 1
  84. 7 5 6 1 2
  85. 8 7 8 1 3
  86.  
  87. oid boxer1Oid boxer2Oid eventOid type
  88. 1 1 2 1 0
  89. 2 3 4 1 1
  90. 3 5 6 1 2
  91. 4 7 8 1 3
  92.  
  93. if((tmpEvent=this.getEvtByDateAddress(_event.getDate(),_event.getAddress()))!=null)
  94.  
  95. tmpEvent.setFights(_event.getFights());
  96. -------
  97. session.update(tmpEvent);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement