Springboot基础02：使用springboot创建简单的JDBC连接数据库

1、数据库采用spring boot自带的H2 database，创建并下载骨架，如下

2、springboot加载数据源

package com.idea;

import java.sql.Connection;
import java.sql.SQLException;

import javax.sql.DataSource;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.CommandLineRunner;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

import lombok.extern.slf4j.Slf4j;

@SpringBootApplication
@Slf4j
public class SpringbootSimplejdbcApplication implements CommandLineRunner{

	//加载数据源Bean
	@Autowired
	private DataSource dataSource;
	
	public static void main(String[] args) {
		SpringApplication.run(SpringbootSimplejdbcApplication.class, args);
	}

	@Override
	public void run(String... args) throws Exception {
		showConnection();
	}
	
	private void showConnection() throws SQLException{
		//直接输出Bean
		System.out.println("dataSource:"+dataSource.toString());
		//自动装配（springboot加载默认配置）
		Connection conn = dataSource.getConnection();
		System.out.println("connection:"+conn.toString());
		conn.close();
	}
	
	

}

3、没有任何配置，就可以加载到H2 database数据库