123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136 |
- /*
- * ********************************************************************************************************************
- *
- * iFHS7.
- * ;BBMBMBMc rZMBMBR BMB
- * MBEr:;PBM, 7MBMMEOBB: BBB RBW
- * XK: BO SB. :SZ MBM. c;; ir BBM :FFr :SSF: ;xBMB:r iuGXv. i:. iF2;
- * DBBM0r. :D S7 ;XMBMB GMBMu. MBM: BMB MBMBBBMBMS WMBMBMBBK MBMBMBM BMBRBMBW .MBMBMBMBB
- * :JMRMMD .. , 1MMRM1; ;MBMBBR: MBM ;MB: BMB: MBM. RMBr sBMH BM0 UMB, BMB. KMBv
- * ;. XOW B1; :uM: 1RE, i .2BMBs rMB. MBO MBO JMB; MBB MBM BBS 7MBMBOBM: MBW :BMc
- * OBRJ.SEE MRDOWOR, 3DE:7OBM . ;BMB RMR7BM BMB MBB. BMB ,BMR .BBZ MMB rMB, BMM rMB7
- * :FBRO0D0 RKXSXPR. JOKOOMPi BMBSSWBMB; BMBB: MBMB0ZMBMS .BMBOXRBMB MBMDE RBM2;SMBM; MBB xBM2
- * iZGE O0SHSPO. uGZ7. sBMBMBDL :BMO OZu:BMBK, rRBMB0; ,EBMB xBMBr:ER. RDU :OO;
- * ,BZ, 1D0 RPSFHXR. xWZ .SMr . .BBB
- * :0BMRDG RESSSKR. 2WOMBW; BMBMR
- * i0BM: SWKHKGO MBDv
- * .UB OOGDM. MK, Copyright (c) 2015-2019. 斯伯坦机器人
- * , XMW ..
- * r All rights reserved.
- *
- * ********************************************************************************************************************
- */
- package com.persagy.mybatis
- import com.persagy.database.SFilter
- import com.persagy.database.SGroup
- import com.persagy.database.SQueryBuilder
- import org.apache.ibatis.annotations.*
- /**
- * 基础数据库操作影射器
- *
- * @author 庞利祥 <sybotan@126.com>
- */
- interface IBaseMapper<ENTITY: Any> {
- /**
- * 根据条件删除
- *
- * @param filterArgs 过滤条件
- * @param whereArgs whereArgs参数值,由SQlProvider填充
- */
- @DeleteProvider(type = SSqlProvider::class, method = "delete")
- fun delete(@Param("entityClass")entityClass: Class<*>,
- @Param("filterArgs")filterArgs: List<SFilter>,
- @Param("whereArgs")whereArgs: Map<String, Any>): Boolean
- /**
- * 删除所有记录
- */
- @DeleteProvider(type = SSqlProvider::class, method = "deleteAll")
- fun deleteAll(@Param("entityClass")entityClass: Class<*>): Boolean
- /**
- * 在数据库中插入实体
- *
- * @param entity 插入数据库的实体
- * @return 插入是否成功
- */
- @InsertProvider(type = SSqlProvider::class, method = "insert")
- @Options(useGeneratedKeys = true, keyProperty = "entity._id")
- fun insert(@Param("entityClass")entityClass: Class<*>,
- @Param("entity")entity: Map<String, Any?>): Boolean
- /**
- * 在数据库中插入实体
- *
- * @param entity 插入数据库的实体
- * @return 插入是否成功
- */
- @InsertProvider(type = SSqlProvider::class, method = "replace")
- fun replace(@Param("entityClass")entityClass: Class<*>,
- @Param("entity")entity: Map<String, Any?>,
- @Param("keyColumnList")keyColumnList: ArrayList<String>): Boolean
- /**
- * 根据条件更新
- *
- * @param entity 更新值
- * @param projection 字段映射
- * @param filterArgs 过滤条件
- * @param whereArgs whereArgs参数值,由SQlProvider填充
- */
- @UpdateProvider(type = SSqlProvider::class, method = "update")
- fun update(@Param("entityClass")entityClass: Class<*>,
- @Param("entity")entity: Map<String, Any?>,
- @Param("projection")projection: ArrayList<String>?,
- @Param("filterArgs")filterArgs: List<SFilter>?,
- @Param("whereArgs")whereArgs: Map<String, Any>): Boolean
- /**
- * 执行查询操作
- *
- * @param builder 查询查询构造器
- * @param whereArgs whereArgs参数值,由SQlProvider填充
- * @return 查询到的记录
- */
- @SelectProvider(type = SSqlProvider::class, method = "execQuery")
- fun execQuery(@Param("entityClass")entityClass: Class<*>,
- @Param("builder")builder: SQueryBuilder<ENTITY>,
- @Param("whereArgs")whereArgs: Map<String, Any>): ArrayList<Map<String, Any?>>
- /**
- * 执行查询操作
- *
- * @param builder 查询查询构造器
- * @param whereArgs whereArgs参数值,由SQlProvider填充
- * @return 查询到的记录
- */
- @SelectProvider(type = SSqlProvider::class, method = "execCount")
- fun execCount(@Param("entityClass")entityClass: Class<*>,
- @Param("builder")builder: SQueryBuilder<ENTITY>,
- @Param("whereArgs")whereArgs: Map<String, Any>): ArrayList<Long>
- ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
- // 级联操作相关
- /**
- * 查询级联关系
- *
- * @param table 表名
- * @param id1 对象表ID字段名
- * @param id2 级联对象ID字段名
- * @param self 自身级联
- * @param filter 附加过滤条件
- * @param idList 对象ID列表
- * @return 关系列表
- */
- @SelectProvider(type = SSqlProvider::class, method = "relationQuery")
- fun relationQuery(@Param("table")table: String,
- @Param("id1")id1: String,
- @Param("id2")id2: String,
- @Param("self")self: Boolean,
- @Param("filter")filter: String,
- @Param("idList")idList: ArrayList<Any>,
- @Param("whereArgs")whereArgs: Map<String, Any>): ArrayList<HashMap<String, Any>>
- } // Interface IBaseMapper
|