SpringBoot整合MyBatis

1、原来如何整合Mybatis的

        1）添加依赖

        2）配置数据源

         3）配置一个SqlSesstionFactoryBean

        4）扫描mybatis的映射接口

<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans"     xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"     xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"     xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd     http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd     http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd     http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">       <!-- 数据库连接池 -->     <!-- 加载配置文件 -->     <context:property-placeholder location="classpath:resource/*.properties" /><!-- spring框架，解决方案，读取properties文件，不用像以前一样我们创建一个properties文件来读取配置文件了。 -->     <!-- 数据库连接池 -->     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"        destroy-method="close">        <property name="url" value="${jdbc.url}" />        <property name="username" value="${jdbc.username}" />        <property name="password" value="${jdbc.password}" />        <property name="driverClassName" value="${jdbc.driver}" />        <property name="maxActive" value="10" />        <property name="minIdle" value="5" />     </bean>     <!-- 配置sqlsessionFactory -->     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">        <property name="configLocation" value="classpath:mybatis/SqlMapConfig.xml"></property>        <property name="dataSource" ref="dataSource"></property>     </bean>     <!-- 配置扫描包，加载mapper代理对象 -->     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">        <property name="basePackage" value="com.taotao.mapper"></property>     </bean> </beans>

2、使用idea创建springboot工程

      使用idea创建springboot工程，请移步查看文章：https://blog.csdn.net/qq_38555490/article/details/90260295

2.1、创建数据库文件

  CREATE TABLE student(
 id INT PRIMARY KEY AUTO_INCREMENT,
 NAME VARCHAR(20) NOT NULL,
 age INT NOT NULL,
 birthday TIMESTAMP NOT NULL
)

 

 

3、创建项目的结构

 

在我们的src/man/java下创建以下包和类

• com.xiaomin.controller
  • Controller.java
• com.xiaomin.dao
  • StuDao.java    
  • com.xiaomin.mapper
    •  StuDaoMapper.xml
• com.xiaomin.service
  • StuService.java
  • com.xiaomin.service.impl
    • StuServiceImol.java
• com.xiaomin.pojo
  • Student.java

图示：

        

 

 

3、添加mybatis的起步依赖

打开我们的pom文件来，添加mybatis的起步依赖

<!--mybatis的起步依赖--> <dependency>     <groupId>org.mybatis.spring.boot</groupId>     <artifactId>mybatis-spring-boot-starter</artifactId>     <version>1.3.1</version> </dependency> <!--mysql包--> <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --> <dependency>     <groupId>mysql</groupId>     <artifactId>mysql-connector-java</artifactId>     <version>5.1.46</version> </dependency>

 

通过依赖树，我们可以看到mybatis起步依赖已经加载了我们与spring整合的包都加进来了。

• mybatis.jar
• mybatis-spring.jar

 

 

4、application.yml配置数据源

在src/resources,打开application.yml,注意的是，我们创建的springbot工程这个文件是appliation.properties 我们需要修改掉这个文件后缀为yml

关于yml配置文件如何使用，请移步文章：https://blog.csdn.net/qq_38555490/article/details/90264257

 

#mybatis与springboot整合所需要的配置 #数据源 spring:   datasource:     url: jdbc:mysql://localhost:3306/mydb     username: root     password: root     driver-class-name: com.mysql.jdbc.Driver mybatis:   #配置映射文件的扫描   #classpath 和classpath*的区别   #classpath ：当前 spring只会去当前项目的类路径下找这个文件   #classpath*：spring会去当前项目的类路径以及所有的jar包的类路径下找这个文件   mapper-locations: classpath:com/xiaomin/dao/mapper/*.xml   #配置别名   type-aliases-package: com.xiaomin.pojo

 

 

5、测试

那么springboot就整合好了mybatis了。

­Student.java

    这里使用了lombok插件来自动生成get/set方法，需要在安装idea,并在pom.xml加上依赖

    如何在idea中添加依赖，请查看我的文章：

    依赖：

<!--pojo注解生成get、set方法--> <!-- https://mvnrepository.com/artifact/org.projectlombok/lombok --> <dependency>     <groupId>org.projectlombok</groupId>     <artifactId>lombok</artifactId>     <version>1.16.18</version>     <scope>provided</scope> </dependency>

 

package com.xiaomin.pojo; import lombok.AllArgsConstructor; import lombok.Getter; import lombok.NoArgsConstructor; import lombok.Setter; import java.util.Date; /**  * @author jattxgt  * @site jattxgt  * @company jattxgt.com  * @create 2019-05-17 10:09  */ @Getter @Setter @NoArgsConstructor @AllArgsConstructor public class Student {     private Integer id;     private String name;     private Integer age;     private Date birthday; }

