瑞吉外卖 1-12 oneday

最新推荐文章于 2024-06-22 15:26:37 发布

佛怒火莲AUX

最新推荐文章于 2024-06-22 15:26:37 发布

阅读量280

点赞数

文章标签：数据库 java mybatis spring boot

本文链接：https://blog.csdn.net/m0_56310654/article/details/126825038

版权

创建数据库 reggle

运行sql文件导入数据库

2.导入 pom.xml和application.yml文件、

3.在resources中的static包中导入前端文件

(1).backend

(2).front

4.设置静态资源映射

如果前端文件不放在 static 可以设置资源映射（一般可以省略）

@Configuration              //告诉SpringBoot 这是一个配置类
@Slf4j
public class WebMVCConfig extends WebMvcConfigurationSupport {
    /**
     *
     * 设置静态资源映射
     */
    @Override
    protected void addResourceHandlers(ResourceHandlerRegistry registry) {
        log.info("开始静态资源映射");
        registry.addResourceHandler("/backend/**").addResourceLocations("classpath:/backend/");
        registry.addResourceHandler("/front/**").addResourceLocations("classpath:/front/");
    }

}

设置完成之后工程可以运行啦！！！！

5.封装全局输出类 R

package com.itheima.reggle.common;

import lombok.Data;
import java.util.HashMap;
import java.util.Map;

/**
*
* 通用结果返回类服务器相应的数据封装成此对象
*
* @param <T>
*/
@Data
public class R<T> {

    private Integer code; //编码：1成功，0和其它数字为失败

    private String msg; //错误信息

    private T data; //数据

    private Map map = new HashMap(); //动态数据

    public static <T> R<T> success(T object) {
        R<T> r = new R<T>();
        r.data = object;
        r.code = 1;
        return r;
    }

    public static <T> R<T> error(String msg) {
        R r = new R();
        r.msg = msg;
        r.code = 0;
        return r;
    }

    public R<T> add(String key, Object value) {
        this.map.put(key, value);
        return this;
    }

}

6.完成登录功能

.用mybatisx 快速生成代码完成 service imp entity mapper 模块

(2).创建 controller包创建EmployeeController

@Slf4j
@RestController
@RequestMapping("/employee")
public class EmployeeController {

    @Autowired
    private EmployeeService employeeService;
@PostMapping("/login")
public R<Employee> login(HttpServletRequest request, @RequestBody Employee employee){
    /**
     * 员工登录
     *
     */
    // 1.md5加密
    String password = employee.getPassword();
    password = DigestUtils.md5DigestAsHex(password.getBytes());

    //2.根据用户名查询数据库
    LambdaQueryWrapper<Employee> queryWrapper = new LambdaQueryWrapper<>();
    queryWrapper.eq(Employee::getUsername,employee.getUsername());
     Employee emp = employeeService.getOne(queryWrapper);
    //3.如果没有查到则返回失败
    if (emp == null){
        return R.error("查询失败");
    }
    //4.密码对比如果不一致返回失败结果
    if(emp.getPassword().equals(password)){

        return R.error("密码错误");
    }

    //5.查看员工状态如果禁用状态则返回员工已经警用

    if (emp.getStatus() == 0){
        return R.error("账号禁用");
    }

    //6.登录成功

    request.getSession().setAttribute("employee",emp.getId());
    return R.success(emp);
};

}

7.完成退出功能

（1）. 代码

  /**
     *
     * 员工退出
     * @param request
     * @return
     */
    @PostMapping("/logout")
public R<String> logout(HttpServletRequest request){
  //清理当前session员工登录的id
        request.getSession().removeAttribute("employee");
        return R.success("退出成功");
};

原理:

清除保存到session中的用户数据直接返回到登录界面

7. 解决可直接跳过登陆界面问题

(1).新建filter 包完成过滤

@Slf4j
/**
*
* 检测用户是否登录
*/
@WebFilter(filterName = "LoginCheckFilter",urlPatterns = "/*")
public class LoginCheckFilter implements Filter {
    //路径匹配器，支持通配符
    public static final AntPathMatcher PATH_MATCHER = new AntPathMatcher();

