2.idea+mybatis连接postgreSql在pom.xml和application.xml配置

mybatis连接postgreSql和连接mysql区别在于：
1.pom.xml引入的插件不同
2.application.yml连接url路径不同等配置不同
以下代码展示：

1.pom.xml引入的插件不同

mysql

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <scope>runtime</scope>
</dependency>

postgreSql

 <dependency>
     <groupId>org.postgresql</groupId>
     <artifactId>postgresql</artifactId>
     <version>42.2.2</version>
 </dependency>

2.application.yml连接url路径不同等配置不同

mysql-dev

server:
  port: 8088
  servlet:
    context-path: /dev
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/bookdemo?useUnicode=true&characterEncoding=utf-8&useSSL=false&allowPublicKeyRetrieval=true
    username: root
    password: tiger
    driver-class-name: com.mysql.jdbc.Driver


mybatis:
  #驼峰命名
  map-underscore-to-camel-case: true
  #配置xml位置
  mapper-locations: classpath:mapping/*.xml
  #标注实体类位置
  type-aliases-package: com.example.springboot6.bean

postgreSql-dev2

server:
  port: 8093
  servlet:
    context-path: /dev2

spring:
  datasource:
    url: jdbc:postgresql://172.16.40.239:30000/data_engine?stringtype=unspecified&useSSL=false&useUnicode=true&characterEncoding=utf-8&reWriteBatchedInserts=true
    username: postgres
    password: 123456
    driverClassName: org.postgresql.Driver

mybatis:
  #驼峰命名
  map-underscore-to-camel-case: true
  #配置xml位置
  mapper-locations: classpath:mapping/*.xml
  #标注实体类位置
  type-aliases-package: com.example.springboot6.bean

其他配置参考
1.idea+mybatis连接mySql自动生成代码,在pom.xml和application.xml的配置
完毕！