de.mvcsys.rsql
Class Rsql

java.lang.Object
  |
  +--de.mvcsys.rsql.Rsql

public class Rsql
extends Object

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

CHARSET_ID_BIG5

public static final int CHARSET_ID_BIG5
Charset id for BIG5

CHARSET_ID_ISO88591

public static final int CHARSET_ID_ISO88591
Charset id for ISO88591

CHARSET_ID_ISO88592

public static final int CHARSET_ID_ISO88592
Charset id for ISO88592

CHARSET_ID_ISO88593

public static final int CHARSET_ID_ISO88593
Charset id for ISO88593

CHARSET_ID_ISO88594

public static final int CHARSET_ID_ISO88594
Charset id for ISO88594

CHARSET_ID_ISO88595

public static final int CHARSET_ID_ISO88595
Charset id for ISO88595

CHARSET_ID_ISO88596

public static final int CHARSET_ID_ISO88596
Charset id for ISO88596

CHARSET_ID_ISO88597

public static final int CHARSET_ID_ISO88597
Charset id for ISO88597

CHARSET_ID_ISO88598

public static final int CHARSET_ID_ISO88598
Charset id for ISO88598

CHARSET_ID_ISO88599

public static final int CHARSET_ID_ISO88599
Charset id for ISO88599

CHARSET_ID_KANJI

public static final int CHARSET_ID_KANJI
Charset id for KANJI

CHARSET_ID_KSC5601

public static final int CHARSET_ID_KSC5601
Charset id for KSC5601

CHARSET_ID_UNKNOWN

public static final int CHARSET_ID_UNKNOWN
Charset id for UNKNOWN

DT_16BIT_S

public static final int DT_16BIT_S
16 bit signed binary number SMALLINT, NUMERIC(1-4, (scale))

DT_16BIT_U

public static final int DT_16BIT_U
16 bit unsigned binary number unsigned NUMERIC(1-4, (scale))

DT_32BIT_S

public static final int DT_32BIT_S
32 bit signed binary number INTEGER, NUMERIC(5-9, (scale))

DT_32BIT_U

public static final int DT_32BIT_U
32 bit unsigned binary number unsigned NUMERIC(5-9, (scale))

DT_64BIT_S

public static final int DT_64BIT_S
64 bit signed binary number LARGEINT, NUMERIC(10-18,(scale))

DT_ASCII_F

public static final int DT_ASCII_F

DT_ASCII_F_UP

public static final int DT_ASCII_F_UP
CHAR datatype, UPSHIFTed

DT_ASCII_V

public static final int DT_ASCII_V
VARCHAR datatype

DT_ASCII_V_UP

public static final int DT_ASCII_V_UP
VARCHAR datatype, UPSHIFted

DT_DATETIME

public static final int DT_DATETIME
DATETIME datatype

DT_DEC_LSE

public static final int DT_DEC_LSE
DECIMAL datatype: leading sign is embedded

DT_DEC_LSS

public static final int DT_DEC_LSS
DECIMAL datatype: leading sign is separate

DT_DEC_TSE

public static final int DT_DEC_TSE
DECIMAL datatype: trailing sign embedded

DT_DEC_TSS

public static final int DT_DEC_TSS
DECIMAL datatype: trailing sign separate

DT_DEC_U

public static final int DT_DEC_U
DECIMAL datatype: unsigned

DT_DOUBLE

public static final int DT_DOUBLE
64 bit FLOAT

DT_DOUBLE_F

public static final int DT_DOUBLE_F
DOUBLE CHAR datatype

DT_DOUBLE_V

public static final int DT_DOUBLE_V
DOUBLE VARCHAR datatype

DT_INT_D_D

public static final int DT_INT_D_D
INTERVAL datatype: DAY TO DAY

DT_INT_D_F

public static final int DT_INT_D_F
INTERVAL datatype: DAY TO FRACTION

DT_INT_D_H

public static final int DT_INT_D_H
INTERVAL datatype: DAY TO HOUR

DT_INT_D_MI

public static final int DT_INT_D_MI
INTERVAL datatype: DAY TO MINUTE

DT_INT_D_S

public static final int DT_INT_D_S
INTERVAL datatype: DAY TO SECOND

DT_INT_F_F

public static final int DT_INT_F_F
INTERVAL datatype: FRACTION TO FRACTION

DT_INT_H_F

public static final int DT_INT_H_F
INTERVAL datatype: HOUR TO FRACTION

DT_INT_H_H

public static final int DT_INT_H_H
INTERVAL datatype: HOUR TO HOUR

DT_INT_H_MI

