Spring Boot Mybatis整合
Spring Boot是由Pivotal团队提供的全新框架,其设计目的是用来简化新Spring应用的初始搭建以及开发过程。该框架使用了特定的方式来进行配置,从而使开发人员不再需要定义样板化的配置。
特点
1. 轻松创建独立的Spring应用程序
2. 嵌入的Tomcat、jetty等web容器,无需部署WAR文件
3. 提供一系列的“starter” 来简化的Maven配置
4. 开箱即用,尽可能自动配置Spring
环境搭建
用IDEA创建一个新项目File-->New Project-->Spring Initializr
Next-->填写Group和Artifact
Next-->选择项目需要的依赖
Next-->填写完项目名称和选择项目位置之后点击Finish
等待编译完成,运行,出现如下图说明搭建成功
完善一下目录结构:
创建一个Hello World Controller作为项目的入口
1 @Controller 2 @EnableAutoConfiguration 3 public class HelloWorld { 4 @RequestMapping("/") 5 @ResponseBody 6 String home(){ 7 return "Hello World!"; 8 } 9 }
运行http://localhost:8080/出现
JDBC连接数据库
项目不使用application.properties文件 而使用更加简洁的application.yml文件:
将原有的resource文件夹下的application.properties文件删除,创建一个新的application.yml配置文件,
文件的内容如下:
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
server: port: 9091 spring: datasource: url: jdbc:mysql://127.0.0.1:3306/test?useSSL=false&characterEncoding=UTF-8 password: root username: root driver-class-name: com.mysql.jdbc.Driver type: com.alibaba.druid.pool.DruidDataSource mybatis: type-aliases-package: com.example.demo.model mapper-locations: classpath:mappers/*.xml
pom.xml
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
<?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.example</groupId> <artifactId>springbootdemo</artifactId> <version>0.0.1-SNAPSHOT</version> <packaging>jar</packaging> <name>springbootdemo</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>org.springframework.boot</groupId> <artifactId>spring-boot-starter-aop</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.3.2</version> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.1.8</version> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>fastjson</artifactId> <version>1.2.47</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> </dependency> <!--Mybatis逆向生成 --> <dependency> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-maven-plugin</artifactId> <version>1.3.5</version> </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>
使用mybatis generator 自动生成代码:/src/main/resources/generator/generatorConfig.xml
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"> <generatorConfiguration> <context id="DB2Tables" targetRuntime="MyBatis3"> <commentGenerator> <property name="suppressAllComments" value="true"/> </commentGenerator> <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://127.0.0.1:3306/test?useSSL=false&characterEncoding=UTF-8" userId="root" password="root"> </jdbcConnection> <!-- 实体类生成位置 --> <javaModelGenerator targetPackage="com.example.demo.model" targetProject=".\src\main\java"> <property name="enableSubPackages" value="true" /> <property name="trimStrings" value="true" /> </javaModelGenerator> <!-- Mappers 文件生成位置 --> <sqlMapGenerator targetPackage="mappers" targetProject=".\src\main\resources"> <property name="enableSubPackages" value="true" /> </sqlMapGenerator> <!-- 接口生成位置 --> <javaClientGenerator type="XMLMAPPER" targetPackage="com.example.demo.mapper" targetProject=".\src\main\java"> <property name="enableSubPackages" value="true" /> </javaClientGenerator> <!-- 生成表目录 --> <table tableName="ie_green_indexsystemtable" schema="ie_green_indexsystemtable" domainObjectName="GreenIndexSystem" enableUpdateByExample="false" enableSelectByExample="false" enableDeleteByExample="false" enableCountByExample="false" enableUpdateByPrimaryKey="false" enableDeleteByPrimaryKey="false" enableInsert="false"> </table> </context> </generatorConfiguration>
Mybatisgenerator
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
public class MybatisGenerator { public static void main(String[] args) throws Exception{ generator("D:\\springbootdemo\\src\\main\\resources\\generator\\generatorConfig.xml"); } public static void generator(String path) throws Exception{ List<String> warnings = new ArrayList<String>(); boolean overwrite = true; File configFile = new File(path); ConfigurationParser cp = new ConfigurationParser(warnings); Configuration config = cp.parseConfiguration(configFile); DefaultShellCallback callback = new DefaultShellCallback(overwrite); MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings); myBatisGenerator.generate(null); } }
运行Mybatisgenerator
项目启动类
@SpringBootApplication @MapperScan("com.example.demo.mapper") public class SpringbootdemoApplication { public static void main(String[] args) { SpringApplication.run(SpringbootdemoApplication.class, args); } }
Mapper
public interface GreenIndexSystemMapper { GreenIndexSystem selectByPrimaryKey(Integer id); List<GreenIndexSystem> selectAll(); }
映射文件Mapper.xml
<select id="selectAll" resultMap="BaseResultMap"> select <include refid="Base_Column_List" /> from ie_green_indexsystemtable </select>
Service
public interface GreenIndexService { List<GreenIndexSystem> selectAll(); }
ServiceImpl
@Service(value = "greenService") public class GreenIndexServiceImpl implements GreenIndexService { @Autowired private GreenIndexSystemMapper greenIndexSystemMapper; @Override public List<GreenIndexSystem> selectAll() { return greenIndexSystemMapper.selectAll(); } }
Controller
@RestController @RequestMapping("/green/") public class GreenIndexController { @Autowired private GreenIndexService greenService; @RequestMapping("getinfo") public List<GreenIndexSystem> getGreenAll(){return greenService.selectAll();} }
运行启动类查询到结果