1.新建项目
2.可以运行测试下
运行->
3.在pom.xml中加入依赖
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
4.创建实体类包-entity
在里面创建Student类
里面根据数据库设置内容
springboot~Integer和int如何选择,Integer的意义何在 - 张占岭 - 博客园 (cnblogs.com)
可以重新toString 等下测试可以用
package com.example.com_connectmysql_demo.entity;
public class Sdtuent {
private Integer id;
private String name;
private Integer age;
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 Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
@Override
public String toString() {
return "Sdtuent{" +
"id=" + id +
", name='" + name + '\'' +
", age=" + age +
'}';
}
}
5.创建Mapper包 注:注意加@Mapper @Param(“id”)
6.然后resources下新建mapper文件夹利用MybatisX插件自动生成xml
select * from Student where id = #{id}
7.创建service包 里面新建StudentService接口
8.在service包内新建实现类包impl 内新建StudentServiceImpl
注意注解不要省略
@Service(“impl1”)
@Atutowired
9.在Application加入扫描Mapper 接口 @MapperScan
@MapperScan("com.example.demo.mapper ")
10.在StudentController中加入测试用方法
@Autowired
@Qualifier("impl1")
private StudentService studentService;
@RequestMapping(value="/hello")
public @ResponseBody String hello(){
return "Hello!";
}
@RequestMapping(value="/findstudentbyid")
public @ResponseBody String findStudentById(Integer id){
Student student = studentService.findStudentById(id);
return student.toString();
}
11.配置文件:
server.port=8080
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/School?useSSL=false
spring.datasource.username=root
spring.datasource.password=123456
#mybatis的相关配置
mybatis.mapper-locations=classpath:mapper/*.xml
#mapper配置文件
mybatis.type-aliases-package=com.example.demo.entity
#开启驼峰命名
mybatis.configuration.map-underscore-to-camel-case=true
12.测试:
参考文档: