#springboot|springboot通过bean连接MySQL数据库

springboot通过bean连接MySQL数据库

import com.alibaba.druid.pool.DruidDataSource; import org.springframework.beans.factory.annotation.Value; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.context.annotation.PropertySource; import org.springframework.stereotype.Component; import javax.sql.DataSource; @Configuration @PropertySource("classpath:application-dev.properties") public class DataConfig {@Value("${spring.datasource.driver-class-name}") private String driver; @Value("${spring.datasource.url}") private String url; @Value("${spring.datasource.username}") private String username; @Value("${spring.datasource.mima}") private String password; @Bean public DataSource dataSource(){ DruidDataSource dataSource = new DruidDataSource(); dataSource.setDriverClassName(driver); dataSource.setUrl(url); dataSource.setUsername(username); dataSource.setPassword(password); dataSource.setValidationQuery("SELECT 1"); dataSource.setTestOnBorrow(true); return dataSource; }}

【#springboot|springboot通过bean连接MySQL数据库】注意:如果是多模块的话,把该类放在公共类中

    推荐阅读