問題描述
我必須使用兩個數(shù)據(jù)庫:
I have to work with two database:
- DB2
- 甲骨文
我在 DB2 數(shù)據(jù)庫中有一個名為 NAVID 的模式.我想使用 Java 為 Oracle 中的所有表創(chuàng)建相同的架構(gòu).
I have a schema in DB2 database named NAVID. I want to create the same schema with all tables in Oracle using Java.
public class automateExport {
static String value;
public static void main(String[] args) throws SQLException, ClassNotFoundException {
ResultSet rs = null;
Connection DB2 = getConnection();
String sqlstm = "SELECT * FROM SYSCAT.COLUMNS WHERE TABSCHEMA NOT LIKE 'SYS%'";
PreparedStatement mainStmt = DB2.prepareStatement(sqlstm);
ResultSet query = mainStmt.executeQuery();
}
private static Connection getConnection() throws ClassNotFoundException, SQLException{
Class.forName("com.ibm.db2os390.sqlj.jdbc.DB2SQLJDriver");
Connection connection =
DriverManager.getConnection("jdbc:db2://localhost:50000/navid","navid","oracle");
return connection;
}
我不知道如何選擇所有有列的表并在 db2 中創(chuàng)建相同的表.
I dont know how to select all tables with columns and create the same tables in db2.
推薦答案
為了做這樣的事情，我邀請你做多種方法；第一種方法必須選擇一個表并獲取這些值并將它們復(fù)制到一個向量中，第二種方法需要一個參數(shù)；向量并獲取這些值并將它們插入到第二個數(shù)據(jù)庫oracle"中.如果您想了解任何其他信息，請通過我的 gmail 帳戶 zahranemehdi@gmail.com 與我聯(lián)系.
To make such thing i invite you to make multiple methods; the first method must select a table and get those values and copy them into a vector, and the second method take an argument; the vector and take those values and insert them in the second database 'oracle'. If you would like any other informations contact me in my gmail account zahranemehdi@gmail.com.
這篇關(guān)于如何使用 Java 創(chuàng)建多個模式連接?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！