快捷導(dǎo)航

java解析dbf之通過(guò)javadbf包生成和讀取dbf文件

更新時(shí)間：2014年01月28日 12:05:17 作者：

這篇文章主要介紹了java通過(guò)javadbf讀取和生成DBF文件的方法，大家參考使用吧

以下是簡(jiǎn)單示例

package com.cramc;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;

import com.linuxense.javadbf.DBFException;
import com.linuxense.javadbf.DBFField;
import com.linuxense.javadbf.DBFReader;
import com.linuxense.javadbf.DBFWriter;

public class Rwdbf {

public static void readDBF(String path)

    {

       InputStream fis = null;
        try
        {
            //讀取文件的輸入流
            fis = new FileInputStream(path);
            //根據(jù)輸入流初始化一個(gè)DBFReader實(shí)例，用來(lái)讀取DBF文件信息
            DBFReader reader = new DBFReader(fis);
            //調(diào)用DBFReader對(duì)實(shí)例方法得到path文件中字段的個(gè)數(shù)
            int fieldsCount = reader.getFieldCount();
            System.out.println("字段數(shù):"+fieldsCount);
            //取出字段信息
            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){}
          }
    }

public static void writeDBF(String path)
{

OutputStream fos = null;
try
{
      //定義DBF文件字段
      DBFField[] fields = new DBFField[3];
      //分別定義各個(gè)字段信息，setFieldName和setName作用相同，
      //只是setFieldName已經(jīng)不建議使用
      fields[0] = new DBFField();
      //fields[0].setFieldName("emp_code");
      fields[0].setName("semp_code");
      fields[0].setDataType(DBFField.FIELD_TYPE_C);
      fields[0].setFieldLength(10);

      fields[1] = new DBFField();
      //fields[1].setFieldName("emp_name");
      fields[1].setName("emp_name");
      fields[1].setDataType(DBFField.FIELD_TYPE_C);
      fields[1].setFieldLength(20);

      fields[2] = new DBFField();
      //fields[2].setFieldName("salary");
      fields[2].setName("salary");
      fields[2].setDataType(DBFField.FIELD_TYPE_N);
      fields[2].setFieldLength(12);
      fields[2].setDecimalCount(2);

      //DBFWriter writer = new DBFWriter(new File(path));

      //定義DBFWriter實(shí)例用來(lái)寫(xiě)DBF文件
      DBFWriter writer = new DBFWriter();
      //把字段信息寫(xiě)入DBFWriter實(shí)例，即定義表結(jié)構(gòu)
      writer.setFields(fields);
      //一條條的寫(xiě)入記錄
      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);

      //定義輸出流，并關(guān)聯(lián)的一個(gè)文件
      fos = new FileOutputStream(path);
      //寫(xiě)入數(shù)據(jù)
      writer.write(fos);

      //writer.write();
}catch(Exception e)
{
      e.printStackTrace();
}
finally
{
      try{
      fos.close();
      }catch(Exception e){}
}
}

public static void main(String[] args){
  String path ="E:\\tmp\\2\\xx.dbf";
  try {
   InputStream fis = new FileInputStream(path);
   DBFReader reader = new DBFReader(fis);
   int fieldsCount = reader.getFieldCount();
            System.out.println("字段數(shù):"+fieldsCount);

            DBFField[] df = new DBFField[fieldsCount+2];
            for( int i=0; i<fieldsCount; i++)
            {
              df[i] = reader.getField(i);
              System.out.println("field"+i+":"+df[i].getName());
            }
            df[fieldsCount] = new DBFField();
            df[fieldsCount].setName("add1");
            df[fieldsCount].setDataType(DBFField.FIELD_TYPE_C);
            df[fieldsCount].setFieldLength(10);
            df[fieldsCount+1] = new DBFField();
            df[fieldsCount+1].setName("add2");
            df[fieldsCount+1].setDataType(DBFField.FIELD_TYPE_C);
            df[fieldsCount+1].setFieldLength(10);

            DBFWriter writer = new DBFWriter();
            writer.setFields(df);

            Object[] rowValues;
            Object[] rowValues1 = new Object[fieldsCount+2];
            //一條條取出path文件中記錄
            while((rowValues = reader.nextRecord()) != null)
            {
              for(int i=0;i<fieldsCount;i++){
               rowValues1[i] = rowValues[i];
              }
              rowValues1[fieldsCount]="x";
              rowValues1[fieldsCount+1]="xx";
              writer.addRecord(rowValues1);
            }


            path ="E:\\tmp\\2\\test2.dbf";
            OutputStream fos = new FileOutputStream(path);
         //寫(xiě)入數(shù)據(jù)
         writer.write(fos);

         System.out.println("OVER");


  } catch (FileNotFoundException | DBFException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
}