一篇文章带你掌握主流办公框架——SpringBoot( 九 ) _生活百科

创建与数据库相同的实体类

package com.itheima.domain;public class Book {private Integer id;private String name;private String type;private String description;@Overridepublic String toString() {return "Book{" +"id=" + id +", name='" + name + '\'' +", type='" + type + '\'' +", description='" + description + '\'' +'}';}public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getType() {return type;}public void setType(String type) {this.type = type;}public String getDescription() {return description;}public void setDescription(String description) {this.description = description;}}

数据层实现

package com.itheima.dao;import com.itheima.domain.Book;import org.apache.ibatis.annotations.Mapper;import org.apache.ibatis.annotations.Select;// 注意：我们SpringBoot整合中的SpringConfig已经被省略，所以我们的JdbcConfig和MyBatisConfig配置类不用配置// JdbcConfig主要用于配置DataSource，我们将会在yaml配置文件中配置// MyBatisConfig配置sqlSessionFactoryBean，大部分属于固定代码，唯一的变量setTypeAliasesPackage我们选择设置整个代码包// MyBatisConfig配置MapperScannerConfigurer映射地址，我们选择在dao数据层采用@Mapper来代替操作@Mapperpublic interface BookDao {@Select("select * from tbl_book where id = #{id}")public Book getById(Integer id);}

配置数据库关联

# 直接配置datasource即可spring:datasource:driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://localhost:3306/ssm_db?serverTimezone=UTCusername: rootpassword: roottype: com.alibaba.druid.pool.DruidDataSource

启动服务器即可

package com.itheima;import org.springframework.boot.SpringApplication;import org.springframework.boot.autoconfigure.SpringBootApplication;@SpringBootApplicationpublic class Springboot08MybatisApplication {	public static void main(String[] args) {SpringApplication.run(Springboot08MybatisApplication.class, args);	}}

简单测试

package com.itheima;import com.itheima.dao.BookDao;import com.itheima.domain.Book;import org.junit.jupiter.api.Test;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.boot.test.context.SpringBootTest;@SpringBootTestclass Springboot08MybatisApplicationTests {	@Autowired	private BookDao bookDao;	@Test	void testGetById() {Book book = bookDao.getById(1);System.out.println(book);	}}

整合SSM我们SpringBoot的最后课程就是用来整合SSM
我们同样采用和之前SSM案例整合的代码对比来介绍SpringBoot的SSM整合
Spring整合SSM我们先给出之前SSM整合的大致框架：