spring boot连接Mybatis数据库的配置文件(MySql、SQLserver、Oracle)

r囧r小猫 2023-10-06 10:02 20阅读 0赞

<table> 
 <thead> 
  <tr> 
   <th>序号</th> 
   <th>类型</th> 
   <th align="left">地址</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>1</td> 
   <td>MySQL</td> 
   <td align="left"><a href="https://blog.csdn.net/weixin_44624117/article/details/96165881" rel="nofollow">MySQL操作之概念、SQL约束（一）</a></td> 
  </tr> 
  <tr> 
   <td>2</td> 
   <td>MySQL</td> 
   <td align="left"><a href="https://blog.csdn.net/weixin_44624117/article/details/96339284" rel="nofollow">MySQL操作之数据定义语言（DDL)（二）</a></td> 
  </tr> 
  <tr> 
   <td>3</td> 
   <td>MySQL</td> 
   <td align="left"><a href="https://blog.csdn.net/weixin_44624117/article/details/96445064" rel="nofollow">MySQL操作之数据操作语言（DML)（三）</a></td> 
  </tr> 
  <tr> 
   <td>4</td> 
   <td>MySQL</td> 
   <td align="left"><a href="https://blog.csdn.net/weixin_44624117/article/details/96726772" rel="nofollow">MySQL操作之数据查询语言：(DQL)（四-1）（单表操作）</a></td> 
  </tr> 
  <tr> 
   <td>5</td> 
   <td>MySQL</td> 
   <td align="left"><a href="https://blog.csdn.net/weixin_44624117/article/details/96729083" rel="nofollow">MySQL操作之数据查询语言：(DQL)（四-2）（多表查询）</a></td> 
  </tr> 
  <tr> 
   <td>6</td> 
   <td>MySQL</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/120254916" rel="nofollow">MySQL操作之数据控制语言：(DC)（五）</a></td> 
  </tr> 
  <tr> 
   <td>7</td> 
   <td>MySQL</td> 
   <td align="left"><a href="https://blog.csdn.net/weixin_44624117/article/details/122593057" rel="nofollow">MySQL操作之数据库函数</a></td> 
  </tr> 
  <tr> 
   <td>8</td> 
   <td>MySQL</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/120383272" rel="nofollow">MySQL管理之数据类型</a></td> 
  </tr> 
  <tr> 
   <td>9</td> 
   <td>MySQL</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/120393164" rel="nofollow">MySQL管理之索引</a></td> 
  </tr> 
  <tr> 
   <td>10</td> 
   <td>MySQL</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/120240970" rel="nofollow">MySQL管理之事务管理</a></td> 
  </tr> 
  <tr> 
   <td>11</td> 
   <td>MySQL</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/120383054" rel="nofollow">MySQL管理之存储过程</a></td> 
  </tr> 
  <tr> 
   <td>12</td> 
   <td>MySQL</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/120251668" rel="nofollow">MySQL管理之视图</a></td> 
  </tr> 
  <tr> 
   <td>13</td> 
   <td>MySQL</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/120383282" rel="nofollow">MySQL管理之数据备份与还原</a></td> 
  </tr> 
  <tr> 
   <td>14</td> 
   <td>MySQL</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/95240161" rel="nofollow">Linux（centos 7.5）服务器安装MySQL</a></td> 
  </tr> 
  <tr> 
   <td>15</td> 
   <td>MyBatis</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/119246809" rel="nofollow">MyBatis从入门到多表关联</a></td> 
  </tr> 
  <tr> 
   <td>16</td> 
   <td>MyBatis</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/120823825" rel="nofollow">MyBatis常用方法</a></td> 
  </tr> 
  <tr> 
   <td>17</td> 
   <td>MyBatis</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/98309342" rel="nofollow">Mybatis逆向工程的使用（附文件地址）</a></td> 
  </tr> 
  <tr> 
   <td>18</td> 
   <td>MyBatis</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/106430172" rel="nofollow">spring boot连接Mybatis数据库的配置文件(MySql、SQLserver、Oracle)</a></td> 
  </tr> 
  <tr> 
   <td>19</td> 
   <td>MyBatis-Plus</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/119060130" rel="nofollow">Mybatis-Plus使用案例(包括初始化以及常用插件)</a></td> 
  </tr> 
  <tr> 
   <td>20</td> 
   <td>MyBatis-Plus</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/124972178" rel="nofollow">Mybatis-Plus(Service CRUD 接口)</a></td> 
  </tr> 
  <tr> 
   <td>21</td> 
   <td>MyBatis-Plus</td> 
   <td align="left"><a href="http://t.csdn.cn/3mdPc" rel="nofollow">Mybatis-plus 4种条件构造器方式</a></td> 
  </tr> 
  <tr> 
   <td>22</td> 
   <td>MyBatis-Plus</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/124936692" rel="nofollow">Mybatis-Plus 执行自定义SQL</a></td> 
  </tr> 
  <tr> 
   <td>23</td> 
   <td>MyBatis-Plus</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/124971821" rel="nofollow">MyBatis-plus配置自定义SQL(执行用户传入SQL)</a></td> 
  </tr> 
  <tr> 
   <td>24</td> 
   <td>MyBatis-Plus</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/124973383" rel="nofollow">Mybatis-Plus(连接Hive)</a></td> 
  </tr> 
  <tr> 
   <td>25</td> 
   <td>MyBatis-Plus</td> 
   <td align="left"><a href="https://blog.csdn.net/lydms/article/details/122095848" rel="nofollow">Mybatis-Plus 代码生成器</a></td> 
  </tr> 
 </tbody> 
