com.arsdigita.persistence
Interface SQLUtilities


public interface SQLUtilities

This is the interface for random SQL utilities that are needed to allow the system to work with different databases. For instance the Oracle instance of this replaces "= null" with "is null"

Version:
$Revision: #9 $ $Date: 2004/04/07 $
Author:
randyg@alum.mit.edu

Field Summary
static String versionId
           
 
Method Summary
 String createNullString(String comparator, String variableName)
          This method takes a comparator (e.g.
 

Field Detail

versionId

public static final String versionId
See Also:
Constant Field Values
Method Detail

createNullString

public String createNullString(String comparator,
                               String variableName)
This method takes a comparator (e.g. =, <=, >=, !=, <>) as well as a variable name and then creates the appropriate string given that the value of the variable is null. In oracle, this will return something like "is not null" or "is null" Other databases will have something like comparator + " :" + variableName



Copyright (c) 2004 Red Hat, Inc. Corporation. All Rights Reserved. Generated at July 21 2004:2337 UTC