From 30bcaac63cafe8ed46a7ab09eac6b90fa7aea1d5 Mon Sep 17 00:00:00 2001 From: liurunyu <lry9898@163.com> Date: 星期三, 08 十一月 2023 09:38:36 +0800 Subject: [PATCH] 代码整理,及应用MybatisPlus,使得可不用mapper.xml配置文件进行查询demo实现 --- pipIrr-platform/pipIrr-web/pipIrr-web-sso/src/main/java/com/dy/sso/busi/SsoSv.java | 35 ++++++++++++++++++++++++++++++++++- 1 files changed, 34 insertions(+), 1 deletions(-) diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-sso/src/main/java/com/dy/sso/busi/SsoSv.java b/pipIrr-platform/pipIrr-web/pipIrr-web-sso/src/main/java/com/dy/sso/busi/SsoSv.java index 6822356..f6cad3e 100644 --- a/pipIrr-platform/pipIrr-web/pipIrr-web-sso/src/main/java/com/dy/sso/busi/SsoSv.java +++ b/pipIrr-platform/pipIrr-web/pipIrr-web-sso/src/main/java/com/dy/sso/busi/SsoSv.java @@ -1,5 +1,6 @@ package com.dy.sso.busi; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.dy.pipIrrGlobal.daoBa.BaPrivilegeMapper; import com.dy.pipIrrGlobal.daoBa.BaUserMapper; import com.dy.pipIrrGlobal.pojoBa.BaUser; @@ -27,10 +28,17 @@ this.baPrivilegeMapper = baPrivilegeMapper ; } + /** + * 闇�瑕丅aUserMapper.xml + * @param uuid 缁欑櫥褰曟垚鍔熺殑鐢ㄦ埛璧嬪�煎叾token + * @param phone 鐢ㄦ埛鎵嬫満鍙� + * @param password 鐢ㄦ埛瀵嗙爜 + * @return 鐧诲綍鎴愬姛鐢ㄦ埛 + */ //褰撴湭娉ㄨВ@Transactional鏃讹紝浼氳緭鍑烘棩蹇楋細SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@46727a0c] was not registered for synchronization because synchronization is not active @Transactional @Cacheable(cacheNames=CacheConstants.cacheNames, key="'" + CacheConstants.loginUserKeyPrefix + "' + #uuid", sync=true) - public BaUser login(String uuid, String phone, String password){ + public BaUser loginWithMapperXml(String uuid, String phone, String password){ BaUser baUser = this.baUserMapper.login(phone, password) ; if(baUser != null && baUser.id != null){ baUser.privileges = this.baPrivilegeMapper.selectPrivilegeByUserId(baUser.id) ; @@ -38,6 +46,31 @@ return baUser; } + /** + * 涓嶉渶瑕� BaUserMapper.xml + * @param uuid 缁欑櫥褰曟垚鍔熺殑鐢ㄦ埛璧嬪�煎叾token + * @param phone 鐢ㄦ埛鎵嬫満鍙� + * @param password 鐢ㄦ埛瀵嗙爜 + * @return 鐧诲綍鎴愬姛鐢ㄦ埛 + */ + //褰撴湭娉ㄨВ@Transactional鏃讹紝浼氳緭鍑烘棩蹇楋細SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@46727a0c] was not registered for synchronization because synchronization is not active + @Transactional + @Cacheable(cacheNames=CacheConstants.cacheNames, key="'" + CacheConstants.loginUserKeyPrefix + "' + #uuid", sync=true) + public BaUser loginWithOutMapperXml(String uuid, String phone, String password){ + QueryWrapper<BaUser> qw = new QueryWrapper<>(); + //QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ; + qw.select("id", "name", "phone", "orgTag", "supperAdmin") + .eq("disabled", 0) + .eq("deleted", 0) + .eq("phone", phone) + .eq("password", password); + BaUser baUser = this.baUserMapper.selectOne(qw) ; + if(baUser != null && baUser.id != null){ + baUser.privileges = this.baPrivilegeMapper.selectPrivilegeByUserId(baUser.id) ; + } + return baUser; + } + @CacheEvict(cacheNames=CacheConstants.cacheNames, key="'" + CacheConstants.loginUserKeyPrefix + "' + #uuid") public void logout(String uuid){ } -- Gitblit v1.8.0