/**
 * @Author lsc
 * <p>spring3.2之前 @Profile注解用在類上
 * spring3.2 之后 @Profile注解用在 方法上
 * </p>
 */
@Configuration
public class DataSourceConfig {

  @Bean
  @Profile("dev")
  public DataSource devDataSource() {
    System.out.println(" dev DataSource !!");
    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setDriverClassName("com.MySQL.jdbc.Driver");
    basicDataSource.setUrl("jdbc:mysql://localhost:3308/zszxz");
    basicDataSource.setUsername("root");
    basicDataSource.setPassword("1234");
    return basicDataSource;
  }

  @Bean
  @Profile("prod")
  public DataSource prodDataSource() {
    System.out.println(" prod DataSource !!");
    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setDriverClassName("com.mysql.jdbc.Driver");
    basicDataSource.setUrl("jdbc:mysql://localhost:3306/zszxz");
    basicDataSource.setUsername("root");
    basicDataSource.setPassword("1234");
    return basicDataSource;
  }
}

<beans profile="dev">
    <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource"
       p:driverClassName="com.mysql.jdbc.Driver"
       p:url="jdbc:mysql://localhost:3306/zszxzb"
       p:username="root"
       p:password="1234"/>
</beans>
<beans profile="prod">
    <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource"
       p:driverClassName="com.mysql.jdbc.Driver"
       p:url="jdbc:mysql://localhost:3306/zszxzb"
       p:username="root"
       p:password="1234"/>
</beans>

<context-param>
	<param-name>spring.profiles.active</param-name>
  <param-value>dev</param-value>
</context-param>
<servlet>
    <servlet-name>zszxzServlet</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <init-param>
      <param-name>spring.profiles.default</param-name>
      <param-value>dev</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
  <servlet-name>zszxzServlet</servlet-name>
  <url-pattern>/</url-pattern>
</servlet-mapping>

@RunWith(SpringJUnit4ClassRunner.class)//創(chuàng)建spring應(yīng)用上下文
@ContextConfiguration(classes= DataSourceConfig.class)//加載配置類
@ActiveProfiles("dev")
public class ProfileTest {

  @Autowired
  private DataSource dataSource;

  @Test
  public void sheetTest(){
    JdbcTemplate jdbc = new JdbcTemplate(dataSource);
    List<String> query = jdbc.query("select * from customer", new RowMapper<String>() {
      @Override
      public String mapRow(ResultSet rs, int rowNum) throws SQLException {
        return rs.getLong("id") + ":" + rs.getString("customer_name");
      }
    });
    // [19:知識追尋者, 20:知識追尋者, 21:知識追尋者, 22:知識追尋者, 23:知識追尋者]
    System.out.println(query);
  }
}