JeecgBoot配置及前后端分离HelloWorld项目

刺骨的言语ヽ痛彻心扉 2022-12-16 06:26 1142阅读 0赞

## 1、Maven私服配置 ##

JEECG存在自定义JAR包，放在自己的Maven私服上面，所以有的时候会遇到下载失败。一般遇到下载失败的情况，是因为用户设置了本地镜像，导致无法从JEECG私服下载资源，参考下面的方式进行镜像排除配置即可。  
找到 maven安装目录中 conf/settings.xml，在标签内增加下面方式的阿里云maven镜像（删除自己的镜像配置）， 最终结果见下面：

<mirrors>
           <mirror>
                <id>nexus-aliyun</id>
                <mirrorOf>*,!jeecg,!jeecg-snapshots,!getui-nexus</mirrorOf>
                <name>Nexus aliyun</name>
                <url>http://maven.aliyun.com/nexus/content/groups/public</url>
            </mirror> 
     </mirrors>

然后执行maven命令，依赖就会顺利下载；此配置重点在这句话：

<mirrorOf>*,!jeecg,!jeecg-snapshots</mirrorOf>

如果不加这句话，默认所有的依赖都会去阿里云仓库下载，加上后jeecg的依赖包就可以从jeecg私服下载了。这里!的意思是排除，就是对所有仓库做镜像，除了jeecg仓库和jeecg-snapshots仓库，这两个仓库在下面的pom.xml文件中配置。  
jeecg-boot-parent中的pom.xml设置：

