初使用SpringBoot整合mybatis笔记（一）

初使用SpringBoot整合mybatis笔记（一）

需要编写的内容有：

1.在pom.xml中导入mybatis的依赖包

- springboot官方的依赖以spring-boot-starter开头，mybatis的依赖包是mybatis根据springboot写的，所以是mybatis开头

<dependency>
   <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.1.4</version>
</dependency>

2.编写实体对象类Department.class，注意匹配数据库表字段

- Lombok注解

• @Data
• @AllArgsConstructor
• @NoArgsConstructor
  IDEA找不到Lombok插件的解决方式\

/*部门表*/
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Department {

    private Integer id;
    private String departmentName;
    private Integer floor;

}

3.编写持久层接口Mapper文件departmentMapper.Interface

- 需要添加@Mapper和@Repository注解

@Mapper
@Repository
public interface DepartmentMapper {

    /*返回部门列表*/
    public List<Department> getDep();

    /*根据id查询部门*/
    public Department getDepById(Integer id);

    /*增加部门*/
    public void insertDep(Department department);

    /*更新部门*/
    public void updateDep(Department department);

    /*删除部门*/
    public void deleteDep(Integer id);
}

4.编写mapper的映射文件departmentMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!--注意此处的mapper设置，下列标签才是mapper开始-->
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.itguigu.webtest.mapper.DepartmentMapper">

    <!--此处的id需要和Mapper里的方法名一致 区分大小写；返回类型只需要写实体类名，不分大小写（相当于已经起了别名）-->
    <select id="getDep" resultType="department">
        select  * from department
    </select>

    <select id="getDepById" parameterType="int" resultType="department">
        select * from department where id=#{id}
    </select>

    <insert id="insertDep" parameterType="department">
        insert into department(departmentName,floor) values(#{departmentName},#{floor})
    </insert>

    <update id="updateDep" parameterType="department">
        update department set departmentName=#{departmentName},floor=#{floor} where id=#{id}
    </update>

    <delete id="deleteDep" parameterType="int">
        delete from department where id=#{id}
    </delete>

</mapper>

5.编写配置文件application.yml（文件名固定，后缀可以用.yml或者.properties)

#配置建立数据库连接参数
spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/eesy_mybatis?serverTimezone=UTC&useUnicode=true&characterEncodeing=UTF-8
    driver-class-name: com.mysql.cj.jdbc.Driver

#整合mybatis ：
#  type-aliases-package：实体类所在的包路径
#  mapper-locations： mapper配置文件所在的路径，注意classpath：后面不加/表示resources路径下
mybatis:
  type-aliases-package: com.itguigu.webtest.pojo
  mapper-locations:  classpath:mybatis/mapper/*.xml

6.编写控制器文件DepartmentController.class

- @RestController：直接返回到浏览器（包含了@Controller和@ResponseBody)

- @Autowried 自动注入

@RestController
public class DepartmentController {

    @Autowired
    private DepartmentMapper departmentMapper;

    @GetMapping("/getDep")
    public List<Department> getDep(){
        List<Department> depList = departmentMapper.getDep();
        for (Department dep : depList){
            System.out.println(dep);
        }
        return depList;

    }
 }

7.运行主程序类

- @SpringBootApplication注解表示这是一个主程序类

8.在浏览器输入http://localhost:8080/getDep