基于Springboot-Maven-Mybatis的demo简单使用

选择五个依赖项

配置maven路径

 修改配置文件

配置文件代码块

#web端口
server:
  port: 8888
#数据库配置
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/wms?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: 123456
#mybatis-plus打印日志
mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

Logging:
  level:
    com.wms: debug

建三层架构

mapper层

service层

controller层

 

 until包里面 需要配置文件

package org.lanqiao.until;


import com.fasterxml.jackson.annotation.JsonInclude;
import lombok.Data;

/**
 * @Data注释  可以省去get set'方法
 */
@Data
public class CommonResult {
    private boolean flag;
    private String message;
    private Object data;


    //成功方法
    public static CommonResult success(String message, Object data) {
        return new CommonResult(true, message, data);
    }

    //重载
    public static CommonResult success(String message) {
        return new CommonResult(true, message, null);
    }

    //失败方法
    public static CommonResult failure(String message, Object data) {
        return new CommonResult(false, message, data);
    }

    public static CommonResult failure(String message) {
        return new CommonResult(false, message, null);
    }

    public CommonResult() {
    }

    public CommonResult(boolean flag, String message, Object data) {
        this.flag = flag;
        this.message = message;
        this.data = data;
    }

    public boolean isFlag() {
        return flag;
    }

    public void setFlag(boolean flag) {
        this.flag = flag;
    }

    public String getMessage() {
        return message;
    }

    public void setMessage(String message) {
        this.message = message;
    }

    public Object getData() {
        return data;
    }

    public void setData(Object data) {
        this.data = data;
    }
}

需要在entity实体类中构建User用户类

package org.lanqiao.demo.entity;

import lombok.Data;

/**
 * @Data注释 不用写get set方法
 */
@Data
public class User {
    private int Uid;
    private String Name;
    private String Password;
    private String Email;
    private String Username;
}

实现登录功能

在UserDao层创建一个接口

在Dao层处理数据库

package org.lanqiao.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.lanqiao.entity.User;

/**
 * 使用位置：适用在 类 接口 枚举 上
 * 描述：进行类的映射
 */
@Mapper
public interface UserDao {
    /**
     * 登陆查询  验证用户
     * @param user
     * @return
     */
    @Select("select * from users where Name = #{name} and Password = #{password}")
    User checkuser(User user);
}