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=E:\\test\\";
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())
{//while
System.out.println(reslts.getString("id") +" "+ reslts.getString("name"));
}//end while
}
catch(Exception e)
{//catch
e.printStackTrace();
System.out.println("Well, something really didn't work out that well!!!");
}//end catch
}}
--------------------------------------------------------
以上程序可以连接到e:\test\table1.dbf,增删改查其中的数据
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=E:\\test\\";
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())
{//while
System.out.println(reslts.getString("id") +" "+ reslts.getString("name"));
}//end while
}
catch(Exception e)
{//catch
e.printStackTrace();
System.out.println("Well, something really didn't work out that well!!!");
}//end catch
}}
--------------------------------------------------------
以上程序可以连接到e:\test\table1.dbf,增删改查其中的数据
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货