bug解决：无法引入org.apache.ibatis.annotations.Select

<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>1.3.2</version>
</dependency>

2.@Select标签的方式搭建SpringBoot的Mybatis框架

  xml搭建SpringBoot的Mybatis框架

package com.wl.course.dao;

import com.wl.course.model.User;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Author: wl
 * @Description:
 * @DateTime: 2020/5/7 9:51
 * @Params:
 * @Return
 */
public interface UserMapper {

    void deleteUser(Long id);

    @Select("select * from user where id = #{id}")
    @Results({
            @Result(property = "username", column = "username"),
            @Result(property = "password", column = "password")
    })
    User getUser(Long id);

    @Select("select * from user where id = #{id} and username=#{name}")
    User getUserByIdAndName(@Param("id") Long id, @Param("name") String username);

    @Select("select * from user")
    List<User> getAll();

    // 使用xml方式
    User getUserByName(String username);

}

 

2.@RestController这个是ResponseBody和Controller的集合，意思是return的数据都变成json的格式，返回到前端，不会跳转界面

如果想跳转页面的话，就需要把RestController改成Controller，就会跳转页面了。

    @GetMapping("/getBlogger")
    public String getBlogger(Model model) {
        Blogger blogger = new Blogger(1L, "wl", "123456");
        model.addAttribute("blogger", blogger);
        return "blogger";
    }