Altibase.jdbc.driver.util

Class AltiSqlProcessor

java.lang.Object

Altibase.jdbc.driver.util.AltiSqlProcessor

public class AltiSqlProcessor
extends java.lang.Object

Field Summary

Fields

Modifier and Type	Field and Description
static int	KEY_SET_ROWID_COLUMN_INDEX

Constructor Summary

Constructors

Constructor and Description
AltiSqlProcessor()

Method Summary

Modifier and Type	Method and Description
static java.util.ArrayList	getAllSequences(java.lang.String aSql) Äõ¸®¹®À» ÆĽÌÇØ SEQUENCE À̸§°ú SEQUENCE°¡ »ç¿ëµÈ Ä÷³ÀÇ À̸§À» ¾ò´Â´Ù.
static boolean	isInsertQuery(java.lang.String aSql) INSERT·Î ½ÃÀÛÇÏ´Â Äõ¸®ÀÎÁö È®ÀÎÇÑ´Ù.
static boolean	isSelectQuery(java.lang.String aSql) SELECT·Î ½ÃÀÛÇÏ´Â Äõ¸®ÀÎÁö È®ÀÎÇÑ´Ù.
static java.lang.String	makeDeleteRowSql(java.lang.String aTableName)
static java.lang.String	makeGenerateKeysSql(java.util.ArrayList aSeqs) Generated Keys¸¦ ¾ò±âÀ§ÇÑ Äõ¸®¹®À» ¸¸µç´Ù.
static java.lang.String	makeGenerateKeysSql(java.util.ArrayList aSeqs, int[] aColIndexes) Generated Keys¸¦ ¾ò±âÀ§ÇÑ Äõ¸®¹®À» ¸¸µç´Ù.
static java.lang.String	makeGenerateKeysSql(java.util.ArrayList aSeqs, java.lang.String[] aColNames) Generated Keys¸¦ ¾ò±âÀ§ÇÑ Äõ¸®¹®À» ¸¸µç´Ù.
static java.lang.String	makeKeySetSql(java.lang.String aSql, java.util.Map aOrderByMap)
static java.lang.String	makePRowIDAddedSql(java.lang.String aSql) _PROWID Ä÷³ÀÌ Ãß°¡µÈ Äõ¸®¹®À» ¾ò´Â´Ù.
static java.lang.String	makeRowSetSql(java.lang.String aSql, int aRowIdCount)
static java.lang.String	processEscape(java.lang.String aOrgSql)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

KEY_SET_ROWID_COLUMN_INDEX

public static final int KEY_SET_ROWID_COLUMN_INDEX

See Also:

Constant Field Values

Constructor Detail

AltiSqlProcessor

public AltiSqlProcessor()

Method Detail

getAllSequences

public static java.util.ArrayList getAllSequences(java.lang.String aSql)

Äõ¸®¹®À» ÆĽÌÇØ SEQUENCE À̸§°ú SEQUENCE°¡ »ç¿ëµÈ Ä÷³ÀÇ À̸§À» ¾ò´Â´Ù.

Parameters:

aSql - SEQUENCE Á¤º¸¸¦ ÆĽÌÇÒ INSERT Äõ¸®¹®

Returns:

SEQUENCE Á¤º¸¸¦ ´ãÀº ¸®½ºÆ®

processEscape

public static java.lang.String processEscape(java.lang.String aOrgSql)

makeGenerateKeysSql

public static java.lang.String makeGenerateKeysSql(java.util.ArrayList aSeqs)

Generated Keys¸¦ ¾ò±âÀ§ÇÑ Äõ¸®¹®À» ¸¸µç´Ù.

Parameters:

aSeqs - SEQUENCE Á¤º¸¸¦ ´ãÀº ¸®½ºÆ®

Returns:

Generated Keys¸¦ ¾ò±âÀ§ÇÑ Äõ¸®¹®

makeGenerateKeysSql

public static java.lang.String makeGenerateKeysSql(java.util.ArrayList aSeqs,
                                                   int[] aColIndexes)
                                            throws java.sql.SQLException

Generated Keys¸¦ ¾ò±âÀ§ÇÑ Äõ¸®¹®À» ¸¸µç´Ù.

Parameters:

aSeqs - SEQUENCE Á¤º¸¸¦ ´ãÀº ¸®½ºÆ®

aColIndexes - °ªÀ» ¾òÀ» SEQUENCEÀÇ ¼ø¹ø(1 base)À» ´ãÀº ¹è¿­

Returns:

Generated Keys¸¦ ¾ò±âÀ§ÇÑ Äõ¸®¹®

Throws:

java.sql.SQLException

makeGenerateKeysSql

public static java.lang.String makeGenerateKeysSql(java.util.ArrayList aSeqs,
                                                   java.lang.String[] aColNames)
                                            throws java.sql.SQLException

Generated Keys¸¦ ¾ò±âÀ§ÇÑ Äõ¸®¹®À» ¸¸µç´Ù.

Parameters:

aSeqs - SEQUENCE Á¤º¸¸¦ ´ãÀº ¸®½ºÆ®

aColNames - °ªÀ» ¾òÀ» SEQUENCE°¡ »ç¿ëµÈ Ä÷³ À̸§À» ´ãÀº ¹è¿­

Returns:

Generated Keys¸¦ ¾ò±âÀ§ÇÑ Äõ¸®¹®

Throws:

java.sql.SQLException

makeKeySetSql

public static java.lang.String makeKeySetSql(java.lang.String aSql,
                                             java.util.Map aOrderByMap)
                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

makeRowSetSql

public static java.lang.String makeRowSetSql(java.lang.String aSql,
                                             int aRowIdCount)
                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

makePRowIDAddedSql

public static java.lang.String makePRowIDAddedSql(java.lang.String aSql)
                                           throws java.sql.SQLException

_PROWID Ä÷³ÀÌ Ãß°¡µÈ Äõ¸®¹®À» ¾ò´Â´Ù.

Parameters:

aSql - ¿øº» Äõ¸®¹®

Returns:

´Ü¼ø SELECT¹®ÀÌ ¾Æ´Ï¸é null, ÀÌ¹Ì _PROWID Ä÷³ÀÌ Ãß°¡µÇ¾îÀÖÀ¸¸é ¿øº» Äõ¸®¹®, _PROWID Ä÷³ÀÌ Ãß°¡µÇÁö¾ÊÀº ´Ü¼ø SELECT ¹®À̸é _PROWID Ä÷³ÀÌ Ãß°¡µÈ Äõ¸®¹®

Throws:

java.sql.SQLException

isSelectQuery

public static boolean isSelectQuery(java.lang.String aSql)

SELECT·Î ½ÃÀÛÇÏ´Â Äõ¸®ÀÎÁö È®ÀÎÇÑ´Ù.

Parameters:

aSql - È®ÀÎÇÒ Äõ¸®¹®

Returns:

SELECT·Î ½ÃÀÛÇÏ´ÂÁö ¿©ºÎ

isInsertQuery

public static boolean isInsertQuery(java.lang.String aSql)

INSERT·Î ½ÃÀÛÇÏ´Â Äõ¸®ÀÎÁö È®ÀÎÇÑ´Ù.

Parameters:

aSql - È®ÀÎÇÒ Äõ¸®¹®

Returns:

INSERT·Î ½ÃÀÛÇÏ´ÂÁö ¿©ºÎ

makeDeleteRowSql

public static java.lang.String makeDeleteRowSql(java.lang.String aTableName)