请问怎样从oracle导出表数据? 导出的表数据直接就是带INSERT语句的数据 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 不能用其他工具导出,比如用toad就能导出,但不太合适 怎样用java写一段上述生成的代码?拜托! http://www.cybercorlin.net/forum/print.php?id=165 import java.io.*;import java.sql.*;import java.text.*;import java.lang.*;import java.util.*;import java.lang.String;class select2insert{ public static void main(String args[]) throws IOException { String MyDBDriver="oracle.jdbc.driver.OracleDriver"; Connection conn = null; Statement stmt = null; ResultSet rs = null; try {Class.forName(MyDBDriver).newInstance();} catch(ClassNotFoundException e) { e.printStackTrace(); } catch (java.lang.InstantiationException e) { e.printStackTrace(); } catch ( java.lang.IllegalAccessException e) { e.printStackTrace(); } try { conn = DriverManager.getConnection("jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521)))(CONNECT_DATA = (SID = your_sid)(SERVER = DEDICATED)))","user","password"); stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); String sql = ""; //这里写上我在另外一个帖子里给你回的SQL语句 BufferedWriter fileou = new BufferedWriter(new FileWriter(args[0],false)); String insert_str = ""; try { rs = stmt.executeQuery(sql); while(rs.next()) { insert_str = rs.getString("fieldname"); fileou.write(insert_str+"\n"); } rs.close(); stmt.close(); conn.close(); fileou.close(); }catch (FileNotFoundException e) {System.out.println("file not found");} }catch (java.sql.SQLException e) { e.printStackTrace(); } }} 高手帮帮忙~ oracle求解 文件型数据库与非文件型数据库的区别? 超级菜鸟问题:如何执行这个script block? <早上好大家> 问个结果集问题 返回的字段个数是动态的 我想不出来 刚刚学习orcale数据库开发,问大家一个关于字符比较的问题,望大家指点一下 高手,请问能不能写个函数判断一个表是不是存在 关于session(会话)与process(进程)的问题再次请教各位高手。 oracle 查詢event的語法錯誤 Oracle怎么让判断语句不执行。 关于ORACLE树结构的问题(100分) 关于排序的问题,请大家指导
import java.sql.*;
import java.text.*;
import java.lang.*;
import java.util.*;
import java.lang.String;class select2insert
{
public static void main(String args[]) throws IOException
{
String MyDBDriver="oracle.jdbc.driver.OracleDriver";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try
{Class.forName(MyDBDriver).newInstance();}
catch(ClassNotFoundException e)
{ e.printStackTrace(); }
catch (java.lang.InstantiationException e)
{ e.printStackTrace(); }
catch ( java.lang.IllegalAccessException e)
{ e.printStackTrace(); }
try
{
conn = DriverManager.getConnection("jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521)))(CONNECT_DATA = (SID = your_sid)(SERVER = DEDICATED)))","user","password");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
String sql = ""; //这里写上我在另外一个帖子里给你回的SQL语句
BufferedWriter fileou = new BufferedWriter(new FileWriter(args[0],false));
String insert_str = "";
try
{
rs = stmt.executeQuery(sql);
while(rs.next())
{
insert_str = rs.getString("fieldname");
fileou.write(insert_str+"\n");
}
rs.close();
stmt.close();
conn.close();
fileou.close();
}catch (FileNotFoundException e) {System.out.println("file not found");}
}catch (java.sql.SQLException e) { e.printStackTrace(); }
}
}