spring boot+iview 前后端分离架构之后端工程的构建和mybatis插件的使用（五）

素颜马尾好姑娘i 2022-02-04 02:29 197阅读 0赞

### spring boot 与 iview 前后端分离架构之后端工程的构建和mybatis插件的使用 ###

*  公众号
 *  创建后端spring boot工程
 *  引入相应的maven依赖
 *  使用mybatis的插件快速生成代码
 *  配置mybatis
 *  验证配置是否成功

# 公众号 #

![在这里插入图片描述][20191218155125364.jpg]  
大家可以直接微信扫描上面的二维码关注我的公众号，然后回复【bg06】 里面就会给到源代码的下载地址同时会附上相应的视频教程，并定期在我的公众号上给大家推送相应的技术文章，欢迎大家关注我的公众号。

# 创建后端spring boot工程 #

首先打开我们的IDEA，在我们的IDEA的bg-admin底下创建一个spring boot工程（file=>new=>module）  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpbnpoZWZlbmc4OQ_size_16_color_FFFFFF_t_70]

# 引入相应的maven依赖 #

然后我们就创建好我们的工程了，接着我们打开我们的pom.xml引入我们的maven依赖:

<?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.4.RELEASE</version>
    		<relativePath/> 
    	</parent>
    	<groupId>com.github.bg.admin</groupId>
    	<artifactId>bg-admin-web-core</artifactId>
    	<version>0.0.1-SNAPSHOT</version>
    	<name>bg-admin-web-core</name>
    	<description>这是一个后端的springboot权限架构工程</description>
    
    	<properties>
    		<java.version>1.8</java.version>
    		<org.mapstruct.version>1.1.0.Final</org.mapstruct.version>
    	</properties>
    
    	<dependencies>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>tk.mybatis</groupId>
    			<artifactId>mapper-spring-boot-starter</artifactId>
    			<version>2.0.4</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>com.alibaba</groupId>
    			<artifactId>druid-spring-boot-starter</artifactId>
    			<version>1.1.9</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>com.github.pagehelper</groupId>
    			<artifactId>pagehelper-spring-boot-starter</artifactId>
    			<version>1.2.4</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>com.didispace</groupId>
    			<artifactId>spring-boot-starter-swagger</artifactId>
    			<version>1.2.0.RELEASE</version>
    		</dependency>
    
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-test</artifactId>
    			<scope>test</scope>
    		</dependency>
    	</dependencies>
    
    	<build>
    		<plugins>
    			<plugin>
    				<groupId>org.apache.maven.plugins</groupId>
    				<artifactId>maven-compiler-plugin</artifactId>
    				<version>3.5.1</version>
    				<configuration>
    					<source>1.8</source>
    					<target>1.8</target>
    					<annotationProcessorPaths>
    						<path>
    							<groupId>org.mapstruct</groupId>
    							<artifactId>mapstruct-processor</artifactId>
    							<version>${org.mapstruct.version}</version>
    						</path>
    					</annotationProcessorPaths>
    				</configuration>
    			</plugin>
    			<plugin>
    				<groupId>org.mybatis.generator</groupId>
    				<artifactId>mybatis-generator-maven-plugin</artifactId>
    				<version>1.3.6</version>
    				<configuration>
    					<configurationFile>
    						${basedir}/src/main/resources/generator/generatorConfig.xml
    					</configurationFile>
    					<overwrite>true</overwrite>
    					<verbose>true</verbose>
    				</configuration>
    				<dependencies>
    					<dependency>
    						<groupId>mysql</groupId>
    						<artifactId>mysql-connector-java</artifactId>
    						<version>5.1.29</version>
    					</dependency>
    					<dependency>
    						<groupId>tk.mybatis</groupId>
    						<artifactId>mapper</artifactId>
    						<version>4.0.0</version>
    					</dependency>
    				</dependencies>
    			</plugin>
    		</plugins>
    	</build>
    
    </project>

# 使用mybatis的插件快速生成代码 #

先在我们的工程的图示的目录底下创建好以下的目录结构，结构如下：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpbnpoZWZlbmc4OQ_size_16_color_FFFFFF_t_70 1]  
在我们的resource目录底下创建一个generator目录，接着在这个目录底下创建一个generatorConfig.xml配置文件，文件内容如下

