dbf-jdbc-wisecoders，JAVA 读写DBF文件工具包

import java.net.URL; import java.sql.*; import java.util.Properties; public class testResultSet { public static void main(String argv[]) { try { Class.forName("com.wisecoders.dbschema.dbf.JdbcDriver"); String url = "jdbc:dbschema:dbf:/E:/workspace/ws_test_new/test-dbf/docs"; //Change "." to your data directory Connection con = DriverManager.getConnection(url, "", ""); String sql="select * from A"; PreparedStatement stmt = con.prepareStatement(sql); stmt.setMaxRows(500); stmt.setFetchSize(20); ResultSetMetaData resultSetMetaData = stmt.getMetaData(); int iNumCols = resultSetMetaData.getColumnCount(); for (int i = 1; i <= iNumCols; i++) { System.out.println(resultSetMetaData.getColumnLabel(i) + " " + resultSetMetaData.getColumnTypeName(i)); } ResultSet rs = stmt.executeQuery(); Object colval; while (rs.next()) { for (int i = 1; i <= iNumCols; i++) { colval = rs.getObject(i); System.out.print(colval + " "); } System.out.println(); } rs.close(); stmt.close(); // sql = "insert into A(HM, SBBH, DZ, CCBH, DH,XH,YE) values (?, ?, ?, ?, ?, ?, ?)"; // stmt = con.prepareStatement(sql); // stmt.setString(1, "测试1"); // stmt.setString(2, "测试2"); // stmt.setString(3, "测试3"); // stmt.setString(4, "测试4"); // stmt.setString(5, "123"); // stmt.setInt(6, 0); // stmt.setInt(7, 300); // stmt.execute(); // stmt.close(); // sql = "update A set DH = ? where SBBH = ?"; // stmt = con.prepareStatement(sql); // stmt.setString(1, "123"); // stmt.setString(2, "测试一下"); // stmt.execute(); // stmt.close(); con.close(); } catch (Exception e) { System.out.println(e.getMessage()); e.printStackTrace(); } } }