    @Override
    public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {

        HttpServletRequest request = (HttpServletRequest) servletRequest;
        HttpServletResponse response = (HttpServletResponse) servletResponse;
        //1.获取本次请求的url

        String requestURI = request.getRequestURI();
        //定义不需要处理的路径
        String[] urls = new String[]{
                "/employee/login",
                "/employee/logout",
                "/backend/**",
                "/front/**"
        };

        //2.判断登陆状态请求是否要处理
      boolean check = check(urls,requestURI);

        //3.不需要处理放行

        if (check) {
            filterChain.doFilter(request,response);
            return;
        }
        //4.判断登录状态已登录则放行

       if( request.getSession().getAttribute("employee") != null){
           filterChain.doFilter(request,response);
           return;
       }

        //5.如果未登录则返回未登录结果通过输出流响应数据
        response.getWriter().write(JSON.toJSONString(R.error("NOTLOGIN")));
         return;

    }

    /**
     * 判断是否要处理
     * @param requestURI
     * @return
     */
    public boolean check(String[] urls,String requestURI){
      for (String url:urls){
      Boolean match = PATH_MATCHER.match(url,requestURI);
      if (match){
          return true;
            }
       }
      return false;
    };

}

8.完成添加员工功能

/**
* 新增员工
* @param employee
* @return
*/
@PostMapping
public R<String> save(HttpServletRequest request, @RequestBody Employee employee){
    log.info("新增员工,员工信息:{}",employee.toString());

    employee.setPassword(DigestUtils.md5DigestAsHex("12345".getBytes()));
    employee.setCreateTime(new Date());
    employee.setUpdateTime(new Date());

    Long empId = (Long) request.getSession().getAttribute("employee");
    employee.setCreateUser(empId);
    employee.setUpdateUser(empId);

    employeeService.save(employee);
    return R.success("新增成功");
}

9.解决相同账号问题

定义全局异常处理

@Slf4j
/**
* 全局异常处理
*/
@ControllerAdvice(annotations = {RestController.class, Controller.class})
@ResponseBody

public class GlobalExceptionHandler {
    /**
     * 异常处理
     * @return
     */
    @ExceptionHandler(SQLIntegrityConstraintViolationException.class)
    public R<String> exceptionHandler(SQLIntegrityConstraintViolationException ex){
        if(ex.getMessage().contains("Duplicate entry")){
        String[] split = ex.getMessage().split(" ") ;
        String msg = split[2]+"已经存在";
        return R.error(msg);
        }
        return R.error("未知错误");
    }
}

10.员工信息分类查询

使用 mybatisplus 内置的分页插件

新建 mybatisPlusConfig

/**
* 分页插件
* mybatisPlus
*/
@Configuration
public class mybatisPlusConfig {
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor(){
     MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
        mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor());
        return mybatisPlusInterceptor;
    }
}

实现分页功能

/**
* 员工信息分页查询
* @param page
* @param pageSize
* @param name             //实现搜索的功能
* @return
*/
@GetMapping("/page")
public R<Page> page(int page,int pageSize,String name){
    log.info("page = {},pageSize = {}，name = {}",page,pageSize,name);
    //构建分页构造器
    Page pageInfo = new Page(page,pageSize);
    //条件构造器
    LambdaQueryWrapper<Employee> queryWrapper = new LambdaQueryWrapper();
    //添加过滤条件
    queryWrapper.like(!StringUtils.isEmpty(name),Employee::getName,name);
    queryWrapper.orderByAsc(Employee::getUpdateTime);
    //执行查询
    employeeService.page(pageInfo,queryWrapper);

    return R.success(pageInfo) ;
}

11. 根据id修改员工信息

（1）.功能代码

/**
* 根据id修改员工信息
* @param employee
* @return
*/
@PutMapping
public R<String> update(HttpServletRequest request,@RequestBody Employee employee){
    Long empId = (Long) request.getSession().getAttribute("employee");
    employee.setUpdateTime(new Date());
    employee.setUpdateUser(empId);
    employeeService.updateById(employee);
    return R.success("员工信息修改成功");
}