Advertisement
Guest User

Untitled

a guest
Feb 7th, 2016
44
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. public class Department
  2. {
  3. departmentId;
  4. name;
  5. country;
  6. type;
  7. }
  8.  
  9. public class ItDepatment extends Department
  10. {
  11. itDeparmentCode;
  12. description;
  13. billingType;
  14. //Many other fields
  15. }
  16.  
  17. <select id="getDepartment" resultMap="departmentMap">
  18. select * from Department
  19. </select>
  20.  
  21. <resultmap id="departmentMap" type="Department">
  22. <result property="departmentId" column="ID"/>
  23. <result property="name" column="NAME"/>
  24. <result property="country" column="COUNTRY"/>
  25. <discriminator javaType="java.lang.String" column="TYPE">
  26. <case value="IT" resultmap="itDepartmentResultmap"/>
  27. <case value="SALES" resultmap="salesDepartmentResultmap"/>
  28. </discriminator>
  29. </resultmap>
  30.  
  31. <resultmap id="itDepartmentResultmap" type="ItDepatment">
  32. <result property="itDeparmentCode" column="CODE"/>
  33. <result property="description" column="DESCRIPTION"/>
  34. <result property="billingType" column="BILLING_TYPE"/>
  35. </resultmap>
  36.  
  37. <select id="getItDepartment" resultMap="itDepartmentResultmap">
  38. select * from ItDepartment where id=#{departmentId}
  39. </select>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement