KickJava   Java API By Example, From Geeks To Geeks.

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


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

5 package com.teamkonzept.db;
6
7 /**
8  * Provides several sql-string-fragments for sybase.
9  *
10  * @author
11  * @version
12  * @see DBStringFactory
13  */

14 public class SybaseStringFactory extends DBStringFactory {
15
16     private static final String JavaDoc SYBASE_IS_NULL = " = NULL ";
17     private static final String JavaDoc SYBASE_IS_NOT_NULL = " != NULL ";
18     private static final String JavaDoc IF_NULL_THAN = " ISNULL";
19     
20     public String JavaDoc specEqualsNull(){
21         return SYBASE_IS_NULL;
22     }
23
24     public String JavaDoc specNotEqualsNull(){
25         return SYBASE_IS_NOT_NULL;
26     }
27
28     /** if null then...*/
29     protected String JavaDoc specNvl(){
30         return IF_NULL_THAN;
31     }
32     
33     /** left outer loin on the given columns */
34     protected String JavaDoc specLeftOuterJoin(String JavaDoc leftColumn, String JavaDoc rightColumn){
35         return leftColumn + " *= " + rightColumn;
36     }
37     /** right outer loin on the given columns */
38     protected String JavaDoc specRightOuterJoin(String JavaDoc leftColumn, String JavaDoc rightColumn){
39         return leftColumn + " =* " + rightColumn;
40     }
41
42     protected String JavaDoc specLeftOuterJoinFrom(String JavaDoc[] columns, String JavaDoc leftTable, String JavaDoc rightTable){
43         return leftTable + "," + rightTable;
44     }
45
46     protected String JavaDoc specRightOuterJoinFrom(String JavaDoc[] columns, String JavaDoc leftTable, String JavaDoc rightTable){
47         return leftTable + "," + rightTable;
48     }
49 }
50
51
52
Popular Tags