1.新建项目
勾上这三项
ps:如果不建站的话spring Web可以不选
2.创建一个mysql库
新建一个数据库用来测试:
数据库名:ssm_db
端口:3306
username:root
password:123456
新建一个表:
表名:book
两个字段:id,title
3.编辑application.yml配置文件
加入如下内容
# 数据库相关配置
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/ssm_db
username: root
password: 123456
4.新增dao和domain
内容如下:
domain.Book
package com.cxstar.domain;
public class Book {
public Integer getId() {
return id;
}
@Override
public String toString() {
return "Book{" +
"id=" + id +
", title='" + title + '\'' +
'}';
}
public void setId(Integer id) {
this.id = id;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
private Integer id;
private String title;
}
dao.BookDao
package com.cxstar.dao;
import com.cxstar.domain.Book;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
@Mapper
public interface BookDao {
@Select("Select * From book Where id = #{id}")
public Book getById(Integer id);
}
5.测试结果
MybatisSpringBootTestApplicationTests中加入测试代码
package com.cxstar;
import com.cxstar.dao.BookDao;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
@SpringBootTest
class MybatisSpringBootTestApplicationTests {
@Autowired
private BookDao bookDao;
@Test
void contextLoads() {
System.out.println(bookDao.getById(114));
}
}
结果如下: