• 多数据源


    在Springboot中配置多数据源

    首先在application.properties文件中配置好两个数据源的地址
    server.port=8080
    server.context-path=/p2p-admin01

    spring.mvc.view.prefix=/
    spring.mvc.view.suffix=.jsp

    #p2padmin   两个数据源
    spring.datasource.p2padminurl=jdbc:mysql://192.168.119.128:3306/p2padmin?useUnicode=true&characterEncoding=utf8&useSSL=false
    spring.datasource.p2padminusername=root
    spring.datasource.p2padminpassword=123456
    spring.datasource.p2padmindriver=com.mysql.jdbc.Driver

    #p2padmin
    spring.datasource.p2purl=jdbc:mysql://192.168.119.128:3306/p2p?useUnicode=true&characterEncoding=utf8&useSSL=false
    spring.datasource.p2pusername=root
    spring.datasource.p2ppassword=123456
    spring.datasource.p2pdriver=com.mysql.jdbc.Driver


    #配置mybatis的配置文件路径
    mybatis.mapper-locations=classpath:com/bjpowernode/p2p/admin/mapper/*.xml


    第二步;  写一个类  读取到配置文件中的数据信息放在DataSourceConfig 对象中 一定要注意两个注解@Component
    @ConfigurationProperties(prefix="spring.datasource") // 这个是通过读取配置文件中的前缀为spring.datasource的信息

    package com.bjpowernode.p2p.admin.datasource;

    import org.springframework.boot.context.properties.ConfigurationProperties;
    import org.springframework.stereotype.Component;
    @Component
    @ConfigurationProperties(prefix="spring.datasource")
    public class DataSourceConfig {

        //#p2padmin
        private String p2padminurl;
        private String p2padminusername;
        private String p2padminpassword;
        private String p2padmindriver;

        //#p2p
        private String p2purl;
        private String p2pusername;
        private String p2ppassword;
        private String p2pdriver;
        
        public String getP2padminurl() {
            return p2padminurl;
        }
        public void setP2padminurl(String p2padminurl) {
            this.p2padminurl = p2padminurl;
        }
        public String getP2padminusername() {
            return p2padminusername;
        }
        public void setP2padminusername(String p2padminusername) {
            this.p2padminusername = p2padminusername;
        }
        public String getP2padminpassword() {
            return p2padminpassword;
        }
        public void setP2padminpassword(String p2padminpassword) {
            this.p2padminpassword = p2padminpassword;
        }
        public String getP2padmindriver() {
            return p2padmindriver;
        }
        public void setP2padmindriver(String p2padmindriver) {
            this.p2padmindriver = p2padmindriver;
        }
        public String getP2purl() {
            return p2purl;
        }
        public void setP2purl(String p2purl) {
            this.p2purl = p2purl;
        }
        public String getP2pusername() {
            return p2pusername;
        }
        public void setP2pusername(String p2pusername) {
            this.p2pusername = p2pusername;
        }
        public String getP2ppassword() {
            return p2ppassword;
        }
        public void setP2ppassword(String p2ppassword) {
            this.p2ppassword = p2ppassword;
        }
        public String getP2pdriver() {
            return p2pdriver;
        }
        public void setP2pdriver(String p2pdriver) {
            this.p2pdriver = p2pdriver;
        }    
    }

    第三步:写一个类创建一个数据源、一个sqlSessionFactory工厂、一个SqlSessionTemplate
        再写一个类去配置另一个数据源
    package com.bjpowernode.p2p.admin.datasource;

    import javax.sql.DataSource;

    import org.apache.ibatis.session.SqlSessionFactory;
    import org.mybatis.spring.SqlSessionFactoryBean;
    import org.mybatis.spring.SqlSessionTemplate;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;

    import com.alibaba.druid.pool.DruidDataSource;

    @Configuration
    @MapperScan(basePackages="com.bjpowernode.p2p.admin.mapper",sqlSessionTemplateRef="getP2PAdminSqlsessionTemplate")
    public class P2PadminDataSource {
        @Autowired
        private DataSourceConfig dataSourceConfig;
        
        /**
         * 配置p2padmin的数据源
         * @return
         */
        @Bean
        public DataSource getP2PAdminDataSource() {
            DruidDataSource dataSource = new DruidDataSource();
            dataSource.setUrl(dataSourceConfig.getP2padminurl());
            dataSource.setPassword(dataSourceConfig.getP2padminpassword());
            dataSource.setUsername(dataSourceConfig.getP2padminusername());
            dataSource.setDriverClassName(dataSourceConfig.getP2padmindriver());
            return dataSource;
        }
        /**
         * 配置sqlSessionFactory工厂
         * @return
         * @throws Exception
         */
        @Bean
        public SqlSessionFactory getP2PAdminSqlSessionFactory() throws Exception {
            
            SqlSessionFactoryBean SqlSessionFactory = new SqlSessionFactoryBean();
            SqlSessionFactory.setDataSource(this.getP2PAdminDataSource());//通过this来将数据源配置进来
            return SqlSessionFactory.getObject();
        }
        
        /**
         * 配置SqlSessionTemplate
         * @return
         * @throws Exception
         */
        @Bean
        public SqlSessionTemplate getP2PAdminSqlsessionTemplate() throws Exception {
            SqlSessionTemplate sqlSessionTemplate = new SqlSessionTemplate(this.getP2PAdminSqlSessionFactory());
            return sqlSessionTemplate;
            
        }    
    }

    第四步: 要在启动时,加上//exclude = (DataSourceAutoConfiguration.class)排除掉自动配置的数据源  因为配置了两个数据源           
                  @SpringBootApplication(exclude = (DataSourceAutoConfiguration.class))

    ----------------------------------------------------------------------------------
    package com.bjpowernode.p2p.admin;
    import org.apache.logging.log4j.LogManager;
    import org.apache.logging.log4j.core.Logger;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;
    //exclude = (DataSourceAutoConfiguration.class)排除掉自动配置的数据源  因为配置了两个数据源
    @SpringBootApplication(exclude = (DataSourceAutoConfiguration.class))
    public class P2pAdminApplication {
        /**
         * 定义一个log4j2的日志记录器
         */
        private static final Logger logger = (Logger) LogManager.getLogger(P2pAdminApplication.class);
        
        public static void main(String[] args) {
            logger.info("spring boor 启动···················");
            SpringApplication.run(P2pAdminApplication.class, args);
        }
    }


















  • 相关阅读:
    组件映射
    联合主键关联
    一对一单向双向主键关联
    7函数
    forEach与map
    3运算符与表达式
    作用域声明提升
    php程序设计 1,2章节
    angularJs(3)过滤器
    angularJs(1)指令篇
  • 原文地址:https://www.cnblogs.com/zgxz/p/7805491.html
Copyright © 2020-2023  润新知