org.marccarre.spring.db.testing.FooStoredProcedure.java Source code

Java tutorial

Introduction

Here is the source code for org.marccarre.spring.db.testing.FooStoredProcedure.java

Source

package org.marccarre.spring.db.testing;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.SqlParameter;
import org.springframework.jdbc.core.SqlReturnResultSet;
import org.springframework.jdbc.object.StoredProcedure;

import javax.sql.DataSource;
import java.sql.Types;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * Copyright (C) 2012, Marc CARRE
 * Date: 27/04/12
 * Time: 07:27
 *
 * Permission is hereby granted, free of charge, to any person obtaining
 * a copy of this software and associated documentation files (the
 * "Software"), to deal in the Software without restriction, including
 * without limitation the rights to use, copy, modify, merge, publish,
 * distribute, sublicense, and/or sell copies of the Software, and to
 * permit persons to whom the Software is furnished to do so, subject to
 * the following conditions:
 *
 * The above copyright notice and this permission notice shall be
 * included in all copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
 * EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
 * MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
 * NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
 * LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
 * OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
 * WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
 */

public class FooStoredProcedure extends StoredProcedure {
    public static final String FOO_ID = "fooId";
    public static final String RESULTS = "results";
    private JdbcTemplate jdbcTemplate;

    public FooStoredProcedure(DataSource dataSource) {
        super(dataSource, "GetFoosById");
        declareParameter(new SqlParameter(FOO_ID, Types.INTEGER));
        declareParameter(new SqlReturnResultSet(RESULTS, new FooRowMapper()));
        compile();
    }

    protected Map<String, Object> executeRaw(int fooId) {
        Map<String, Object> inputs = new HashMap<String, Object>();
        inputs.put(FOO_ID, fooId);
        return super.execute(inputs);
    }

    public List<Foo> execute(int fooId) {
        Map<String, Object> results = executeRaw(fooId);
        return (List<Foo>) results.get(RESULTS);
    }
}