使用JDBC从mysql数据库中导出数据到Oracle数据库
来源:互联网 发布:百度搜索关键词优化 编辑:程序博客网 时间:2024/06/07 07:34
public class SubjectImpornt {
public static final String url = "jdbc:mysql://IP地址/数据库名称";
public static final String name = "com.mysql.jdbc.Driver";
public static final String user = "root";
public static final String password = "ln123";
public static final String urlo = "jdbc:oracle:thin:@IP地址:端口号:orcl";
public static final String nameo = "oracle.jdbc.driver.OracleDriver";
public static final String usero = "账号";
public static final String passwordo = "密码";
public static Connection conn = null;
public static PreparedStatement pst = null;
public static Connection conno = null;
public static PreparedStatement psto = null;
public static void main(String[] args) throws ClassNotFoundException, SQLException {
String select_sql = "select * from b2_subnumber_mgr";
String insert_sql = "insert into SUBJECT (ID, SUBJECT_NAME, SUBJECT_NUM) values (?,?,?)";
Class.forName(name);
Class.forName(nameo);
conn = DriverManager.getConnection(url, user, password);
conno = DriverManager.getConnection(urlo, usero, passwordo);
pst = conn.prepareStatement(select_sql);
psto = conno.prepareStatement(insert_sql);
ResultSet rs = pst.executeQuery();
while(rs.next()) {
psto.setString(1, IdUtil.getUUID());
psto.setString(2, rs.getString(4));
psto.setString(3, rs.getString(5));
psto.executeUpdate();
}
rs.close();
pst.close();
psto.close();
conn.close();
conno.close();
}
public static final String url = "jdbc:mysql://IP地址/数据库名称";
public static final String name = "com.mysql.jdbc.Driver";
public static final String user = "root";
public static final String password = "ln123";
public static final String urlo = "jdbc:oracle:thin:@IP地址:端口号:orcl";
public static final String nameo = "oracle.jdbc.driver.OracleDriver";
public static final String usero = "账号";
public static final String passwordo = "密码";
public static Connection conn = null;
public static PreparedStatement pst = null;
public static Connection conno = null;
public static PreparedStatement psto = null;
public static void main(String[] args) throws ClassNotFoundException, SQLException {
String select_sql = "select * from b2_subnumber_mgr";
String insert_sql = "insert into SUBJECT (ID, SUBJECT_NAME, SUBJECT_NUM) values (?,?,?)";
Class.forName(name);
Class.forName(nameo);
conn = DriverManager.getConnection(url, user, password);
conno = DriverManager.getConnection(urlo, usero, passwordo);
pst = conn.prepareStatement(select_sql);
psto = conno.prepareStatement(insert_sql);
ResultSet rs = pst.executeQuery();
while(rs.next()) {
psto.setString(1, IdUtil.getUUID());
psto.setString(2, rs.getString(4));
psto.setString(3, rs.getString(5));
psto.executeUpdate();
}
rs.close();
pst.close();
psto.close();
conn.close();
conno.close();
}
}
阅读全文
0 0
- 使用JDBC从mysql数据库中导出数据到Oracle数据库
- 从mysql中将数据导入到oracle数据库中
- 从MySQL数据库中导出数据
- oracle 数据库中数据导出到excel
- 使用 jdbc 从数据库中查询数据
- 使用jdbc将mysql数据库导出到Excel
- oracle数据库导出到mysql
- 从Hive导出数据到Oracle数据库--Sqoop
- Sqoop1.4.4将文件数据集从HDFS中导出到MySQL数据库表中
- 【Database】【JDBC】从.xls与.dbf文件中转移数据到MySQL数据库
- sqoop从HIVE导出元数据到oracle数据库中实例
- jdbc导出数据库数据到Excel表格
- 数据从sqlserver中导出到access数据库中
- 数据从sqlserver中导出到access数据库中
- NPOI从数据库中导出数据到excel中
- 从数据库中导出数据
- 从数据库中导出数据
- 从文本文档中导入数据库数据、从数据库中导出数据到文本文档
- jQuery Validate验证框架详解
- 一元函数积分学基本计算例题
- C#入门基础之计算器
- 工作第三到五年
- POJ 3311
- 使用JDBC从mysql数据库中导出数据到Oracle数据库
- C#处理表格的问题
- GOLANG 实现Stack和Queue
- Kotlin-解构声明
- 模态视图和视图控制器的生命周期
- 个人网站买主机和域名,网站备案
- 安卓自定义圆环进度
- 你可能不知道,你登曾是个气喘小胖子,靠努力逆袭完成梦想
- 云服务器一二