com.poscoict.glueframework.dao.jdbc
Class GlueQueryStringHelper

java.lang.Object
  extended by 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


Copyright © 2013–2014 POSCO ICT SWÁ¦Ç°±â¼úÆÀ. All rights reserved.