- Notifications
You must be signed in to change notification settings - Fork3
DbfEngine - a fast and lightweight Java tools to read, write, append and clone xBase(DBASE, Foxpro dbf files).
License
smart-flex/DbfEngine
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
DbfEngine - a Java API to read, write, append and clone xBase(DBASE, Foxpro dbf files). Also API allows read memory files (.mem) of Foxpro.Samples for both operations you can see atDbfEngine javadoc
This API is pure lightweight library without memory consumption and any third party libraries (there are no java loggers and etc.)The DBF Java API is intended as a fast engine for data exchange purposes.
Engine is very small and fast.API for reading is made as iterator, API for writing is made in manner as JDBC statement. It is allows to write compact Java code.
Also, you can look inside your dbf file by invoking it through command line:java -jar dbfEngine-1.12.jar your.dbf
The result of parsing dbf header and content will be saved into text file.
This version was tested under MS Foxpro 2.6 without memo field support.
DbfEngine requires JDK 1.6 or higher.
publicclassFp26Reader {privatestaticvoidtestRead() {DbfIteratordbfIterator =DbfEngine.getReader(Fp26Reader.class.getResourceAsStream("FP_26_SAMPLE.DBF"),null);while (dbfIterator.hasMoreRecords()) {DbfRecorddbfRecord =dbfIterator.nextRecord();Stringstring =dbfRecord.getString("string");floatsumFloat =dbfRecord.getFloat("sum_f");BigDecimalsumNumeric =dbfRecord.getBigDecimal("sum_n");booleanbool =dbfRecord.getBoolean("bool_val");Datedate =dbfRecord.getDate("date_val");System.out.println(string +" " +sumFloat +" " +sumNumeric +" " +bool +" " +date); } }publicstaticvoidmain(String[]args) {Fp26Reader.testRead(); }}publicclassFp26Writer {privatestaticvoidtestWrite() {DbfAppenderdbfAppender =DbfEngine.getWriter("WRT_PERSON.DBF",DbfCodePages.Cp866);DbfColumndc01 =newDbfColumn("magic",DbfColumnTypes.Logical,0,0);DbfColumndc02 =newDbfColumn("actor",DbfColumnTypes.Character,60,0);DbfColumndc03 =newDbfColumn("currdate",DbfColumnTypes.Date,0,0);DbfColumndc04 =newDbfColumn("hit",DbfColumnTypes.Numeric,10,2);DbfColumndc05 =newDbfColumn("forever",DbfColumnTypes.Logical,0,0);dbfAppender.defineColumns(dc01,dc02,dc03,dc04,dc05);DbfStatementstatement =dbfAppender.getStatement();statement.setString("actor","Chuck Norris");statement.setDate("currdate",newDate());statement.setBigDecimal("hit",newBigDecimal("500.5"));statement.insertStatement();statement.setBoolean("magic",Boolean.TRUE);statement.setString("actor","Bruce Lee");statement.setBigDecimal("hit",newBigDecimal("1000.10"));statement.setBoolean("forever",Boolean.TRUE);statement.insertStatement();dbfAppender.writeDbfAndClose(); }publicstaticvoidmain(String[]args) {Fp26Writer.testWrite(); }}publicclassDbfClonePerformance {privatestaticvoidcloneDBF(StringsrcFile,StringcloneFile) {Fileroom64File =newFile(srcFile);System.out.println("Length src file (bytes): " +room64File.length() +" (megabytes): " +room64File.length()/(1024*1024));DbfHeaderheader =DbfEngine.getHeader(room64File,"Cp866");System.out.println(header.toString());DbfIteratordbfIterator =header.getDbfIterator();FilecloneDbf =newFile(cloneFile);if (cloneDbf.exists()) {cloneDbf.delete();}DbfAppenderdbfAppender =DbfEngine.getWriter(cloneDbf,DbfCodePages.Cp866);dbfAppender.defineColumns(header);while (dbfIterator.hasMoreRecords()) {DbfRecorddbfRecord =dbfIterator.nextRecord();// here can be your filtering code ....DbfStatementstatement =dbfAppender.getStatement();statement.fillStatement(dbfRecord);statement.insertStatement();}dbfAppender.writeDbfAndClose();header.closeDbfHeader();}publicstaticvoidmain(String[]args) {longstart =System.currentTimeMillis();cloneDBF("F:\\fias_dbf\\ROOM64.DBF","F:\\fias_dbf\\ROOM64_CLONE.DBF");longfinish =System.currentTimeMillis();System.out.println("Clone finished for: " + (finish -start)/1000 +" sec");}}
The result of performance are (below is the work log of DbfClonePerformance class):
- Length src file (bytes): 600606501 (megabytes): 572
- DbfHeader [firstRecordPosition=641, countRecords=1078287, countColumns=19, lengthRecord=557, codePage=Cp866, typeDbf={3,FoxBASE_dBASE_III_PLUS_without_memo}]
- Clone finished for: 52 sec
This java code is worked under jdk1.6/32; Intel Core i3; Windows 10. And there is no one messages such as: java.lang.OutOfMemoryError: Java heap space
DbfEngine is issued on under the GNU Lesser General Public License.
If you have any issues or questions or suggestions you can send me a letter by email:gali.shaimardanov@gmail.com
Djf is Desktop Java Forms, a compact master-detail UI library like FoxBase, but based on Swing:You can see Djf here
About
DbfEngine - a fast and lightweight Java tools to read, write, append and clone xBase(DBASE, Foxpro dbf files).