From 209a57aecbf26911f6a3ae0692b51ed0289f5b1a Mon Sep 17 00:00:00 2001
From: wu <731351411@qq.com>
Date: 星期四, 14 九月 2023 17:04:56 +0800
Subject: [PATCH] 优化理片笼逻辑
---
springboot-vue3/src/main/java/com/example/springboot/mapper/UserMapper.java | 30 +++++++-----------------------
1 files changed, 7 insertions(+), 23 deletions(-)
diff --git a/springboot-vue3/src/main/java/com/example/springboot/mapper/UserMapper.java b/springboot-vue3/src/main/java/com/example/springboot/mapper/UserMapper.java
index ded288b..4c942dd 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/mapper/UserMapper.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/mapper/UserMapper.java
@@ -1,31 +1,15 @@
package com.example.springboot.mapper;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.springboot.entity.User;
-import org.apache.ibatis.annotations.*;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.springframework.stereotype.Repository;
import java.util.List;
@Mapper
-public interface UserMapper {
-
- @Select("select * from user where name like concat('%',#{name},'%') or date like concat('%',#{name},'%') " +
- "or address like concat('%',#{name},'%') or user_no like concat('%',#{name},'%')")
- List<User> selectAll(String name);
-
- @Select("select * from user where name like concat('%',#{name},'%') or date like concat('%',#{name},'%') " +
- "or address like concat('%',#{name},'%') or user_no like concat('%',#{name},'%') order by id desc limit #{start},#{pageSize}")
- List<User> selectPage(@Param("name") String name, @Param("start") Integer start, @Param("pageSize") Integer pageSize);
-
- @Select("select count(id) from user where name like concat('%',#{name},'%') or date like concat('%',#{name},'%') " +
- "or address like concat('%',#{name},'%') or user_no like concat('%',#{name},'%')")
- Integer selectTotal(@Param("name") String name);
-
- @Insert("insert into user(name, date, address, user_no) values (#{name}, #{date}, #{address}, #{userNo})")
- void insert(User user);
-
- void update(User user);
-
- @Delete("delete from user where id = #{id}")
- void delete(Integer id);
+@Repository
+public interface UserMapper extends BaseMapper<User> {
+ List<User> selectChild(@Param("path") String path);
}
-//@Update("update user set name = #{name}, date = #{date}, address = #{address}, user_no = #{userNo} where id = #{id}")
\ No newline at end of file
--
Gitblit v1.8.0