readdbf.java

数据库课程lab。通过java下的xmlAPI实现xml文件数据库到oracle数据的迁移。

package logic;

import java.io.*;
import com.linuxense.javadbf.*;

public class ReadDbf {
	public Object[][] readDbf(String fileName) {
		Object[][] objTemp= null;

		try {
			InputStream is = new FileInputStream(fileName);
			DBFReader reader = new DBFReader(is);
			
			int numberOfFields = reader.getFieldCount();
			int numberOfRecords = reader.getRecordCount();
			objTemp = new Object[numberOfRecords+1][numberOfFields];
			for(int i =0;i<numberOfFields;i++){
				DBFField field = reader.getField( i);
				objTemp[0][i] = field;

			}
			
			 Object []rowObjects;
		    for(int i = 1;i <numberOfRecords+1;i++){
		    	rowObjects = reader.nextRecord();
		        for( int j=0; j<numberOfFields; j++) {
		        	objTemp[i][j] = rowObjects[j];
		        }
		      }

			

		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return objTemp;
	}
}