1.删除oracle相关配置
1.1删除pom中的oracle依赖
1.2删除有关@Configuration中oracle配置
2.驱动引入
引入mysql依赖
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.13</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
3.配置文件更改
spring:
datasource:
druid:
url: jdbc:mysql://172.**.**.**:808*/******?characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false
username: ******
password: ******
driver-class-name: com.mysql.cj.jdbc.Driver
initial-size: 1
min-idle: 1
max-active: 200
max-wait: 6000
pool-prepared-statements: true
max-pool-prepared-statement-per-connection-size: 20
time-between-eviction-runs-millis: 6000
min-evictable-idle-time-millis: 300000
validation-query: SELECT 1 FROM DUAL
test-on-borrow: true
test-while-idle: true
test-on-return: false
remove-abandoned: true
remove-abandoned-timeout: 600
log-abandoned: true
filters: stat,log4j2
filter:
stat:
enabled: true
merge-sql: true
log4j2:
enabled: true
connectionLogEnabled: false
connectionLogErrorEnabled: true
statementLogEnabled: true
statementExecuteUpdateAfterLogEnable: true
statementCreateAfterLogEnabled: false
statementPrepareAfterLogEnabled: false
statementPrepareCallAfterLogEnabled: false
statementParameterClearLogEnable: false
statementCloseAfterLogEnabled: false
resultSetOpenAfterLogEnabled: false
resultSetCloseAfterLogEnabled: false
default-auto-commit: false
4.启动
下边两个需要注释掉,否则启动失败
5.分页配置
拿sql语句直接去数据库执行是成功的,但是放在程序里边就执行失败,打印sql看是分页的问题
想起来oracle分页和mysql不同
解决方法:application.yml中
原来
pagehelper:
helper-dialect: oracle
改为
pagehelper:
helper-dialect: mysql
6.sql语句修改
6.1 Oracle ifnull函数在MySQL中使用nvl替代
6.2
oracle --> mysql
to_char(sysdate,'yyyy-mm-dd')-->date_format(sysdate(),'%Y-%m-%d');
to_date(sysdate,'yyyy-mm-dd')-->STR_TO_DATE(sysdate(),'%Y-%m-%d');
7.中间还有一个插曲,与跟类路径有关
我发现页面带着根路径调用不到我得接口,但是我用postman不加跟类路径就能调用到我得接口
所以就在配置文件里把根路径给加上就可以正常访问了
server:
servlet:
context-path: /bdp-web