将ORACLE中查询出来的数转换为DBF格式?高分相送,不够再加!

[luck_529]

我现在在一张网页中查询出来的数据生成一个DBF,以前都是生成access后再转换成DBF.大家能提供相关源码.相互学习.

[影子传说_Hades]

每个表空间里面都会有多个dbf数据文件啊

[luck_529]

package untitled1;

/*
* 创建日期 2007-8-10
*
* 更改所生成文件模板为
* 窗口 > 首选项 > Java > 代码生成 > 代码和注释


/**
* @author Administrator
*
* 更改所生成类型注释的模板为
* 窗口 > 首选项 > Java > 代码生成 > 代码和注释
*/
import java.lang.*;
import java.util.*;
import java.text.*;
import java.sql.*;

public class dbf {

static public void main(String[] args) throws Exception {

try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection conn = null;
String url="jdbc:odbc:DRIVER={MICROSOFT FOXPRO VFP DRIVER (*.DBF)};SourceType=DBF;SourceDB=D:\\test\\temp001.dbf";

conn = DriverManager.getConnection(url);

Statement statmnt = conn.createStatement();

int rt = statmnt.executeUpdate("insert into table1(id,name) values(1,'abc')");

ResultSet reslts = statmnt.executeQuery("Select * from table1");
while(reslts.next())
{
System.out.println(reslts.getString("id") +" "+ reslts.getString("name"));
}

}
catch(Exception e)
{
e.printStackTrace();
System.out.println("Well, something really didn't work out that well!!!");
}
}

}


看看这个程序.

[luck_529]

出现的问题是:

java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 驱动程序不支持此功能

at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6879)

at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036)

at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3028)

at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)

at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)

at java.sql.DriverManager.getConnection(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:193)Well, something really didn't work out that well!!!



at untitled1.dbf.main(dbf.java:30)