JAVA-springboot 集成 mysql/sql server

springboot 集成 mysql

pom

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

yml

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/dictionary?useUnicode=true&characterEncoding=utf8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=GMT%2B8
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver

springboot 集成 sql server

如果依赖下载不下来，先去下载jar到本地
链接：jar下载链接
提取码：bnb2
然后打开cmd.exe，到jar 所在的目录
执行下列命令可以将jar导入maven仓库：

mvn install:install-file -Dfile=sqljdbc4-4.0.jar -Dpackaging=jar -DgroupId=com.microsoft.sqlserver -DartifactId=sqljdbc4 -Dversion=4-4.0

pom

	<dependency>
        <groupId>com.microsoft.sqlserver</groupId>
        <artifactId>sqljdbc4</artifactId>
        <version>4.0</version>
    </dependency>

yml

spring:
  datasource:
    url: jdbc:sqlserver://localhost:1433;DatabaseName=myTest
    username: sa
    password: 123456
    driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver