java dbf 写入_用java实现读写dbf文件

maven配置

com.linuxense

javadbf

0.4.0

代码片段

public static void main(String[] args) {

Text01.readDBF("D:/test.dbf");

/*Text01.writeDBF("D:/test.dbf");*/

}

/**

* 读取dbf

*

* @param path

*/

public static void readDBF(String path) {

InputStream fis = null;

try {

// 读取文件的输入流

fis = new FileInputStream(path);

// 根据输入流初始化一个DBFReader实例，用来读取DBF文件信息

DBFReader reader = new DBFReader(fis);

// 解决乱码

reader.setCharactersetName("GBK");

// 调用DBFReader对实例方法得到path文件中字段的个数

int fieldsCount = reader.getFieldCount();

// 取出字段信息

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

}

}

}

/**

* 写dbf

* @param path

*/

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

fields[0].setDataType(DBFField.FIELD_TYPE_C);

fields[0].setFieldLength(10);

fields[0].setDecimalCount(0);

fields[1] = new DBFField();

// fields[1].setFieldName("emp_name");

fields[1].setName("emp_Test2");

fields[1].setDataType(DBFField.FIELD_TYPE_C);

fields[1].setFieldLength(20);

fields[1].setDecimalCount(0);

fields[2] = new DBFField();

// fields[2].setFieldName("salary");

fields[2].setName("emp_Test3");

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

}

}

}

参考更多：https://blog..net/u013703363/article/details/78548195