package myapp.server;

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


import myapp.server.common.BaseService;
import myapp.client.MyService;

import myapp.client.MyBean;


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



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

 
}