第springboot+springJdbc+postgresql實現多數據源的配置最近公司在服務拆遷,接口轉移,相同的功能接口到要遷移到對應的服務中,因為時間比較趕,別問為什么沒給時間,沒人,沒資源,但是活還是得干的,為了減少工作量和穩妥的需要分兩步走

先遷移相關代碼,保證包的路徑不變,請求接口的路徑不變

將遷移的相關代碼進行遷表遷庫(這目前還沒做,計劃9月實施)

配置文件

數據庫配置相關類

importcom.alibaba.druid.pool.DruidDataSource;

importjava.io.Serializable;

importjava.sql.SQLException;

publicclassJdbcConfigimplementsSerializable{

publicJdbcConfig(){

super();

//TODOAuto-generatedconstructorstub

publicbooleanisDecrypt(){

returndecrypt;

publicvoidsetDecrypt(booleandecrypt){

this.decrypt=decrypt;

publicStringgetDriverClass(){

returndriverClass;

publicvoidsetDriverClass(StringdriverClass){

this.driverClass=driverClass;

publicStringgetTerminalUrl(){returnterminalUrl;}

publicvoidsetTerminalUrl(StringterminalUrl){this.terminalUrl=terminalUrl;}

publicStringgetSlaveurl(){

returnslaveurl;

publicvoidsetSlaveurl(Stringslaveurl){

this.slaveurl=slaveurl;

publicStringgetUsername(){

returnusername;

publicvoidsetUsername(Stringusername){

this.username=username;

publicStringgetPassword(){

returnpassword;

publicvoidsetPassword(Stringpassword){

this.password=password;

publicintgetInitialSize(){

returninitialSize;

publicvoidsetInitialSize(intinitialSize){

this.initialSize=initialSize;

publicintgetMinIdle(){

returnminIdle;

publicvoidsetMinIdle(intminIdle){

this.minIdle=minIdle;

publicintgetMaxActive(){

returnmaxActive;

publicvoidsetMaxActive(intmaxActive){

this.maxActive=maxActive;

privatebooleandecrypt;

privateStringdriverClass;

privateStringterminalUrl;

privateStringslaveurl;

privateStringusername;

privateStringpassword;

privateintinitialSize;

privateintminIdle;

privateintmaxActive;

publicDruidDataSourcemainds()throwsSQLException{

DruidDataSourceds=ds();

ds.setUrl(terminalUrl);

returnds;

publicDruidDataSourceslaveds()throwsSQLException{

DruidDataSourceds=ds();

ds.setUrl(slaveurl);

returnds;

privateDruidDataSourceds()throwsSQLException{

DruidDataSourceds=newDruidDataSource();

ds.setUrl(terminalUrl);

ds.setUsername(username);

ds.setPassword(password);

ds.setFilters("config");

ds.setConnectionProperties("config.decrypt="+decrypt);

ds.setInitialSize(initialSize);

ds.setMaxActive(maxActive);

ds.setTimeBetweenEvictionRunsMillis(60000);

ds.setMinEvictableIdleTimeMillis(300000);

ds.setValidationQuery("select'X'");

ds.setTestWhileIdle(true);

ds.setTestOnBorrow(false);

ds.setTestOnReturn(false);

System.out.println("terminalUrl:"+terminalUrl);

returnds;

}

相關配置

@Bean

@ConfigurationProperties(prefix="jdbc")

publicJdbcConfigjdbcConfig(){

returnnewJdbcConfig();

@Bean

@ConfigurationProperties(prefix="business.jdbc")

publicJdbcConfigbusinessJdbcConfig(){

returnnewJdbcConfig();

@Bean(initMethod="init",destroyMethod="close")

publicDruidDataSourcebusinessDataSource()throwsSQLException{

returnbusinessJdbcConfig().mainds();

@Bean(initMethod="init",destroyMethod="close")

publicDruidDataSourcemasterDataSource()throwsSQLException{

returnjdbcConfig().mainds();

@Bean("jdbctemplate")

publicJdbcTemplatejdbcTemplate()throwsSQLException{

JdbcTemplatet=newJdbcTemplate();

t.setDataSource(masterDataSource());

returnt;

@Bean("businessJdbctemplate")

publicJdbcTemplatebusinessjdbcTemplate()throwsSQLException{

JdbcTemplatet=newJdbcTemplate();

t.setDataSource(businessDataSource());

returnt;

}

使用

@Bean

publicRobotDataDaorobotDataDao()throwsSQLException{

Robot