1 5 package com.teamkonzept.db; 6 7 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 29 protected String specNvl(){ 30 return IF_NULL_THAN; 31 } 32 33 34 protected String specLeftOuterJoin(String leftColumn, String rightColumn){ 35 return leftColumn + " *= " + rightColumn; 36 } 37 38 protected String specRightOuterJoin(String leftColumn, String rightColumn){ 39 return leftColumn + " =* " + rightColumn; 40 } 41 42 protected String specLeftOuterJoinFrom(String [] columns, String leftTable, String rightTable){ 43 return leftTable + "," + rightTable; 44 } 45 46 protected String specRightOuterJoinFrom(String [] columns, String leftTable, String rightTable){ 47 return leftTable + "," + rightTable; 48 } 49 } 50 51 52 | Popular Tags |