|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectru.smartflex.tools.dbf.DbfEngine
public class DbfEngine
The main class that supplies iterators and appenders - start here.
The reader parts may be used in two ways:
DbfIterator dbfIterator = DbfEngine.getReader( Fp26Reader.class.getResourceAsStream("FP_26_SAMPLE.DBF"), null);
DbfHeader dbfHeader = DbfEngine.getHeader( Fp26Reader.class.getResourceAsStream("FP_26_SAMPLE.DBF"), null); DbfIterator dbfIterator = dbfHeader.getDbfIterator();
while (dbfIterator.hasMoreRecords()) { DbfRecord dbfRecord = dbfIterator.nextRecord(); String string = dbfRecord.getString("string"); float sumFloat = dbfRecord.getFloat("sum_f"); BigDecimal sumNumeric = dbfRecord.getBigDecimal("sum_n"); boolean bool = dbfRecord.getBoolean("bool_val"); Date date = dbfRecord.getDate("date_val"); System.out.println(string + " " + sumFloat + " " + sumNumeric + " " + bool + " " + date); }
DbfAppender dbfAppender = DbfEngine.getWriter("WRT_PERSON.DBF", DbfCodePages.Cp866);And then you have to define columns for dbf header:
DbfColumn dc01 = new DbfColumn("magic", DbfColumnTypes.Logical, 0, 0); DbfColumn dc02 = new DbfColumn("actor", DbfColumnTypes.Character, 60, 0); DbfColumn dc03 = new DbfColumn("currdate", DbfColumnTypes.Date, 0, 0); DbfColumn dc04 = new DbfColumn("hit", DbfColumnTypes.Numeric, 10, 2); DbfColumn dc05 = new DbfColumn("forever", DbfColumnTypes.Logical, 0, 0); dbfAppender.defineColumns(dc01, dc02, dc03, dc04, dc05);After that you have to use DbfStatement:
DbfStatement statement = dbfAppender.getStatement();
statement.setString("actor", "Chuck Norris"); statement.setDate("currdate", new Date()); statement.setBigDecimal("hit", new BigDecimal("500.5"));
statement.insertStatement();
statement.setBoolean("magic", Boolean.TRUE); statement.setString("actor", "Bruce Lee"); statement.setBigDecimal("hit", new BigDecimal("1000.10")); statement.setBoolean("forever", Boolean.TRUE);
statement.insertStatement();
dbfAppender.writeDbfAndClose();
Method Summary | |
---|---|
static DbfHeader |
getHeader(java.io.File dbfFile,
java.lang.String enc)
Gets DBF header. |
static DbfHeader |
getHeader(java.io.InputStream dbfStream,
java.lang.String enc)
Gets DBF header. |
static DbfHeader |
getHeader(java.lang.String dbfFileName,
java.lang.String enc)
Gets DBF header. |
static DbfHeader |
getHeader(java.lang.String path,
java.lang.String dbfFileName,
java.lang.String enc)
Gets DBF header. |
static DbfIterator |
getReader(java.io.File dbfFile,
java.lang.String enc)
|
static DbfIterator |
getReader(java.io.InputStream dbfStream,
java.lang.String enc)
|
static DbfIterator |
getReader(java.lang.String dbfFileName,
java.lang.String enc)
|
static DbfIterator |
getReader(java.lang.String path,
java.lang.String dbfFileName,
java.lang.String enc)
|
static DbfAppender |
getWriter(java.io.File dbfFile,
DbfCodePages dbfCodePage)
|
static DbfAppender |
getWriter(java.io.OutputStream dbfStream,
DbfCodePages dbfCodePage)
|
static DbfAppender |
getWriter(java.lang.String dbfFileName,
DbfCodePages dbfCodePage)
|
static DbfAppender |
getWriter(java.lang.String path,
java.lang.String dbfFileName,
DbfCodePages dbfCodePage)
|
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Method Detail |
---|
public static DbfHeader getHeader(java.lang.String dbfFileName, java.lang.String enc)
dbfFileName
- enc
-
public static DbfHeader getHeader(java.lang.String path, java.lang.String dbfFileName, java.lang.String enc)
path
- dbfFileName
- enc
-
public static DbfHeader getHeader(java.io.File dbfFile, java.lang.String enc)
dbfFile
- enc
-
public static DbfHeader getHeader(java.io.InputStream dbfStream, java.lang.String enc)
dbfStream
- enc
-
public static DbfIterator getReader(java.lang.String dbfFileName, java.lang.String enc)
public static DbfIterator getReader(java.lang.String path, java.lang.String dbfFileName, java.lang.String enc)
public static DbfIterator getReader(java.io.File dbfFile, java.lang.String enc)
public static DbfIterator getReader(java.io.InputStream dbfStream, java.lang.String enc)
public static DbfAppender getWriter(java.lang.String path, java.lang.String dbfFileName, DbfCodePages dbfCodePage)
public static DbfAppender getWriter(java.lang.String dbfFileName, DbfCodePages dbfCodePage)
public static DbfAppender getWriter(java.io.File dbfFile, DbfCodePages dbfCodePage)
public static DbfAppender getWriter(java.io.OutputStream dbfStream, DbfCodePages dbfCodePage)
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |