14.1 步骤分析
1 准备一个Springboot项目
2 pom-引入Mybatis Stater
3 yml配置
4 入口类
5 写代码测试
14.2 实现
14.2.1 准备一个Springboot项目
14.2.2 pom-引入Mybatis Stater
<!-- spring-boot整合mybatis -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>
<!-- mysql驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.projectlombok/lombok
导入这个jar后,编译后会自动生成相关方法
-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.8</version>
<scope>provided</scope>
</dependency>
14.2.3 yml配置
server:
port: 8080 #端口
spring:
application:
name: springboot-hello # 应用名称
datasource:
driver-class-name: com.mysql.jdbc.Driver
username: root
password: admin
url: jdbc:mysql:///test?useUnicode=true&characterEncoding=UTF-8
mybatis:
type-aliases-package: org.yaosang.org.domain,org.yaosang.org.query
14.2.4 入口类
package org.yaosang;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
//标识改项目为springboot项目
@SpringBootApplication //复合注解
@MapperScan("org.yaosang.*.mapper")
public class App {//可以是任何名称
//springboot启动类,以后以main方法的方式就可以启动Springboot的项目。
public static void main(String[] args) {
SpringApplication.run(App.class,args);
}
}
14.2.4 写代码测试
-
Domain
package org.yaosang.org.domain; import lombok.Data; //实体类 @Data public class Department { private Integer id; private String name; public Department(String name) { this.name = name; } public Department() { } }
-
Mapper&Mapper.xml
package org.yaosang.org.mapper; import org.yaosang.org.domain.Department; import java.util.List; //Mapper接口 public interface DepartmentMapper { //保存一个对象 void save(Department department); //通过id移除一个对象 void remove(Long id); //更新对象 void update(Department department); //通过id加载对象 Department loadById(Long id); //加载所有对象 List<Department> loadAll(); }
<?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"> <!--namespace和Mapper接口同包并同名--> <mapper namespace="org.yaosang.org.mapper.DepartmentMapper"> <!--void save(Department department);--> <insert id="save" parameterType="Department"> insert into t_department(name) values(#{name}) </insert> <!--void remove(Long id);--> <delete id="remove" parameterType="long"> delete from t_department where id = #{id} </delete> <!--void update(Department department);--> <update id="update" parameterType="Department"> update t_department set name = #{name} where id = #{id} </update> <!--Department loadById(Long id);--> <select id="loadById" resultType="Department"> select * from t_department where id = #{id} </select> <!--Department loadAll();--> <select id="loadAll" resultType="Department"> select * from t_department </select> </mapper>
-
Service
package org.yaosang.org.service; import org.yaosang.org.domain.Department; import java.util.List; //业务类接口 public interface IDepartmentService { //添加一个对象 void add(Department department); //通过id删除一个对象 void del(Long id); //更新对象 void update(Department department); //通过id获取对象 Department getById(Long id); //获取所有对象 List<Department> getAll(); } package org.yaosang.org.service.impl; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.yaosang.org.domain.Department; import org.yaosang.org.mapper.DepartmentMapper; import org.yaosang.org.service.IDepartmentService; import java.util.List; //业务实现类 @Service public class DepartmentServiceImpl implements IDepartmentService { @Autowired private DepartmentMapper departmentMapper; @Override public void add(Department department) { departmentMapper.save(department); } @Override public void del(Long id) { departmentMapper.remove(id); } @Override public void update(Department department) { departmentMapper.update(department); } @Override public Department getById(Long id) { return departmentMapper.loadById(id); } @Override public List<Department> getAll() { return departmentMapper.loadAll(); } }
-
Test
package org.yaosang.org.service.impl; import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.context.SpringBootTest; import org.springframework.test.context.junit4.SpringRunner; import org.yaosang.App; import org.yaosang.org.domain.Department; import org.yaosang.org.service.IDepartmentService; import static org.junit.Assert.*; @RunWith(SpringRunner.class) @SpringBootTest(classes = App.class) public class DepartmentServiceImplTest { @Autowired private IDepartmentService departmentService; @Test public void add() { departmentService.add(new Department("屌丝部")); } @Test public void del() { Department department = departmentService.getById(1L); System.out.println(department); departmentService.del(1L); department = departmentService.getById(1L); System.out.println(department); } @Test public void update() { Department department = departmentService.getById(1L); System.out.println(department); department.setName(department.getName()+"-edit"); departmentService.update(department); department = departmentService.getById(1L); System.out.println(department); } @Test public void getById() { System.out.println(departmentService.getById(1L)); } @Test public void getAll() { departmentService.getAll().forEach(System.out::println); } }
14.3 小结
本章节通过Springboot集成了Mybatis