package generated;

import java.sql.*;
import java.util.*;


import common.BaseService;
import generated.WrimpService;

import generated.NameBean;
import generated.EnrichedNameBean;


public class WrimpServiceImpl extends BaseService implements WrimpService
{
    private List<NameBean> getNameList()
    throws SQLException
    {
        Connection connection = getConnection();
        PreparedStatement pstmt= connection.prepareCall(
            "select id, name "+ 
            "from   t_name ");
        ResultSet resultSet=pstmt.executeQuery();
        List<NameBean> c = new ArrayList<NameBean>();
        while ( resultSet.next() )
        {
            c.add(resultSetToNameBean( resultSet ) );
        }
        resultSet.close();
        pstmt.close();
        returnConnection(connection);
        return c;
    }

    public List<EnrichedNameBean> getEnrichedNameList()
    throws SQLException
    {
        List<EnrichedNameBean> list=new ArrayList<EnrichedNameBean>(); 
        for ( NameBean b : getNameList() )
        {
            EnrichedNameBean n = new EnrichedNameBean();     
            n.setId( b.getId() );
            n.setName( b.getName() );
            n.setUpperCaseName( b.getName().toUpperCase() );
            list.add(n);
        } 
        return list;
    } 



    private NameBean resultSetToNameBean(ResultSet resultSet)
    throws SQLException
    {
       NameBean o = new NameBean();
       o.setId( resultSet.getString(1)); 
       o.setName( resultSet.getString(2)); 
       return o;
    }


 
}