Examples of org.springframework.jdbc.object.SqlFunction

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

      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()},

 * @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();
  }

    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) });
  }

Examples of org.springframework.jdbc.object.SqlFunction

Related Classes of org.springframework.jdbc.object.SqlFunction