From 3b55d06b89bf64873e685c3d78fce5affbba3d17 Mon Sep 17 00:00:00 2001 From: zheng_wenlong Date: Tue, 16 Apr 2019 11:20:38 +0900 Subject: Add warehouse server source code. [Patch Set 2] Add ReadMe.md Change-Id: I6ade52d2490f5ca4ba107c1a27ed6d5b39048725 Signed-off-by: zheng_wenlong --- .../persistence/xml/authority/AuthorityMapper.xml | 194 +++++++++++++++++++++ .../xml/authority/AuthorityResourceLinkMapper.xml | 146 ++++++++++++++++ 2 files changed, 340 insertions(+) create mode 100644 appmarket-persistence/src/main/java/app/market/persistence/xml/authority/AuthorityMapper.xml create mode 100644 appmarket-persistence/src/main/java/app/market/persistence/xml/authority/AuthorityResourceLinkMapper.xml (limited to 'appmarket-persistence/src/main/java/app/market/persistence/xml/authority') diff --git a/appmarket-persistence/src/main/java/app/market/persistence/xml/authority/AuthorityMapper.xml b/appmarket-persistence/src/main/java/app/market/persistence/xml/authority/AuthorityMapper.xml new file mode 100644 index 0000000..7843e0a --- /dev/null +++ b/appmarket-persistence/src/main/java/app/market/persistence/xml/authority/AuthorityMapper.xml @@ -0,0 +1,194 @@ + + + + + + + + + + + + + + + + + and ${criterion.condition} + + + and ${criterion.condition} #{criterion.value} + + + and ${criterion.condition} #{criterion.value} and #{criterion.secondValue} + + + and ${criterion.condition} + + #{listItem} + + + + + + + + + + + + + + + + + + and ${criterion.condition} + + + and ${criterion.condition} #{criterion.value} + + + and ${criterion.condition} #{criterion.value} and #{criterion.secondValue} + + + and ${criterion.condition} + + #{listItem} + + + + + + + + + + + AU_ID, AU_NAME, AU_IS_DEL + + + + + delete from t_authority + where AU_ID = #{auId,jdbcType=CHAR} + + + delete from t_authority + + + + + + insert into t_authority (AU_ID, AU_NAME, AU_IS_DEL + ) + values (#{auId,jdbcType=CHAR}, #{auName,jdbcType=VARCHAR}, #{isDel,jdbcType=CHAR} + ) + + + insert into t_authority + + + AU_ID, + + + AU_NAME, + + + AU_IS_DEL, + + + + + #{auId,jdbcType=CHAR}, + + + #{auName,jdbcType=VARCHAR}, + + + #{isDel,jdbcType=CHAR}, + + + + + + update t_authority + + + AU_ID = #{record.auId,jdbcType=CHAR}, + + + AU_NAME = #{record.auName,jdbcType=VARCHAR}, + + + AU_IS_DEL = #{record.isDel,jdbcType=CHAR}, + + + + + + + + update t_authority + set AU_ID = #{record.auId,jdbcType=CHAR}, + AU_NAME = #{record.auName,jdbcType=VARCHAR}, + AU_IS_DEL = #{record.isDel,jdbcType=CHAR} + + + + + + update t_authority + + + AU_NAME = #{auName,jdbcType=VARCHAR}, + + + AU_IS_DEL = #{isDel,jdbcType=CHAR}, + + + where AU_ID = #{auId,jdbcType=CHAR} + + + update t_authority + set AU_NAME = #{auName,jdbcType=VARCHAR}, + AU_IS_DEL = #{isDel,jdbcType=CHAR} + where AU_ID = #{auId,jdbcType=CHAR} + + + \ No newline at end of file diff --git a/appmarket-persistence/src/main/java/app/market/persistence/xml/authority/AuthorityResourceLinkMapper.xml b/appmarket-persistence/src/main/java/app/market/persistence/xml/authority/AuthorityResourceLinkMapper.xml new file mode 100644 index 0000000..bff6c1f --- /dev/null +++ b/appmarket-persistence/src/main/java/app/market/persistence/xml/authority/AuthorityResourceLinkMapper.xml @@ -0,0 +1,146 @@ + + + + + + + + + + + + + + + + and ${criterion.condition} + + + and ${criterion.condition} #{criterion.value} + + + and ${criterion.condition} #{criterion.value} and #{criterion.secondValue} + + + and ${criterion.condition} + + #{listItem} + + + + + + + + + + + + + + + + + + and ${criterion.condition} + + + and ${criterion.condition} #{criterion.value} + + + and ${criterion.condition} #{criterion.value} and #{criterion.secondValue} + + + and ${criterion.condition} + + #{listItem} + + + + + + + + + + + R_RES_ID, R_AU_ID + + + + delete from t_authority_resource_link + where R_RES_ID = #{resId,jdbcType=CHAR} + and R_AU_ID = #{auId,jdbcType=CHAR} + + + delete from t_authority_resource_link + + + + + + insert into t_authority_resource_link (R_RES_ID, R_AU_ID) + values (#{resId,jdbcType=CHAR}, #{auId,jdbcType=CHAR}) + + + insert into t_authority_resource_link + + + R_RES_ID, + + + R_AU_ID, + + + + + #{resId,jdbcType=CHAR}, + + + #{auId,jdbcType=CHAR}, + + + + + + update t_authority_resource_link + + + R_RES_ID = #{record.resId,jdbcType=CHAR}, + + + R_AU_ID = #{record.auId,jdbcType=CHAR}, + + + + + + + + update t_authority_resource_link + set R_RES_ID = #{record.resId,jdbcType=CHAR}, + R_AU_ID = #{record.auId,jdbcType=CHAR} + + + + + \ No newline at end of file -- cgit 1.2.3-korg