com.wu.framework.easy.temple.config.DataSourceConfig Maven / Gradle / Ivy
package com.wu.framework.easy.temple.config;
import com.mysql.cj.jdbc.MysqlDataSource;
import org.h2.jdbcx.JdbcDataSource;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import javax.sql.DataSource;
/**
* description 手动配置数据源
*
* @author Jia wei Wu
* @date 2021/2/9 下午5:29
*/
@Configuration
public class DataSourceConfig {
@Bean(name = "dataSourceMySQL")
public DataSource dataSourceMySQL() {
MysqlDataSource build = DataSourceBuilder.create().type(MysqlDataSource.class).build();
build.setUrl("jdbc:mysql://127.0.0.1:3306/temp?rewriteBatchedStatements=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai");
build.setUser("root");
build.setPassword("wujiawei");
return build;
}
/**
* @param
* @return describe H2数据库
* @author Jia wei Wu
* @date 2021/4/15 8:21 下午
**/
// @Bean(name = "dataSourceH2")
public DataSource dataSourceH2() {
JdbcDataSource build = DataSourceBuilder.create().type(org.h2.jdbcx.JdbcDataSource.class).build();
build.setUrl("jdbc:h2:file:./database/db");
build.setUser("root");
build.setPassword("wujiawei");
return build;
}
}