Here is a simple example
The code copy is as follows:
package com.cramc;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;
import com.linuxense.javadbf.DBFException;
import com.linuxense.javadbf.DBFField;
import com.linuxense.javadbf.DBFReader;
import com.linuxense.javadbf.DBFWriter;
public class Rwdbf {
public static void readDBF(String path)
{
InputStream fis = null;
try
{
//Read the input stream of the file
fis = new FileInputStream(path);
//Initialize a DBFReader instance according to the input stream to read DBF file information
DBFReader reader = new DBFReader(fis);
//Call DBFReader to get the number of fields in the path file to the instance method
int fieldsCount = reader.getFieldCount();
System.out.println("Number of fields:"+fieldsCount);
//Fetch field information
for( int i=0; i<fieldsCount; i++)
{
DBFField field = reader.getField(i);
System.out.println(field.getName());
}
Object[] rowValues;
//Fetch the path file one by one and record
while((rowValues = reader.nextRecord()) != null)
{
for( int i=0; i<rowValues.length; i++)
{
System.out.println(rowValues[i]);
}
}
}
catch(Exception e)
{
e.printStackTrace();
}
Finally
{
try{
fis.close();
}catch(Exception e){}
}
}
public static void writeDBF(String path)
{
OutputStream fos = null;
try
{
//Define DBF file fields
DBFField[] fields = new DBFField[3];
//Define each field information separately, setFieldName and setName function the same.
//It's just that setFieldName is no longer recommended to use
fields[0] = new DBFField();
//fields[0].setFieldName("emp_code");
fields[0].setName("semp_code");
fields[0].setDataType(DBFField.FIELD_TYPE_C);
fields[0].setFieldLength(10);
fields[1] = new DBFField();
//fields[1].setFieldName("emp_name");
fields[1].setName("emp_name");
fields[1].setDataType(DBFField.FIELD_TYPE_C);
fields[1].setFieldLength(20);
fields[2] = new DBFField();
//fields[2].setFieldName("salary");
fields[2].setName("salary");
fields[2].setDataType(DBFField.FIELD_TYPE_N);
fields[2].setFieldLength(12);
fields[2].setDecimalCount(2);
//DBFWriter writer = new DBFWriter(new File(path));
//Define DBFWriter instance to write DBF files
DBFWriter writer = new DBFWriter();
//Write field information into DBFWriter instance, that is, define the table structure
writer.setFields(fields);
//Write records
Object[] rowData = new Object[3];
rowData[0] = "1000";
rowData[1] = "John";
rowData[2] = new Double(5000.00);
writer.addRecord(rowData);
rowData = new Object[3];
rowData[0] = "1001";
rowData[1] = "Lalit";
rowData[2] = new Double(3400.00);
writer.addRecord(rowData);
rowData = new Object[3];
rowData[0] = "1002";
rowData[1] = "Rohit";
rowData[2] = new Double(7350.00);
writer.addRecord(rowData);
//Define the output stream and associate a file
fos = new FileOutputStream(path);
//Write data
writer.write(fos);
//writer.write();
}catch(Exception e)
{
e.printStackTrace();
}
Finally
{
try{
fos.close();
}catch(Exception e){}
}
}
public static void main(String[] args){
String path ="E://tmp//2//xx.dbf";
try {
InputStream fis = new FileInputStream(path);
DBFReader reader = new DBFReader(fis);
int fieldsCount = reader.getFieldCount();
System.out.println("Number of fields:"+fieldsCount);
DBFField[] df = new DBFField[fieldsCount+2];
for( int i=0; i<fieldsCount; i++)
{
df[i] = reader.getField(i);
System.out.println("field"+i+":"+df[i].getName());
}
df[fieldsCount] = new DBFField();
df[fieldsCount].setName("add1");
df[fieldsCount].setDataType(DBFField.FIELD_TYPE_C);
df[fieldsCount].setFieldLength(10);
df[fieldsCount+1] = new DBFField();
df[fieldsCount+1].setName("add2");
df[fieldsCount+1].setDataType(DBFField.FIELD_TYPE_C);
df[fieldsCount+1].setFieldLength(10);
DBFWriter writer = new DBFWriter();
writer.setFields(df);
Object[] rowValues;
Object[] rowValues1 = new Object[fieldsCount+2];
//Fetch the path file one by one and record
while((rowValues = reader.nextRecord()) != null)
{
for(int i=0;i<fieldsCount;i++){
rowValues1[i] = rowValues[i];
}
rowValues1[fieldsCount]="x";
rowValues1[fieldsCount+1]="xx";
writer.addRecord(rowValues1);
}
path ="E://tmp//2//test2.dbf";
OutputStream fos = new FileOutputStream(path);
//Write data
writer.write(fos);
System.out.println("OVER");
} catch (FileNotFoundException | DBFException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}