- 浏览: 296223 次
文章分类
最新评论
-
feargod:
...
ActivityGroup的子activity响应back事件的顺序问题 -
hoarhoar:
谢谢你,终于解决了,我真是受够了,总是45秒钟,真是疯了。
youku 的广告必须要屏蔽 -
lilai:
...
youku 的广告必须要屏蔽 -
aijuans2:
...
youku 的广告必须要屏蔽 -
weiwo1978:
说的非常好,mark
SELECT语句执行的顺序
使用Java实现对dbf文件的简单读写
我将dbf文件的读写基本分成四个类,Writer,Reader, Field, Exception,内容如下,如果在使用该程序包时有什么问题或者好的建议,请发mail到 iiihero#hotmail.com
下载的过程详见:http://computer.mblogger.cn/ehero/posts/31204.aspx
如果您能多Re几下本文,我将更为高兴。
/**
* <p>Title: java访问DBF文件的接口</p>
* <p>Description: 这个类用于表示DBF文件中的写操作</p>
* <p>Copyright: Copyright (c) 2004</p>
* <p>Company: ict</p>
* @author : He Xiong
* @version 1.0
*/
package com.hexiong.jdbf;
import java.io.*;
import java.util.Calendar;
// Referenced classes of package com.hexiong.jdbf:
// JDBFException, JDBField
public class DBFWriter
{
public DBFWriter(String s, JDBField ajdbfield[])
throws JDBFException
{
stream = null;
recCount = 0;
fields = null;
fileName = null;
dbfEncoding = null;
fileName = s;
try
{
init(new FileOutputStream(s), ajdbfield);
}
catch(FileNotFoundException filenotfoundexception)
{
throw new JDBFException(filenotfoundexception);
}
}
public DBFWriter(OutputStream outputstream, JDBField ajdbfield[])
throws JDBFException
{
stream = null;
recCount = 0;
fields = null;
fileName = null;
dbfEncoding = null;
init(outputstream, ajdbfield);
}
public DBFWriter(String s, JDBField ajdbfield[], String s1)
throws JDBFException
{
stream = null;
recCount = 0;
fields = null;
fileName = null;
dbfEncoding = null;
fileName = s;
try
{
dbfEncoding = s1;
init(new FileOutputStream(s), ajdbfield);
}
catch(FileNotFoundException filenotfoundexception)
{
throw new JDBFException(filenotfoundexception);
}
}
private void init(OutputStream outputstream, JDBField ajdbfield[])
throws JDBFException
{
fields = ajdbfield;
try
{
stream = new BufferedOutputStream(outputstream);
writeHeader();
for(int i = 0; i < ajdbfield.length; i++)
writeFieldHeader(ajdbfield[i]);
stream.write(13);
stream.flush();
}
catch(Exception exception)
{
throw new JDBFException(exception);
}
}
private void writeHeader()
throws IOException
{
byte abyte0[] = new byte[16];
abyte0[0] = 3;
Calendar calendar = Calendar.getInstance();
abyte0[1] = (byte)(calendar.get(1) - 1900);
abyte0[2] = (byte)calendar.get(2);
abyte0[3] = (byte)calendar.get(5);
abyte0[4] = 0;
abyte0[5] = 0;
abyte0[6] = 0;
abyte0[7] = 0;
int i = (fields.length + 1) * 32 + 1;
abyte0[8] = (byte)(i % 256);
abyte0[9] = (byte)(i / 256);
int j = 1;
for(int k = 0; k < fields.length; k++)
j += fields[k].getLength();
abyte0[10] = (byte)(j % 256);
abyte0[11] = (byte)(j / 256);
abyte0[12] = 0;
abyte0[13] = 0;
abyte0[14] = 0;
abyte0[15] = 0;
stream.write(abyte0, 0, abyte0.length);
for(int l = 0; l < 16; l++)
abyte0[l] = 0;
stream.write(abyte0, 0, abyte0.length);
}
private void writeFieldHeader(JDBField jdbfield)
throws IOException
{
byte abyte0[] = new byte[16];
String s = jdbfield.getName();
int i = s.length();
if(i > 10)
i = 10;
for(int j = 0; j < i; j++)
abyte0[j] = (byte)s.charAt(j);
for(int k = i; k <= 10; k++)
abyte0[k] = 0;
abyte0[11] = (byte)jdbfield.getType();
abyte0[12] = 0;
abyte0[13] = 0;
abyte0[14] = 0;
abyte0[15] = 0;
stream.write(abyte0, 0, abyte0.length);
for(int l = 0; l < 16; l++)
abyte0[l] = 0;
abyte0[0] = (byte)jdbfield.getLength();
abyte0[1] = (byte)jdbfield.getDecimalCount();
stream.write(abyte0, 0, abyte0.length);
}
public void addRecord(Object aobj[])
throws JDBFException
{
if(aobj.length != fields.length)
throw new JDBFException("Error adding record: Wrong number of values. Expected " + fields.length + ", got " + aobj.length + ".");
int i = 0;
for(int j = 0; j < fields.length; j++)
i += fields[j].getLength();
byte abyte0[] = new byte[i];
int k = 0;
for(int l = 0; l < fields.length; l++)
{
String s = fields[l].format(aobj[l]);
byte abyte1[];
try
{
if(dbfEncoding != null)
abyte1 = s.getBytes(dbfEncoding);
else
abyte1 = s.getBytes();
}
catch(UnsupportedEncodingException unsupportedencodingexception)
{
throw new JDBFException(unsupportedencodingexception);
}
for(int i1 = 0; i1 < fields[l].getLength(); i1++)
abyte0[k + i1] = abyte1[i1];
k += fields[l].getLength();
}
try
{
stream.write(32);
stream.write(abyte0, 0, abyte0.length);
stream.flush();
}
catch(IOException ioexception)
{
throw new JDBFException(ioexception);
}
recCount++;
}
public void close()
throws JDBFException
{
try
{
stream.write(26);
stream.close();
RandomAccessFile randomaccessfile = new RandomAccessFile(fileName, "rw");
randomaccessfile.seek(4L);
byte abyte0[] = new byte[4];
abyte0[0] = (byte)(recCount % 256);
abyte0[1] = (byte)((recCount / 256) % 256);
abyte0[2] = (byte)((recCount / 0x10000) % 256);
abyte0[3] = (byte)((recCount / 0x1000000) % 256);
randomaccessfile.write(abyte0, 0, abyte0.length);
randomaccessfile.close();
}
catch(IOException ioexception)
{
throw new JDBFException(ioexception);
}
}
private BufferedOutputStream stream;
private int recCount;
private JDBField fields[];
private String fileName;
private String dbfEncoding;
}
/**
* <p>Title: java访问DBF文件的接口</p>
* <p>Description: 这个类用于表示DBF文件中的字段</p>
* <p>Copyright: Copyright (c) 2004</p>
* <p>Company: ict</p>
* @author : He Xiong
* @version 1.0
*/
package com.hexiong.jdbf;
import java.text.*;
import java.util.Date;
// Referenced classes of package com.hexiong.jdbf:
// JDBFException
public class JDBField
{
public JDBField(String s, char c, int i, int j)
throws JDBFException
{
if(s.length() > 10)
throw new JDBFException("The field name is more than 10 characters long: " + s);
if(c != 'C' && c != 'N' && c != 'L' && c != 'D' && c != 'F')
throw new JDBFException("The field type is not a valid. Got: " + c);
if(i < 1)
throw new JDBFException("The field length should be a positive integer. Got: " + i);
if(c == 'C' && i >= 254)
throw new JDBFException("The field length should be less than 254 characters for character fields. Got: " + i);
if(c == 'N' && i >= 21)
throw new JDBFException("The field length should be less than 21 digits for numeric fields. Got: " + i);
if(c == 'L' && i != 1)
throw new JDBFException("The field length should be 1 characater for logical fields. Got: " + i);
if(c == 'D' && i != 8)
throw new JDBFException("The field length should be 8 characaters for date fields. Got: " + i);
if(c == 'F' && i >= 21)
throw new JDBFException("The field length should be less than 21 digits for floating point fields. Got: " + i);
if(j < 0)
throw new JDBFException("The field decimal count should not be a negative integer. Got: " + j);
if((c == 'C' || c == 'L' || c == 'D') && j != 0)
throw new JDBFException("The field decimal count should be 0 for character, logical, and date fields. Got: " + j);
if(j > i - 1)
{
throw new JDBFException("The field decimal count should be less than the length - 1. Got: " + j);
} else
{
name = s;
type = c;
length = i;
decimalCount = j;
return;
}
}
public String getName()
{
return name;
}
public char getType()
{
return type;
}
public int getLength()
{
return length;
}
public int getDecimalCount()
{
return decimalCount;
}
public String format(Object obj)
throws JDBFException
{
if(type == 'N' || type == 'F')
{
if(obj == null)
obj = new Double(0.0D);
if(obj instanceof Number)
{
Number number = (Number)obj;
StringBuffer stringbuffer = new StringBuffer(getLength());
for(int i = 0; i < getLength(); i++)
stringbuffer.append("#");
if(getDecimalCount() > 0)
stringbuffer.setCharAt(getLength() - getDecimalCount() - 1, '.');
DecimalFormat decimalformat = new DecimalFormat(stringbuffer.toString());
String s1 = decimalformat.format(number);
int k = getLength() - s1.length();
if(k < 0)
throw new JDBFException("Value " + number + " cannot fit in pattern: '" + stringbuffer + "'.");
StringBuffer stringbuffer2 = new StringBuffer(k);
for(int l = 0; l < k; l++)
stringbuffer2.append(" ");
return stringbuffer2 + s1;
} else
{
throw new JDBFException("Expected a Number, got " + obj.getClass() + ".");
}
}
if(type == 'C')
{
if(obj == null)
obj = "";
if(obj instanceof String)
{
String s = (String)obj;
if(s.length() > getLength())
throw new JDBFException("'" + obj + "' is longer than " + getLength() + " characters.");
StringBuffer stringbuffer1 = new StringBuffer(getLength() - s.length());
for(int j = 0; j < getLength() - s.length(); j++)
stringbuffer1.append(' ');
return s + stringbuffer1;
} else
{
throw new JDBFException("Expected a String, got " + obj.getClass() + ".");
}
}
if(type == 'L')
{
if(obj == null)
obj = new Boolean(false);
if(obj instanceof Boolean)
{
Boolean boolean1 = (Boolean)obj;
return boolean1.booleanValue() ? "Y" : "N";
} else
{
throw new JDBFException("Expected a Boolean, got " + obj.getClass() + ".");
}
}
if(type == 'D')
{
if(obj == null)
obj = new Date();
if(obj instanceof Date)
{
Date date = (Date)obj;
SimpleDateFormat simpledateformat = new SimpleDateFormat("yyyyMMdd");
return simpledateformat.format(date);
} else
{
throw new JDBFException("Expected a Date, got " + obj.getClass() + ".");
}
} else
{
throw new JDBFException("Unrecognized JDBFField type: " + type);
}
}
public Object parse(String s)
throws JDBFException
{
s = s.trim();
if(type == 'N' || type == 'F')
{
if(s.equals(""))
s = "0";
try
{
if(getDecimalCount() == 0)
return new Long(s);
else
return new Double(s);
}
catch(NumberFormatException numberformatexception)
{
throw new JDBFException(numberformatexception);
}
}
if(type == 'C')
return s;
if(type == 'L')
{
if(s.equals("Y") || s.equals("y") || s.equals("T") || s.equals("t"))
return new Boolean(true);
if(s.equals("N") || s.equals("n") || s.equals("F") || s.equals("f"))
return new Boolean(false);
else
throw new JDBFException("Unrecognized value for logical field: " + s);
}
if(type == 'D')
{
SimpleDateFormat simpledateformat = new SimpleDateFormat("yyyyMMdd");
try
{
if("".equals(s))
return null;
else
return simpledateformat.parse(s);
}
catch(ParseException parseexception)
{
throw new JDBFException(parseexception);
}
} else
{
throw new JDBFException("Unrecognized JDBFField type: " + type);
}
}
public String toString()
{
return name;
}
private String name;
private char type;
private int length;
private int decimalCount;
}
/**
* <p>Title: java访问DBF文件的接口</p>
* <p>Description: 这个类用于表示DBF文件中的读写异常</p>
* <p>Copyright: Copyright (c) 2004</p>
* <p>Company: ict</p>
* @author : He Xiong
* @version 1.0
*/
package com.hexiong.jdbf;
import java.io.PrintStream;
import java.io.PrintWriter;
public class JDBFException extends Exception
{
public JDBFException(String s)
{
this(s, null);
}
public JDBFException(Throwable throwable)
{
this(throwable.getMessage(), throwable);
}
public JDBFException(String s, Throwable throwable)
{
super(s);
detail = throwable;
}
public String getMessage()
{
if(detail == null)
return super.getMessage();
else
return super.getMessage();
}
public void printStackTrace(PrintStream printstream)
{
if(detail == null)
{
super.printStackTrace(printstream);
return;
}
PrintStream printstream1 = printstream;
printstream1.println(this);
detail.printStackTrace(printstream);
return;
}
public void printStackTrace()
{
printStackTrace(System.err);
}
public void printStackTrace(PrintWriter printwriter)
{
if(detail == null)
{
super.printStackTrace(printwriter);
return;
}
PrintWriter printwriter1 = printwriter;
printwriter1.println(this);
detail.printStackTrace(printwriter);
return;
}
private Throwable detail;
}
/**
* <p>Title: java访问DBF文件的接口</p>
* <p>Description: 这个类用于表示DBF文件中的读操作</p>
* <p>Copyright: Copyright (c) 2004</p>
* <p>Company: ict</p>
* @author : He Xiong
* @version 1.0
*/
package com.hexiong.jdbf;
import java.io.*;
// Referenced classes of package com.hexiong.jdbf:
// JDBFException, JDBField
public class DBFReader
{
public DBFReader(String s)
throws JDBFException
{
stream = null;
fields = null;
nextRecord = null;
try
{
init(new FileInputStream(s));
}
catch(FileNotFoundException filenotfoundexception)
{
throw new JDBFException(filenotfoundexception);
}
}
public DBFReader(InputStream inputstream)
throws JDBFException
{
stream = null;
fields = null;
nextRecord = null;
init(inputstream);
}
private void init(InputStream inputstream)
throws JDBFException
{
try
{
stream = new DataInputStream(inputstream);
int i = readHeader();
fields = new JDBField[i];
int j = 1;
for(int k = 0; k < i; k++)
{
fields[k] = readFieldHeader();
j += fields[k].getLength();
}
if(stream.read() < 1)
throw new JDBFException("Unexpected end of file reached.");
nextRecord = new byte[j];
try
{
stream.readFully(nextRecord);
}
catch(EOFException eofexception)
{
nextRecord = null;
stream.close();
}
}
catch(IOException ioexception)
{
throw new JDBFException(ioexception);
}
}
private int readHeader()
throws IOException, JDBFException
{
byte abyte0[] = new byte[16];
try
{
stream.readFully(abyte0);
}
catch(EOFException eofexception)
{
throw new JDBFException("Unexpected end of file reached.");
}
int i = abyte0[8];
if(i < 0)
i += 256;
i += 256 * abyte0[9];
i = --i / 32;
i--;
try
{
stream.readFully(abyte0);
}
catch(EOFException eofexception1)
{
throw new JDBFException("Unexpected end of file reached.");
}
return i;
}
private JDBField readFieldHeader()
throws IOException, JDBFException
{
byte abyte0[] = new byte[16];
try
{
stream.readFully(abyte0);
}
catch(EOFException eofexception)
{
throw new JDBFException("Unexpected end of file reached.");
}
StringBuffer stringbuffer = new StringBuffer(10);
for(int i = 0; i < 10; i++)
{
if(abyte0[i] == 0)
break;
stringbuffer.append((char)abyte0[i]);
}
char c = (char)abyte0[11];
try
{
stream.readFully(abyte0);
}
catch(EOFException eofexception1)
{
throw new JDBFException("Unexpected end of file reached.");
}
int j = abyte0[0];
int k = abyte0[1];
if(j < 0)
j += 256;
if(k < 0)
k += 256;
return new JDBField(stringbuffer.toString(), c, j, k);
}
public int getFieldCount()
{
return fields.length;
}
public JDBField getField(int i)
{
return fields[i];
}
public boolean hasNextRecord()
{
return nextRecord != null;
}
public Object[] nextRecord()
throws JDBFException
{
if(!hasNextRecord())
throw new JDBFException("No more records available.");
Object aobj[] = new Object[fields.length];
int i = 1;
for(int j = 0; j < aobj.length; j++)
{
int k = fields[j].getLength();
StringBuffer stringbuffer = new StringBuffer(k);
stringbuffer.append(new String(nextRecord, i, k));
aobj[j] = fields[j].parse(stringbuffer.toString());
i += fields[j].getLength();
}
try
{
stream.readFully(nextRecord);
}
catch(EOFException eofexception)
{
nextRecord = null;
}
catch(IOException ioexception)
{
throw new JDBFException(ioexception);
}
return aobj;
}
public void close()
throws JDBFException
{
nextRecord = null;
try
{
stream.close();
}
catch(IOException ioexception)
{
throw new JDBFException(ioexception);
}
}
private DataInputStream stream;
private JDBField fields[];
private byte nextRecord[];
}
最后,给出一个简单的测试样例程序
/**
* <p>Title: java访问DBF文件的接口</p>
* <p>Description: 测试DBF文件的读写</p>
* <p>Copyright: Copyright (c) 2004</p>
* <p>Company: ict</p>
* @author : He Xiong
* @version 1.0
*/
import com.hexiong.jdbf.DBFReader;
import java.io.PrintStream;
import java.net.URL;
public class Test
{
public Test()
{
}
public static void main(String args[])
throws Exception
{
DBFReader dbfreader = new DBFReader("E://lakes.dbf");
int i;
for(i = 0; dbfreader.hasNextRecord(); i++)
{
Object aobj[] = dbfreader.nextRecord();
for (int j=0; j<aobj.length; j++)
System.out.print(aobj[j]+" | ");
System.out.print("/n");
}
System.out.println("Total Count: " + i);
}
}
相关推荐
总结来说,xBaseJ是Java开发人员处理DBF文件的强大工具,它简化了读写过程,使得在Java应用程序中集成对DBF文件的操作变得轻松易行。如果你需要在项目中处理DBF数据,xBaseJ是一个值得考虑的优秀选择。
`dbf-jdbc-wisecoders`是一个Java库,它提供了对DBF文件的读写功能,使得开发者能够通过Java语言方便地操作这些文件。 这个工具包的主要特点和功能包括: 1. **JDBC接口**:`dbf-jdbc-wisecoders`通过提供一个类似...
Java DBF是对dbase文件进行读写访问的库,它为Java开发者提供了一种方便的方式来操作这种古老的数据库格式。dbase文件是早期个人...通过这个库,开发者可以轻松地在Java应用程序中实现对dbase数据库的管理和操作。
对于希望在Java环境下实现DBF文件读写的开发者而言,理解其文件结构和格式规范是必不可少的第一步。随着技术的发展,这种老旧技术的支持需求逐渐减少,但特定的历史和数据兼容性问题仍然会引导开发者面对这一挑战。
在给定的压缩包`javadbf-0.4.0`中,可能包含了这个库的源代码、文档和相关的示例,这使得开发者能够理解和使用这个库来完成读写DBF文件的任务。 1. **读取DBF文件**: 使用`javadbf`库,你可以创建一个`DbfFile`...
为了更好地理解和应用JavaDBF,建议参考其官方文档或者开源项目的源代码,理解其实现原理和使用方法。同时,对于大量数据的操作,可以考虑性能优化,如批处理写入、缓存策略等。 总结来说,JavaDBF是一个用于Java...
"dbf java"标签表明这是一个关于Java处理DBF文件的专题,对于那些需要在Java应用中处理DBF数据的开发者来说,这个修复后的javadbf.jar及其使用说明是一个宝贵的资源。通过合理使用,可以避免因编码问题导致的数据...
本主题聚焦于在LINUX平台上使用Java直接连接到Access数据库中的DBF文件。DBF文件是FoxPro、dBase等数据库系统常用的表格文件格式,虽然它不是Oracle或MySQL这样的主流数据库格式,但在某些特定场景下,仍然有其应用...
标题中的"java代码DBF转Text"表明我们要讨论的是使用Java编程语言实现DBF文件向Text文件的转换过程。描述中的"包括javadbf.jar包"提示我们,这个转换过程可能需要用到一个名为`javadbf.jar`的第三方库,它提供了解析...
下面我们将深入探讨Java下读写DBF文件的相关知识点。 1. **DBF文件结构**:DBF文件由文件头、字段描述符数组、记录数据和文件尾组成。文件头包含文件的基本信息,如创建日期、记录数量等;字段描述符数组则定义了每...
### Java实现XML文件的读写知识点详解 #### 一、XML简介与应用 XML(Extensible Markup Language,可扩展标记语言)是一种用于标记数据的语言,它具有良好的结构化特性,可以方便地描述复杂的数据结构。随着信息...
3. 使用JavaDBF库读取DBF文件 - 首先,通过`DbfFile`的静态方法`open()`打开DBF文件。 - 然后,可以调用`DbfFile`的`getFields()`获取字段列表,`getHeader()`获取表头信息。 - 接着,通过迭代`DbfFile`的`...
本篇将详细探讨如何使用Java操作DBF文件,以及涉及到的相关知识点。 首先,DBF文件是dBase系列数据库管理系统(包括FoxPro)创建的一种表格文件格式。它包含了表的结构定义和实际数据,支持字段类型如字符、数字、...
使用这个包提供的API,可以实现对DBF文件的读写
在Java中,我们可以通过第三方库来实现对DBF文件的读取和操作。 本项目源码提供了关于如何在Java中读取和操作DBF文件的具体实现。通过这些源代码,我们可以学习以下几个关键知识点: 1. **JDBC驱动**:虽然DBF文件...
5. **性能优化**:描述中提到JavaDBF的效率不高,这可能是因为原始实现没有进行充分的优化,比如没有使用缓冲区批量读写,或者对I/O操作进行了过多的同步。如果需要提高性能,可以通过调整I/O策略、使用多线程并发...
这使得开发者能够方便地在Java环境中处理DBF文件,无论是简单的读写操作还是更复杂的转换和分析。通过阅读源码和教程,开发者不仅可以掌握使用这个库的技巧,还能深入理解DBF文件格式,提升自己的数据库处理能力。
标题 "geotools读取*.dbf/*....通过以上介绍,我们了解到如何使用GeoTools库读取和处理Shapefile中的几何数据和DBF文件中的属性数据。在实际开发中,可以根据需求进行更复杂的操作,如空间查询、几何变换、地图渲染等。
javadbf-0.4.0版本本已增加setCharactersetName方法支持中文读写,但在写入时会发生写入中文数据丢失问题。资源压缩文件包含有修改后的jar文件和读写测试类。 @Test public void testWrite1(){ File file=new File...