</table>

--------------------

### 文章目录 ###

*   *  一、MySql连接数据库
     *   *   *  1、pom依赖
             *  2、properties配置
     *  二、SQLserver连接数据库
     *   *   *  1、pom依赖
             *  2、properties配置
     *  三、Oracle连接数据库
     *   *   *  1、pom依赖
             *  2、properties配置

--------------------

## 一、MySql连接数据库 ##

#### 1、pom依赖 ####

<dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>2.0.1</version>
    </dependency>
    
    
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
    </dependency>

#### 2、properties配置 ####

#MySql
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver
    spring.datasource.url=jdbc:mysql://106.12.58.186:3306/learn
    spring.datasource.username=root
    spring.datasource.password=root
    
    spring.datasource.tomcat.initial-size=10
    spring.datasource.tomcat.max-active=50
    spring.datasource.tomcat.max-wait=1000
    spring.datasource.tomcat.validation-query=select 1 from dual
    spring.datasource.tomcat.test-on-borrow=true
    spring.datasource.tomcat.max-idle=100
    spring.datasource.tomcat.min-idle=10
    spring.datasource.tomcat.testWhileIdle=true
    spring.datasource.tomcat.removeAbandoned=true

## 二、SQLserver连接数据库 ##

#### 1、pom依赖 ####

<dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>2.0.1</version>
    </dependency>
    
    
    <dependency>
        <groupId>com.microsoft.sqlserver</groupId>
        <artifactId>mssql-jdbc</artifactId>
    </dependency>

#### 2、properties配置 ####

# SqlServer
    spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
    spring.datasource.url=jdbc:sqlserver://106.12.58.186:1433;databaseName=learn
    spring.datasource.username=sa
    spring.datasource.password=sa
    
    spring.datasource.tomcat.initial-size=10
    spring.datasource.tomcat.max-active=50
    spring.datasource.tomcat.max-wait=1000
    spring.datasource.tomcat.validation-query=select 1
    spring.datasource.tomcat.test-on-borrow=true
    spring.datasource.tomcat.max-idle=100
    spring.datasource.tomcat.min-idle=10
    spring.datasource.tomcat.testWhileIdle=true
    spring.datasource.tomcat.removeAbandoned=true

## 三、Oracle连接数据库 ##

#### 1、pom依赖 ####

<dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>2.0.1</version>
    </dependency>
    
    
    <dependency>
    	<groupId>com.oracle</groupId>
    	<artifactId>ojdbc6</artifactId>
    	<version>12.1.0.2</version>
    </dependency>

#### 2、properties配置 ####

# Oracle
    spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
    spring.datasource.url=jdbc:oracle:thin:@106.12.58.186:1521/dual
    spring.datasource.username=dual
    spring.datasource.password=dual
    
    spring.datasource.tomcat.initial-size=10
    spring.datasource.tomcat.max-active=50
    spring.datasource.tomcat.max-wait=1000
    spring.datasource.tomcat.validation-query=select 1 from dual
    spring.datasource.tomcat.test-on-borrow=true
    spring.datasource.tomcat.max-idle=100
    spring.datasource.tomcat.min-idle=10
    spring.datasource.tomcat.testWhileIdle=true
    spring.datasource.tomcat.removeAbandoned=true