com.poscoict.glueframework.dao.jdbc
Class GlueQueryStringHelper

java.lang.Object
  com.poscoict.glueframework.dao.jdbc.GlueQueryStringHelper

Deprecated.

@Deprecated
public abstract class GlueQueryStringHelper
extends Object

Internal Use Only. Query 문장을 다양한 포맷으로 변경해주는 유틸리티 클래스.

Field Summary

static String	CLOSE_PARENTHESIS Deprecated.
static String	CLOSE_PARENTHESIS_NAVI_PAGE Deprecated.
static String	COUNT_STMT Deprecated.
static String	COUNT_STMT_MYSQL Deprecated.
static String	INSERT_AUDIT_ATTR_STMT Deprecated.
static String	INSERT_AUDIT_VALUE_STMT Deprecated.
static String	OPEN_PARENTHESIS Deprecated.
static String	ORDER_BY_CLAUSE Deprecated.
static String	SELECT Deprecated.
static String	SELECT_HEADER Deprecated.
static String	SELECT_II Deprecated.
static String	SELECT_TAIL Deprecated.
static String	SQLSERVER_TOP_KEYWORD Deprecated.
static String	UPDATE_AUDIT_STMT Deprecated.
static String	WHERE Deprecated.

Constructor Summary

GlueQueryStringHelper()
Deprecated.

Method Summary

static String	createQueryStmtWhereOrderByClause(String query, String whereClause, String orderByClause) Deprecated. 자바독을 자세하게 작성한다.
static String	getAuditStatement(String query, int dmltype) Deprecated.
static String	getAuditStatementForInsert(String query) Deprecated.
static String	getAuditStatementForUpdate(String query) Deprecated.
static String	getBindingName(String str) Deprecated. Internal Use only.
static String	getCountQuery(String query) Deprecated. Argument로 주어지는 쿼리문장을 기반으로 레코드 총 개수를 얻을 수 있는 쿼리를 생성한다.
static int	getDmlType(String queryStmt) Deprecated.
static boolean	isMSSQLDriver() Deprecated.
static boolean	isOracleDriver() Deprecated.
static String	makeOrderByClause(String str1, String str2) Deprecated. Internal Use only. Code : String orderby = GlueQueryStringHelper.makeOrderByClause("deptno asc","empno"); System.out.println(orderby); Result : deptno asc, empno
static void	setDatabaseProductName(String databaseProductName) Deprecated. DBMS에 따른 JDBC Driver 설정.

Methods inherited from class java.lang.Object

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

Field Detail

WHERE

public static final String WHERE

Deprecated.

See Also:

Constant Field Values

SELECT_HEADER

public static final String SELECT_HEADER

Deprecated.

See Also:

Constant Field Values

SELECT_TAIL

public static final String SELECT_TAIL

Deprecated.

See Also:

Constant Field Values

ORDER_BY_CLAUSE

public static final String ORDER_BY_CLAUSE

Deprecated.

See Also:

Constant Field Values

OPEN_PARENTHESIS

@Deprecated
public static final String OPEN_PARENTHESIS

Deprecated.

See Also:

Constant Field Values

CLOSE_PARENTHESIS

@Deprecated
public static final String CLOSE_PARENTHESIS

Deprecated.

See Also:

Constant Field Values

CLOSE_PARENTHESIS_NAVI_PAGE

@Deprecated
public static final String CLOSE_PARENTHESIS_NAVI_PAGE

Deprecated.

See Also:

Constant Field Values

SELECT

@Deprecated
public static final String SELECT

Deprecated.

See Also:

Constant Field Values

SELECT_II

@Deprecated
public static final String SELECT_II

Deprecated.

See Also:

Constant Field Values

COUNT_STMT_MYSQL

@Deprecated
public static final String COUNT_STMT_MYSQL

Deprecated.

See Also:

Constant Field Values

COUNT_STMT

@Deprecated
public static final String COUNT_STMT

Deprecated.

See Also:

Constant Field Values

SQLSERVER_TOP_KEYWORD

@Deprecated
public static final String SQLSERVER_TOP_KEYWORD

Deprecated.

See Also:

Constant Field Values

UPDATE_AUDIT_STMT

@Deprecated
public static final String UPDATE_AUDIT_STMT

Deprecated.

See Also:

Constant Field Values

INSERT_AUDIT_ATTR_STMT

