JSH_ERP华夏ERP开发配置

jshErp官网：http://www.huaxiaerp.com

后端

idea、jdk1.8、mysql8、Redis3.0

1、创建数据库：jsh_erp
\JSH_ERP\jshERP-boot\docs\jsh_erp.sql

2、idea导入项目后，执行报错：

Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: GlobalConfigUtils setMetaData Fail !  
Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: 
Could not create connection to database server.

3、参考：

https://www.cnblogs.com/jyroy/p/11276152.html

https://www.cnblogs.com/alsf/p/9346921.html

4、在com.mysql.jdbc.Driver上Ctrl+鼠标左键单击，会定位到右侧的位置，可以看出用的是5.1.30版本的jar包，因为连接mysql8，故修改pom.xml，增加8.0.11版本的jar包

修改\JSH_ERP\jshERP-boot\pom.xml

<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>8.0.11</version>
</dependency>

5、修改\JSH_ERP\jshERP-boot\src\main\resources\application.properties

#数据库连接
#spring.datasource.url=jdbc:mysql://127.0.0.1:3306/jsh_erp?useUnicode=true&characterEncoding=utf8&useCursorFetch=true&defaultFetchSize=500&allowMultiQueries=true&rewriteBatchedStatements=true
#spring.datasource.driverClassName=com.mysql.jdbc.Driver
#spring.datasource.username=xx
#spring.datasource.password=yy

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/jsh_erp?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.datasource.username=xx
spring.datasource.password=yy

6、如果Redis没有密码，注释掉下面这句

#spring.redis.password=1234abcd

7、 Cannot get Jedis connection; 启动Redis

参考：https://blog.csdn.net/qq_37896194/article/details/80249369

8、启动后如下：

前端：VSCode

1、终端中按顺序分别执行：

yarn install
yarn serve

2、报错：

To install them, you can run: npm install --save tinymce/plugins/colorpicker tinymce/plugins/contextmenu tinymce/plugins/fullscreen
tinymce/plugins/image tinymce/plugins/link tinymce/plugins/lists tinymce/plugins/media tinymce/plugins/table tinymce/plugins/textcolor
tinymce/plugins/wordcount tinymce/themes/silver/theme tinymce/tinymce tui-editor tui-editor/dist/tui-editor-contents.css
tui-editor/dist/tui-editor.css

 使用下面的方法，报：unable to access 'https://github.com/nhn/raphael.git/': OpenSSL SSL_read: Connection was reset

yarn add tui-editor
yarn add tinymce

使用下面的方法OK

npm i tui-editor --save
npm i tinymce --save

3、浏览器中执行：