KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > db > OracleStringFactory


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/db/OracleStringFactory.java,v 1.7 2001/10/15 09:39:21 markus Exp $
3  *
4  */

5 package com.teamkonzept.db;
6
7 /**
8  * provides databasespecific strings
9  *
10  * @author
11  * @version
12  * @see DBStringFactory
13  */

14 public class OracleStringFactory extends DBStringFactory {
15
16     private static final String JavaDoc NULL_INTEGER = " TO_NUMBER( NULL ) ";
17     private static final String JavaDoc IF_NULL_THAN = " nvl";
18     private static final String JavaDoc ORACLE_TEMP = " GLOBAL TEMPORARY ";
19     private static final String JavaDoc ORACLE_TRANS = " ON COMMIT DELETE ROWS ";
20     private static final String JavaDoc CHECK_EXISTENCE = " SELECT TABLE_NAME FROM USER_CATALOG WHERE TABLE_NAME ";
21     private static final String JavaDoc ORACLE_FROM = " FROM DUAL ";
22
23     public String JavaDoc specDeclareAsTemp(){
24         return ORACLE_TEMP;
25     }
26
27     public String JavaDoc specDeclareForTransaction(){
28         return ORACLE_TRANS;
29     }
30
31     public String JavaDoc specNullValue(){
32         return NULL_INTEGER;
33     }
34     
35     /** if null then...*/
36     protected String JavaDoc specNvl(){
37         return IF_NULL_THAN;
38     }
39
40     protected String JavaDoc specCheckExistence(){
41         return CHECK_EXISTENCE;
42     }
43
44     protected String JavaDoc specGetFromSystem(){
45         return ORACLE_FROM;
46     }
47
48     /** left outer loin on the given columns */
49     protected String JavaDoc specLeftOuterJoin(String JavaDoc leftColumn, String JavaDoc rightColumn){
50         return leftColumn + " = " + rightColumn + " (+) ";
51     }
52     /** right outer loin on the given columns */
53     protected String JavaDoc specRightOuterJoin(String JavaDoc leftColumn, String JavaDoc rightColumn){
54         return leftColumn + " (+) = " + rightColumn;
55     }
56
57     protected String JavaDoc specLeftOuterJoinFrom(String JavaDoc[] columns, String JavaDoc leftTable, String JavaDoc rightTable){
58         return leftTable + "," + rightTable;
59     }
60
61     protected String JavaDoc specRightOuterJoinFrom(String JavaDoc[] columns, String JavaDoc leftTable, String JavaDoc rightTable){
62         return leftTable + "," + rightTable;
63     }
64 }
65
66
67
Popular Tags