package generated;

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


import common.BaseService;
import generated.MasterDetailService;

import generated.MasterBean;
import generated.DetailBean;


public class MasterDetailServiceImpl extends BaseService implements MasterDetailService
{
    public List<MasterBean> getMasterList()
    throws SQLException
    {
        Connection connection = getConnection();
        PreparedStatement pstmt= connection.prepareCall(
            "select id, artist, album "+ 
            "from   t_master ");
        ResultSet resultSet=pstmt.executeQuery();
        List<MasterBean> c = new ArrayList<MasterBean>();
        while ( resultSet.next() )
        {
            c.add(resultSetToMasterBean( resultSet ) );
        }
        resultSet.close();
        pstmt.close();
        returnConnection(connection);
        return c;
    }

    public Map<String,List<DetailBean>> getDetailMap()
    throws SQLException
    {
        Connection connection = getConnection();
        PreparedStatement pstmt= connection.prepareCall(
            "select master_id, trackno, title "+ 
            "from   t_detail ");
        ResultSet resultSet=pstmt.executeQuery();
        Map<String,List<DetailBean>> c = new HashMap<String,List<DetailBean>>();
        while ( resultSet.next() )
        {
            String k=resultSet.getString(1);
            List<DetailBean> l = null;
            if ( c.containsKey(k))
            {
               l=c.get(k); 
            } 
            else
            {
               l=new ArrayList<DetailBean>();
               c.put(k,l);
            }
            l.add(resultSetToDetailBean( resultSet ) );
        }
        resultSet.close();
        pstmt.close();
        returnConnection(connection);
        return c;
    }



    private MasterBean resultSetToMasterBean(ResultSet resultSet)
    throws SQLException
    {
       MasterBean o = new MasterBean();
       o.setId( resultSet.getString(1)); 
       o.setArtist( resultSet.getString(2)); 
       o.setAlbum( resultSet.getString(3)); 
       return o;
    }

    private DetailBean resultSetToDetailBean(ResultSet resultSet)
    throws SQLException
    {
       DetailBean o = new DetailBean();
       o.setMasterId( resultSet.getString(1)); 
       o.setTrackno( resultSet.getInt(2)); 
       o.setTitle( resultSet.getString(3)); 
       return o;
    }

 
}