SpringBoot整合MyBatis的代码详解

            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            1.3.2
        
        
            mysql
            mysql-connector-java
        
        
            org.projectlombok
            lombok
            1.18.12
            provided
        
        
            com.alibaba
            druid
            1.2.1
        
        
            org.mybatis
            mybatis
            3.4.6
        

@Mapper
@Repository
public interface UserLoginMapper {
    //查询
    public List queryAll();
    //添加数据
    public int add(User user);
    //根据用户名查询数据
    public User queryByName(String name);

}

    
        select * from student
    
    
        insert into student values (#{name},#{password})
    
    
        select * from student where name = #{name}
    

#配置mapper
mybatis.mapper-locations=classpath:mapper/*.xml 
mybatis.type-aliases-package=com.example.springbootdemo03.mapper

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/mysql1?serverTimezone=GMT%2B8&useSSL=true
    username: root
    password: 密码
  jdbc:
    template:
      query-timeout: 3

@AllArgsConstructor
@NoArgsConstructor
@Data
public class User {
    private Integer id;
    private String name;
    private  String password;
    private String sex;
    private String fullName;
    private String email;
}

public interface UserLogin {
    /**
     *查询用户名是否存在
     */
    public Boolean IsExit(String name);
    /**
     * 判断账号密码是否存在
     * @param name
     * @return
     */
    public User Login(String name);
}

@Service
public class UserLoginImpl implements UserLogin {
    //自动注入UserLoginMapper
    @Autowired
    UserLoginMapper userLoginMapper;

    @Override
    public Boolean IsExit(String name){
        if(userLoginMapper.queryByName(name) == null){
            return false;
        }else return true;
    }
    @Override
    public User Login(String name) {
        User user = userLoginMapper.queryByName(name);
        return user;
    }
}

@Autowired
    UserLogin userLogin;
    @GetMapping(value = {\"/\",\"/login\"})
    public String Index(){
        return \"login\";
    }
    @GetMapping(\"main.html\")
    public String Main(){
        return \"index\";
    }
    @PostMapping(\"/login\")
    public String Login(User user, HttpSession session, Model model){
        if(!userLogin.IsExit(user.getName())){
            session.setAttribute(\"msg\", \"登录失败\");
            return \"redirect:/login\";
        }
        User login = userLogin.Login(user.getName());
        if(user.getName().equals(login.getName()) && user.getPassword().equals(login.getPassword())){
            session.setAttribute(\"loginUser\",user);
            return \"redirect:/main.html\";
        }
        else {
            session.setAttribute(\"msg\", \"登录失败\");
            return \"redirect:/login\";
        }
    }