Examples of SQLFunction

org.apache.torque.util.functions.SQLFunction
Define the basic methods that classes that support SQL Functions need to implement for Classes that use them. This is intended to allow code to be written before functions are fully integrated with the DBAdaptors. As well as allowing for functions to expand as needed. @author Greg Monroe @version $Id: SQLFunction.java 1448414 2013-02-20 21:06:35Z tfischer $
org.eigenbase.sql.SqlFunction
A SqlFunction is a type of operator which has conventional function-call syntax.
org.hibernate.dialect.function.SQLFunction
Provides support routines for the HQL functions as used in the various SQL Dialects Provides an interface for supporting various HQL functions that are translated to SQL. The Dialect and its sub-classes use this interface to provide details required for processing of the function. @author David Channon
org.springframework.jdbc.object.SqlFunction
SQL "function" wrapper for a query that returns a single row of results. The default behavior is to return an int, but that can be overridden by using the constructor with an extra return type parameter.
Intended to use to call SQL functions that return a single result using a query like "select user()" or "select sysdate from dual". It is not intended for calling more complex stored functions or for using a CallableStatement to invoke a stored procedure or stored function. Use StoredProcedure or SqlCall for this type of processing.
This is a concrete class, which there is often no need to subclass. Code using this package can create an object of this type, declaring SQL and parameters, and then invoke the appropriate run method repeatedly to execute the function. Subclasses are only supposed to add specialized run methods for specific parameter and return types.
Like all RdbmsOperation objects, SqlFunction objects are thread-safe. @author Rod Johnson @author Juergen Hoeller @author Jean-Pierre Pawlak @see org.springframework.jdbc.object.StoredProcedure

Examples of org.springframework.jdbc.object.SqlFunction

      return null;
    }
  }


  public void addCategory(DocumentCategory category) {
    SqlFunction sqlFunction = new SqlFunction(getDataSource(),
                  "select category_id from category");
    sqlFunction.compile();
    int categoryId = sqlFunction.run()+1;
    category.setId(categoryId);


    getJdbcTemplate().update(
      "insert into category (category_id,category_name) values(?,?)",
      new Object[] {new Integer(category.getId()), category.getName()},

View Full Code Here

Examples of org.springframework.jdbc.object.SqlFunction

 * @author Thierry Templier
 */
public class DocumentIdDaoImpl extends JdbcDaoSupport implements DocumentIdDao {


  public long getNextDocumentId() {
    SqlFunction sqlFunction = new SqlFunction(getDataSource(),
                  "select next_document_id from document_id");
    sqlFunction.compile();
    return sqlFunction.run();
  }

View Full Code Here

Examples of org.springframework.jdbc.object.SqlFunction

    sqlFunction.compile();
    return sqlFunction.run();
  }


  public void incrementDocumentId() {
    SqlFunction sqlFunction = new SqlFunction(getDataSource(),
                  "select next_document_id from document_id");
    sqlFunction.compile();
    int nextDocumentId = sqlFunction.run();
    getJdbcTemplate().update("update document_id set next_document_id=?",
                  new Object[] { new Integer(nextDocumentId+1) });
  }

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.