SpringBoot:springboot与mysql配置

迈不过友情╰ 2022-05-24 09:24 515阅读 0赞

原文来自:http://www.vxzsk.com/355.html

在任何一个平台都逃离不了数据库的操作，那么在spring boot中怎么接入数据库呢？

很简单，我们需要在application.properties进行配置一下，application.properties路径是src/main/resources下，对于application.properties更多的介绍请自行百度进行查找相关资料进行查看，在此不进行过多的介绍，以下只是mysql的配置文件。

大体步骤：

(1)在application.properties中加入datasouce的配置

(2)在pom.xml加入mysql的依赖。

(3)获取DataSouce的Connection进行测试。

src/main/resouces/application.properties：

<table style="border-spacing:0px;width:1242px;color:rgb(51,51,51);font-size:14px;background-color:rgb(255,255,255);"> 
 <tbody style="float:none;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;background:none;"> 
  <tr style="border-collapse:collapse;padding:5px;border-top:0px;background:none;float:none;line-height:1.1em;margin:0px;vertical-align:baseline;min-height:auto;"> 
   <td style="margin:0px;"> 
    <div style="padding:0px;margin:0px;">
      1 
    </div> 
    <div style="padding:0px;margin:0px;">
      2 
    </div> 
    <div style="padding:0px;margin:0px;">
      3 
    </div> 
    <div style="padding:0px;margin:0px;">
      4 
    </div> 
    <div style="padding:0px;margin:0px;">
      5 
    </div> 
    <div style="padding:0px;margin:0px;">
      6 
    </div> 
    <div style="padding:0px;margin:0px;">
      7 
    </div> 
    <div style="padding:0px;margin:0px;">
      8 
    </div> 
    <div style="padding:0px;margin:0px;">
      9 
    </div> 
    <div style="padding:0px;margin:0px;">
      10 
    </div> 
    <div style="padding:0px;margin:0px;">
      11 
    </div></td> 
   <td style="border-collapse:collapse;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;padding:0px;margin:0px;border-width:0px;font-size:13px;line-height:1.1em;float:none;vertical-align:baseline;min-height:auto;background:none;"> 
    <div style="padding:24px 24px 0px;margin:0px auto;width:1216px;"> 
     <div style="padding:0px;margin:0px;"> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">########################################################</code> 
     </div> 
     <div style="padding:0px;margin:0px;"> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">###datasource</code> 
     </div> 
     <div style="padding:0px;margin:0px;"> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">########################################################</code> 
     </div> 
     <div style="padding:0px;margin:0px;"> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">spring.datasource.url&nbsp;=&nbsp;jdbc:mysql://localhost:3306/test</code> 
     </div> 
     <div style="padding:0px;margin:0px;"> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">spring.datasource.username&nbsp;=&nbsp;root</code> 
     </div> 
     <div style="padding:0px;margin:0px;"> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">spring.datasource.password&nbsp;=&nbsp;root</code> 
     </div> 
     <div style="padding:0px;margin:0px;"> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">spring.datasource.driverClassName&nbsp;=&nbsp;com.mysql.jdbc.Driver</code> 
     </div> 
     <div style="padding:0px;margin:0px;"> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">spring.datasource.max-active=20</code> 
     </div> 
     <div style="padding:0px;margin:0px;"> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">spring.datasource.max-idle=8</code> 
     </div> 
     <div style="padding:0px;margin:0px;"> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">spring.datasource.min-idle=8</code> 
     </div> 
     <div style="padding:0px;margin:0px;"> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">spring.datasource.initial-size=10</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

pom.xml配置：

<table style="border-spacing:0px;width:1242px;color:rgb(51,51,51);font-size:14px;background-color:rgb(255,255,255);"> 
 <tbody style="float:none;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;background:none;"> 
  <tr style="border-collapse:collapse;padding:5px;border-top:0px;background:none;float:none;line-height:1.1em;margin:0px;vertical-align:baseline;min-height:auto;"> 
   <td style="margin:0px;"> 
    <div style="padding:0px;margin:0px;">
      1 
    </div> 
    <div style="padding:0px;margin:0px;">
      2 
    </div> 
    <div style="padding:0px;margin:0px;">
      3 
    </div> 
    <div style="padding:0px;margin:0px;">
      4 
    </div></td> 
   <td style="border-collapse:collapse;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;padding:0px;margin:0px;border-width:0px;font-size:13px;line-height:1.1em;float:none;vertical-align:baseline;min-height:auto;background:none;"> 
    <div style="padding:24px 24px 0px;margin:0px auto;width:1216px;"> 
     <div style="padding:0px;margin:0px;"> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">&lt;</code> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(255,120,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;font-weight:bold;min-height:auto;">dependency</code> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">&gt;</code> 
     </div> 
     <div style="padding:0px;margin:0px;"> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">&lt;</code> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(255,120,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;font-weight:bold;min-height:auto;">groupId</code> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">&gt;mysql&lt;/</code> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(255,120,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;font-weight:bold;min-height:auto;">groupId</code> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">&gt;</code> 
     </div> 
     <div style="padding:0px;margin:0px;"> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">&lt;</code> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(255,120,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;font-weight:bold;min-height:auto;">artifactId</code> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">&gt;mysql-connector-java&lt;/</code> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(255,120,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;font-weight:bold;min-height:auto;">artifactId</code> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">&gt;</code> 
     </div> 
     <div style="padding:0px;margin:0px;"> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">&lt;/</code> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(255,120,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;font-weight:bold;min-height:auto;">dependency</code> 
      <code style="font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:14px;line-height:1.1em;color:rgb(0,0,0);background:none;border:0px;float:none;margin:0px;padding:0px;vertical-align:baseline;min-height:auto;">&gt;</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

到此相关配置就ok了，那么就可以在项目中进行测试了，我们可以新建一个class Demo进行测试，实体类创建完毕之后，我们可能需要手动进行编写建表语句，这时候我们可能就会想起Hibernate的好处了。那么怎么在spring boot使用Hibernate好的特性呢？So easy,具体怎么操作，请看上篇文章之[JPA – Hibernate][JPA _ Hibernate]。

[JPA _ Hibernate]: http://www.vxzsk.com/352.html