devbox
我家小花儿
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

SpringBoot2+Vue2实战(六)登录,注册实现及自定义异常处理,个人信息页面与昵称头像功能实现_基于springboot+vue通过http请求个人信息

作者：我家小花儿 | 2024-04-09 14:44:24

赞

踩

基于springboot+vue通过http请求个人信息

一、登录：

UserDto

  1.  
  2. @Data
  3. public class UserDto {
  4.  
  5.     private String username;
  6.  
  7.     private String password;
  8.  
  9.     @Alias("nickname")
  10.     private String nickname;
  11.  
  12.     private String avatarUrl;
  13. }

UserController

  1.  //登录
  2.     @PostMapping("/login")
  3.     public Result login(@RequestBody UserDto userDto) {
  4.         String username = userDto.getUsername();
  5.         String password = userDto.getPassword();
  6.         if (StrUtil.isBlank(username) || StrUtil.isBlank(password)) {
  7.             return Result.error(Constants.CODE_400, "系统错误");
  8.         }
  9.         UserDto dto = userService.login(userDto);
  10.         return success(dto);
  11.     }

UserService

  1.  
  2. public interface UserService extends IService<User> {
  3.  
  4.  UserDto login(UserDto userDto);
  5. }

UserServiceImpl

  1. @Service
  2. public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {
  3.  
  4.     @Resource
  5.     private UserMapper userMapper;
  6.  
  7.  
  8.     private static final Log LOG = Log.get();
  9.  
  10.  
  11.    @Override
  12.     public UserDto login(UserDto userDto) {
  13.         User one = getUserInfo(userDto);
  14.         if (one != null){
  15.             BeanUtil.copyProperties(one,userDto,true);
  16.             return userDto;
  17.         }else {
  18.             throw new ServiceException(Constants.CODE_600,"用户名或密码错误");
  19.         }
  20.     }
  21.  
  22. private User getUserInfo(UserDto userDto) {
  23.         QueryWrapper<User> queryWrapper = new QueryWrapper<>();
  24.         queryWrapper.eq("username",userDto.getUsername());
  25.         queryWrapper.eq("password",userDto.getPassword());
  26.         User one;
  27.         try{
  28.             one = getOne(queryWrapper);
  29.         }catch (Exception e){
  30.             LOG.error(e);
  31.             throw new ServiceException(Constants.CODE_500,"系统错误");
  32.         }
  33.         return one;
  34.     }
  35.  
  36. }

