通过java反射连接数据库

首先新建一个资源文件：jdbc.properties

jdbc.Url =jdbc:mysql://localhost:3306/test
jdbc.username = root
jdbc.password = root
jdbc.driverClass=com.mysql.jdbc.Driver

主要代码：

package day01.Annotation.DataSourceJdbc;



import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;

import javax.sql.DataSource;

//声明这是一个配置类
@Configuration
//指定初始化需要扫描的包
@ComponentScan("day01.Annotation.DataSourceJdbc")
//加载配置文件
@PropertySource("day01/Annotation/DataSourceJdbc/jdbc.properties")
public class DataSources {
	//通过注解的方式获取资源文件的值
    @Value("${jdbc.Url}")
    private String jdbcUrl;
    @Value("${jdbc.username}")
    private String userName;
    @Value("${jdbc.password}")
    private String passWord;
    @Value("${jdbc.driverClass}")
    private String driverClassName;

    @Bean("dataSource")
    public DataSource getDataSource() {
        DruidDataSource dds =new DruidDataSource();

        dds.setUrl(jdbcUrl);
        dds.setUsername(userName);
        dds.setPassword(passWord);
        dds.setDriverClassName(driverClassName);
        return dds;

    }
}

测试：

package day01.Annotation.DataSourceJdbc;

import org.springframework.context.annotation.AnnotationConfigApplicationContext;

import javax.sql.DataSource;
import java.sql.Connection;

public class Client {

    public static void main(String[] args) throws Exception {
        AnnotationConfigApplicationContext context = new AnnotationConfigApplicationContext(DataSources.class);
        DataSource dataSource = (DataSource) context.getBean("dataSource");
        Connection conn = dataSource.getConnection();
        System.out.println(conn);
        conn.close();
    }
}

运行结果：