先把DBF附加到FoxPro中,
然后与一个程序,
把它导入到Oracle中即可。提示foxpro连接: sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
sConnStr = "jdbc:odbc:driver=Microsoft FoxPro VFP Driver (*.dbf);"
+ "UID=;"
+ "Deleted=Yes;"
+ "Null=Yes;"
+ "Collate=Machine;"
+ "BackgroundFetch=Yes;"
+ "Exclusive=No;"
+ "SourceType=DBF;"
+ "SourceDB=" + 数据库文件;
然后与一个程序,
把它导入到Oracle中即可。提示foxpro连接: sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
sConnStr = "jdbc:odbc:driver=Microsoft FoxPro VFP Driver (*.dbf);"
+ "UID=;"
+ "Deleted=Yes;"
+ "Null=Yes;"
+ "Collate=Machine;"
+ "BackgroundFetch=Yes;"
+ "Exclusive=No;"
+ "SourceType=DBF;"
+ "SourceDB=" + 数据库文件;
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:driver=Microsoft FoxPro VFP Driver (*.dbf);"
+ "UID=;"
+ "Deleted=Yes;"
+ "Null=Yes;"
+ "Collate=Machine;"
+ "BackgroundFetch=Yes;"
+ "Exclusive=No;"
+ "SourceType=DBF;"
+ "SourceDB=" + "f:/test/sfb.dbf"; try
{
Class.forName(sDBDriver);
}
catch(ClassNotFoundException e)
{
System.out.println(e.getMessage());
}
try
{
con=DriverManager.getConnection(sConnStr);
}
catch(Exception e1)
{
System.out.println(e1.getMessage());
}
}
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); //加载驱动程序
StringBuffer dbUrl = new StringBuffer(100);
//配置dbf数据库驱动信息:指定到文件
dbUrl.append("jdbc:odbc:;DRIVER=Microsoft FoxPro VFP Driver (*.dbf);");
dbUrl.append("UID=;Deleted=Yes;Null=Yes;Collate=Machine;BackgroundFetch=Yes;");
dbUrl.append("Exclusive=No;SourceType=DBF;SourceDB=MyTest.dbf");
Connection connFHBA = DriverManager.getConnection(dbUrl.toString(),"", "");
//以下操作跟平常操作数据库一样
}
catch (Exception e) {
e.printStackTrace();
}