java解析dbf之通過javadbf包生成和讀取dbf文件

以下是簡單示例

複製代碼代碼如下:

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

{

//讀取文件的輸入流

fis = new FileInputStream(path);

//根據輸入流初始化一個DBFReader實例，用來讀取DBF文件信息

DBFReader reader = new DBFReader(fis);

//調用DBFReader對實例方法得到path文件中字段的個數

int fieldsCount = reader.getFieldCount();

System.out.println("字段數:"+fieldsCount);

//取出字段信息

for( int i=0; i<fieldsCount; i++)

{

DBFField field = reader.getField(i);

System.out.println(field.getName());

}

Object[] rowValues;

//一條條取出path文件中記錄

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

{

//定義DBF文件字段

DBFField[] fields = new DBFField[3];

//分別定義各個字段信息，setFieldName和setName作用相同，

//只是setFieldName已經不建議使用

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));

//定義DBFWriter實例用來寫DBF文件

DBFWriter writer = new DBFWriter();

//把字段信息寫入DBFWriter實例，即定義表結構

writer.setFields(fields);

//一條條的寫入記錄

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);

//定義輸出流，並關聯的一個文件

fos = new FileOutputStream(path);

//寫入數據

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("字段數:"+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];

//一條條取出path文件中記錄

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);

//寫入數據

writer.write(fos);

System.out.println("OVER");

} catch (FileNotFoundException | DBFException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}