SpringBoot连接数据库的方式

1、Spring集成的服务

直接通过注入方式使用，如redis，jdbc等等服务。

spring:
  redis:
    host: localhost
    port: 6379
    password: 123456
    database: 0
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/test
    username: root
    password: 123456

@Autowired
private RedisTemplate<String, Object> redisTemplate;

@Autowired
private JdbcTemplate jdbcTemplate;

2、非spring集成(注册Bean服务)

iotdb:
    host: 127.0.0.1
    port: 8080
    username: root
    password: 123456

@Data
@Component
@ConfigurationProperties(prefix = "iotdb")
public class ConnUtils{

    private String ip;
    private String port;
    private String username;
    private String passwrod;

    // 通过Bean注册成长连接，启动项目就连接上
    @Bean
    public Connection connection(){
        Connection connection = new connection(ip,port,username,passwrod);
        connection.openConnection();
        return connection;
    }
}
/**
* 调用方式
**/
public class Test{
    @Autowired
    private Connection connection;
}

2、非spring集成应用(静态调用)

iotdb:
    host: 127.0.0.1
    port: 8080
    username: root
    password: 123456

@Data
@Component
@ConfigurationProperties(prefix = "iotdb")
public class ConnUtils{

    private static String ip;
    private static String port;
    private static String username;
    private static String passwrod;

    public void setIp(String ip){
        ConnUtils.ip = id;
    }
    public void setPort(String port){
        ConnUtils.port = port;
    }
    public void setUsername(String username){
        ConnUtils.username = username;
    }
    public void setPasswrod(String passwrod){
        ConnUtils.passwrod = passwrod;
    }

    // 短连接，每次需要时就手动调用
    public static Connection getConnection(){
        Connection connection = new connection(ip,port,username,passwrod);
        connection.openConnection();
        return connection;
    }
}
/**
* 调用方式
**/
public class Test{

    public void method(){
        Connection connection = ConnUtils.getConnection();
    }
}