mybatis 多数据源

最新推荐文章于 2022-07-17 07:52:55 发布

ht_stonebridge

最新推荐文章于 2022-07-17 07:52:55 发布

阅读量735

点赞数

本文链接：https://blog.csdn.net/neutrojan/article/details/8910826

版权

<?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>

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);
    }
}