DBF數據庫文件Java讀寫類庫: jdbf
使用java實現的dbf文件讀寫庫,非常方便。
示例生成一個DBF文件:
public static void main(String args[])
throws Exception
{
JDBField[] fields = {
new JDBField("ID", 'C', 8, 0),
new JDBField("Name", 'C', 32, 0),
new JDBField("TestN", 'N', 20, 0), //第三個參數值一定不大于20
new JDBField("TestF", 'F', 20, 6), //F類型與N類型同,且第四個參數值有小數位數,否則會截短
new JDBField("TestD", 'D', 8, 0)
};
//DBFReader dbfreader = new DBFReader("E:\\hexiong\\work\\project\\book2.dbf");
DBFWriter dbfwriter = new DBFWriter("./testwrite.dbf", fields);
Object[][] records = {
{"1", "hexiong", new Integer(500), new Double(500.123), new Date() },
{"2", "hefang", new Integer(600), new Double(600.234), new Date() },
{"3", "heqiang", new Integer(700), new Double(700.456), new Date() }
};
for (int i=0; i<records.length; i++){
dbfwriter.addRecord(records[i]);
}
dbfwriter.close();
System.out.println("testwrite.dbf write finished.......");
}讀一個DBF文件:public static void main(String args[])
throws Exception
{
//DBFReader dbfreader = new DBFReader((new URL("http://www.svcon.com/us48st.dbf")).openStream());
//DBFReader dbfreader = new DBFReader("F:\\work\\book2.dbf");
DBFReader dbfreader = new DBFReader("./book2.dbf");
//DBFReader dbfreader = new DBFReader("E:\\hexiongshare\\test.dbf");
int i;
for (i=0; i<dbfreader.getFieldCount(); i++) {
System.out.print(dbfreader.getField(i).getName()+" ");
}
System.out.print("\n");
for(i = 0; dbfreader.hasNextRecord(); i++)
{
Object aobj[] = dbfreader.nextRecord(Charset.forName("GBK"));
for (int j=0; j<aobj.length; j++)
System.out.print(aobj[j]+" | ");
System.out.print("\n");
}
System.out.println("Total Count: " + i);
}
本文由用戶 jopen 自行上傳分享,僅供網友學習交流。所有權歸原作者,若您的權利被侵害,請聯系管理員。
轉載本站原創文章,請注明出處,并保留原始鏈接、圖片水印。
本站是一個以用戶分享為主的開源技術平臺,歡迎各類分享!