StuDaoMapper.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.xiaomin.dao.StuDao" >     <insert id="insert">         insert into student value (null,#{name},#{age},#{birthday})     </insert> </mapper>

 

StuDao.java

package com.xiaomin.dao; import com.xiaomin.pojo.Student; /**  * @author jattxgt  * @site jattxgt  * @company jattxgt.com  * @create 2019-05-17 10:13  */ public interface StuDao {     int insert(Student student); }

Stuservice.java

package com.xiaomin.service; import com.xiaomin.dao.StuDao; import com.xiaomin.pojo.Student; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; /**  * @author jattxgt  * @site jattxgt  * @company jattxgt.com  * @create 2019-05-17 10:20  */ public interface StuService {     int insert(Student student); }

 

StuServiceImpl.java

package com.xiaomin.service.impl; import com.xiaomin.dao.StuDao; import com.xiaomin.pojo.Student; import com.xiaomin.service.StuService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; /**  * @author jattxgt  * @site jattxgt  * @company jattxgt.com  * @create 2019-05-17 10:21  */ @Service public class StuServiceImpl implements StuService {     @Autowired     private StuDao stuDao;     public int insert(Student student) {         int aa=stuDao.insert(student);         return aa;     } }

pom.xml

<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">     <modelVersion>4.0.0</modelVersion>     <parent>         <groupId>org.springframework.boot</groupId>         <artifactId>spring-boot-starter-parent</artifactId>         <version>2.1.5.RELEASE</version>         <relativePath/> <!-- lookup parent from repository -->     </parent>     <groupId>com.xiaomin</groupId>     <artifactId>springboot_mybatis</artifactId>     <version>0.0.1-SNAPSHOT</version>     <name>springboot_mybatis</name>     <description>Demo project for Spring Boot</description>     <properties>         <java.version>1.8</java.version>     </properties>     <dependencies>         <dependency>             <groupId>org.springframework.boot</groupId>             <artifactId>spring-boot-starter-web</artifactId>         </dependency>         <dependency>             <groupId>org.springframework.boot</groupId>             <artifactId>spring-boot-starter-test</artifactId>             <scope>test</scope>         </dependency>         <!--mybatis的起步依赖-->         <dependency>             <groupId>org.mybatis.spring.boot</groupId>             <artifactId>mybatis-spring-boot-starter</artifactId>             <version>1.3.1</version>         </dependency>         <!--mysql包-->         <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->         <dependency>             <groupId>mysql</groupId>             <artifactId>mysql-connector-java</artifactId>             <version>5.1.46</version>         </dependency>         <!--pojo注解生成get、set方法-->         <!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->         <dependency>             <groupId>org.projectlombok</groupId>             <artifactId>lombok</artifactId>             <version>1.16.18</version>             <scope>provided</scope>         </dependency>     </dependencies>        <!--因为没有准守springboot约定，没有把类放置在启动类，那么我们需要在pom中配置下-->     <build>         <plugins>             <plugin>                 <groupId>org.springframework.boot</groupId>                 <artifactId>spring-boot-maven-plugin</artifactId>             </plugin>         </plugins>         <resources>             <resource>                 <directory>src/main/java</directory>                 <includes>                     <include>com/xiaomin/dao/mapper/*.xml</include>                 </includes>             </resource>             <resource>                 <directory>src/main/resource</directory>             </resource>         </resources>     </build> </project>

 

Controller.java

package com.xiaomin.controller; import com.xiaomin.pojo.Student; import com.xiaomin.service.StuService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.util.Date; /**  * @author jattxgt  * @site jattxgt  * @company jattxgt.com  * @create 2019-05-16 23:57  */ @RestController public class Controller {     @Autowired     private StuService stuService;     @RequestMapping("/hello")     public String fun(){         return "hello";     }     @RequestMapping("/insert")     public String insert(){         Student student = new Student(null,"李四",18,new Date());         int aa=stuService.insert(student);         return "插入成功，影响："+aa+"行";     } }

启动类

@SpringBootApplication  spring的注解扫描

@MapperScan  mapper接口的扫描

@SpringBootApplication(scanBasePackages = "com.xiaomin") @MapperScan ("com.xiaomin.dao")

 

package com.xiaomin.springboot_mybatis; import org.mybatis.spring.annotation.MapperScan; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; @SpringBootApplication(scanBasePackages = "com.xiaomin") @MapperScan("com.xiaomin.dao") public class SpringbootMybatisApplication {     public static void main(String[] args) {         SpringApplication.run(SpringbootMybatisApplication.class, args);     } }

效果图：

 demo百度云地址：链接：https://pan.baidu.com/s/1kJzJ-ruZNfWRYeFhXbmrRQ 
提取码：g2pf