<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>org.jeecgframework.boot</groupId>
      <artifactId>jeecg-boot-parent</artifactId>
      <version>2.2.1</version>
      <packaging>pom</packaging>
      
      	<parent>
    	    <groupId>org.springframework.boot</groupId>
    	    <artifactId>spring-boot-starter-parent</artifactId>
    	    <version>2.1.3.RELEASE</version>
    	    <relativePath/>
    	</parent>
    
    	<modules>
    		<module>jeecg-boot-base-common</module>
    		<module>jeecg-boot-module-system</module>
    		<module>jeecg-boot-module-activiti</module>
    	</modules>
    
    	<distributionManagement>
    	  	<repository>
                <id>jeecg</id>
                <name>jeecg Repository</name>
                <url>http://maven.jeecg.com:8090/nexus/content/repositories/jeecg</url>
            </repository>
            <snapshotRepository>
    	        <id>jeecg-snapshots</id>
                <name>jeecg Snapshot Repository</name>
                <url>http://maven.jeecg.com:8090/nexus/content/repositories/snapshots/</url>
    	    </snapshotRepository>
    	</distributionManagement>
    	
    	<repositories>
    		<repository>
                <id>aliyun</id>
                <name>aliyun Repository</name>
                <url>http://maven.aliyun.com/nexus/content/groups/public</url>
                <snapshots>
    				<enabled>false</enabled>
    			</snapshots>
            </repository>
    		<repository>
                <id>jeecg</id>
                <name>jeecg Repository</name>
                <url>http://maven.jeecg.org/nexus/content/repositories/jeecg</url>
                <snapshots>
    				<enabled>false</enabled>
    			</snapshots>
            </repository>
    	</repositories>
    	
        <properties>
            <jeecgboot.version>2.2.1</jeecgboot.version>
            <java.version>1.8</java.version>
            <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            <mybatis-plus.version>3.3.2</mybatis-plus.version>
            <druid.version>1.1.17</druid.version>
            <jwt.version>0.9.1</jwt.version>
            <commons.version>2.6</commons.version>
    		<aliyun-java-sdk-dysmsapi.version>1.0.0</aliyun-java-sdk-dysmsapi.version>
    		<aliyun.oss.version>3.6.0</aliyun.oss.version>
    		<guava.version>26.0-jre</guava.version>
        </properties>
        
    	<dependencies>
    		
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-websocket</artifactId>
    		</dependency>
    		<dependency>
        		<groupId>org.springframework.boot</groupId>
        		<artifactId>spring-boot-starter-mail</artifactId>
    		</dependency>
    		<dependency>
    	        <groupId>org.springframework.boot</groupId>
    	        <artifactId>spring-boot-starter-test</artifactId>
    	        <scope>test</scope>
    	    </dependency>
    	    <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-aop</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-actuator</artifactId>
            </dependency>
    	    
    		
    		
    		<dependency>
    			<groupId>commons-io</groupId>
    			<artifactId>commons-io</artifactId>
    			<version>${commons.version}</version>
    		</dependency>
    		<dependency>
    			<groupId>commons-lang</groupId>
    			<artifactId>commons-lang</artifactId>
    			<version>${commons.version}</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-freemarker</artifactId>
    		</dependency>
    		
    		
    		<dependency>
    			<groupId>org.projectlombok</groupId>
    			<artifactId>lombok</artifactId>
    		</dependency>
    		
    		
    		 <dependency>
    	        <groupId>com.baomidou</groupId>
    	        <artifactId>mybatis-plus-boot-starter</artifactId>
    	        <version>${mybatis-plus.version}</version>
    	    </dependency>
    		
    		
           <dependency>
    		   <groupId>com.alibaba</groupId>
    		   <artifactId>druid-spring-boot-starter</artifactId>
    		   <version>${druid.version}</version>
    		</dependency>
    		
    		
    		<dependency>
    		  <groupId>com.baomidou</groupId>
    		  <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
    		  <version>2.5.4</version>
    		</dependency>
    				
    		
    		<dependency>
             	<groupId>com.alibaba</groupId>
             	<artifactId>fastjson</artifactId>
             	<version>1.2.72</version>
            </dependency>
          
    		
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    			<version>8.0.20</version>
    			<scope>runtime</scope>
    		</dependency>
    		
    		<dependency>
    		    <groupId>com.microsoft.sqlserver</groupId>
    		    <artifactId>sqljdbc4</artifactId>
    		    <version>4.0</version>
    		    <scope>runtime</scope>
    		</dependency>
    		
    		<dependency>
    		    <groupId>com.oracle</groupId>
    		    <artifactId>ojdbc6</artifactId>
    		    <version>11.2.0.3</version>
    			<scope>runtime</scope>
    		</dependency>
            
    		<dependency>
    			<groupId>org.postgresql</groupId>
    			<artifactId>postgresql</artifactId>
    			<version>42.2.6</version>
    			<scope>runtime</scope>
    		</dependency>
    
    		 
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-quartz</artifactId>
            </dependency>
            
    		
    		<dependency>
    			<groupId>com.auth0</groupId>
    			<artifactId>java-jwt</artifactId>
    			<version>3.7.0</version>
    		</dependency>
    		
    		
    		<dependency>
    		    <groupId>org.apache.shiro</groupId>
    		    <artifactId>shiro-spring-boot-starter</artifactId>
    		    <version>1.4.0</version>
    		</dependency>
    		
            <dependency>
                <groupId>org.crazycake</groupId>
                <artifactId>shiro-redis</artifactId>
                <version>3.1.0</version>
                <exclusions>
                    <exclusion>
                        <groupId>org.apache.shiro</groupId>
                        <artifactId>shiro-core</artifactId>
                    </exclusion>
                </exclusions>
            </dependency>
    
    		
    		<dependency>
    			<groupId>org.hibernate</groupId>
    			<artifactId>hibernate-re</artifactId>
    			<version>2.2.1</version>
    		</dependency>
    		<dependency>
    			<groupId>org.hibernate</groupId>
    			<artifactId>hibernate-core</artifactId>
    			<exclusions>
    				<exclusion>
    					<groupId>commons-collections</groupId>
    					<artifactId>commons-collections</artifactId>
    				</exclusion>
    			</exclusions>
    		</dependency>
    
    		
            <dependency>
    		    <groupId>io.springfox</groupId>
    		    <artifactId>springfox-swagger2</artifactId>
    		    <version>2.9.2</version>
    			<exclusions>
    				<exclusion>
    					<groupId>io.swagger</groupId>
    					<artifactId>swagger-annotations</artifactId>
    				</exclusion>
    				<exclusion>
    					<groupId>io.swagger</groupId>
    					<artifactId>swagger-models</artifactId>
    				</exclusion>
    			</exclusions>
    		</dependency>
    		<dependency>
    			<groupId>io.springfox</groupId>
    			<artifactId>springfox-swagger-ui</artifactId>
    			<version>2.9.2</version>
    		</dependency>
    		<dependency>
    			<groupId>com.github.xiaoymin</groupId>
    			<artifactId>swagger-bootstrap-ui</artifactId>
    			<version>1.9.6</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>io.swagger</groupId>
    			<artifactId>swagger-annotations</artifactId>
    			<version>1.5.22</version>
    		</dependency>
    		<dependency>
    			<groupId>io.swagger</groupId>
    			<artifactId>swagger-models</artifactId>
    			<version>1.5.22</version>
    		</dependency>
    
    		
    		<dependency>
    			 <groupId>org.springframework.boot</groupId>
    			  <artifactId>spring-boot-starter-data-redis</artifactId>
    		</dependency>
    		<dependency>
                <groupId>org.apache.commons</groupId>
                <artifactId>commons-pool2</artifactId>
            </dependency>
            
    		
    		
    		<dependency>
    			<groupId>org.jeecgframework.boot</groupId>
    			<artifactId>codegenerate</artifactId>
    			<version>1.2.0</version>
    		</dependency>
    		
            
    		<dependency>
    			<groupId>org.jeecgframework</groupId>
    			<artifactId>autopoi-web</artifactId>
    			<version>1.2</version>
    			<exclusions>
    				<exclusion>
    					<groupId>commons-codec</groupId>
    					<artifactId>commons-codec</artifactId>
    				</exclusion>
    			</exclusions>
    		</dependency>
    
    		<dependency>
    		    <groupId>cn.hutool</groupId>
    		    <artifactId>hutool-all</artifactId>
    		    <version>5.3.8</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>io.minio</groupId>
    			<artifactId>minio</artifactId>
    			<version>4.0.0</version>
    		</dependency>
    		<dependency>
    			<groupId>com.google.guava</groupId>
    			<artifactId>guava</artifactId>
    			<version>${guava.version}</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>com.aliyun</groupId>
    			<artifactId>aliyun-java-sdk-dysmsapi</artifactId>
    			<version>${aliyun-java-sdk-dysmsapi.version}</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>com.aliyun.oss</groupId>
    			<artifactId>aliyun-sdk-oss</artifactId>
    			<version>${aliyun.oss.version}</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>com.xkcoding.justauth</groupId>
    			<artifactId>justauth-spring-boot-starter</artifactId>
    			<version>1.3.2</version>
    		</dependency>
    
    	</dependencies>
    
    	<dependencyManagement>
    		<dependencies>
    			
    			<dependency>
    	    		<groupId>org.jeecgframework.boot</groupId>
    	    		<artifactId>jeecg-boot-base-common</artifactId>
    	    		<version>${jeecgboot.version}</version>
    	    	</dependency>
    	    	
    			<dependency>
    				<groupId>com.qiniu</groupId>
    				<artifactId>qiniu-java-sdk</artifactId>
    				<version>7.2.23</version>
    			</dependency>
    		</dependencies>
    	</dependencyManagement>
    	<build>
    		<plugins>
    			
                <plugin>
                    <groupId>org.apache.maven.plugins</groupId>
                    <artifactId>maven-compiler-plugin</artifactId>
                    <configuration>
                        <source>1.8</source>
                        <target>1.8</target>
                        <encoding>UTF-8</encoding>
                    </configuration>
                </plugin>
                
                <plugin>
    		        <groupId>org.apache.maven.plugins</groupId>
    		        <artifactId>maven-surefire-plugin</artifactId>
    		        <configuration>
    		          <skipTests>true</skipTests>
    		        </configuration>
    	        </plugin>
    	         
    	         <plugin>
                    <groupId>org.apache.maven.plugins</groupId>
                    <artifactId>maven-resources-plugin</artifactId>
                    <configuration>
                        <nonFilteredFileExtensions>
                            <nonFilteredFileExtension>woff</nonFilteredFileExtension>
                            <nonFilteredFileExtension>woff2</nonFilteredFileExtension>
                            <nonFilteredFileExtension>eot</nonFilteredFileExtension>
                            <nonFilteredFileExtension>ttf</nonFilteredFileExtension>
                            <nonFilteredFileExtension>svg</nonFilteredFileExtension>
                        </nonFilteredFileExtensions>
                    </configuration>
                </plugin>
    		</plugins>
    		<resources>
    			<resource>
                    <directory>src/main/resources</directory>
                    <filtering>true</filtering>
                </resource>
    			<resource>
    				<directory>src/main/java</directory>
    				<includes>
    					<include>**/*.xml</include>
    					<include>**/*.json</include>
    					<include>**/*.ftl</include>
    				</includes>
    			</resource>
    		</resources>
    	</build>
    </project>

## 2、数据库切换Oracle/SqlServer/Postgresql ##

### Oracle数据 ###

1.  添加oracle驱动，修改pom.xml：

<dependency>
    	<groupId>com.oracle</groupId>
    	<artifactId>ojdbc6</artifactId>
    	<version>11.2.0.3</version>
    </dependency>

1.  修改数据库连接  
    修改druid配置：

validationQuery: SELECT 1 FROM DUAL
    
    driver-class-name: oracle.jdbc.OracleDriver
    url: jdbc:oracle:thin:@192.168.1.200:1521:ORCL
    username: jeecgboot
    password: jeecgboot

### SQL Server数据 ###

1.  添加SQL server驱动，修改pom.xml：

<dependency>
    	<groupId>com.microsoft.sqlserver</groupId>
    	<artifactId>sqljdbc4</artifactId>
    	<version>4.0</version>
    	<scope>runtime</scope>
    </dependency>

1.  修改数据库连接  
    修改druid配置：

validationQuery: SELECT 1
    filters: stat,slf4j
    
    driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
    url: jdbc:sqlserver://192.168.1.200:1433;SelectMethod=cursor;DatabaseName=jeecg-boot
    username: sa
    password: SA

### postgresql数据库 ###

1.  添加postgresql驱动，修改pom.xml  
    (根据不同版本的数据库引入对应版本的驱动，下载地址：https://jdbc.postgresql.org/download.html)

<dependency>
    	<groupId>postgresql</groupId>
    	<artifactId>postgresql</artifactId>
    	<version>42.2.5</version>
    </dependency>

1.  修改数据库连接  
    增加spring下的配置：

spring:
      #postgresql 报错问题
      jpa:
          properties:
              hibernate:
                  temp:
                      use_jdbc_metadata_defaults: false

修改druid配置：

validationQuery: SELECT 1
    
    url: jdbc:postgresql://localhost:5432/postgres
    username: postgres
    password: root
    driver-class-name: org.postgresql.Driver

## 3、前端配置后台API地址 ##

### public/index.html页面配置后台服务API URL ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dvbmd4aWZhY2FpX2JlbGlldmU_size_16_color_FFFFFF_t_70_pic_center][]

### src/utils/request.js 配置 ###

此处默认不需要修改，配合下面操作的时候，可以手工指定后台项目名字。  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dvbmd4aWZhY2FpX2JlbGlldmU_size_16_color_FFFFFF_t_70_pic_center 1][]

### vue.config.js配置 ###

此处可以设置多个代理映射（如果要映射多个，则request.js需要手工指定项目名）  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dvbmd4aWZhY2FpX2JlbGlldmU_size_16_color_FFFFFF_t_70_pic_center 2][]

## 4、前后端分离HelloWorld项目 ##

### 后台服务代码实现 ###

@RestController
    @RequestMapping("/test/jeecgDemo")
    @Slf4j
    public class JeecgDemoController { 
    
    	/** * hello world * * @param id * @return */
    	@GetMapping(value = "/hello")
    	public Result<String> hello() { 
    		Result<String> result = new Result<String>();
    		result.setResult("Hello World!");
    		result.setSuccess(true);
    		return result;
    	}
    }

