4.spring_boot mybatis

四、spring_boot整合Mybatis

1. 创建maven工程

2. 更改工程jdk版本

   <properties>
   	<!-- java版本 -->
   	<java.version>1.8</java.version>
   	<!-- 编译时的编码 -->
   	<maven.compiler.encoding>UTF-8</maven.compiler.encoding>
   </properties>
   <build>
   	<plugins>
   		<plugin>
   			<artifactId>maven-compiler-plugin</artifactId>
   			<configuration>
   				<source>${java.version}</source>
   				<target>${java.version}</target>
   				<encoding>${maven.compiler.encoding}</encoding>
   			</configuration>
   		</plugin>
   	</plugins>
   </build>
   

3. 引入spring boot 父类

   <!-- 引入父类更好的规范各个依赖的version -->
   <parent>
   	<groupId>org.springframework.boot</groupId>
   	<artifactId>spring-boot-starter-parent</artifactId>
   	<version>2.1.0.RELEASE</version>
   </parent>
   

4. 引入依赖

   <dependencies>
   	<dependency>
   		<groupId>org.springframework.boot</groupId>
   		<artifactId>spring-boot-starter</artifactId>
   	</dependency>
   	<dependency>
           <groupId>org.mybatis.spring.boot</groupId>
           <artifactId>mybatis-spring-boot-starter</artifactId>
           <version>1.1.1</version>
       </dependency>
       <dependency>
           <groupId>mysql</groupId>
           <artifactId>mysql-connector-java</artifactId>
       </dependency>
   </dependencies>
   
   

5. 添加数据源，新增application.yml

   spring:
   	datasource:
   		url: jdbc:mysql://192.168.128.11:3306/j815?useUnicode=true&characterEncoding=utf-8
   		username: root
   		password: 123456
   		driver-class-name: com.mysql.jdbc.Driver
   mybatis: 
   	mapperLocations: classpath:mybatis/com/jk/springboot/mapper/xml/*.xml
   

6. 在启动类加上

   @MapperScan(“com.jk.springboot.mapper”)

7. 加入pagehelp,在pom.xml增加

   <dependency>
   	<groupId>com.github.pagehelper</groupId>
   	<artifactId>pagehelper</artifactId>
   	<version>3.7.5</version>
   </dependency>
   

8. 增加如下配置类

   @Configuration
   public class HelperConfig {
   	// 配置mybatis的分页插件pageHelper
   	@Bean
   	public PageHelper pageHelper() {
   		PageHelper pageHelper = new PageHelper();
   		Properties properties = new Properties();
   		properties.setProperty("offsetAsPageNum", "true");
   		properties.setProperty("rowBoundsWithCount", "true");
   		properties.setProperty("reasonable", "true");
   		properties.setProperty("dialect", "mysql"); // 配置mysql数据库的方言
   		pageHelper.setProperties(properties);
   		return pageHelper;
   	}
   }