SpringBoot整合MyBatis
1、引入依赖文件
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.2</version>
</dependency>
2、配置Druid数据源
见整合druid
3、建表
建表方式多样,以下方式仅为其中一种
3.1放入sql文件
3.2、在yml文件中配置
spring:
#指定建表sql文件的位置
schema:
- classpath:sql/department.sql
- classpath:sql/employee.sql
3.3、创建实体类
public class Department {
private Integer id;
private String departmentName;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getDepartmentName() {
return departmentName;
}
public void setDepartmentName(String departmentName) {
this.departmentName = departmentName;
}
}
4、使用myBatis
4.1使用注解
4.1.1新建Mapper接口类
//指定这是一个操作数据库的mapper
@Mapper
public interface DepartmentMapper {
@Select("select * from department where id = #{id}")
public Department getDeptById(Integer id);
@Delete("delete from department where id = #{id}")
public int deletdDeptById(Integer id);
//使用数据库自动生成的主键,并声明那个是主键
@Options(useGeneratedKeys = true,keyProperty = "id")
@Insert("insert into department(departmentName) values(#{departmentName})")
public int insertDept(Department department);
@Update("update department set departmentName = #{departmentNAme} where id = #{id}")
public int updateDept(Department department);
}
4.1.2、新建controller并访问
@RestController
public class DeptController {
@Autowired
DepartmentMapper departmentMapper;
@GetMapping("/dept/{id}")
public Department getDepartment(@PathVariable("id") Integer id){
return departmentMapper.getDeptById(id);
}
@GetMapping("/dept")
public Department insertDept(Department department){
departmentMapper.insertDept(department);
return department;
}
}
4.2使用配置文件
在yml配置文件中
mybatis:
config-location: classpath:mybatis/mybatis-config.xml 指定全局配置文件的位置
mapper-locations: classpath:mybatis/mapper/*.xml 指定sql映射文件的位置
4.3配置MyBatis
@org.springframework.context.annotation.Configuration
public class MyBatisConfig {
@Bean
public ConfigurationCustomizer configurationCustomizer() {
return new ConfigurationCustomizer() {
//开启MyBatis驼峰命名法
@Override
public void customize(Configuration configuration) {
configuration.setMapUnderscoreToCamelCase(true);
}
};
}
}
4.4、使用MapperScan
//指定批量扫描mapper文件的地址,此时mpper文件可以不用写@Mapper注解
@MapperScan(value = "com.mrw.mybatis.mapper")
@SpringBootApplication
public class MybatisApplication {
public static void main(String[] args) {
SpringApplication.run(MybatisApplication.class, args);
System.out.println("启动成功");
}
}