卜若的代码笔记系列-Web系列-SpringBoot-第十七章：jdbc连接sqlserver-3217

1.首先，你的jdbc的pom的配置最好是我这个

     

   <!--数据库-->
        
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>sqljdbc4</artifactId>
<version>4.0</version>
</dependency>
 
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
    </dependency>
    <dependency>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

<dependency>
<groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.0.5</version>
</dependency>

2.application.properties的配置

spring.datasource.url=jdbc:sqlserver:******;database=*****;integratedSecurity=false;
spring.datasource.username=***
spring.datasource.password=*****
spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver

这样，你就能和数据库连上了，下一章教你怎么向你的数据库写数据