public static final int DT_INT_H_MI
INTERVAL datatype: HOUR TO MINUTE

DT_INT_H_S

public static final int DT_INT_H_S
INTERVAL datatype: HOUR TO SECOND

DT_INT_MI_F

public static final int DT_INT_MI_F
INTERVAL datatype: MINUTE TO FRACTION

DT_INT_MI_MI

public static final int DT_INT_MI_MI
INTERVAL datatype: MINUTE TO MINUTE

DT_INT_MI_S

public static final int DT_INT_MI_S
INTERVAL datatype: MINUTE TO SECOND

DT_INT_MO_MO

public static final int DT_INT_MO_MO
INTERVAL datatype: MONTH TO MONTH

DT_INT_S_F

public static final int DT_INT_S_F
INTERVAL datatype: SECOND TO FRACTION

DT_INT_S_S

public static final int DT_INT_S_S
INTERVAL datatype: SECOND TO SECOND

DT_INT_Y_MO

public static final int DT_INT_Y_MO
INTERVAL datatype: YEAR TO MONTH

DT_INT_Y_Y

public static final int DT_INT_Y_Y
INTERVAL datatype: YEAR TO YEAR

DT_REAL

public static final int DT_REAL
32 bit FLOAT

DTINT_QUAL_D_D

public static final int DTINT_QUAL_D_D
DATETIME OR INTERVAL qualifier: DAY TO DAY

DTINT_QUAL_D_F

public static final int DTINT_QUAL_D_F
DATETIME OR INTERVAL qualifier: DAY TO FRACTION

DTINT_QUAL_D_H

public static final int DTINT_QUAL_D_H
DATETIME OR INTERVAL qualifier: DAY TO HOUR

DTINT_QUAL_D_MI

public static final int DTINT_QUAL_D_MI
DATETIME OR INTERVAL qualifier: DAY TO MINUTE

DTINT_QUAL_D_S

public static final int DTINT_QUAL_D_S
DATETIME OR INTERVAL qualifier: DAY TO SECOND

DTINT_QUAL_F_F

public static final int DTINT_QUAL_F_F
DATETIME OR INTERVAL qualifier: FRACTION TO FRACTION

DTINT_QUAL_H_F

public static final int DTINT_QUAL_H_F
DATETIME OR INTERVAL qualifier: HOUR TO FRACTION

DTINT_QUAL_H_H

public static final int DTINT_QUAL_H_H
DATETIME OR INTERVAL qualifier: HOUR TO HOUR

DTINT_QUAL_H_MI

public static final int DTINT_QUAL_H_MI
DATETIME OR INTERVAL qualifier: HOUR TO MINUTE

DTINT_QUAL_H_S

public static final int DTINT_QUAL_H_S
DATETIME OR INTERVAL qualifier: HOUR TO SECOND

DTINT_QUAL_MI_F

public static final int DTINT_QUAL_MI_F
DATETIME OR INTERVAL qualifier: SECOND TO FRACTION

DTINT_QUAL_MI_MI

public static final int DTINT_QUAL_MI_MI
DATETIME OR INTERVAL qualifier: MINUTE TO MINUTE

DTINT_QUAL_MI_S

public static final int DTINT_QUAL_MI_S
DATETIME OR INTERVAL qualifier: SECOND TO SECOND

DTINT_QUAL_MO_D

public static final int DTINT_QUAL_MO_D
DATETIME OR INTERVAL qualifier: MONTH TO DAY

DTINT_QUAL_MO_F

public static final int DTINT_QUAL_MO_F
DATETIME OR INTERVAL qualifier: MONTH TO FRACTION

DTINT_QUAL_MO_H

public static final int DTINT_QUAL_MO_H
DATETIME OR INTERVAL qualifier: MONTH TO HOUR

DTINT_QUAL_MO_MI

public static final int DTINT_QUAL_MO_MI
DATETIME OR INTERVAL qualifier: MONTH TO MINUTE

DTINT_QUAL_MO_MO

public static final int DTINT_QUAL_MO_MO
DATETIME OR INTERVAL qualifier: MONTH TO MONTH

DTINT_QUAL_MO_S

public static final int DTINT_QUAL_MO_S
DATETIME OR INTERVAL qualifier: MONTH TO SECOND

DTINT_QUAL_S_F

public static final int DTINT_QUAL_S_F
DATETIME OR INTERVAL qualifier: SECOND TO FRACTION

DTINT_QUAL_S_S

public static final int DTINT_QUAL_S_S
DATETIME OR INTERVAL qualifier: SECOND TO SECOND

DTINT_QUAL_Y_D

