From 4c6dcf757cc7962a8dbaefd83588cc576ee44594 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 23 七月 2025 11:29:40 +0800
Subject: [PATCH] 迁移redis服务

---
 se-common/src/main/java/com/terra/common/mapper/OperatePoMapper.java |   25 +++++++++++++++++++++++++
 1 files changed, 25 insertions(+), 0 deletions(-)

diff --git a/se-common/src/main/java/com/terra/common/mapper/OperatePoMapper.java b/se-common/src/main/java/com/terra/common/mapper/OperatePoMapper.java
new file mode 100644
index 0000000..f3c1b6c
--- /dev/null
+++ b/se-common/src/main/java/com/terra/common/mapper/OperatePoMapper.java
@@ -0,0 +1,25 @@
+package com.terra.common.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.terra.common.entity.lf.OperatePo;
+import com.terra.common.entity.lf.TokenPo;
+import com.terra.common.entity.lf.UserPo;
+import org.apache.ibatis.annotations.Insert;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Select;
+import org.springframework.stereotype.Repository;
+
+import java.util.Map;
+
+@Mapper
+@Repository
+public interface OperatePoMapper extends BaseMapper<OperatePo> {
+    @Insert("INSERT INTO lf.sys_operate(url, ip, exec, clazz, type, userid, bak, modular1, modular2) VALUES (#{url}, #{ip}, #{exec}, #{clazz}, #{type}, #{userid}, #{bak}, #{modular1}, #{modular2})")
+    int insertOperate(Map<String, Object> map);
+
+    @Select("select * from lf.sys_user where id = (select create_user from lf.sys_token where token=#{token} and expire > now() limit 1)")
+    public UserPo selectByToken(String token);
+
+    @Select("select a.* from lf.sys_token a where token = #{token} and expire > now() limit 1")
+    public TokenPo selectOneByToken(String token);
+}

--
Gitblit v1.9.3