Examples of ResultSetHandler


Examples of org.apache.commons.dbutils.ResultSetHandler

    assertNotNull(results);
    assertEquals("3", results);
  }

  public void testEmptyResultSetHandle() throws SQLException {
    ResultSetHandler h = new ScalarHandler();
    Object results = (Object) h.handle(this.emptyResultSet);

    assertNull(results);
  }
View Full Code Here

Examples of org.apache.commons.dbutils.ResultSetHandler

      final QueryRunner runner = new QueryRunner();
      final ArrayList<String> stores = new ArrayList<String>();

      Hermes.ui.getDefaultMessageSink().add("Getting message stores....");

      runner.query(connection, statements.getStoresStatement(), new ResultSetHandler()
      {
         public Object handle(ResultSet rs) throws SQLException
         {
            while (rs.next())
            {
View Full Code Here

Examples of org.apache.commons.dbutils.ResultSetHandler

      final QueryRunner runner = new QueryRunner();

      Hermes.ui.getDefaultMessageSink().add("Getting message store destinations....");

      runner.query(connection, "select distinct destination, domain from stores where storeId=? ", new Object[] { storeId },
            new ResultSetHandler()
            {
               public Object handle(ResultSet rs) throws SQLException
               {
                  while (rs.next())
                  {
View Full Code Here

Examples of org.apache.commons.dbutils.ResultSetHandler

   public int getDepth(Connection connection, String storeId, Destination destination) throws SQLException, JMSException
   {
      final QueryRunner runner = new QueryRunner();

      return (Integer) runner.query(connection, statements.getDepthStatement(), new Object[] { storeId, JMSUtils.getDestinationName(destination) },
            new ResultSetHandler()
            {
               public Object handle(ResultSet rs) throws SQLException
               {
                  rs.next();
View Full Code Here

Examples of org.apache.commons.dbutils.ResultSetHandler

                qr.update(con, "insert into ArticleTag(tag, articleId) values(?, ?)", tag, article.id);
            }
            StringBuilder sb = new StringBuilder();
            sb.append(qr.query("select count(*) from Article where authorId=?", new ScalarHandler<Number>(), getLoginUser().id));
            final Map<String, Integer> tagMap = new HashMap<String, Integer>();
            qr.query(con, "select at.tag, count(at.tag) from Article a join ArticleTag at on a.id=at.articleId where a.authorId=? group by at.tag", new ResultSetHandler() {
                @Override
                public Object handle(ResultSet rs) throws SQLException {
                    while (rs.next()) {
                        tagMap.put(rs.getString(1), rs.getInt(2));
                    }
View Full Code Here

Examples of org.apache.commons.dbutils.ResultSetHandler

    *           Class to bind object to.
    * @return List
    */
   public List getList(final String sql, final Class clazz) {
      try{
         final ResultSetHandler bean = new BeanListHandler(clazz);
         return (List) runner.query(conn, sql, null, bean);
      }catch (final SQLException e){
         if(GlobalSettings.logActive)
            new LogEngine().logMessage(e.getStackTrace().toString(), GlobalSettings.logPath, "ERROR");
         throw new RuntimeException(e);
View Full Code Here

Examples of org.apache.ibatis.executor.resultset.ResultSetHandler

  public ResultSetHandler newResultSetHandler(Executor executor,
      MappedStatement mappedStatement, RowBounds rowBounds,
      ParameterHandler parameterHandler, ResultHandler resultHandler,
      BoundSql boundSql) {
    ResultSetHandler resultSetHandler = mappedStatement.hasNestedResultMaps() ? new NestedResultSetHandler(
        executor, mappedStatement, parameterHandler, resultHandler, boundSql,
        rowBounds) : new FastResultSetHandler(executor, mappedStatement,
        parameterHandler, resultHandler, boundSql, rowBounds);
    resultSetHandler = (ResultSetHandler) interceptorChain
        .pluginAll(resultSetHandler);
View Full Code Here

Examples of org.apache.ibatis.executor.resultset.ResultSetHandler

    parameterHandler = (ParameterHandler) interceptorChain.pluginAll(parameterHandler);
    return parameterHandler;
  }

  public ResultSetHandler newResultSetHandler(Executor executor, MappedStatement mappedStatement, RowBounds rowBounds, ParameterHandler parameterHandler, ResultHandler resultHandler, BoundSql boundSql) {
    ResultSetHandler resultSetHandler = mappedStatement.hasNestedResultMaps() ?
        new NestedResultSetHandler(executor, mappedStatement, parameterHandler, resultHandler, boundSql, rowBounds)
        : new FastResultSetHandler(executor, mappedStatement, parameterHandler, resultHandler, boundSql, rowBounds);
    resultSetHandler = (ResultSetHandler) interceptorChain.pluginAll(resultSetHandler);
    return resultSetHandler;
  }
View Full Code Here

Examples of org.apache.ibatis.executor.resultset.ResultSetHandler

    parameterHandler = (ParameterHandler) interceptorChain.pluginAll(parameterHandler);
    return parameterHandler;
  }

  public ResultSetHandler newResultSetHandler(Executor executor, MappedStatement mappedStatement, RowBounds rowBounds, ParameterHandler parameterHandler, ResultHandler resultHandler, BoundSql boundSql) {
    ResultSetHandler resultSetHandler = mappedStatement.hasNestedResultMaps() ?
        new NestedResultSetHandler(executor, mappedStatement, parameterHandler, resultHandler, boundSql, rowBounds)
        : new FastResultSetHandler(executor, mappedStatement, parameterHandler, resultHandler, boundSql, rowBounds);
    resultSetHandler = (ResultSetHandler) interceptorChain.pluginAll(resultSetHandler);
    return resultSetHandler;
  }
View Full Code Here

Examples of org.apache.ibatis.executor.resultset.ResultSetHandler

    parameterHandler = (ParameterHandler) interceptorChain.pluginAll(parameterHandler);
    return parameterHandler;
  }

  public ResultSetHandler newResultSetHandler(Executor executor, MappedStatement mappedStatement, RowBounds rowBounds, ParameterHandler parameterHandler, ResultHandler resultHandler, BoundSql boundSql) {
    ResultSetHandler resultSetHandler = mappedStatement.hasNestedResultMaps() ?
        new NestedResultSetHandler(executor, mappedStatement, parameterHandler, resultHandler, boundSql, rowBounds)
        : new FastResultSetHandler(executor, mappedStatement, parameterHandler, resultHandler, boundSql, rowBounds);
    resultSetHandler = (ResultSetHandler) interceptorChain.pluginAll(resultSetHandler);
    return resultSetHandler;
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.