public static final int DTINT_QUAL_Y_D
DATETIME OR INTERVAL qualifier: YEAR TO DAY

DTINT_QUAL_Y_F

public static final int DTINT_QUAL_Y_F
DATETIME OR INTERVAL qualifier: YEAR TO FRACTION

DTINT_QUAL_Y_H

public static final int DTINT_QUAL_Y_H
DATETIME OR INTERVAL qualifier: YEAR TO HOUR

DTINT_QUAL_Y_MI

public static final int DTINT_QUAL_Y_MI
DATETIME OR INTERVAL qualifier: YEAR TO MINUTE

DTINT_QUAL_Y_MO

public static final int DTINT_QUAL_Y_MO
DATETIME OR INTERVAL qualifier: YEAR TO MONTH

DTINT_QUAL_Y_S

public static final int DTINT_QUAL_Y_S
DATETIME OR INTERVAL qualifier: YEAR TO SECOND

DTINT_QUAL_Y_Y

public static final int DTINT_QUAL_Y_Y
DATETIME OR INTERVAL qualifier: YEAR TO YEAR

ERR_CLASS_API

public static final int ERR_CLASS_API
Fehlerklasse API

ERR_CLASS_SQL

public static final int ERR_CLASS_SQL
Fehlerklasse SQL

ERR_CONNECTED

public static final int ERR_CONNECTED
Fehler "Connected" (Basis-Wert + 3)

ERR_DATA_CONVERSION

public static final int ERR_DATA_CONVERSION
Fehler "Data Conversion" (Basis-Wert + 13)

ERR_EXECUTION_FAILURE

public static final int ERR_EXECUTION_FAILURE
Fehler "Execution failure" (Basis-Wert + 5)

ERR_FILE_NOT_FOUND

public static final int ERR_FILE_NOT_FOUND
Fehler "File not found" (Basis-Wert + 4)

ERR_FIRST

public static final int ERR_FIRST
API-Fehlernummern (Basis-Wert 23000)

ERR_INCONSISTENCY

public static final int ERR_INCONSISTENCY
Fehler "Inconsistency" (Basis-Wert + 8)

ERR_INTERNAL_FAILURE

public static final int ERR_INTERNAL_FAILURE
Fehler "Internal failure" (Basis-Wert + 9)

ERR_NAME_EXISTS

public static final int ERR_NAME_EXISTS
Fehler "Name exists" (Basis-Wert + 2)

ERR_NAME_UNDEFINED

public static final int ERR_NAME_UNDEFINED
Fehler "Name undefined" (Basis-Wert + 10)

ERR_NOT_CONNECTED

public static final int ERR_NOT_CONNECTED
Fehler "Not connected" (Basis-Wert + 1)

ERR_NOT_OPEN

public static final int ERR_NOT_OPEN
Fehler "Not Open" (Basis-Wert + 14)

ERR_NOT_PREPARED

public static final int ERR_NOT_PREPARED
Fehler "Not Prepared" (Basis-Wert + 12)

ERR_OUT_OF_MEMORY

public static final int ERR_OUT_OF_MEMORY
Fehler "Out of memeory" (Basis-Wert + 7)

ERR_TOO_MANY_CURSORS

public static final int ERR_TOO_MANY_CURSORS
Fehler "Too many cursors" (Basis-Wert + 11)

ERR_TOO_MANY_STATEMENTS

public static final int ERR_TOO_MANY_STATEMENTS
Fehler "Too many statements" (Basis-Wert + 6)

FETCH_AHEAD

public static final int FETCH_AHEAD
Flag für gepuffertes Lesen

NO_FETCH_AHEAD

public static final int NO_FETCH_AHEAD
Flag für ungepuffertes Lesen

SQL_ERR_CONSTRAINT

public static final int SQL_ERR_CONSTRAINT
SQLCODE "Constraint violation"

SQL_WARN_NO_ROWS_FOUND

public static final int SQL_WARN_NO_ROWS_FOUND
SQLCODE "No rows found"

STATEMENT_CONTROL

public static final int STATEMENT_CONTROL
Dynamic SQL statement type: run-time control statement

STATEMENT_DCL

public static final int STATEMENT_DCL
Dynamic SQL statement type: lock, unlock, free resources

STATEMENT_DDL

public static final int STATEMENT_DDL
Dynamic SQL statement type: DDL statement

STATEMENT_DELETE

public static final int STATEMENT_DELETE
Dynamic SQL statement type: delete statement

STATEMENT_GET

public static final int STATEMENT_GET
Dynamic SQL statement type: get statements

STATEMENT_INSERT

public static final int STATEMENT_INSERT
Dynamic SQL statement type: insert statement