访问请求http://localhost:8080/jeecg-boot/test/jeecgDemo/hello 会提示token无效，所以需要配置下拦截器ShiroConfig排除。  
配置文件：

jeecg-boot-module-system/src/main/java/org/jeecg/config/ShiroConfig.java

加入配置：

filterChainDefinitionMap.put("/test/jeecgDemo/hello", "anon");

再访问http://localhost:8080/jeect-boot/test/jeecgDemo/hello，会返回结果如下：

{ 
    	"success": true,
    	"message": null,
    	"code": null,
    	"result": "Hello World!",
    	"timestamp": 1548833208562
    }

### 前台vue页面实现 ###

创建vue页面src/views/jeecg/helloworld.vue  
调用后台请求，获取返回的Hello World! 输出到页面，页面代码如下：

<template>
      <div>
        {
       { msg }}
      </div>
    </template>
    
    <script> import { getAction} from '@/api/manage' export default { data () { return { msg: "" } }, methods: { hello () { var url = "/test/jeecgDemo/hello" getAction(url).then((res) => { if (res.success) { this.msg = res.result; } }) } }, created() { this.hello(); } } </script>

代码说明：

1.  data() 方法中定义数据对象msg
2.  数据对象msg输出到页面，表达式如下：

{
       { msg }}

