Java实现Oracle表导出到Txt中

import java.sql.*;
import java.io.*;
public class oracle_into_txt
{
public static void main(String[] args)
{
  // TODO Auto-generated method stub
  Connection con=null;    //定义Connection类对象
  try
  {
   //加载驱动
      Class.forName("oracle.jdbc.driver.OracleDriver");
      String url="jdbc:oracle:oci8:@PIPEGIS";  //定位
  
    //用oci驱动方式建立连接
    con=DriverManager.getConnection(url,"scott","tiger");
    
    
      Statement st=con.createStatement();  //JDBC中的类或是接口      
      
      //创建一个ResultSet对象，提交SQL语句  
      ResultSet rs=st.executeQuery("select * from scott.test");   //执行查询
      FileWriter fos=new FileWriter("D:\\1.txt");
      //输出字段
      ResultSetMetaData rsmd=rs.getMetaData();
    int numCols=rsmd.getColumnCount();
        //输出列头
    for(int i=1;i<=numCols;i++)
    {
      if(i>1)System.out.print("  ");
      System.out.print("  "+rsmd.getColumnLabel(i));
      fos.write("  "+rsmd.getColumnLabel(i));
    }
    fos.write("\r\n");
    System.out.println("");  //输入回车
    System.out.println("");
    
    
    
                while(rs.next())
                {
                
                for(int i=1;i<=numCols;i++)
    {
      if(i>1)System.out.print("  ");
      String str="  "+rs.getString(i);
      System.out.print(str);
      fos.write(str);
    }
                System.out.println("");
              fos.write("\r\n");
                  
                }
                fos.close();
          rs.close();
      st.close();
    
  }
  catch(Exception e)
  {
      System.out.println("some error");
      System.out.println(e.getMessage());
  }
  finally
  {
  try{con.close();}  //关闭连接
   catch(Exception ex){}
  }
}
}
前提要在配置ODBC哈~~~~~~~~~
程序正确可运行