org.cloudfoundry.samples.handson.ex6.CopyController.java Source code

Introduction

Here is the source code for org.cloudfoundry.samples.handson.ex6.CopyController.java

Source

/*
 * Copyright 2012 the original author or authors.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.cloudfoundry.samples.handson.ex6;

import org.cloudfoundry.samples.handson.ex5.Person;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.namedparam.BeanPropertySqlParameterSource;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.servlet.ModelAndView;

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

/**
 * This exercise shows what happens if you have two services of the same "kind"
 * (here two RDBMS {@link DataSource DataSources}) in your app. Uncomment the
 * injection part and add a second DataSource to your context and see it fail
 * on CloudFoundry.
 * 
 * @author Eric Bottard
 * @author Florent Biville
 * 
 */
@Controller
public class CopyController {

    private NamedParameterJdbcTemplate fromTemplate;

    private NamedParameterJdbcTemplate toTemplate;

    // @Inject
    @Qualifier("fromDataSource")
    public void setFromDataSource(DataSource dataSource) {
        this.fromTemplate = new NamedParameterJdbcTemplate(dataSource);
    }

    // @Inject
    @Qualifier("toDataSource")
    public void setToDataSource(DataSource dataSource) {
        this.toTemplate = new NamedParameterJdbcTemplate(dataSource);
    }

    /**
     * Displays the list of {@link Person Persons} in the destination DB and a
     * button to trigger the copy mechanism.
     */
    @RequestMapping(value = "/ex6", method = RequestMethod.GET)
    public ModelAndView displayDestinationData() {
        ModelAndView mav = new ModelAndView("ex6-form");
        mav.addObject("persons", fetchPersons(toTemplate));
        return mav;
    }

    /**
     * Actually performs the copy and redirects to the list.
     */
    @RequestMapping(value = "/ex6", method = RequestMethod.POST)
    public String copy() {
        for (Person person : fetchPersons(fromTemplate)) {
            toTemplate.update("insert into Persons(firstName, lastName, age) values (:firstName, :lastName, :age)",
                    new BeanPropertySqlParameterSource(person));
        }
        return "redirect:/ex6";
    }

    private List<Person> fetchPersons(NamedParameterJdbcTemplate template) {
        return template.query("SELECT firstName, lastName, age FROM Persons", //
                new HashMap<String, Object>(), //
                new BeanPropertyRowMapper<Person>(Person.class));
    }

}