SpringBoot整合mabtis

1.引入mabtis的依赖

可以在创建springboot项目的时候就勾选引用mabits框架模板,相关mabtis场景启动器就会自动导入

或者手动引入依赖

Springboot整合mabtis包

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

 jdbc包

 <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
  </dependency>

mysql包

<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
</dependency>

2.编写实体类  lombok插件提供的注解

 3. 在yml配置相关的信息

mvc:
    static-path-pattern: /static/**
  datasource:
    driver-class-name:  com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/test
    username: root
    password: root


mybatis:
  mapper-locations: classpath:mabtis/mapper/*.xml
  configuration:
    map-underscore-to-camel-case: true
  type-aliases-package: com.zwz.springbootweb.domain

 4.写接口和mapper映射

防止后面测试用@Autowired注解爆红 用@Repository注解解决

 mapper映射,resultType由于上述在yml起了别名只需要写包里面的类名

<?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.zwz.springbootweb.dao.ReglisterDao">

    <select id="selectTest" resultType="Regilster">
        <!--要执行的 sql 语句-->
        select * from stu
    </select>


    <insert id="insertReglister" >
        insert into stu
            value (#{username},#{password})
    </insert>


    <select id="selectReglister" resultType="Regilster">

        select * from stu  where username=#{username} and password =#{password}
    </select>



</mapper>

5.测试

 编写测试类

使用@AutoWired自动注入属性,@Transactional自动回滚

 

@SpringBootTest
class SpringbootWebApplicationTests {
    @Autowired
     private  ReglisterDao reglisterDao;
    @Test
    @Transactional
    public void insertReglister() {
        int i = reglisterDao.insertReglister("牛牛", "12345");
        System.out.println(i+"rows changed");
    }
 
}