1 5 package com.teamkonzept.db; 6 7 import org.apache.log4j.Category; 8 9 15 public class DBStringFactory{ 16 17 18 private static final String NO_DEFAULT = " NO_DEFAULT "; 19 private static final String DEFAULT_IS_NULL = " IS NULL "; 20 private static final String DEFAULT_IS_NOT_NULL = " IS NOT NULL "; 21 private static final String DEFAULT_NULL_VALUE = " NULL "; 22 private static final String DEFAULT_TEMP = " "; 23 private static final String DEFAULT_TRANS = " "; 24 private static final String DEFAULT_JOIN = " "; 25 private static final String DEFAULT_FROM = " "; 26 private static final String DEFAULT_ESCAPE = " ESCAPE '\\' "; 27 28 private static final String DEFAULT_UPPER_ORDER = ""; 29 30 public static String equalsNull(){ 31 return getDBStringFactory().specEqualsNull(); 32 } 33 public static String declareAsTemp(){ 34 return getDBStringFactory().specDeclareAsTemp(); 35 } 36 public static String declareForTransaction(){ 37 return getDBStringFactory().specDeclareForTransaction(); 38 } 39 public static String notEqualsNull(){ 40 return getDBStringFactory().specNotEqualsNull(); 41 } 42 public static String nullValue(){ 43 return getDBStringFactory().specNullValue(); 44 } 45 public static String nvl(){ 46 return getDBStringFactory().specNvl(); 47 } 48 public static String checkExistence(){ 49 return getDBStringFactory().specCheckExistence(); 50 } 51 public static String getFromSystem(){ 52 return getDBStringFactory().specGetFromSystem(); 53 } 54 public static String leftOuterJoin(String leftColumn, String rightColumn){ 55 return getDBStringFactory().specLeftOuterJoin(leftColumn, rightColumn); 56 } 57 public static String rightOuterJoin(String leftColumn, String rightColumn){ 58 return getDBStringFactory().specRightOuterJoin(leftColumn, rightColumn); 59 } 60 61 public static String leftOuterJoinFrom(String [] columns, String leftTable, String rightTable){ 62 return getDBStringFactory().specLeftOuterJoinFrom(columns, leftTable, rightTable); 63 } 64 public static String rightOuterJoinFrom(String [] columns, String leftTable, String rightTable){ 65 return getDBStringFactory().specRightOuterJoinFrom(columns, leftTable, rightTable); 66 } 67 68 69 public static String escape(){ 70 return getDBStringFactory().specEscape(); 71 } 72 73 75 public static String upper_order(){ 76 return getDBStringFactory().specupperorder(); 77 } 78 79 public static DBStringFactory getDBStringFactory(){ 80 return getDBStringFactory(TKDBManager.getManager().getConnectionData()); 81 } 82 83 public static DBStringFactory getDBStringFactory(TKConnectData connectData){ 84 85 if(connectData instanceof TKOracleConnectData){ 86 return new OracleStringFactory(); 87 } 88 if(connectData instanceof TKSybaseConnectData){ 89 return new SybaseStringFactory(); 90 } 91 if(connectData instanceof TKPostgreSQLConnectData){ 92 return new PostgreSQLStringFactory(); 93 } 94 else{ 95 return new DBStringFactory(); 96 } 97 } 98 99 100 public static DBStringFactory getDBStringFactory(TKOracleConnectData connectData){ 101 return new OracleStringFactory(); 102 } 103 104 public static DBStringFactory getDBStringFactory(TKSybaseConnectData connectData){ 105 return new SybaseStringFactory(); 106 } 107 108 public static DBStringFactory getDBStringFactory(TKPostgreSQLConnectData connectData){ 109 return new PostgreSQLStringFactory(); 110 } 111 112 113 114 protected String specNullValue(){ 115 return DEFAULT_NULL_VALUE; 116 }; 117 118 119 protected String specDeclareAsTemp(){ 120 return DEFAULT_TEMP; 121 } 122 123 124 protected String specDeclareForTransaction(){ 125 return DEFAULT_TRANS; 126 } 127 128 protected String specEqualsNull(){ 129 return DEFAULT_IS_NULL; 130 } 131 132 133 protected String specEscape(){ 134 return DEFAULT_ESCAPE; 135 } 136 137 138 protected String specupperorder(){ 139 return DEFAULT_UPPER_ORDER; 140 } 141 142 143 protected String specNotEqualsNull(){ 144 return DEFAULT_IS_NOT_NULL; 145 } 146 147 148 protected String specNvl(){ 149 return NO_DEFAULT; 150 } 151 152 protected String specCheckExistence(){ 153 return NO_DEFAULT; 154 } 155 156 protected String specGetFromSystem(){ 157 return DEFAULT_FROM; 158 } 159 160 161 protected String specLeftOuterJoin(String leftColumn, String rightColumn){ 162 return DEFAULT_JOIN; 163 } 164 165 protected String specRightOuterJoin(String leftColumn, String rightColumn){ 166 return DEFAULT_JOIN; 167 } 168 169 170 protected String specLeftOuterJoinFrom(String [] columns, String leftTable, String rightTable){ 171 return DEFAULT_JOIN; 172 } 173 174 protected String specRightOuterJoinFrom(String [] columns, String leftTable, String rightTable){ 175 return DEFAULT_JOIN; 176 } 177 } 178 179 180 | Popular Tags |