JeecgBoot v3.0 尝鲜

git code 源.
git源.
JeecgBoot开发文档.

#拉取项目代码
git clone https://github.com/zhangdaiscott/jeecg-boot.git
#或者用gitcode镜像拉取项目代码
https://gitcode.net/mirrors/jeecgboot/jeecg-boot.git

#################后端部署###################

#切到后台程序目录
cd  jeecg-boot/jeecg-boot/
#打包
mvn package
#打包后的jar包位于jeecg-boot/jeecg-boot/jeecg-boot-module-system/target目录下
#后台运行jar
nohup java -jar jeecg-boot-module-system-3.0.jar >catalina.out 2>&1 &

#################前端部署###################

#拉取项目代码
cd  jeecg-boot/ant-design-vue-jeecg

安装node.js
切换到ant-design-vue-jeecg文件夹下

**# 安装yarn**
npm install -g yarn
**# 下载依赖**
yarn install

开发模式 启动

#运行一下命令即可用ip:port访问了
yarn run serve

正式环境打包 编译项目执行此命令后会在当前目录生成一个dist文件夹

yarn run build
#将dist移动到nginx目录的html文件夹下,我这里用的是宝塔的默认路径
mv dist/ /www/server/nginx/html
#重命名dist为jeecgboot,方便记忆
cd /www/server/nginx/html
mv dist yeecgboot

在nginx.conf，修改如下配置

server {
		listen       80;
		server_name  你的域名;

		#后台服务配置，配置了这个location便可以通过http://域名/jeecg-boot/xxxx 访问		
		location ^~ /jeecg-boot {
			proxy_pass              http://127.0.0.1:8080/jeecg-boot/;
			proxy_set_header        Host 127.0.0.1;
			proxy_set_header        X-Real-IP $remote_addr;
			proxy_set_header        X-Forwarded-For $proxy_add_x_forwarded_for;
		}
		#解决Router(mode: 'history')模式下，刷新路由地址不能找到页面的问题
		location / {
			root   html;
			index  index.html index.htm;
			if (!-e $request_filename) {
				rewrite ^(.*)$ /index.html?s=$1 last;
				break;
			}
		}
	}

这里我用的是宝塔，沿用了宝塔的习惯

#单独创建了一个jeecgboot.conf文件，此目录下的后缀为.conf的文件都会被包含到nginx.conf的文件中
到这里就可以用域名访问前端了

# Lints and fixes files
yarn run lint

遇到的问题
1、Table ‘jeecg-boot.QRTZ_TRIGGERS’ doesn’t exist,我用的是mysql，实际看了下表是存在的，只不过名字是小写，所以原因是表名大小写敏感导致的，修改my.cnf,在[mysqld]后边添加lower_case_table_names=1 重启mysql服务

lower_case_table_names=0（默认）区分大小写，lower_case_table_names=1表示不区分大小写

 NEXT_FIRE_TIME ASC, PRIORITY DESC
java.sql.SQLSyntaxErrorException: Table 'jeecg-boot.QRTZ_TRIGGERS' doesn't exist
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3240)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:465)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3237)
	at com.alibaba.druid.wall.WallFilter.preparedStatement_executeQuery(WallFilter.java:647)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3237)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:465)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3237)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:181)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:227)
	at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTriggerToAcquire(StdJDBCDelegate.java:2613)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2844)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport$41.execute(JobStoreSupport.java:2805)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport$41.execute(JobStoreSupport.java:2803)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3864)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(JobStoreSupport.java:2802)
	at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:287)

2、前端跨域问题：
前端开发环境 yarn run serve 出现如下问题，
git下载的源文件 vue.config.js下的 是http://localhost:8080,这里我修改端口为8088，我把这里修改成外网ip之后就可以了
‘/jeecg-boot’: {
target: ‘http://120.53.125.233:8088’, //请求本地 需要jeecg-boot后台项目
ws: false,
changeOrigin: true
},
#################后端部署###################