Login.vue 

  1. <template>
  2.   <div class="wrapper">
  3.     <div style="margin: 200px auto; background-color: #fff; width: 350px; height: 300px; padding: 20px; border-radius: 10px">
  4.       <div style="margin: 20px 0; text-align: center; font-size: 24px"><b>登 录</b></div>
  5.  
  6.       <el-form :model="user" :rules="rules" ref="userForm">
  7.         <el-form-item prop="username">
  8.           <el-input size="medium" style="margin: 10px 0" prefix-icon="el-icon-user" v-model="user.username"></el-input>
  9.         </el-form-item>
  10.         <el-form-item prop="password">
  11.           <el-input size="medium" style="margin: 10px 0" prefix-icon="el-icon-lock" show-password v-model="user.password"></el-input>
  12.         </el-form-item>
  13.         <el-form-item style="margin: 10px 0; text-align: right">
  14.           <el-button type="primary" size="small"  autocomplete="off" @click="login">登录</el-button>
  15.           <el-button type="warning" size="small"  autocomplete="off">注册</el-button>
  16.         </el-form-item>
  17.       </el-form>
  18.  
  19.     </div>
  20.   </div>
  21. </template>
  22.  
  23. <script>
  24. export default {
  25.   name: "Login",
  26.   data() {
  27.     return {
  28.       user: {},
  29.       rules: {
  30.         username: [
  31.           { required: true, message: '请输入用户名', trigger: 'blur' },
  32.           { min: 3, max: 10, message: '长度在 3 到 5 个字符', trigger: 'blur' }
  33.         ],
  34.         password: [
  35.           { required: true, message: '请输入密码', trigger: 'blur' },
  36.           { min: 1, max: 20, message: '长度在 1 到 20 个字符', trigger: 'blur' }
  37.         ],
  38.       }
  39.     }
  40.   },
  41.   methods: {
  42.      login() {
  43.       this.$refs['userForm'].validate((valid) => {
  44.         if (valid) {  // 表单校验合法
  45.           this.request.post("/user/login", this.user).then(res => {
  46.             if (res.code === '200'){
  47.               //存储用户信息到浏览器
  48.               localStorage.setItem("user",JSON.stringify(res.data))
  49.               this.$router.push("/")
  50.               this.$message.success("登录成功")
  51.             }else {
  52.               this.$message.error(res.msg)
  53.             }
  54.           })
  55.         }
  56.       });
  57.     }
  58. }
  59. </script>
  60.  
  61. <style>
  62. .wrapper {
  63.   height: 100vh;
  64.   background-image: linear-gradient(to bottom right, #FC466B , #3F5EFB);
  65.   overflow: hidden;
  66. }
  67. </style>

router/index.js

  1.  {
  2.     path: '/login',
  3.     name: 'Login',
  4.     component: () => import('../views/Login.vue')
  5.   }

二、退出

Header.vue

  1. <el-dropdown-item style="font-size: 14px; padding: 5px 0">
  2.           <span style="text-decoration: none" @click="logout">退出</span>
  3.         </el-dropdown-item>
  4.  
  5.  
  6.  
  7. data() {
  8.     return {
  9.       user: localStorage.getItem("user") ? JSON.parse(localStorage.getItem("user")) : {}
  10.     }
  11.   },
  12.   methods: {
  13.     logout() {
  14.       this.$router.push("/login")
  15.       localStorage.removeItem("user")
  16.       this.$message.success("退出成功")
  17.     }
  18.   }

三、注册

router/index.js

  1. {
  2.     path: '/register',
  3.     name: 'Register',
  4.     component: () => import('../views/Register.vue')
  5.   },

Header.vue

  1. <template>
  2.   <div class="wrapper">
  3.     <div style="margin: 100px auto; background-color: #fff; width: 350px; height: 400px; padding: 20px; border-radius: 10px">
  4.       <div style="margin: 20px 0; text-align: center; font-size: 24px"><b>注 册</b></div>
  5.       <el-form :model="user" :rules="rules" ref="userForm">
  6.         <el-form-item prop="username">
  7.           <el-input placeholder="请输入账号" size="medium" style="margin: 5px 0" prefix-icon="el-icon-user" v-model="user.username"></el-input>
  8.         </el-form-item>
  9.         <el-form-item prop="password">
  10.           <el-input placeholder="请输入密码" size="medium" style="margin: 5px 0" prefix-icon="el-icon-lock" show-password v-model="user.password"></el-input>
  11.         </el-form-item>
  12.         <el-form-item prop="confirmPassword">
  13.           <el-input placeholder="请确认密码" size="medium" style="margin: 5px 0" prefix-icon="el-icon-lock" show-password v-model="user.confirmPassword"></el-input>
  14.         </el-form-item>
  15.         <el-form-item style="margin: 5px 0; text-align: right">
  16.           <el-button type="primary" size="small"  autocomplete="off" @click="register">注册</el-button>
  17.           <el-button type="warning" size="small"  autocomplete="off" @click="$router.push('/login')">返回登录</el-button>
  18.         </el-form-item>
  19.       </el-form>
  20.     </div>
  21.   </div>
  22. </template>
  23.  
  24. <script>
  25. export default {
  26.   name: "Register",
  27.   data() {
  28.     return {
  29.       user: {},
  30.       rules: {
  31.         username: [
  32.           { required: true, message: '请输入用户名', trigger: 'blur' },
  33.           { min: 3, max: 10, message: '长度在 3 到 5 个字符', trigger: 'blur' }
  34.         ],
  35.         password: [
  36.           { required: true, message: '请输入密码', trigger: 'blur' },
  37.           { min: 1, max: 20, message: '长度在 1 到 20 个字符', trigger: 'blur' }
  38.         ],
  39.         confirmPassword: [
  40.           { required: true, message: '请输入密码', trigger: 'blur' },
  41.           { min: 1, max: 20, message: '长度在 1 到 20 个字符', trigger: 'blur' }
  42.         ],
  43.       }
  44.     }
  45.   },
  46.   methods: {
  47.     register() {
  48.       this.$refs['userForm'].validate((valid) => {
  49.         if (valid) {  // 表单校验合法
  50.           if (this.user.password !== this.user.confirmPassword) {
  51.             this.$message.error("两次输入的密码不一致")
  52.             return false
  53.           }
  54.           this.request.post("/user/register", this.user).then(res => {
  55.             if(res.code === '200') {
  56.               this.$message.success("注册成功")
  57.               this.$router.push("/login")
  58.             } else {
  59.               this.$message.error(res.msg)
  60.             }
  61.           })
  62.         }
  63.       });
  64.     }
  65.   }
  66. }
  67. </script>
  68.  
  69. <style>
  70. .wrapper {
  71.   height: 100vh;
  72.   background-image: linear-gradient(to bottom right, #FC466B , #3F5EFB);
  73.   overflow: hidden;
  74. }
  75. </style>

Login.vue

  1. methods: {
  2.     login() {
  3.       this.$refs['userForm'].validate((valid) => {
  4.         if (valid) {  // 表单校验合法
  5.           this.request.post("/user/login", this.user).then(res => {
  6.             if (res.code === '200'){
  7.               //存储用户信息到浏览器
  8.               localStorage.setItem("user",JSON.stringify(res.data))
  9.               this.$router.push("/")
  10.               this.$message.success("登录成功")
  11.             }else {
  12.               this.$message.error(res.msg)
  13.             }
  14.           })
  15.         }
  16.       });
  17.     }
  18.   }

Register.vue

  1. <template>
  2.   <div class="wrapper">
  3.     <div style="margin: 100px auto; background-color: #fff; width: 350px; height: 400px; padding: 20px; border-radius: 10px">
  4.       <div style="margin: 20px 0; text-align: center; font-size: 24px"><b>注 册</b></div>
  5.       <el-form :model="user" :rules="rules" ref="userForm">
  6.         <el-form-item prop="username">
  7.           <el-input placeholder="请输入账号" size="medium" style="margin: 5px 0" prefix-icon="el-icon-user" v-model="user.username"></el-input>
  8.         </el-form-item>
  9.         <el-form-item prop="password">
  10.           <el-input placeholder="请输入密码" size="medium" style="margin: 5px 0" prefix-icon="el-icon-lock" show-password v-model="user.password"></el-input>
  11.         </el-form-item>
  12.         <el-form-item prop="confirmPassword">
  13.           <el-input placeholder="请确认密码" size="medium" style="margin: 5px 0" prefix-icon="el-icon-lock" show-password v-model="user.confirmPassword"></el-input>
  14.         </el-form-item>
  15.         <el-form-item style="margin: 5px 0; text-align: right">
  16.           <el-button type="primary" size="small"  autocomplete="off" @click="register">注册</el-button>
  17.           <el-button type="warning" size="small"  autocomplete="off" @click="$router.push('/login')">返回登录</el-button>
  18.         </el-form-item>
  19.       </el-form>
  20.     </div>
  21.   </div>
  22. </template>
  23.  
  24. <script>
  25. export default {
  26.   name: "Register",
  27.   data() {
  28.     return {
  29.       user: {},
  30.       rules: {
  31.         username: [
  32.           { required: true, message: '请输入用户名', trigger: 'blur' },
  33.           { min: 3, max: 10, message: '长度在 3 到 5 个字符', trigger: 'blur' }
  34.         ],
  35.         password: [
  36.           { required: true, message: '请输入密码', trigger: 'blur' },
  37.           { min: 1, max: 20, message: '长度在 1 到 20 个字符', trigger: 'blur' }
  38.         ],
  39.         confirmPassword: [
  40.           { required: true, message: '请输入密码', trigger: 'blur' },
  41.           { min: 1, max: 20, message: '长度在 1 到 20 个字符', trigger: 'blur' }
  42.         ],
  43.       }
  44.     }
  45.   },
  46.   methods: {
  47.     register() {
  48.       this.$refs['userForm'].validate((valid) => {
  49.         if (valid) {  // 表单校验合法
  50.           if (this.user.password !== this.user.confirmPassword) {
  51.             this.$message.error("两次输入的密码不一致")
  52.             return false
  53.           }
  54.           this.request.post("/user/register", this.user).then(res => {
  55.             if(res.code === '200') {
  56.               this.$message.success("注册成功")
  57.               this.$router.push("/login")
  58.             } else {
  59.               this.$message.error(res.msg)
  60.             }
  61.           })
  62.         }
  63.       });
  64.     }
  65.   }
  66. }
  67. </script>
  68.  
  69. <style>
  70. .wrapper {
  71.   height: 100vh;
  72.   background-image: linear-gradient(to bottom right, #FC466B , #3F5EFB);
  73.   overflow: hidden;
  74. }
  75. </style>

router/index.js

  1. {
  2.     path: '/register',
  3.     name: 'Register',
  4.     component: () => import('../views/Register.vue')
  5.   }

User.vue

  1. methods: {
  2.     load() {
  3.       this.request.get("/user/selectPage", {
  4.         params: {
  5.           pageNum: this.pageNum,
  6.           pageSize: this.pageSize,
  7.           username: this.username,
  8.           email: this.email,
  9.           address: this.address,
  10.         }
  11.       }).then(res => {
  12.         //注意data
  13.         this.tableData = res.data.records
  14.         this.total = res.data.total
  15.       })
  16.     },
  17.  
  18. save() {
  19.       this.request.post("/user/saveUser", this.form).then(res => {
  20.         if (res.data) {
  21.           this.$message.success("保存成功")
  22.           this.dialogFormVisible = false
  23.           this.load()
  24.         } else {
  25.           this.$message.error("保存失败")
  26.         }
  27.       })
  28.     },
  29.  
  30.  
  31. del(id) {
  32.       this.request.delete("/user/" + id).then(res => {
  33.         if (res.data) {
  34.           this.$message.success("删除成功")
  35.           this.load()
  36.         } else {
  37.           this.$message.error("删除失败")
  38.         }
  39.       })
  40.     },
  41.  
  42.  
  43. delBatch() {
  44.       let ids = this.multipleSelection.map(v => v.id)  // [{}, {}, {}] => [1,2,3]
  45.       this.request.post("/user/del/batch", ids).then(res => {
  46.         if (res.data) {
  47.           this.$message.success("批量删除成功")
  48.           this.load()
  49.         } else {
  50.           this.$message.error("批量删除失败")
  51.         }
  52.       })
  53.     },

UserDto

  1. import lombok.Data;
  2.  
  3. @Data
  4. public class UserDto {
  5.  
  6.     private String username;
  7.  
  8.     private String password;
  9.  
  10.     private String nickname;
  11.  
  12.     private String avatarUrl;
  13. }

Constants.java（常量类，定义Code）

  1. public interface Constants {
  2.  
  3.     String CODE_200 = "200"; //成功
  4.     String CODE_401 = "401";  // 权限不足
  5.     String CODE_400 = "400";  // 参数错误
  6.     String CODE_500 = "500"; // 系统错误
  7.     String CODE_600 = "600"; // 其他业务异常
  8.  
  9. }

Result

  1. import lombok.AllArgsConstructor;
  2. import lombok.Data;
  3. import lombok.NoArgsConstructor;
  4.  
  5. /**
  6.  * 接口统一返回包装类
  7.  */
  8. @Data
  9. @NoArgsConstructor
  10. @AllArgsConstructor
  11. public class Result {
  12.  
  13.     private String code;
  14.     private String msg;
  15.     private Object data;
  16.  
  17.     public static Result success() {
  18.         return new Result(Constants.CODE_200, "", null);
  19.     }
  20.  
  21.     public static Result success(Object data) {
  22.         return new Result(Constants.CODE_200, "", data);
  23.     }
  24.  
  25.     public static Result error(String code, String msg) {
  26.         return new Result(code, msg, null);
  27.     }
  28.  
  29.     public static Result error() {
  30.         return new Result(Constants.CODE_500, "系统错误", null);
  31.     }
  32.  
  33. }

ServiceException.java（自定义业务异常）

  1. import lombok.Getter;
  2.  
  3. /**
  4.  * 自定义异常
  5.  */
  6. @Getter
  7. public class ServiceException extends RuntimeException {
  8.     private String code;
  9.  
  10.     public ServiceException(String code, String msg) {
  11.         super(msg);
  12.         this.code = code;
  13.     }
  14.  
  15. }

GlobalExceptionHandler.java

  1. import com.example.springboot.common.Result;
  2. import org.springframework.web.bind.annotation.ControllerAdvice;
  3. import org.springframework.web.bind.annotation.ExceptionHandler;
  4. import org.springframework.web.bind.annotation.ResponseBody;
  5.  
  6. @ControllerAdvice
  7. public class GlobalExceptionHandler {
  8.  
  9.     /**
  10.      * 如果抛出的的是ServiceException，则调用该方法
  11.      * @param se 业务异常
  12.      * @return Result
  13.      */
  14.     @ExceptionHandler(ServiceException.class)
  15.     @ResponseBody
  16.     public Result handle(ServiceException se){
  17.         return Result.error(se.getCode(), se.getMessage());
  18.     }
  19.  
  20. }

头像，昵称功能实现：

Header.vue

  1. <div style="display: inline-block">
  2.         <img :src="user.avatarUrl" referrerpolicy="no-referrer" alt=""
  3.              style="width: 30px; border-radius: 50%; position: relative; top: 10px; right: 5px">
  4.         <span>{{ user.nickname }}</span><i class="el-icon-arrow-down" style="margin-left: 5px"></i>
  5.       </div>

UserDto

  1. @Data
  2. public class UserDto {
  3.  
  4.     private String username;
  5.  
  6.     private String password;
  7.  
  8.     @Alias("nickname")
  9.     private String nickname;
  10.  
  11.     private String avatarUrl;
  12. }

四、个人信息页面显示

Person.vue

  1. <template>
  2.   <el-card style="width: 500px;">
  3.     <el-form label-width="80px" size="small">
  4.       <el-form-item label="用户名">
  5.         <el-input v-model="form.username" autocomplete="off"></el-input>
  6.       </el-form-item>
  7.       <el-form-item label="昵称">
  8.         <el-input v-model="form.nickname" autocomplete="off"></el-input>
  9.       </el-form-item>
  10.       <el-form-item label="邮箱">
  11.         <el-input v-model="form.email" autocomplete="off"></el-input>
  12.       </el-form-item>
  13.       <el-form-item label="电话">
  14.         <el-input v-model="form.phone" autocomplete="off"></el-input>
  15.       </el-form-item>
  16.       <el-form-item label="地址">
  17.         <el-input v-model="form.address" autocomplete="off"></el-input>
  18.       </el-form-item>
  19.       <el-form-item>
  20.         <el-button type="primary" @click="save">确 定</el-button>
  21.       </el-form-item>
  22.     </el-form>
  23.   </el-card>
  24. </template>
  25.  
  26. <script>
  27. export default {
  28.   name: "Person",
  29.   data() {
  30.     return {
  31.       form: {},
  32.       user: localStorage.getItem("user") ? JSON.parse(localStorage.getItem("user")) : {}
  33.     }
  34.   },
  35.   created() {
  36.     this.request.get("user/findUserName/" + this.user.username).then(res => {
  37.       if (res.code === '200') {
  38.         this.form = res.data
  39.       }
  40.     })
  41.   },
  42.   methods: {
  43.     save() {
  44.       this.request.post("/user/saveUser", this.form).then(res => {
  45.         if (res.data) {
  46.           this.$message.success("保存成功")
  47.         } else {
  48.           this.$message.error("保存失败")
  49.         }
  50.       })
  51.     },
  52.   }
  53. }
  54. </script>
  55.  
  56. <style>
  57.  
  58. </style>

UserController

  1.  @GetMapping("/findUserName/{username}")
  2.     public Result findByName(@PathVariable String username){
  3.         QueryWrapper<User> queryWrapper = new QueryWrapper<>();
  4.         queryWrapper.eq("username",username);
  5.         return Result.success(userService.getOne(queryWrapper));
  6.     }

用result封装方法

UserController

  1.  
  2.  
  3. import cn.hutool.core.collection.CollUtil;
  4. import cn.hutool.core.util.StrUtil;
  5. import cn.hutool.poi.excel.ExcelReader;
  6. import cn.hutool.poi.excel.ExcelUtil;
  7. import cn.hutool.poi.excel.ExcelWriter;
  8. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  9. import com.baomidou.mybatisplus.core.metadata.IPage;
  10. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  11. import com.example.springboot.common.Constants;
  12. import com.example.springboot.common.Result;
  13. import com.example.springboot.entity.User;
  14. import com.example.springboot.entity.dto.UserDto;
  15. import com.example.springboot.service.UserService;
  16. import org.springframework.web.bind.annotation.*;
  17. import org.springframework.web.multipart.MultipartFile;
  18.  
  19. import javax.annotation.Resource;
  20. import javax.servlet.ServletOutputStream;
  21. import javax.servlet.http.HttpServletResponse;
  22. import java.io.InputStream;
  23. import java.net.URLEncoder;
  24. import java.util.List;
  25.  
  26. import static com.example.springboot.common.Result.success;
  27.  
  28. @RestController
  29. @RequestMapping("/user")
  30. public class UserController {
  31.  
  32.     @Resource
  33.     private UserService userService;
  34.  
  35.     @GetMapping("/findUserName/{username}")
  36.     public Result findByName(@PathVariable String username){
  37.         QueryWrapper<User> queryWrapper = new QueryWrapper<>();
  38.         queryWrapper.eq("username",username);
  39.         return Result.success(userService.getOne(queryWrapper));
  40.     }
  41.  
  42.     //登录
  43.     @PostMapping("/login")
  44.     public Result login(@RequestBody UserDto userDto) {
  45.         String username = userDto.getUsername();
  46.         String password = userDto.getPassword();
  47.         if (StrUtil.isBlank(username) || StrUtil.isBlank(password)) {
  48.             return Result.error(Constants.CODE_400, "系统错误");
  49.         }
  50.         UserDto dto = userService.login(userDto);
  51.         return success(dto);
  52.     }
  53.  
  54.     //注册
  55.     @PostMapping("/register")
  56.     public Result register(@RequestBody UserDto userDto) {
  57.         String username = userDto.getUsername();
  58.         String password = userDto.getPassword();
  59.         if (StrUtil.isBlank(username) || StrUtil.isBlank(password)) {
  60.             return Result.error(Constants.CODE_400, "系统错误");
  61.         }
  62.         return success(userService.register(userDto));
  63.     }
  64.  
  65.     //导入
  66.     @PostMapping("/import")
  67.     public Result imp(MultipartFile file) throws Exception {
  68.         InputStream inputStream = file.getInputStream();
  69.         ExcelReader reader = ExcelUtil.getReader(inputStream);
  70.         //方式1(推荐) 通过javabean的方式读取Excel内的对象 但是要求表头必须是英文，跟javabean的属性要对应起来
  71.         /*List<User> list = reader.readAll(User.class);*/
  72.         //方式二:忽略表头的中文 直接读取表内容
  73.         List<List<Object>> list = reader.read(1);
  74.         List<User> users = CollUtil.newArrayList();
  75.         for (List<Object> row : list) {
  76.             User user = new User();
  77.             user.setUsername(row.get(0).toString());
  78.             user.setPassword(row.get(1).toString());
  79.             user.setNickname(row.get(2).toString());
  80.             user.setEmail(row.get(3).toString());
  81.             user.setPhone(row.get(4).toString());
  82.             user.setAddress(row.get(5).toString());
  83.             user.setAvatarUrl(row.get(6).toString());
  84.             users.add(user);
  85.         }
  86.         userService.saveBatch(users);
  87.         return success(true);
  88.     }
  89.  
  90.     //导出
  91.     @GetMapping("/export")
  92.     public Result export(HttpServletResponse response) throws Exception {
  93.         //从数据库查询出所有数据
  94.         List<User> list = userService.list();
  95.         //通过工具类创建writer写出到磁盘路径
  96.         /*ExcelWriter writer = ExcelUtil.getWriter(filesUploadPath+"/用户信息.xlsx");*/
  97.         //在内存操作，写出到浏览器
  98.         ExcelWriter writer = ExcelUtil.getWriter(true);
  99.         //自定义标签别名
  100.         writer.addHeaderAlias("username", "用户名");
  101.         writer.addHeaderAlias("password", "密码");
  102.         writer.addHeaderAlias("nickname", "昵称");
  103.         writer.addHeaderAlias("email", "邮箱");
  104.         writer.addHeaderAlias("phone", "电话");
  105.         writer.addHeaderAlias("address", "地址");
  106.         writer.addHeaderAlias("createTime", "创建时间");
  107.         writer.addHeaderAlias("avatarUrl", "头像");
  108.  
  109.         //一次性写出list内的对象到excel。使用默认样式，强制输出标题
  110.         writer.write(list, true);
  111.  
  112.         //响应浏览器响应的格式
  113.         response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8");
  114.         String fileName = URLEncoder.encode("用户信息", "UTF-8");
  115.         response.setHeader("Content-Disposition", "attachment;filename=" + fileName + ".xlsx");
  116.  
  117.         ServletOutputStream out = response.getOutputStream();
  118.         writer.flush(out, true);
  119.         out.close();
  120.         writer.close();
  121.         return Result.success();
  122.     }
  123.  
  124.     //修改或增加
  125.     @PostMapping("/saveUser")
  126.     public Result saveUser(@RequestBody User user) {
  127.         //新增或修改
  128.         return success(userService.saveOrUpdate(user));
  129.     }
  130.  
  131.     @GetMapping("/findAll")
  132.     public Result findAll() {
  133.         return success(userService.list());
  134.     }
  135.  
  136.     @DeleteMapping("/{id}")
  137.     public Result delete(@PathVariable("id") Integer id) {
  138.         return success(userService.removeById(id));
  139.     }
  140.  
  141.     //批量删除
  142.     @PostMapping("/del/batch")
  143.     public Result deleteBatch(@RequestBody List<Integer> ids) {
  144.         return success(userService.removeBatchByIds(ids));
  145.     }
  146.  
  147.     //分页查询
  148.     //接口路径 /user/selectPage?pageNum = 1 &pageSize = 10
  149.     //@RequestParam 接收
  150.     //limit第一个参数 = (pageNum - 1)*pageSize
  151.     //pageSize
  152.    /* @GetMapping("/selectPage")
  153.     public Map<String, Object> selectPage(@RequestParam String username, @RequestParam Integer pageSize, @RequestParam Integer pageNum) {
  154.         pageNum = (pageNum - 1) * pageSize;
  155.         username = "%" + username + "%";
  156.         List<User> data = userService.selectPage(pageNum, pageSize, username);
  157.         Integer total = userService.selectTotal(username);
  158.         Map<String, Object> res = new HashMap<>();
  159.         res.put("data", data);
  160.         res.put("total", total);
  161.         return res;
  162.     }*/
  163.  
  164.     //分页查询 mybatis-plus方式
  165.     @GetMapping("/selectPage")
  166.     public Result selectPage(@RequestParam(defaultValue = "") String username,
  167.                                   @RequestParam Integer pageSize,
  168.                                   @RequestParam Integer pageNum,
  169.                                   @RequestParam(defaultValue = "") String email,
  170.                                   @RequestParam(defaultValue = "") String address) {
  171.  
  172.         IPage<User> page = new Page<>(pageNum, pageSize);
  173.         QueryWrapper<User> queryWrapper = new QueryWrapper<>();
  174.         if (!"".equals(username)) {
  175.             queryWrapper.like("username", username);
  176.         }
  177.         if (!"".equals(email)) {
  178.             queryWrapper.like("email", email);
  179.  
  180.         }
  181.         if (!"".equals(address)) {
  182.             queryWrapper.like("address", address);
  183.         }
  184.         queryWrapper.orderByDesc("id");
  185.         return success(userService.page(page, queryWrapper));
  186.     }
  187. }

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/我家小花儿/article/detail/393427
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号