项目中需要对DBF的文件进行导入处理，上网搜了发现有java-dbf这个东西。实际应用中踩了不少坑，主要就是中文乱码的问题。
InputStream in =
new FileInputStream("D:\\test.dbf"
);
DBFReader reader =
new DBFReader(in);
reader.setCharactersetName("GBK"
);
for(
int i = 0; i < reader.getFieldCount(); i++
){
DBFField field =
reader.getField(i);
System.out.print(field.getName() + ","
);
}
System.out.print("\r\n"
);
Object[] values;
while ( (values = reader.nextRecord()) !=
null ){
for(Object value : values){
System.out.print(value.toString() + ","
);
}
System.out.print("\r\n"
);
}
网上写法千篇一律，大概就是这样。问题来了DBF中具体数据的中文乱码通过reader.setCharactersetName("GBK")解决了。
但是发现列名的乱码还是没有解决。
后来查了一下源码，发现了问题所在
public DBFReader(InputStream in, Charset charset,
boolean showDeletedRows) {
try {
this.showDeletedRows =
showDeletedRows;
this.inputStream =
in;
this.dataInputStream =
new DataInputStream(
this.inputStream);
this.header =
new DBFHeader();
this.header.read(
this.dataInputStream, charset, showDeletedRows);
setCharset(this.header.getUsedCharset());
/* it might be required to leap to the start of records at times */
int fieldSize =
this.header.getFieldDescriptorSize();
int tableSize =
this.header.getTableHeaderSize();
int t_dataStartIndex =
this.header.headerLength - (tableSize + (fieldSize *
this.header.fieldArray.length)) - 1
;
skip(t_dataStartIndex);
this.mapFieldNames = createMapFieldNames(
this.header.userFieldArray);
} catch (IOException e) {
DBFUtils.close(dataInputStream);
DBFUtils.close(in);
throw new DBFException(e.getMessage(), e);
}
}
其中header就是我们读取的列名，列数所依靠的成员变量，但是这个变量在对象创建的时候就赋值好了。
这就导致了后来即使调用了setCharactersetName也解决不了列名乱码问题。
所以我们要从根本上解决问题，创建对象的时候直接传入charset对象。
修改后代码如下
public static void main(String[] args)
throws FileNotFoundException {
InputStream in =
new FileInputStream("D:\\test.dbf"
);
Charset charset = Charset.forName("GBK"
);
DBFReader reader =
new DBFReader(in,charset);
for(
int i = 0; i < reader.getFieldCount(); i++
){
DBFField field =
reader.getField(i);
System.out.print(field.getName() + ","
);
}
System.out.print("\r\n"
);
Object[] values;
while ( (values = reader.nextRecord()) !=
null ){
for(Object value : values){
System.out.print(value.toString() + ","
);
}
System.out.print("\r\n"
);
}
}
输出时候列名就正常了
转载于:https://www.cnblogs.com/guofx/p/11509472.html
相关资源：解决了DBF数据和表头乱码的javadbf.jar