1.  定义一个方法，发起请求获取后台响应，后台实现的是get方法，引入getAction方法

import { getAction} from '@/api/manage'

定义方法调用：

hello () { 
       var url = "/test/jeecgDemo/hello"
       getAction(url).then((res) => { 
         if (res.success) { 
           this.msg = res.result;
         }
       })
     }

1.  Vue生命周期 created 中调用方法

created() { 
      this.hello();
    }

hello方法中

this.msg = res.result;

把请求返回的Hello World! 赋值给msg数据对象，msg值改变则页面显示也改变。

### 配置菜单 ###

1.  配置helloworld菜单【系统管理】-【菜单管理】  
    ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dvbmd4aWZhY2FpX2JlbGlldmU_size_16_color_FFFFFF_t_70_pic_center 3][]

*  其中前端组件配置相对src/views/目录下的 目录名+文件名
 *  例如页面src/views/jeecg/helloworld.vue 前端组件配置 jeecg/helloworld  
    ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dvbmd4aWZhY2FpX2JlbGlldmU_size_16_color_FFFFFF_t_70_pic_center 4][]

1.  用户角色授权【系统管理】-【角色管理】-授权  
    ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dvbmd4aWZhY2FpX2JlbGlldmU_size_16_color_FFFFFF_t_70_pic_center 5][]  
    ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dvbmd4aWZhY2FpX2JlbGlldmU_size_16_color_FFFFFF_t_70_pic_center 6][]  
    点击菜单访问页面展示Hello World!

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dvbmd4aWZhY2FpX2JlbGlldmU_size_16_color_FFFFFF_t_70_pic_center]: /images/20221123/17a746c677e04fcb9cff82cd85e4d65f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dvbmd4aWZhY2FpX2JlbGlldmU_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221123/cf0e53905c8a424ea21c942645b44e56.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dvbmd4aWZhY2FpX2JlbGlldmU_size_16_color_FFFFFF_t_70_pic_center 2]: /images/20221123/d03bc282d1604f79bca713ce20443aa2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dvbmd4aWZhY2FpX2JlbGlldmU_size_16_color_FFFFFF_t_70_pic_center 3]: /images/20221123/daec0b5fa27f4e268f21f9af4965580f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dvbmd4aWZhY2FpX2JlbGlldmU_size_16_color_FFFFFF_t_70_pic_center 4]: /images/20221123/685d66b88ff243f1b51f1db2870a61ff.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dvbmd4aWZhY2FpX2JlbGlldmU_size_16_color_FFFFFF_t_70_pic_center 5]: /images/20221123/8d48c95aff7e404c81d0d5b943e2c11f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dvbmd4aWZhY2FpX2JlbGlldmU_size_16_color_FFFFFF_t_70_pic_center 6]: /images/20221123/4a11c972793f420d81761d92509b8194.png