1、环境准备
idea 2018、mysql、jdk1.8
2、idea创建springBoot项目(网上步骤很多)
idea创建项目时可以选择web、mybatis、mysql,这样idea会自动加载其jar包;
但是还需要mybatis-plus的jar包:点这里提供
项目结构:
3、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>
<groupId>com.xsy.sbmp</groupId>
<artifactId>springbmp</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>jar</packaging>
<name>springbmp</name>
<description>Demo project for Spring Boot</description>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.0.3.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatisplus-spring-boot-starter</artifactId>
<version>1.0.2</version>
<scope>system</scope>
<systemPath>${basedir}/lib/mybatisplus-spring-boot-starter-1.0.2.jar</systemPath>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus</artifactId>
<version>2.1.0</version>
<scope>system</scope>
<systemPath>${basedir}/lib/mybatis-plus-2.1.0.jar</systemPath>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
4、application.properties:
#server port
server.port=8080
#mysql datasource
spring.datasource.url=jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useSSL=false
spring.datasource.username=
spring.datasource.password=
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
#logger
logging.level.com.xsy.sbmp.springbmp.dao=debug
#mapper.xml location
mybatis-plus.mapper-locations=classpath*:mapper/*.xml
#entity location
mybatis-plus.type-aliases-package=com.xsy.sbmp.springbmp.entity
5、mybatisplus配置:
@Configuration
public class MybatisPlusConfig {
@Bean
public PaginationInterceptor paginationInterceptor(){
PaginationInterceptor page = new PaginationInterceptor();
//设置方言
page.setDialectType("mysql");
return page;
}
}
6、创建实体类、dao接口、mapper.xml、service、serviceImpl、controller
实体类中字段和数据库字段不一致时:@TableField("");
dao接口需要: dao接口类上需要@Repository @Mapper注解
还需要在springBoot启动类上jiar加上注解:@MapperScan("dao路径")
mapper.xml所有文件放到 resources文件夹下,即和application.properties同目录,否则会加载不了;
其他都和ssm时一样