spring boot 与 iview 前后端分离架构之后端工程的构建和mybatis插件的使用
公众号
大家可以直接微信扫描上面的二维码关注我的公众号,然后回复【bg06】 里面就会给到源代码的下载地址同时会附上相应的视频教程,并定期在我的公众号上给大家推送相应的技术文章,欢迎大家关注我的公众号。
创建后端spring boot工程
首先打开我们的IDEA,在我们的IDEA的bg-admin底下创建一个spring boot工程(file=>new=>module)
引入相应的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/> <!-- lookup parent from repository -->
</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>
<!--通用 Mapper-->
<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>
<!-- swagger插件 -->
<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的插件快速生成代码
先在我们的工程的图示的目录底下创建好以下的目录结构,结构如下:
在我们的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"/>
<!-- 是否区分大小写,默认值 false -->
<property name="caseSensitive" value="true"/>
<!-- 是否强制生成注解,默认 false,如果设置为 true,不管数据库名和字段名是否一致,都会生成注解(包含 @Table 和 @Column) -->
<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">
<!-- 字段属性是否驼峰展示,true为驼峰展示 -->
<property name="useActualColumnNames" value="true"></property>
<generatedKey column="userId" sqlStatement="JDBC"/>
</table>
<table tableName="t_role" domainObjectName="Role" mapperName="RoleDao">
<!-- 字段属性是否驼峰展示,true为驼峰展示 -->
<property name="useActualColumnNames" value="true"></property>
<generatedKey column="roleId" sqlStatement="JDBC"/>
</table>
<table tableName="t_org" domainObjectName="Org" mapperName="OrgeDao">
<!-- 字段属性是否驼峰展示,true为驼峰展示 -->
<property name="useActualColumnNames" value="true"></property>
<generatedKey column="orgId" sqlStatement="JDBC"/>
</table>
<table tableName="t_behavior_log" domainObjectName="BehaviorLog" mapperName="BehaviorLogDao">
<!-- 字段属性是否驼峰展示,true为驼峰展示 -->
<property name="useActualColumnNames" value="true"></property>
<generatedKey column="behaviorLogId" sqlStatement="JDBC"/>
</table>
<table tableName="t_dict" domainObjectName="Dict" mapperName="DictDao">
<!-- 字段属性是否驼峰展示,true为驼峰展示 -->
<property name="useActualColumnNames" value="true"></property>
<generatedKey column="id" sqlStatement="JDBC"/>
</table>
<table tableName="t_tree" domainObjectName="Tree" mapperName="TreeDao">
<!-- 字段属性是否驼峰展示,true为驼峰展示 -->
<property name="useActualColumnNames" value="true"></property>
<generatedKey column="treeId" sqlStatement="JDBC"/>
</table>
<table tableName="t_role_tree" domainObjectName="RoleTree" mapperName="RoleTreeDao">
<!-- 字段属性是否驼峰展示,true为驼峰展示 -->
<property name="useActualColumnNames" value="true"></property>
<generatedKey column="roleTreeId" sqlStatement="JDBC"/>
</table>
<table tableName="t_user_org" domainObjectName="UserOrg" mapperName="UserOrgDao">
<!-- 字段属性是否驼峰展示,true为驼峰展示 -->
<property name="useActualColumnNames" value="true"></property>
<generatedKey column="userOrgId" sqlStatement="JDBC"/>
</table>
<table tableName="t_user_role" domainObjectName="UserRole" mapperName="UserRoleDao">
<!-- 字段属性是否驼峰展示,true为驼峰展示 -->
<property name="useActualColumnNames" value="true"></property>
<generatedKey column="userRoleId" sqlStatement="JDBC"/>
</table>
</context>
</generatorConfiguration>
接着我们打开我们的IDEA右侧的maven,然后找到mybatis-generator如下所示双击执行
然后我们就会看到我们的entity、dao、mapper底下会生成如下的文件,那则说明我们的插件已经帮助我们生成了我们想要的代码了。
配置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 然后我们去数据库里面看下是否有我们想要的数据,如果有则说明我们的后端工程的第一步已经构建完成了。
到此处我们就完成了本章节的内容了。
上一篇文章地址:spring boot+iview 前后端分离架构之数据库的设计(四)
下一篇文章地址:spring boot+iview 前后端分离架构之前后端交互的实现(六)