org.sakaiproject.genericdao.api.mappers.StatementMapper Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of generic-dao Show documentation

Generic Dao is a Java package which allows a developer to skip writing DAOs for their persistence objects when they are using Spring and/or Hibernate. The package was originally created by Aaron Zeckoski for the Evaluation System project but was repackaged to make it distributable by request. It is used in the RSF framework (http://www2.caret.cam.ac.uk/rsfwiki/). Note about the BeanUtils provided dependency: BeanUtils is not required if you are not using it in your project. Note about the Hibernate provided dependency: Hibernate is not required if you are not using it in your project.

There is a newer version: 0.12.0

Show newest version

/**
 * $Id$
 * $URL$
 * StatementMapper.java - genericdao - Apr 26, 2008 10:09:15 AM - azeckoski
 **************************************************************************
 * Copyright (c) 2008 Aaron Zeckoski
 * Licensed under the Apache License, Version 2
 * 
 * A copy of the Apache License, Version 2 has been included in this 
 * distribution and is available at: http://www.apache.org/licenses/LICENSE-2.0.txt
 *
 * Aaron Zeckoski ([email protected]) ([email protected]) ([email protected])
 */

package org.sakaiproject.genericdao.api.mappers;

/**
 * Allows defining of SQL to use when executing standard queries,
 * ? will be replaced by the values to be updated or inserted in standard SQL fashion
 * 
 * @author Aaron Zeckoski ([email protected])
 */
public interface StatementMapper extends DataMapper {

   /**
    * Will be replaced by the table name
    */
   public static String TABLE_NAME = "{tableName}";
   /**
    * Will be replaced by a list of column names,
    * example: ID, TITLE
    */
   public static String COLUMNS = "{columns}";
   /**
    * Will be replaced by a list of "?" corresponding to the list of columns,
    * example: ?,?
    */
   public static String VALUES = "{values}";
   /**
    * Will be replaced by the where portion of the statement,
    * examples: where id = ?
    */
   public static String WHERE = "{where}";
   public static String UPDATE = "{update}";
   /**
    * Will be replaced by the select,
    * examples: *, count(*), distinct(id)
    */
   public static String SELECT = "{select}";

   public String BASIC_INSERT = "INSERT INTO "+TABLE_NAME+" ("+COLUMNS+") VALUES ("+VALUES+") ";
   public String BASIC_SELECT = "SELECT "+SELECT+" FROM "+TABLE_NAME+" "+WHERE;
   public String BASIC_UPDATE = "UPDATE "+TABLE_NAME+" SET "+UPDATE+" "+WHERE;
   public String BASIC_DELETE = "DELETE FROM "+TABLE_NAME+" "+WHERE;

   /**
    * @return the template to use when generating insert statements,
    * use the {@link #TABLE_NAME}, {@link #COLUMNS} and {@link #VALUES} constants to indicate replacements
    * OR return null to use the default templates
    */
   public String getInsertTemplate();

   /**
    * @return the template to use when generating selects,
    * use the {@link #SELECT}, {@link #TABLE_NAME}, and {@link #WHERE} constants to indicate replacements
    * OR return null to use the default templates
    */
   public String getSelectTemplate();

   /**
    * @return the template to use when generating updates,
    * use the {@link #TABLE_NAME}, {@link #UPDATE} and {@link #WHERE} constants to indicate replacements
    * OR return null to use the default templates
    */
   public String getUpdateTemplate();

   /**
    * @return the template to use when generating deletes,
    * use the {@link #TABLE_NAME} and {@link #WHERE} constants to indicate replacements
    * OR return null to use the default templates
    */
   public String getDeleteTemplate();

}