<?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="Mysql" targetRuntime="MyBatis3Simple" defaultModelType="flat">
            <property name="beginningDelimiter" value="`"/>
            <property name="endingDelimiter" value="`"/>
    
            <plugin type="tk.mybatis.mapper.generator.MapperPlugin">
                <property name="mappers" value="tk.mybatis.mapper.common.Mapper"/>
                
                <property name="caseSensitive" value="true"/>
                
                <property name="forceAnnotation" value="true"/>
            </plugin>
    
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                            connectionURL="jdbc:mysql://127.0.0.1:3306/vcm?characterEncoding=utf-8"
                            userId="root"
                            password="123456">
            </jdbcConnection>
    
            <javaModelGenerator targetPackage="com.github.bg.admin.core.entity" targetProject="src/main/java">
    
            </javaModelGenerator>
    
            <sqlMapGenerator targetPackage="mybatis/mapper" targetProject="src/main/resources" />
    
            <javaClientGenerator targetPackage="com.github.bg.admin.core.dao" targetProject="src/main/java"  type="XMLMAPPER"/>
    
            <table tableName="t_user" domainObjectName="User" mapperName="UserDao">
                
                <property name="useActualColumnNames" value="true"></property>
                <generatedKey column="userId" sqlStatement="JDBC"/>
            </table>
    
            <table tableName="t_role" domainObjectName="Role" mapperName="RoleDao">
                
                <property name="useActualColumnNames" value="true"></property>
                <generatedKey column="roleId" sqlStatement="JDBC"/>
            </table>
    
            <table tableName="t_org" domainObjectName="Org" mapperName="OrgeDao">
                
                <property name="useActualColumnNames" value="true"></property>
                <generatedKey column="orgId" sqlStatement="JDBC"/>
            </table>
    
            <table tableName="t_behavior_log" domainObjectName="BehaviorLog" mapperName="BehaviorLogDao">
                
                <property name="useActualColumnNames" value="true"></property>
                <generatedKey column="behaviorLogId" sqlStatement="JDBC"/>
            </table>
    
            <table tableName="t_dict" domainObjectName="Dict" mapperName="DictDao">
                
                <property name="useActualColumnNames" value="true"></property>
                <generatedKey column="id" sqlStatement="JDBC"/>
            </table>
    
            <table tableName="t_tree" domainObjectName="Tree" mapperName="TreeDao">
                
                <property name="useActualColumnNames" value="true"></property>
                <generatedKey column="treeId" sqlStatement="JDBC"/>
            </table>
    
            <table tableName="t_role_tree" domainObjectName="RoleTree" mapperName="RoleTreeDao">
                
                <property name="useActualColumnNames" value="true"></property>
                <generatedKey column="roleTreeId" sqlStatement="JDBC"/>
            </table>
    
            <table tableName="t_user_org" domainObjectName="UserOrg" mapperName="UserOrgDao">
                
                <property name="useActualColumnNames" value="true"></property>
                <generatedKey column="userOrgId" sqlStatement="JDBC"/>
            </table>
    
            <table tableName="t_user_role" domainObjectName="UserRole" mapperName="UserRoleDao">
                
                <property name="useActualColumnNames" value="true"></property>
                <generatedKey column="userRoleId" sqlStatement="JDBC"/>
            </table>
    
        </context>
    </generatorConfiguration>

接着我们打开我们的IDEA右侧的maven，然后找到mybatis-generator如下所示双击执行  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpbnpoZWZlbmc4OQ_size_16_color_FFFFFF_t_70 2]  
然后我们就会看到我们的entity、dao、mapper底下会生成如下的文件，那则说明我们的插件已经帮助我们生成了我们想要的代码了。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpbnpoZWZlbmc4OQ_size_16_color_FFFFFF_t_70 3]

# 配置mybatis #

接着我们打开我们的主入口类BgAdminWebCoreApplication.java修改成如下：

package com.github.bg.admin.core;
    
    import com.didispace.swagger.EnableSwagger2Doc;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import tk.mybatis.spring.annotation.MapperScan;
    
    /**
     * @author linzf
     * @since 2019-05-06
     * 类描述：主入口类
     */
    @SpringBootApplication
    @EnableSwagger2Doc
    @MapperScan("com.github.bg.admin.core.dao")
    public class BgAdminWebCoreApplication {
    
    	public static void main(String[] args) {
    		SpringApplication.run(BgAdminWebCoreApplication.class, args);
    	}
    
    }

接着修改我们的application.properties为application.yml，同时新增一个配置文件为application-dev.yml，该文件的配置信息如下：

