Spring 全家桶之 Spring Boot 2.6.4（四）- Data Access（Part B MyBatis）

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.2.8</version>
</dependency>
复制代码

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for employee
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lastName` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `gender` int(2) DEFAULT NULL,
  `d_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
复制代码

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `departmentName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
复制代码

@Data
public class Employee {
    private Integer id;
    private String lastName;
    private String email;
    private Integer gender;
    private Integer dId;
}
复制代码

@Data
public class Department {
    private Integer id;
    private String departmentName;
}
复制代码

@Configuration
public class LilithDataSourceInitializer {
    @Value("classpath:employee.sql")
    private Resource employee;
    @Value("classpath:department.sql")
    private Resource department;
    @Bean
    public DataSourceInitializer dataSourceInitializer(final DataSource dataSource){
        final DataSourceInitializer initializer = new DataSourceInitializer();
        initializer.setDataSource(dataSource);
        initializer.setDatabasePopulator(databasePopulator());
        return initializer;
    }
    private DatabasePopulator databasePopulator(){
        final ResourceDatabasePopulator populator = new ResourceDatabasePopulator();
        populator.addScripts(employee,department);
        return populator;
    }
}
复制代码

@Mapper
public interface DepartmentMapper {
    @Select("SELECT * FROM department WHERE id = #{id}")
    Department selectOneById(Integer id);
    @Delete("DELETE FROM department WHERE id = #{id}")
    void deleteOneById(Integer id);
    @Insert("INSERT INTO department (department_name) VALUES (#{departmentName})")
    void insert(Department department);
    @Update("UPDATE department SET department_name = #{departmentName} where id = #{departmentId}")
    void update(Department department);
}
复制代码

@SpringBootTest
public class DepartmentMapperTest {
    @Resource
    private DepartmentMapper departmentMapper;
    @Test
    public void selectOneById() {
        Department department = departmentMapper.selectOneById(1);
        System.out.println(department);
    }
    @Test
    public void insert() {
        Department department = new Department();
        department.setDepartmentName("Avengers");
        departmentMapper.insert(department);
    }
}
复制代码

mybatis:
  configuration:
    map-underscore-to-camel-case: true
复制代码

@Configuration
public class LilithMyBatisConfig {
    @Bean
    public ConfigurationCustomizer configurationCustomizer(){
        return configuration -> configuration.setMapUnderscoreToCamelCase(true);
    }
}
复制代码

@Mapper
public interface EmployeeMapper {
    void insert(Employee employee);
    Employee selectOneById(Integer id);
}
复制代码

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lilith.mybatis.mapper.EmployeeMapper">
    <select id="selectOneById" resultType="com.lilith.mybatis.entity.Employee">
        select * from employee where id = #{id}
    </select>
    <insert id="insert" useGeneratedKeys="true" keyProperty="id" keyColumn="id">
        INSERT INTO employee (last_name, email, gender, d_id)
        VALUES (#{lastName}, #{email}, #{gender},#{dId})
    </insert>
</mapper>
复制代码

mybatis:
  # 全局配置文件的位置
  config-location: classpath:mybatis-config.xml
  mapper-locations: classpath:mappers/*.xml
  configuration:
    map-underscore-to-camel-case: true
复制代码

@SpringBootTest
public class EmployeeMapperTest {
    @Resource
    private EmployeeMapper employeeMapper;
    @Test
    public void insert() {
        Employee employee = new Employee();
        employee.setLastName("Thanos");
        employee.setEmail("thanos@gmail.com");
        employee.setGender(1);
        employee.setDId(1);
        employeeMapper.insert(employee);
    }
    @Test
    public void selectOneById() {
        Employee employee = employeeMapper.selectOneById(1);
        System.out.println(employee);
    }
}
复制代码

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>
</configuration>
复制代码