<!-- jdbc -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!-- mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.4</version>
</dependency>
<!-- spring,mybatis整合包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.1</version>
</dependency>
<!-- mysql 驱动包 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
在 application.properties 中添加:
# 数据源配置
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=tiger
@Configuration
public class MyBatisConfiguration {
@Bean
@ConditionalOnMissingBean // 当容器里没有指定的 Bean 的情况下创建该对象
public SqlSessionFactoryBean sqlSessionFactory(DataSource dataSource) {
SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
// 设置数据源
sqlSessionFactoryBean.setDataSource(dataSource);
// 设置mybatis的主配置文件
sqlSessionFactoryBean.setConfigLocation(new ClassPathResource("mybatis/mybatis-config.xml"));
// 设置mapper映射文件
PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
Resource[] mapperXml;
try {
mapperXml = resolver.getResources("classpath:mybatis/mapper/*.xml");
sqlSessionFactoryBean.setMapperLocations(mapperXml);
} catch (IOException e) {
e.printStackTrace();
}
// 设置别名包
sqlSessionFactoryBean.setTypeAliasesPackage("com.light.springboot.domain");
return sqlSessionFactoryBean;
}
@Bean
@ConditionalOnBean(SqlSessionFactoryBean.class) // 当 SqlSessionFactoryBean 实例存在时创建对象
public MapperScannerConfigurer mapperScannerConfigurer() {
MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();
mapperScannerConfigurer.setBasePackage("com.light.springboot.mapper");
return mapperScannerConfigurer;
}
}
在 src/main/resources 下创建 mybatis 文件夹,并在 mybatis 文件夹中创建 "mybatis-config.xml" 配置文件,内容如下:
<?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="useGeneratedKeys" value="true"/>
<!-- 使用列别名替换列名,默认为 true -->
<setting name="useColumnLabel" value="true"/>
<!-- 开启驼峰命名转换:Table(create_time) => Entity(createTime) -->
<setting name="mapUnderscoreToCamelCase" value="true"/>
</settings>
</configuration>
mybatis 文件夹下再创建一个 "mapper" 文件夹,里边存放 Mpper 接口对应的 mapper 映射文件。
在 MySQL 中创建名为 springboot 的数据库,在该库中创建 role 表:
CREATE TABLE `department` (
`id` INT(11) NOT NULL,
`name` VARCHAR(10) NOT NULL,
`descr` VARCHAR(50) NULL DEFAULT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
;
setet 和 getter 方法省略。
public class Department implements Serializable{
private static final long serialVersionUID = 6067283535977178571L;
private Integer id;
private String name;
private String descr;
}
@Mapper
public interface DepartmentMapper {
public void insert(Department department);
public Department getById(Integer id);
public void update(Department department);
public void deleteById(Integer id);
}
补充:Mapper 接口需要添加 @Mapper 注解,如果不想使用该注解,可以在启动类上使用 @MapperScan 配置 Mapper 接口路径
mybatis/mapper/departmentMapper.xml :
<?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.light.springboot.dao.DepartmentMapper">
<insert id="insert" parameterType="com.light.springboot.domain.Department">
insert into department(id,name,descr) values(#{id},#{name},#{descr})
</insert>
<select id="getById" parameterType="java.lang.Integer" resultType="com.light.springboot.domain.Department">
select id,name,descr from department where id = #{id}
</select>
<update id="update" parameterType="com.light.springboot.domain.Department">
update department set descr = #{descr} where id = #{id}
</update>
<delete id="deleteById" parameterType="java.lang.Integer">
delete from department where id = #{id}
</delete>
</mapper>
@RunWith(SpringRunner.class)
@SpringBootTest
public class DepartmentTest {
@Autowired
private DepartmentMapper departmentMapper;
@Test
public void testInsert() {
Department department = new Department();
department.setId(1);
department.setName("研发部");
department.setDescr("开发产品");
this.departmentMapper.insert(department);
}
@Test
public void testGetById() {
Department department = this.departmentMapper.getById(1);
System.out.println(department);
}
@Test
public void testUpdate() {
Department department = new Department();
department.setId(1);
department.setDescr("开发高级产品");
this.departmentMapper.update(department);
}
@Test
public void testDeleteById() {
this.departmentMapper.deleteById(1);
}
}