|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--de.mvcsys.rsql.Rsql
Remote-SQL-Konstanten etc.
Field Summary | |
static int |
CHARSET_ID_BIG5
Charset id for BIG5 |
static int |
CHARSET_ID_ISO88591
Charset id for ISO88591 |
static int |
CHARSET_ID_ISO88592
Charset id for ISO88592 |
static int |
CHARSET_ID_ISO88593
Charset id for ISO88593 |
static int |
CHARSET_ID_ISO88594
Charset id for ISO88594 |
static int |
CHARSET_ID_ISO88595
Charset id for ISO88595 |
static int |
CHARSET_ID_ISO88596
Charset id for ISO88596 |
static int |
CHARSET_ID_ISO88597
Charset id for ISO88597 |
static int |
CHARSET_ID_ISO88598
Charset id for ISO88598 |
static int |
CHARSET_ID_ISO88599
Charset id for ISO88599 |
static int |
CHARSET_ID_KANJI
Charset id for KANJI |
static int |
CHARSET_ID_KSC5601
Charset id for KSC5601 |
static int |
CHARSET_ID_UNKNOWN
Charset id for UNKNOWN |
static int |
DT_16BIT_S
16 bit signed binary number SMALLINT, NUMERIC(1-4, (scale)) |
static int |
DT_16BIT_U
16 bit unsigned binary number unsigned NUMERIC(1-4, (scale)) |
static int |
DT_32BIT_S
32 bit signed binary number INTEGER, NUMERIC(5-9, (scale)) |
static int |
DT_32BIT_U
32 bit unsigned binary number unsigned NUMERIC(5-9, (scale)) |
static int |
DT_64BIT_S
64 bit signed binary number LARGEINT, NUMERIC(10-18,(scale)) |
static int |
DT_ASCII_F
|
static int |
DT_ASCII_F_UP
CHAR datatype, UPSHIFTed |
static int |
DT_ASCII_V
VARCHAR datatype |
static int |
DT_ASCII_V_UP
VARCHAR datatype, UPSHIFted |
static int |
DT_DATETIME
DATETIME datatype |
static int |
DT_DEC_LSE
DECIMAL datatype: leading sign is embedded |
static int |
DT_DEC_LSS
DECIMAL datatype: leading sign is separate |
static int |
DT_DEC_TSE
DECIMAL datatype: trailing sign embedded |
static int |
DT_DEC_TSS
DECIMAL datatype: trailing sign separate |
static int |
DT_DEC_U
DECIMAL datatype: unsigned |
static int |
DT_DOUBLE
64 bit FLOAT |
static int |
DT_DOUBLE_F
DOUBLE CHAR datatype |
static int |
DT_DOUBLE_V
DOUBLE VARCHAR datatype |
static int |
DT_INT_D_D
INTERVAL datatype: DAY TO DAY |
static int |
DT_INT_D_F
INTERVAL datatype: DAY TO FRACTION |
static int |
DT_INT_D_H
INTERVAL datatype: DAY TO HOUR |
static int |
DT_INT_D_MI
INTERVAL datatype: DAY TO MINUTE |
static int |
DT_INT_D_S
INTERVAL datatype: DAY TO SECOND |
static int |
DT_INT_F_F
INTERVAL datatype: FRACTION TO FRACTION |
static int |
DT_INT_H_F
INTERVAL datatype: HOUR TO FRACTION |
static int |
DT_INT_H_H
INTERVAL datatype: HOUR TO HOUR |
static int |
DT_INT_H_MI
INTERVAL datatype: HOUR TO MINUTE |
static int |
DT_INT_H_S
INTERVAL datatype: HOUR TO SECOND |
static int |
DT_INT_MI_F
INTERVAL datatype: MINUTE TO FRACTION |
static int |
DT_INT_MI_MI
INTERVAL datatype: MINUTE TO MINUTE |
static int |
DT_INT_MI_S
INTERVAL datatype: MINUTE TO SECOND |
static int |
DT_INT_MO_MO
INTERVAL datatype: MONTH TO MONTH |
static int |
DT_INT_S_F
INTERVAL datatype: SECOND TO FRACTION |
static int |
DT_INT_S_S
INTERVAL datatype: SECOND TO SECOND |
static int |
DT_INT_Y_MO
INTERVAL datatype: YEAR TO MONTH |
static int |
DT_INT_Y_Y
INTERVAL datatype: YEAR TO YEAR |
static int |
DT_REAL
32 bit FLOAT |
static int |
DTINT_QUAL_D_D
DATETIME OR INTERVAL qualifier: DAY TO DAY |
static int |
DTINT_QUAL_D_F
DATETIME OR INTERVAL qualifier: DAY TO FRACTION |
static int |
DTINT_QUAL_D_H
DATETIME OR INTERVAL qualifier: DAY TO HOUR |
static int |
DTINT_QUAL_D_MI
DATETIME OR INTERVAL qualifier: DAY TO MINUTE |
static int |
DTINT_QUAL_D_S
DATETIME OR INTERVAL qualifier: DAY TO SECOND |
static int |
DTINT_QUAL_F_F
DATETIME OR INTERVAL qualifier: FRACTION TO FRACTION |
static int |
DTINT_QUAL_H_F
DATETIME OR INTERVAL qualifier: HOUR TO FRACTION |
static int |
DTINT_QUAL_H_H
DATETIME OR INTERVAL qualifier: HOUR TO HOUR |
static int |
DTINT_QUAL_H_MI
DATETIME OR INTERVAL qualifier: HOUR TO MINUTE |
static int |
DTINT_QUAL_H_S
DATETIME OR INTERVAL qualifier: HOUR TO SECOND |
static int |
DTINT_QUAL_MI_F
DATETIME OR INTERVAL qualifier: SECOND TO FRACTION |
static int |
DTINT_QUAL_MI_MI
DATETIME OR INTERVAL qualifier: MINUTE TO MINUTE |
static int |
DTINT_QUAL_MI_S
DATETIME OR INTERVAL qualifier: SECOND TO SECOND |
static int |
DTINT_QUAL_MO_D
DATETIME OR INTERVAL qualifier: MONTH TO DAY |
static int |
DTINT_QUAL_MO_F
DATETIME OR INTERVAL qualifier: MONTH TO FRACTION |
static int |
DTINT_QUAL_MO_H
DATETIME OR INTERVAL qualifier: MONTH TO HOUR |
static int |
DTINT_QUAL_MO_MI
DATETIME OR INTERVAL qualifier: MONTH TO MINUTE |
static int |
DTINT_QUAL_MO_MO
DATETIME OR INTERVAL qualifier: MONTH TO MONTH |
static int |
DTINT_QUAL_MO_S
DATETIME OR INTERVAL qualifier: MONTH TO SECOND |
static int |
DTINT_QUAL_S_F
DATETIME OR INTERVAL qualifier: SECOND TO FRACTION |
static int |
DTINT_QUAL_S_S
DATETIME OR INTERVAL qualifier: SECOND TO SECOND |
static int |
DTINT_QUAL_Y_D
DATETIME OR INTERVAL qualifier: YEAR TO DAY |
static int |
DTINT_QUAL_Y_F
DATETIME OR INTERVAL qualifier: YEAR TO FRACTION |
static int |
DTINT_QUAL_Y_H
DATETIME OR INTERVAL qualifier: YEAR TO HOUR |
static int |
DTINT_QUAL_Y_MI
DATETIME OR INTERVAL qualifier: YEAR TO MINUTE |
static int |
DTINT_QUAL_Y_MO
DATETIME OR INTERVAL qualifier: YEAR TO MONTH |
static int |
DTINT_QUAL_Y_S
DATETIME OR INTERVAL qualifier: YEAR TO SECOND |
static int |
DTINT_QUAL_Y_Y
DATETIME OR INTERVAL qualifier: YEAR TO YEAR |
static int |
ERR_CLASS_API
Fehlerklasse API |
static int |
ERR_CLASS_SQL
Fehlerklasse SQL |
static int |
ERR_CONNECTED
Fehler "Connected" (Basis-Wert + 3) |
static int |
ERR_DATA_CONVERSION
Fehler "Data Conversion" (Basis-Wert + 13) |
static int |
ERR_EXECUTION_FAILURE
Fehler "Execution failure" (Basis-Wert + 5) |
static int |
ERR_FILE_NOT_FOUND
Fehler "File not found" (Basis-Wert + 4) |
static int |
ERR_FIRST
API-Fehlernummern (Basis-Wert 23000) |
static int |
ERR_INCONSISTENCY
Fehler "Inconsistency" (Basis-Wert + 8) |
static int |
ERR_INTERNAL_FAILURE
Fehler "Internal failure" (Basis-Wert + 9) |
static int |
ERR_NAME_EXISTS
Fehler "Name exists" (Basis-Wert + 2) |
static int |
ERR_NAME_UNDEFINED
Fehler "Name undefined" (Basis-Wert + 10) |
static int |
ERR_NOT_CONNECTED
Fehler "Not connected" (Basis-Wert + 1) |
static int |
ERR_NOT_OPEN
Fehler "Not Open" (Basis-Wert + 14) |
static int |
ERR_NOT_PREPARED
Fehler "Not Prepared" (Basis-Wert + 12) |
static int |
ERR_OUT_OF_MEMORY
Fehler "Out of memeory" (Basis-Wert + 7) |
static int |
ERR_TOO_MANY_CURSORS
Fehler "Too many cursors" (Basis-Wert + 11) |
static int |
ERR_TOO_MANY_STATEMENTS
Fehler "Too many statements" (Basis-Wert + 6) |
static int |
FETCH_AHEAD
Flag für gepuffertes Lesen |
static int |
NO_FETCH_AHEAD
Flag für ungepuffertes Lesen |
static int |
SQL_ERR_CONSTRAINT
SQLCODE "Constraint violation" |
static int |
SQL_WARN_NO_ROWS_FOUND
SQLCODE "No rows found" |
static int |
STATEMENT_CONTROL
Dynamic SQL statement type: run-time control statement |
static int |
STATEMENT_DCL
Dynamic SQL statement type: lock, unlock, free resources |
static int |
STATEMENT_DDL
Dynamic SQL statement type: DDL statement |
static int |
STATEMENT_DELETE
Dynamic SQL statement type: delete statement |
static int |
STATEMENT_GET
Dynamic SQL statement type: get statements |
static int |
STATEMENT_INSERT
Dynamic SQL statement type: insert statement |
static int |
STATEMENT_SELECT
Dynamic SQL statement type: select (cursor) statement |
static int |
STATEMENT_UPDATE
Dynamic SQL statement type: update statement |
Method Summary | |
protected static int |
computeDateOffset(int scale)
Hilfsfunktion: Bestimme den RsqlDate-Offset |
static Object |
computeValue(byte[] buffer,
int offset,
int type,
int length,
int scale,
int precision,
String encoding)
Wandle die Daten im Puffer in einen Java-Datentyp um. |
static void |
dot()
|
static byte[] |
getBytes(Object o,
String encoding)
Hilfsfunktion: Ermittle die Bytes eines Strings |
static void |
main(String[] args)
Test |
static BigDecimal |
makeBigDecimal(Object o,
int scale)
Hilfsfunktion: Wandle ein Object in einen BigDecimal |
static String |
makeDateString(Object o,
int length,
int scale)
Hilfsfunktion: Wandle ein Datums-Object in einen SQL-Text |
static BigDecimal |
makeDecimal(long value,
int scale)
Hilfsfunktion um einen BigDecimal zu erzeugen |
static double |
makeDouble(Object o)
Hilfsfunktion: Wandle ein Object in einen double. |
static int |
makeInt(Object o,
int scale)
Hilfsfunktion: Wandle ein Object in einen int |
static long |
makeLong(Object o,
int scale)
Hilfsfunktion: Wandle ein Object in einen long |
static short |
makeShort(Object o,
int scale)
Hilfsfunktion: Wandle ein Object in einen short |
static String |
makeUnscaledString(Object o,
int scale)
Hilfsfunktion: Wandle ein Object in einen unskalierten String |
static void |
storeBytes(byte[] src,
int srcOff,
int srcLen,
byte[] buffer,
int offset,
int length,
byte filler,
boolean right)
Hilfsfunktion: Kopiere mit Filler |
static void |
storeValue(Object value,
byte[] buffer,
int offset,
int type,
int length,
int scale,
int precision,
String encoding)
Wandle einen Java-Datentyp in Pufferdaten um. |
static boolean |
testConv(Object value,
int type,
int length,
int scale,
int precision)
Test der Konvertierung |
static String |
typeName(int type,
int length,
int scale,
int precision)
Wandle einen Typ in einen Namen um |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
public static final int CHARSET_ID_BIG5
public static final int CHARSET_ID_ISO88591
public static final int CHARSET_ID_ISO88592
public static final int CHARSET_ID_ISO88593
public static final int CHARSET_ID_ISO88594
public static final int CHARSET_ID_ISO88595
public static final int CHARSET_ID_ISO88596
public static final int CHARSET_ID_ISO88597
public static final int CHARSET_ID_ISO88598
public static final int CHARSET_ID_ISO88599
public static final int CHARSET_ID_KANJI
public static final int CHARSET_ID_KSC5601
public static final int CHARSET_ID_UNKNOWN
public static final int DT_16BIT_S
public static final int DT_16BIT_U
public static final int DT_32BIT_S
public static final int DT_32BIT_U
public static final int DT_64BIT_S
public static final int DT_ASCII_F
public static final int DT_ASCII_F_UP
public static final int DT_ASCII_V
public static final int DT_ASCII_V_UP
public static final int DT_DATETIME
public static final int DT_DEC_LSE
public static final int DT_DEC_LSS
public static final int DT_DEC_TSE
public static final int DT_DEC_TSS
public static final int DT_DEC_U
public static final int DT_DOUBLE
public static final int DT_DOUBLE_F
public static final int DT_DOUBLE_V
public static final int DT_INT_D_D
public static final int DT_INT_D_F
public static final int DT_INT_D_H
public static final int DT_INT_D_MI
public static final int DT_INT_D_S
public static final int DT_INT_F_F
public static final int DT_INT_H_F
public static final int DT_INT_H_H
public static final int DT_INT_H_MI
public static final int DT_INT_H_S
public static final int DT_INT_MI_F
public static final int DT_INT_MI_MI
public static final int DT_INT_MI_S
public static final int DT_INT_MO_MO
public static final int DT_INT_S_F
public static final int DT_INT_S_S
public static final int DT_INT_Y_MO
public static final int DT_INT_Y_Y
public static final int DT_REAL
public static final int DTINT_QUAL_D_D
public static final int DTINT_QUAL_D_F
public static final int DTINT_QUAL_D_H
public static final int DTINT_QUAL_D_MI
public static final int DTINT_QUAL_D_S
public static final int DTINT_QUAL_F_F
public static final int DTINT_QUAL_H_F
public static final int DTINT_QUAL_H_H
public static final int DTINT_QUAL_H_MI
public static final int DTINT_QUAL_H_S
public static final int DTINT_QUAL_MI_F
public static final int DTINT_QUAL_MI_MI
public static final int DTINT_QUAL_MI_S
public static final int DTINT_QUAL_MO_D
public static final int DTINT_QUAL_MO_F
public static final int DTINT_QUAL_MO_H
public static final int DTINT_QUAL_MO_MI
public static final int DTINT_QUAL_MO_MO
public static final int DTINT_QUAL_MO_S
public static final int DTINT_QUAL_S_F
public static final int DTINT_QUAL_S_S
public static final int DTINT_QUAL_Y_D
public static final int DTINT_QUAL_Y_F
public static final int DTINT_QUAL_Y_H
public static final int DTINT_QUAL_Y_MI
public static final int DTINT_QUAL_Y_MO
public static final int DTINT_QUAL_Y_S
public static final int DTINT_QUAL_Y_Y
public static final int ERR_CLASS_API
public static final int ERR_CLASS_SQL
public static final int ERR_CONNECTED
public static final int ERR_DATA_CONVERSION
public static final int ERR_EXECUTION_FAILURE
public static final int ERR_FILE_NOT_FOUND
public static final int ERR_FIRST
public static final int ERR_INCONSISTENCY
public static final int ERR_INTERNAL_FAILURE
public static final int ERR_NAME_EXISTS
public static final int ERR_NAME_UNDEFINED
public static final int ERR_NOT_CONNECTED
public static final int ERR_NOT_OPEN
public static final int ERR_NOT_PREPARED
public static final int ERR_OUT_OF_MEMORY
public static final int ERR_TOO_MANY_CURSORS
public static final int ERR_TOO_MANY_STATEMENTS
public static final int FETCH_AHEAD
public static final int NO_FETCH_AHEAD
public static final int SQL_ERR_CONSTRAINT
public static final int SQL_WARN_NO_ROWS_FOUND
public static final int STATEMENT_CONTROL
public static final int STATEMENT_DCL
public static final int STATEMENT_DDL
public static final int STATEMENT_DELETE
public static final int STATEMENT_GET
public static final int STATEMENT_INSERT
public static final int STATEMENT_SELECT
public static final int STATEMENT_UPDATE
Method Detail |
protected static int computeDateOffset(int scale)
scale
- Eine der DTINT_QUAL_...-KonstantenRsqlDate
.F_...-Konstantepublic static Object computeValue(byte[] buffer, int offset, int type, int length, int scale, int precision, String encoding) throws RsqlException
Wandle die Daten im Puffer in einen Java-Datentyp um.
buffer
- Byte-Array vom Serverbase
- Beginn der Daten im Puffertype
- SQL-Datentyp DT_...length
- Länge der Datenscale
- numerische Skalierungprecision
- Präzision bei DATETIME und INTERVALencoding
- Java-Encodingpublic static void dot()
public static byte[] getBytes(Object o, String encoding)
o
- String (wird mit o.toString()
ermittelt)encoding
- Encoding. Bei Fehlern wird Default-Encoding benutzt.public static void main(String[] args) throws Exception
public static BigDecimal makeBigDecimal(Object o, int scale)
o
- Number oder Stringscale
- Skalierungpublic static String makeDateString(Object o, int length, int scale) throws RsqlException
o
- RsqlDate, Date oder Stringlength
- Länge des Feldesscale
- DATETIME-Qualifier DTINT_QUAL_...public static BigDecimal makeDecimal(long value, int scale)
value
- Wert (unskaliert)scale
- Anzahl der Nachkommastellenpublic static double makeDouble(Object o)
o
- Number oder Stringscale
- Skalierungpublic static int makeInt(Object o, int scale)
o
- Number oder Stringscale
- Skalierungpublic static long makeLong(Object o, int scale)
o
- Number oder Stringscale
- Skalierungpublic static short makeShort(Object o, int scale)
o
- Number oder Stringscale
- Skalierungpublic static String makeUnscaledString(Object o, int scale)
o
- Number oder Stringscale
- Skalierungpublic static void storeBytes(byte[] src, int srcOff, int srcLen, byte[] buffer, int offset, int length, byte filler, boolean right)
src
- QuellesrcOff
- Offset in der QuellesrcLen
- Länge der Quellebuffer
- Zieloffset
- Offset im Ziellength
- Länge des Zielsfiller
- Füllzeichenright
- Rechtsbündigpublic static void storeValue(Object value, byte[] buffer, int offset, int type, int length, int scale, int precision, String encoding) throws RsqlException
Wandle einen Java-Datentyp in Pufferdaten um.
buffer
- Byte-Array vom Serverbase
- Beginn der Daten im Puffertype
- SQL-Datentyp DT_...length
- Länge der Datenscale
- numerische Skalierungprecision
- Präzision bei DATETIME und INTERVALencoding
- Java-Encodingpublic static boolean testConv(Object value, int type, int length, int scale, int precision) throws RsqlException
true
bei Fehlern/Abweichungenpublic static String typeName(int type, int length, int scale, int precision)
type
- eine der DT-Konstantenlength
- Längescale
- Numerischer Scaleprecision
- Genauigkeit (DATETIME und INTERVAL)
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |