IBaseMapper.kt 5.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139
  1. /*
  2. * *********************************************************************************************************************
  3. *
  4. * !!
  5. * .F88X
  6. * X8888Y
  7. * .}888888N;
  8. * i888888N; .:! .I$WI:
  9. * R888888I .'N88~ i8}+8Y&8"l8i$8>8W~'>W8}8]KW+8IIN"8&
  10. * .R888888I .;N8888~ .X8' "8I.!,/8" !%NY8`"8I8~~8>,88I
  11. * +888888N; .8888888Y "&&8Y.}8,
  12. * ./888888N; .R888888Y .'}~ .>}'.`+> i}! "i' +/' .'i~ !11,.:">, .~]! .i}i
  13. * ~888888%: .I888888l .]88~`1/iY88Ii+1'.R$8$8]"888888888> Y8$ W8E X8E W8888'188Il}Y88$*
  14. * 18888888 E8888881 .]W%8$`R8X'&8%++N8i,8N%N8+l8%` .}8N:.R$RE%N88N%N$K$R 188,FE$8%~Y88I
  15. * .E888888I .i8888888' .:$8I;88+`E8R:/8N,.>881.`$8E/1/]N8X.Y8N`"KF&&FK!'88*."88K./$88%RN888+~
  16. * 8888888I .,N888888~ ~88i"8W,!N8*.I88.}888%F,i$88"F88" 888:E8X.>88!i88>`888*.}Fl1]*}1YKi'
  17. * i888888N' I888Y ]88;/EX*IFKFK88X K8R .l8W 88Y ~88}'88E&%8W.X8N``]88!.$8K .:W8I
  18. * .i888888N; I8Y .&8$ .X88! i881.:%888>I88 ;88] +88+.';;;;:.Y88X 18N.,88l .+88/
  19. * .:R888888I
  20. * .&888888I Copyright (c) 2016-2020. 博锐尚格科技股份有限公司
  21. * ~8888'
  22. * .!88~ All rights reserved.
  23. *
  24. * *********************************************************************************************************************
  25. */
  26. package com.persagy.mybatis
  27. import com.persagy.database.SFilter
  28. import com.persagy.database.SGroup
  29. import com.persagy.database.SQueryBuilder
  30. import org.apache.ibatis.annotations.*
  31. /**
  32. * 基础数据库操作影射器
  33. *
  34. * @author 庞利祥 <sybotan@126.com>
  35. */
  36. interface IBaseMapper<ENTITY: Any> {
  37. /**
  38. * 根据条件删除
  39. *
  40. * @param filterArgs 过滤条件
  41. * @param whereArgs whereArgs参数值,由SQlProvider填充
  42. */
  43. @DeleteProvider(type = SSqlProvider::class, method = "delete")
  44. fun delete(@Param("entityClass")entityClass: Class<*>,
  45. @Param("filterArgs")filterArgs: List<SFilter>,
  46. @Param("whereArgs")whereArgs: Map<String, Any>): Boolean
  47. /**
  48. * 删除所有记录
  49. */
  50. @DeleteProvider(type = SSqlProvider::class, method = "deleteAll")
  51. fun deleteAll(@Param("entityClass")entityClass: Class<*>): Boolean
  52. /**
  53. * 在数据库中插入实体
  54. *
  55. * @param entity 插入数据库的实体
  56. * @return 插入是否成功
  57. */
  58. @InsertProvider(type = SSqlProvider::class, method = "insert")
  59. @Options(useGeneratedKeys = true, keyProperty = "entity._id")
  60. fun insert(@Param("entityClass")entityClass: Class<*>,
  61. @Param("entity")entity: Map<String, Any?>): Boolean
  62. /**
  63. * 在数据库中插入实体
  64. *
  65. * @param entity 插入数据库的实体
  66. * @return 插入是否成功
  67. */
  68. @InsertProvider(type = SSqlProvider::class, method = "replace")
  69. fun replace(@Param("entityClass")entityClass: Class<*>,
  70. @Param("entity")entity: Map<String, Any?>,
  71. @Param("keyColumnList")keyColumnList: ArrayList<String>): Boolean
  72. /**
  73. * 根据条件更新
  74. *
  75. * @param entity 更新值
  76. * @param projection 字段映射
  77. * @param filterArgs 过滤条件
  78. * @param whereArgs whereArgs参数值,由SQlProvider填充
  79. */
  80. @UpdateProvider(type = SSqlProvider::class, method = "update")
  81. fun update(@Param("entityClass")entityClass: Class<*>,
  82. @Param("entity")entity: Map<String, Any?>,
  83. @Param("projection")projection: ArrayList<String>?,
  84. @Param("filterArgs")filterArgs: List<SFilter>?,
  85. @Param("whereArgs")whereArgs: Map<String, Any>): Boolean
  86. /**
  87. * 执行查询操作
  88. *
  89. * @param builder 查询查询构造器
  90. * @param whereArgs whereArgs参数值,由SQlProvider填充
  91. * @return 查询到的记录
  92. */
  93. @SelectProvider(type = SSqlProvider::class, method = "execQuery")
  94. fun execQuery(@Param("entityClass")entityClass: Class<*>,
  95. @Param("builder")builder: SQueryBuilder<ENTITY>,
  96. @Param("whereArgs")whereArgs: Map<String, Any>): ArrayList<Map<String, Any?>>
  97. /**
  98. * 执行查询操作
  99. *
  100. * @param builder 查询查询构造器
  101. * @param whereArgs whereArgs参数值,由SQlProvider填充
  102. * @return 查询到的记录
  103. */
  104. @SelectProvider(type = SSqlProvider::class, method = "execCount")
  105. fun execCount(@Param("entityClass")entityClass: Class<*>,
  106. @Param("builder")builder: SQueryBuilder<ENTITY>,
  107. @Param("whereArgs")whereArgs: Map<String, Any>): ArrayList<Long>
  108. ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
  109. // 级联操作相关
  110. /**
  111. * 查询级联关系
  112. *
  113. * @param table 表名
  114. * @param id1 对象表ID字段名
  115. * @param id2 级联对象ID字段名
  116. * @param self 自身级联
  117. * @param filter 附加过滤条件
  118. * @param idList 对象ID列表
  119. * @return 关系列表
  120. */
  121. @SelectProvider(type = SSqlProvider::class, method = "relationQuery")
  122. fun relationQuery(@Param("table")table: String,
  123. @Param("id1")id1: String,
  124. @Param("id2")id2: String,
  125. @Param("self")self: Boolean,
  126. @Param("filter")filter: String,
  127. @Param("idList")idList: ArrayList<Any>,
  128. @Param("whereArgs")whereArgs: Map<String, Any>): ArrayList<HashMap<String, Any>>
  129. } // Interface IBaseMapper