1、创建resources目录并标记为资源目录(Resources root)
2、创建datasource.properties配置文件,定义属性driver,url,username,password
3、在spring-config.xml文件中定义数据库配置的文件,即插入下面一句代码:
<context:property-placeholder location="datasource.properties" />
4、定义一个类读取配置文件的内容,通过注解的方式解析
//导入配置文件
@ImportResource("classpath:spring-config.xml")
public class DBHelper {
//通过注解的方式,读取配置文件的值交给定义的属性
@Value("${driver}")
private String driver;
@Value("${url}")
private String url;
@Value("${username}")
private String username;
@Value("${password}")
private String password;
@Bean("datasource")
public DriverManagerDataSource loadSource() {
DriverManagerDataSource dataSource = new DriverManagerDataSource();
dataSource.setDriverClassName(driver);
dataSource.setUsername(username);
dataSource.setPassword(password);
dataSource.setUrl(url);
return dataSource;
}
}
5、创建对象,获取连接
ApplicationContext ctx = new AnnotationConfigApplicationContext(DBHelper.class);
DriverManagerDataSource dataSource = ctx.getBean(DriverManagerDataSource.class);
try {
Connection conn = dataSource.getConnection();
System.out.println(conn);
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}