STATEMENT_SELECT

public static final int STATEMENT_SELECT
Dynamic SQL statement type: select (cursor) statement

STATEMENT_UPDATE

public static final int STATEMENT_UPDATE
Dynamic SQL statement type: update statement
Method Detail

computeDateOffset

protected static int computeDateOffset(int scale)
Hilfsfunktion: Bestimme den RsqlDate-Offset
Parameters:
scale - Eine der DTINT_QUAL_...-Konstanten
Returns:
Die passende RsqlDate.F_...-Konstante

computeValue

public 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.

Parameters:
buffer - Byte-Array vom Server
base - Beginn der Daten im Puffer
type - SQL-Datentyp DT_...
length - Länge der Daten
scale - numerische Skalierung
precision - Präzision bei DATETIME und INTERVAL
encoding - Java-Encoding

dot

public static void dot()

getBytes

public static byte[] getBytes(Object o,
                              String encoding)
Hilfsfunktion: Ermittle die Bytes eines Strings
Parameters:
o - String (wird mit o.toString() ermittelt)
encoding - Encoding. Bei Fehlern wird Default-Encoding benutzt.
Returns:
passender Byte-Array

main

public static void main(String[] args)
                 throws Exception
Test

makeBigDecimal

public static BigDecimal makeBigDecimal(Object o,
                                        int scale)
Hilfsfunktion: Wandle ein Object in einen BigDecimal
Parameters:
o - Number oder String
scale - Skalierung
Returns:
Wert

makeDateString

public static String makeDateString(Object o,
                                    int length,
                                    int scale)
                             throws RsqlException
Hilfsfunktion: Wandle ein Datums-Object in einen SQL-Text
Parameters:
o - RsqlDate, Date oder String
length - Länge des Feldes
scale - DATETIME-Qualifier DTINT_QUAL_...
Returns:
Wert

makeDecimal

public static BigDecimal makeDecimal(long value,
                                     int scale)
Hilfsfunktion um einen BigDecimal zu erzeugen
Parameters:
value - Wert (unskaliert)
scale - Anzahl der Nachkommastellen
Returns:
BigDecimal mit dem richtigen Wert

makeDouble

public static double makeDouble(Object o)
Hilfsfunktion: Wandle ein Object in einen double.
Parameters:
o - Number oder String
scale - Skalierung
Returns:
Wert

makeInt

public static int makeInt(Object o,
                          int scale)
Hilfsfunktion: Wandle ein Object in einen int
Parameters:
o - Number oder String
scale - Skalierung
Returns:
Wert

makeLong

public static long makeLong(Object o,
                            int scale)
Hilfsfunktion: Wandle ein Object in einen long
Parameters:
o - Number oder String
scale - Skalierung
Returns:
Wert

makeShort

public static short makeShort(Object o,
                              int scale)
Hilfsfunktion: Wandle ein Object in einen short
Parameters:
o - Number oder String
scale - Skalierung
Returns:
Wert

makeUnscaledString

public static String makeUnscaledString(Object o,
                                        int scale)
Hilfsfunktion: Wandle ein Object in einen unskalierten String
Parameters:
o - Number oder String
scale - Skalierung
Returns:
Wert

storeBytes

public static void storeBytes(byte[] src,
                              int srcOff,
                              int srcLen,
                              byte[] buffer,
                              int offset,
                              int length,
                              byte filler,
                              boolean right)
Hilfsfunktion: Kopiere mit Filler
Parameters:
src - Quelle
srcOff - Offset in der Quelle
srcLen - Länge der Quelle
buffer - Ziel
offset - Offset im Ziel
length - Länge des Ziels
filler - Füllzeichen
right - Rechtsbündig

storeValue

public 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.

Parameters:
buffer - Byte-Array vom Server
base - Beginn der Daten im Puffer
type - SQL-Datentyp DT_...
length - Länge der Daten
scale - numerische Skalierung
precision - Präzision bei DATETIME und INTERVAL
encoding - Java-Encoding

testConv

public static boolean testConv(Object value,
                               int type,
                               int length,
                               int scale,
                               int precision)
                        throws RsqlException
Test der Konvertierung
Returns:
true bei Fehlern/Abweichungen

typeName

public static String typeName(int type,
                              int length,
                              int scale,
                              int precision)
Wandle einen Typ in einen Namen um
Parameters:
type - eine der DT-Konstanten
length - Länge
scale - Numerischer Scale
precision - Genauigkeit (DATETIME und INTERVAL)
Returns:
Bezeichnung des Datentyps


Copyright ¸ 2002 MvC Systemsoftware.