com.huawei.dataconvert.db.convert

public void convertAllTable(DataBase sourceDB, DBUser suser,
DataBase targetDB, DBUser tuser, DataFilter filter)
throws Exception
{
List<SqlRecord> records = null;
String userName = suser.getUserName();
records = filter.getSqls();
Connection sconn = sourceDB.getConn(suser.getUserName(), suser
.getPassword());
Connection tconn = targetDB.getConn(tuser.getUserName(), tuser
.getPassword());
sconn.setAutoCommit(true);
tconn.setAutoCommit(true);
for (SqlRecord record : records)
{
String tableName = record.getTableName();
record.setUser(suser.getUserName());
if (DataConvertor.user_TableMap.get(userName).contains(tableName))
{
// System.out.println("user:"+userName+" table:"+tableName);
convertAllTable(sourceDB, sconn, tconn, record);
}
}
}

public void convertSequence(DataBase sourceDB, DBUser suser,
DataBase targetDB, DBUser tuser)
{
Connection sconn = sourceDB.getConn(suser.getUserName(), suser
.getPassword());
Connection tconn = targetDB.getConn(tuser.getUserName(), tuser
.getPassword());
try
{
convertSeque(sconn, tconn);
} catch (Exception e1)
{
e1.printStackTrace();
}

}

/**
* @param originDB
* @param user
* @param targetDB
* @param user2
* @param filter
*/
public void convertAllViews(DataBase originDB, DBUser user,
DataBase targetDB, DBUser user2, DataFilter filter)
{
// TODO Auto-generated method stub

}
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值