package com.exen.dbroll;

import java.sql.SQLException;

import javax.sql.DataSource;

import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;
import org.springframework.context.support.PropertySourcesPlaceholderConfigurer;

@Configuration
@PropertySource("datasource.properties")
public class AppConfig {

	@Bean
	public static PropertySourcesPlaceholderConfigurer PropertySources() {
		return new PropertySourcesPlaceholderConfigurer();
	}

	@Bean
	@Qualifier("dataSourceMySQL")
	public DataSource dataSourceMySQL() throws SQLException {
		CustomDatasource driverManagerDataSource = new CustomDatasource();
		driverManagerDataSource.setUrl("jdbc:mysql://localhost/employee");
		driverManagerDataSource.setUsername("root");
		driverManagerDataSource.setDriverClassName("com.mysql.jdbc.Driver");
		return driverManagerDataSource;
	}

	@Bean
	@Qualifier("dataSourceOracle")
	public DataSource dataSourceOracle() throws SQLException {
		CustomDatasource driverManagerDataSource = new CustomDatasource();
		driverManagerDataSource.setUrl("jdbc:oracle:thin:@localhost:1521:xe");
		driverManagerDataSource.setUsername("system");
		driverManagerDataSource.setDriverClassName("oracle.jdbc.driver.OracleDriver");
		return driverManagerDataSource;
	}

}