SpringBoot整合MyBatis

springboot整合mybatis小案例

1.导入相关依赖

<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

        <!--freemarker支持-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-freemarker</artifactId>
        </dependency>

        <!-- mysql驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

        <!--整合mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>

2.application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/bookshop
spring.datasource.username=root
spring.datasource.password=123
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

3.entity层

public class Book {

    private Integer bookid;

    private String bookname;

    private Integer bookprice;

   
}

4.mapper层

public interface BookMapper {

    @Select("select * from book where bookname=#{bookname}")
    public Book findByName(@Param("bookname") String bookname);

    @Insert("insert into book(bookname,bookprice) values (#{bookname},#{bookprice})")
    public int insertBook(@Param("bookname") String bookname,@Param("bookprice") Double bookprice);
}

5.controller层 

@RestController
public class BookController {
    @Autowired
    private BookMapper bookMapper;

    @RequestMapping("findByName")
    public Object findByName(String bookname){
        return bookMapper.findByName(bookname);
    }

    @RequestMapping("insert")
    public String insert(String bookname,Double bookprice){
        bookMapper.insertBook(bookname,bookprice);
        return "success";
    }

 6.启动类上加入  @MapperScan(basePackages = {"cn.happy.mapper"})  扫描mapper包下文件

 

@RestController和@Controller的区别

@RestController注解相当于@ResponseBody ＋ @Controller合在一起的作用。

1)如果只是使用@RestController注解Controller，则Controller中的方法无法返回jsp页面，配置的视图解析器InternalResourceViewResolver不起作用，返回的内容就是Return 里的内容。

例如：本来应该到success.jsp页面的，则其显示success.

 

2)如果需要返回到指定页面，则需要用 @Controller配合视图解析器InternalResourceViewResolver才行。
3)如果需要返回JSON，XML或自定义mediaType内容到页面，则需要在对应的方法上加上@ResponseBody注解。

 

7.启动项目

查询指定图书

 

 

 添加图书