01: /*
02: * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/db/SybaseStringFactory.java,v 1.7 2001/10/15 09:40:44 markus Exp $
03: *
04: */
05: package com.teamkonzept.db;
06:
07: /**
08: * Provides several sql-string-fragments for sybase.
09: *
10: * @author
11: * @version
12: * @see DBStringFactory
13: */
14: public class SybaseStringFactory extends DBStringFactory {
15:
16: private static final String SYBASE_IS_NULL = " = NULL ";
17: private static final String SYBASE_IS_NOT_NULL = " != NULL ";
18: private static final String IF_NULL_THAN = " ISNULL";
19:
20: public String specEqualsNull() {
21: return SYBASE_IS_NULL;
22: }
23:
24: public String specNotEqualsNull() {
25: return SYBASE_IS_NOT_NULL;
26: }
27:
28: /** if null then...*/
29: protected String specNvl() {
30: return IF_NULL_THAN;
31: }
32:
33: /** left outer loin on the given columns */
34: protected String specLeftOuterJoin(String leftColumn,
35: String rightColumn) {
36: return leftColumn + " *= " + rightColumn;
37: }
38:
39: /** right outer loin on the given columns */
40: protected String specRightOuterJoin(String leftColumn,
41: String rightColumn) {
42: return leftColumn + " =* " + rightColumn;
43: }
44:
45: protected String specLeftOuterJoinFrom(String[] columns,
46: String leftTable, String rightTable) {
47: return leftTable + "," + rightTable;
48: }
49:
50: protected String specRightOuterJoinFrom(String[] columns,
51: String leftTable, String rightTable) {
52: return leftTable + "," + rightTable;
53: }
54: }
|