Exemple #1
0
  /**
   * @param dbfFile A DBF file
   * @return A list of attribute names in the DBF file
   */
  public static List<String> getAttributeNames(File dbfFile) throws IOException {
    FileInputStream fis = new FileInputStream(dbfFile);
    DbaseFileReader dbfReader =
        new DbaseFileReader(fis.getChannel(), false, Charset.forName("ISO-8859-1"));

    // contains the header columns
    DbaseFileHeader dbfHeader = dbfReader.getHeader();

    // get the names from the header
    List<String> names = new Vector<String>();
    int n = dbfHeader.getNumFields();
    for (int i = 0; i < n; i++) names.add(dbfHeader.getFieldName(i));

    return names;
  }
Exemple #2
0
 // returns a string format of the SQL Datatype of the column using the getFieldType function from
 // DBaseFileHeader
 private static String getSQLDataType(Connection conn, DbaseFileHeader dbfHeader, int index) {
   char dataType = dbfHeader.getFieldType(index);
   String sqlDataType = "";
   if (dataType == 'C')
     sqlDataType = SQLUtils.getVarcharTypeString(conn, dbfHeader.getFieldLength(index));
   else if (dataType == 'N' || dataType == 'F') {
     // if it has not 0 decimals return type as integer else Double Precision
     if (dbfHeader.getFieldDecimalCount(index) == 0)
       sqlDataType = SQLUtils.getBigIntTypeString(conn);
     else sqlDataType = SQLUtils.getDoubleTypeString(conn);
   } else if (dataType == 'D') {
     sqlDataType = SQLUtils.getDateTimeTypeString(conn);
   } else {
     throw new RuntimeException(
         "Unknown DBF data type: " + dataType + " in column " + dbfHeader.getFieldName(index));
   }
   return sqlDataType;
 }
Exemple #3
0
  /**
   * @param dbfFile A DBF file
   * @return A list of attribute names in the DBF file
   */
  public static Object[][] getDBFData(File dbfFile) throws IOException {
    FileInputStream fis = new FileInputStream(dbfFile);
    DbaseFileReader dbfReader =
        new DbaseFileReader(fis.getChannel(), false, Charset.forName("ISO-8859-1"));

    // contains the header columns
    DbaseFileHeader dbfHeader = dbfReader.getHeader();

    List<Object[]> rowsList = new Vector<Object[]>();

    while (dbfReader.hasNext()) {
      rowsList.add(dbfReader.readEntry());
    }

    int numOfCol = dbfHeader.getNumFields();

    Object[][] dataRows = new Object[rowsList.size()][numOfCol];

    for (int i = 0; i < rowsList.size(); i++) {
      dataRows[i] = rowsList.get(i);
    }

    return dataRows;
  }