server:
      port: 8288
    
    # 配置日志信息
    logging:
      level:
        root: INFO
        com.github.bg.admin.core: DEBUG
    
    spring:
      datasource:
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://127.0.0.1:3306/vcm?characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai
        username: root
        password: 123456
        type: com.alibaba.druid.pool.DruidDataSource
        druid:
          filters: stat
          maxActive: 20
          initialSize: 1
          maxWait: 60000
          minIdle: 1
          timeBetweenEvictionRunsMillis: 60000
          minEvictableIdleTimeMillis: 300000
          validationQuery: select 'x'
          testWhileIdle: true
          testOnBorrow: false
          testOnReturn: false
          poolPreparedStatements: true
          maxOpenPreparedStatements: 20
    
    swagger:
      title: 用户权限架构的接口测试中心
      description: 用户权限架构的接口测试专用API文档
      base-package: com.github.bg.admin.core.controller
      contact:
        name: 林泽锋
        email: 282245889@qq.com

application.yml的配置信息如下：

spring:
      profiles:
        active: dev
    
    mybatis:
      mapper-locations: classpath:mybatis/mapper/*.xml
    
    pagehelper:
      helperDialect: mysql
      reasonable: true

# 验证配置是否成功 #

首先我们在service底下创建一个DictService.java类，代码如下：

package com.github.bg.admin.core.service;
    
    import com.github.bg.admin.core.dao.DictDao;
    import com.github.bg.admin.core.entity.Dict;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    /**
     * @author linzf
     * @since 2019-05-06
     * 类描述：数据字典的service类
     */
    @Service
    public class DictService {
    
        @Autowired
        private DictDao dictDao;
    
    
        public void save(Dict dict){
            dictDao.insert(dict);
        }
    
    }

接着在controller底下创建一个DictController.java，代码如下：

package com.github.bg.admin.core.controller;
    
    import com.github.bg.admin.core.entity.Dict;
    import com.github.bg.admin.core.service.DictService;
    import io.swagger.annotations.ApiOperation;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.PostMapping;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    
    /**
     * @author linzf
     * @since 2019/05/06
     * 类描述：数据字典的controller类
     */
    @RestController
    @RequestMapping("/dict")
    public class DictController {
    
        @Autowired
        private DictService dictService;
    
        /**
         * 功能描述：实现增加字典数据
         *
         * @param dict 包含字典数据的实体
         * @return 返回操作结果
         */
        @ApiOperation(value = "实现增加字典数据")
        @PostMapping("save")
        public void save(Dict dict){
            dictService.save(dict);
        }
    
    }

接着我们启动我们的工程，然后访问http://127.0.0.1:8288/swagger-ui.html这个地址，然后我们会看到如下的页面，然后输入测试的值点击try it out 然后我们去数据库里面看下是否有我们想要的数据，如果有则说明我们的后端工程的第一步已经构建完成了。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpbnpoZWZlbmc4OQ_size_16_color_FFFFFF_t_70 4]  
到此处我们就完成了本章节的内容了。  
上一篇文章地址：[spring boot+iview 前后端分离架构之数据库的设计（四）][spring boot_iview]  
下一篇文章地址：[spring boot+iview 前后端分离架构之前后端交互的实现（六）][spring boot_iview 1]

[20191218155125364.jpg]: /images/20220204/ed172e8e4e8844e386aa32c02c4409b1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpbnpoZWZlbmc4OQ_size_16_color_FFFFFF_t_70]: /images/20220204/bc1a92e5afa2495cbda8d33ae2e2ab42.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpbnpoZWZlbmc4OQ_size_16_color_FFFFFF_t_70 1]: /images/20220204/c5e632dd30784c0db8bf919f5eff1ae4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpbnpoZWZlbmc4OQ_size_16_color_FFFFFF_t_70 2]: /images/20220204/9c9d25e7c4264eb197970f19f947cd4a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpbnpoZWZlbmc4OQ_size_16_color_FFFFFF_t_70 3]: /images/20220204/48c1ab2089d1452bab96a649eb90fe43.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpbnpoZWZlbmc4OQ_size_16_color_FFFFFF_t_70 4]: /images/20220204/e1d869f540da437b99d6f61074f74252.png
[spring boot_iview]: https://blog.csdn.net/linzhefeng89/article/details/89857502
[spring boot_iview 1]: https://blog.csdn.net/linzhefeng89/article/details/90236546