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 自行上傳分享,僅供網友學習交流。所有權歸原作者,若您的權利被侵害,請聯系管理員。
轉載本站原創文章,請注明出處,并保留原始鏈接、圖片水印。
本站是一個以用戶分享為主的開源技術平臺,歡迎各類分享!