org.springframework.samples.jca.dao.PersonDaoImpl.java Source code

Introduction

Here is the source code for org.springframework.samples.jca.dao.PersonDaoImpl.java

Source

/*
 * Copyright 2002-2004 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.springframework.samples.jca.dao;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import javax.resource.ResourceException;
import javax.resource.cci.IndexedRecord;
import javax.resource.cci.Record;
import javax.resource.cci.RecordFactory;
import javax.resource.cci.ResultSet;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.dao.DataAccessException;
import org.springframework.jca.cci.core.RecordCreator;
import org.springframework.jca.cci.core.RecordExtractor;
import org.springframework.jca.cci.core.support.CciDaoSupport;
import org.springframework.samples.jca.dao.PersonDao;
import org.springframework.samples.jca.exception.PersonException;
import org.springframework.samples.jca.model.Person;

import com.sun.connector.cciblackbox.CciInteractionSpec;

/**
 * 
 * 
 * @author Thierry TEMPLIER
 */
public class PersonDaoImpl extends CciDaoSupport implements PersonDao {

    private static final Log log = LogFactory.getLog(PersonDaoImpl.class);

    /**
     * @see org.springframework.samples.jca.dao.PersonneDao#getPerson(int)
     */
    public Person getPerson(final int id) throws PersonException {
        CciInteractionSpec interactionSpec = new CciInteractionSpec();
        /*interactionSpec.setUser("sa");
        interactionSpec.setPassword("");*/
        interactionSpec.setSql("select * from person where person_id=?");

        List people = (List) getCciTemplate().execute(interactionSpec, new RecordCreator() {
            public Record createRecord(RecordFactory recordFactory) throws ResourceException, DataAccessException {
                IndexedRecord input = recordFactory.createIndexedRecord("input");
                input.add(new Integer(id));
                return input;
            }
        }, new RecordExtractor() {
            public Object extractData(Record record) throws ResourceException, SQLException, DataAccessException {
                List people = new ArrayList();
                ResultSet rs = (ResultSet) record;
                while (rs.next()) {
                    Person person = new Person();
                    person.setId(rs.getInt("person_id"));
                    person.setLastName(rs.getString("person_last_name"));
                    person.setFirstName(rs.getString("person_first_name"));
                    people.add(person);
                }
                return people;
            }
        });

        if (people.size() == 1) {
            return (Person) people.get(0);
        } else {
            throw new PersonException("Can't the person");
        }
    }

    /**
     * @see org.springframework.samples.jca.dao.PersonDao#updatePerson(org.springframework.samples.jca.model.Person)
     */
    public void updatePerson(final Person person) {
        StringBuffer request = new StringBuffer();
        request.append("update person set ");
        request.append("person_last_name=?,");
        request.append("person_first_name=?");
        request.append(" where person_id=?");
        CciInteractionSpec interactionSpec = new CciInteractionSpec();
        interactionSpec.setSql(request.toString());

        getCciTemplate().execute(interactionSpec, new RecordCreator() {
            public Record createRecord(RecordFactory recordFactory) throws ResourceException, DataAccessException {
                IndexedRecord input = recordFactory.createIndexedRecord("input");
                input.add(person.getLastName());
                input.add(person.getFirstName());
                input.add(new Integer(person.getId()));
                return input;
            }
        }, new RecordExtractor() {
            public Object extractData(Record record) throws ResourceException, SQLException, DataAccessException {
                IndexedRecord output = (IndexedRecord) record;
                for (Iterator i = output.iterator(); i.hasNext();) {
                    log.debug("Number of updated lines : " + i.next());
                }
                return null;
            }
        });

    }

}