mybatis多数据源配置

最新推荐文章于 2023-10-23 12:39:49 发布

原创最新推荐文章于 2023-10-23 12:39:49 发布 · 7.8k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#jdbc #string #properties #encoding #url #import

这篇博客介绍了如何在MyBatis中配置多个数据源。通过在`environments`节点下创建不同的`environment`，每个环境对应一个`dataSource`，分别配置了不同数据库的连接信息，包括driver、url、username和password。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在environments里面建多个environment，每个environment里面建一个dataSource

java代码：

package dbcopy;

import java.io.IOException;
import java.io.Reader;
import java.util.List;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import test.dao.user1.AlprNameMstrDbMapper;
import test.dao.user1.ParmMngeDb1Mapper;
import test.model.user1.AlprNameMstrDb;
import test.model.user1.AlprNameMstrDbExample;
import test.model.user1.ParmMngeDb1;
import test.model.user1.ParmMngeDb1Example;

public class DBCopy {

    private static final String resource = "hirdb-config.xml";

    public static void main(String args[]) throws IOException {

        Reader readerFrom = getReader(resource);
        Reader readerTo = getReader(resource);

//不同的environment 连接不同的数据源

        SqlSessionFactory sessionFactoryFrom = getSqlSessionFactory(readerFrom, "development");
        SqlSessionFactory sessionFactoryTo = getSqlSessionFactory(readerTo, "to");

        SqlSession sessionFrom = sessionFactoryFrom.openSession(true);
        SqlSession sessionTo = sessionFactoryTo.openSession(true);

        AlprNameMstrDbMapper alprNameMstrDbMapper = sessionFrom.getMapper(AlprNameMstrDbMapper.class);
        ParmMngeDb1Mapper parmMngeDb1Mapper = sessionTo.getMapper(ParmMngeDb1Mapper.class);

        AlprNameMstrDbExample alprNameMstrDb = new AlprNameMstrDbExample();
        ParmMngeDb1Example parmMngeDb1Example = new ParmMngeDb1Example();

        List<AlprNameMstrDb> list = alprNameMstrDbMapper.selectByExample(alprNameMstrDb);
        List<ParmMngeDb1> listTo = parmMngeDb1Mapper.selectByExample(parmMngeDb1Example);

        System.out.println(list.size());
        System.out.println(listTo.size());

    }

    private static Reader getReader(String resource) throws IOException {
        return Resources.getResourceAsReader(resource);
    }

    private static SqlSessionFactory getSqlSessionFactory(Reader reader, String environmentId) {

        return new SqlSessionFactoryBuilder().build(reader, environmentId);
    }
}

hirdb-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>

   <properties resource="hirdb.properties" />

   <typeAliases>
       <typeAlias type="test.model.user1.AlprNameMstrDb" alias="AlprNameMstrDb" />
       <typeAlias type="test.model.user1.ParmMngeDb1" alias="ParmMngeDb1" />
   </typeAliases>

   <environments default="development">
       <environment id="development">
           <transactionManager type="JDBC">
           </transactionManager>
           <dataSource type="POOLED" >
               <property name="driver" value="${driver}" />
               <property name="url" value="${url}" />
               <property name="username" value="${username}" />
               <property name="password" value="${password}" />
           </dataSource>
       </environment>

       <environment id="to">
           <transactionManager type="JDBC">
           </transactionManager>
           <dataSource type="POOLED" >
               <property name="driver" value="${driver}" />
               <property name="url" value="jdbc:hitachi:hirdb://DBID=22200,DBHOST=192.168.11.113" />
               <property name="username" value="${username}" />
               <property name="password" value="${password}" />
           </dataSource>
       </environment>
   </environments>

   <mappers>
       <mapper resource="test/xml/user1/AlprNameMstrDbMapper.xml" />
       <mapper resource="test/xml/user1/ParmMngeDb1Mapper.xml" />
   </mappers>

</configuration>

hirdb.properties

driver=JP.co.Hitachi.soft.HiRDB.JDBC.HiRDBDriver
url=jdbc:hitachi:hirdb://DBID=22200,DBHOST=127.0.0.1
username=USER1
password=pswd