@Deprecated public abstract class GlueQueryStringHelper extends Object
Modifier and Type | Field and Description |
---|---|
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 and Description |
---|
GlueQueryStringHelper()
Deprecated.
|
Modifier and Type | Method and Description |
---|---|
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 ¼³Á¤.
|
public static final String WHERE
public static final String SELECT_HEADER
public static final String SELECT_TAIL
public static final String ORDER_BY_CLAUSE
@Deprecated public static final String OPEN_PARENTHESIS
@Deprecated public static final String CLOSE_PARENTHESIS
@Deprecated public static final String CLOSE_PARENTHESIS_NAVI_PAGE
@Deprecated public static final String SELECT
@Deprecated public static final String SELECT_II
@Deprecated public static final String COUNT_STMT_MYSQL
@Deprecated public static final String COUNT_STMT
@Deprecated public static final String SQLSERVER_TOP_KEYWORD
@Deprecated public static final String UPDATE_AUDIT_STMT
@Deprecated public static final String INSERT_AUDIT_ATTR_STMT
@Deprecated public static final String INSERT_AUDIT_VALUE_STMT
public static String getCountQuery(String query) throws GlueBadSqlGrammarException
¿øº» Äõ¸®: "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
query
- Äõ¸® ¹®ÀåGlueBadSqlGrammarException
public static String getAuditStatementForUpdate(String query)
query
- public static String getAuditStatementForInsert(String query)
query
- public static String getAuditStatement(String query, int dmltype)
query
- dmltype
- public static void setDatabaseProductName(String databaseProductName)
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
databaseProductName
- public static boolean isMSSQLDriver()
public static boolean isOracleDriver()
public static String createQueryStmtWhereOrderByClause(String query, String whereClause, String orderByClause)
orderByClause
- whereClause
- query
- public static int getDmlType(String queryStmt)
queryStmt
- public static String getBindingName(String str)
Code : String name = GlueQueryStringHelper.getBindingName("empno=:EmpnoP"); System.out.println(name); Result : EmpnoP
str
- Copyright © 2013–2020 POSCO ICT. All rights reserved.