Spring Boot 整合Mybatis Annotation

和上一章一样创建一个Spring Boot项目

修改application.yml

server:
  port: 8099
spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/springboot?useUnicode=true&&characterEncoding=utf8
    username: root
    password: u2tc7c/F8N31S
mybatis:
  type-aliases-package: com.wya.springboot.entity
  

创建实体类、Mapper接口、业务层、Controller层

Mapper接口代码

public interface StudentMapper {

	@Select("select * from t_student")
	@Results({
		@Result(property="studentId",column="student_id"),
		@Result(property="studentName",column="student_name"),
		@Result(property="studentAge",column="student_age")
	})
	List<Student> findAll();
	
	@Select("select * from t_student where student_id = #{id}")
	@Results({
		@Result(property="studentId",column="student_id"),
		@Result(property="studentName",column="student_name"),
		@Result(property="studentAge",column="student_age")
	})
	Student findById(Integer id);
}

Controller层代码

@RestController
public class StudentController {

	@Resource
	private StudentService studentService;
	
	@GetMapping("student")
	public List<Student> findAll(){
		return this.studentService.findAll();
	}
	
	@GetMapping("student/{id}")
	public Student findById(@PathVariable("id") Integer id){
		return this.studentService.findById(id);
	}
	
}

启动应用类代码

@SpringBootApplication
@MapperScan("com.wya.springboot.dao")
public class SpringbootMybatisAnnotationApplication {

	public static void main(String[] args) {
		SpringApplication.run(SpringbootMybatisAnnotationApplication.class, args);
	}
}

启动应用