@Deprecated
public static final String INSERT_AUDIT_ATTR_STMT

Deprecated.

See Also:

Constant Field Values

INSERT_AUDIT_VALUE_STMT

@Deprecated
public static final String INSERT_AUDIT_VALUE_STMT

Deprecated.

See Also:

Constant Field Values

Constructor Detail

GlueQueryStringHelper

public GlueQueryStringHelper()

Deprecated.

Method Detail

getCountQuery

public static String getCountQuery(String query)
                            throws GlueBadSqlGrammarException

Deprecated.

Argument로 주어지는 쿼리문장을 기반으로 레코드 총 개수를 얻을 수 있는 쿼리를 생성한다. 데이터베이스가 MS SQL Server인 경우에는 인라인 쿼리에 ORDER BY 절이 있으면 TOP 키워드를 사용해야 하기 때문에 다음과 같이 TOP 키워드를 항상 추가해서 카운트 쿼리를 생성한다.

 원본 쿼리: 
  "SELECT EMPNO, SAL FROM TABLE WHERE SAL > ? ORDER BY SAL"
  
 반환되는 쿼리: 
   
 1. SQL Server) 
  "SELECT COUNT(1) FROM (SELECT TOP 100 PERCENT EMPNO, SAL FROM TABLE WHERE SAL > ? ORDER BY SAL) FIND_FOR_NAVIGATION_PAGE"
 
 2. Oracle) 
  "SELECT COUNT(1) FROM (SELECT EMPNO, SAL FROM TABLE WHERE SAL > ? ORDER BY SAL) FIND_FOR_NAVIGATION_PAGE
 
 3. MySQL
  "SELECT COUNT(0) FROM (SELECT EMPNO, SAL FROM TABLE WHERE SAL > ? ORDER BY SAL) FIND_FOR_NAVIGATION_PAGE
 

Parameters:

query - 쿼리 문장

Returns:

레코드 총 개수를 얻을 수 있는 쿼리

Throws:

GlueBadSqlGrammarException

getAuditStatementForUpdate

public static String getAuditStatementForUpdate(String query)

Deprecated.

Parameters:

query -

Returns:

String

getAuditStatementForInsert

public static String getAuditStatementForInsert(String query)

Deprecated.

Parameters:

query -

Returns:

String

getAuditStatement

public static String getAuditStatement(String query,
                                       int dmltype)

Deprecated.

Parameters:

query -

dmltype -

Returns:

String

setDatabaseProductName

public static void setDatabaseProductName(String databaseProductName)

Deprecated.

DBMS에 따른 JDBC Driver 설정.

 1. Oracle
 DBMS Name: Oracle
 2. DB2
 DBMS Name: DB2/NT
 3. MSSQL
 DBMS Name: Microsoft SQL Server
 4. MySQL
 DBMS Name: MySQL
 5. Postgre
 DBMS Name: PostgreSQL
 6. SQLLite
 DBMS Name: SQLite
 

Parameters:

databaseProductName -

isMSSQLDriver

public static boolean isMSSQLDriver()

Deprecated.

Returns:

boolean

isOracleDriver

public static boolean isOracleDriver()

Deprecated.

Returns:

boolean

createQueryStmtWhereOrderByClause

public static String createQueryStmtWhereOrderByClause(String query,
                                                       String whereClause,
                                                       String orderByClause)

Deprecated.

자바독을 자세하게 작성한다.

Parameters:

orderByClause -

whereClause -

query -

Returns:

String

getDmlType

public static int getDmlType(String queryStmt)

Deprecated.

Parameters:

queryStmt -

Returns:

int - 2 : update, 3 : insert, 4 : delete

getBindingName

public static String getBindingName(String str)

Deprecated.

Internal Use only.

 Code : 
 String name = GlueQueryStringHelper.getBindingName("empno=:EmpnoP");
 System.out.println(name);
 
 Result : 
 EmpnoP
 

Parameters:

str -

Returns:

String

makeOrderByClause

public static String makeOrderByClause(String str1,
                                       String str2)

Deprecated. Internal Use only.

 Code : 
 String orderby = GlueQueryStringHelper.makeOrderByClause("deptno asc","empno");
 System.out.println(orderby);
 
 Result : 
 deptno asc, empno
 

Parameters:

str1 -

str2 -

Returns:

String