hibernate jpa 实现连接多个数据库

最近使用jpa进行数据迁移,由于跨数据库,就直接使用jpa来做。

先放上配置文件:

<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://xmlns.jcp.org/xml/ns/persistence" version="2.1">
    <persistence-unit name="old" transaction-type="RESOURCE_LOCAL">
        <class>net.mllw.exports.entity.old.TBaseGoodsBrand</class>
        <class>net.mllw.exports.entity.old.TBaseGoodsClass</class>
        <class>net.mllw.exports.entity.old.TBaseGoodsInfo</class>
        <class>net.mllw.exports.entity.old.TBaseGoodsLable</class>
        <class>net.mllw.exports.entity.old.TBaseGoodsPicture</class>
        <class>net.mllw.exports.entity.old.TBaseGoodsRelativeClass</class>
        <class>net.mllw.exports.entity.old.TBaseGoodsRelativeLable</class>
        <class>net.mllw.exports.entity.old.TGoodsConsult</class>
        <class>net.mllw.exports.entity.old.TGoodsEvaluation</class>
        <exclude-unlisted-classes>true</exclude-unlisted-classes>
        <properties>
            <property name="hibernate.connection.url"
                      value="jdbc:mysql:xxx"/>
            <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
            <property name="hibernate.connection.username" value="xxx"/>
            <property name="hibernate.connection.password" value="xxx"/>
        </properties>
    </persistence-unit>
    <persistence-unit name="new" transaction-type="RESOURCE_LOCAL">
        <class>net.mllw.exports.entity.wen.TGGoods</class>
        <class>net.mllw.exports.entity.wen.TGGoodsChannel</class>
        <class>net.mllw.exports.entity.wen.TGGoodsCombination</class>
        <class>net.mllw.exports.entity.wen.TGGoodsCustomer</class>
        <class>net.mllw.exports.entity.wen.TGGoodsPicture</class>
        <class>net.mllw.exports.entity.wen.TGGoodsPrice</class>
        <class>net.mllw.exports.entity.wen.TGProduct</class>
        <class>net.mllw.exports.entity.wen.TGProductProperty</class>
        <class>net.mllw.exports.entity.wen.TGPromotion</class>
        <class>net.mllw.exports.entity.wen.TGPromotionCombination</class>
        <class>net.mllw.exports.entity.wen.TGPromotionCustomer</class>
        <class>net.mllw.exports.entity.wen.TGPromotionFavour</class>
        <class>net.mllw.exports.entity.wen.TGPromotionPicture</class>
        <exclude-unlisted-classes>true</exclude-unlisted-classes>

        <properties>
            <property name="hibernate.connection.url"
                      value="jdbc:mysql:xxx"/>
            <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
            <property name="hibernate.connection.username" value="xxx"/>
            <property name="hibernate.connection.password" value="xxx"/>
            <property name="hibernate.show_sql" value="true"/>
            <property name="hibernate.format_sql" value="true"/>
        </properties>
    </persistence-unit>
</persistence>

然后在代码里使用如下代码就可以了。


EntityManagerFactory factory = Persistence.();
EntityManager manager = factory.createEntityManager();


EntityManagerFactory factorynew = Persistence.();
EntityManager managernew = factorynew.createEntityManager();

....

factorynew.close();
factory.close();


转载于:https://my.oschina.net/mllw/blog/388523

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值