ejemplo2

package Persistencia;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Timestamp;
import java.util.Vector;
import Negocio.Afiliado;
import Negocio.Distribuidora;
import Negocio.EstadoAfiliado;
import Negocio.TipoDoc;

public class AdmPersistenciaAfiliado extends AdministradorPersistencia
{
	private static AdmPersistenciaAfiliado instancia;

	private AdmPersistenciaAfiliado()
	{

	}
	public static AdmPersistenciaAfiliado getInstancia()
	{
		if (instancia == null)
			instancia = new AdmPersistenciaAfiliado();
		return instancia;
	}

	@Override
	public void delete(Object d)
	{
		try
		{
			Afiliado a = (Afiliado)d;
			Connection con = PoolConnection.getPoolConnection().getConnection();
			PreparedStatement s = con.prepareStatement("delete from A_Interactivas_01.dbo.Afiliados where codigo = ?");
			s.setLong(1, a.getCodigo());
			s.execute();
			PoolConnection.getPoolConnection().realeaseConnection(con);
		}
		catch (Exception e)
		{
			System.out.println();
		}


	}

	@Override
	public void insert(Object o)
	{
		try
		{
			Afiliado a = (Afiliado)o;
			Connection con = PoolConnection.getPoolConnection().getConnection();
			PreparedStatement s = con.prepareStatement("insert into A_Interactivas_01.dbo.Afiliados values (?,?,?,?,?,?,?,?,?,?,?)");
			//agregar campos
			s.setLong(1,a.getCodigo());
			s.setString(2, a.getNombre());
			s.setString(3,a.getDomicilio());
			s.setString(4, a.getTelefono());
			s.setInt(5,a.getTipodoc().getCodigo());
			s.setString(6, a.getNroDoc());
			s.setString(7,a.getSexo());
			s.setTimestamp(8, a.getFechaNac());
			s.setInt(9,a.getDistribuidora().getCodigo());
			s.setTimestamp(10,  a.getFechaAlta());
			s.setInt(11,a.getEstado().getCodigo());
			s.execute();
			PoolConnection.getPoolConnection().realeaseConnection(con);
		}
		catch (Exception e)
		{
			System.out.println();
		}


	}

	@Override
	public Vector<Object> select(Object o)
	{
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public void update(Object o)
	{
		try
		{
			Afiliado a = (Afiliado)o;
			Connection con = PoolConnection.getPoolConnection().getConnection();
			PreparedStatement s = con.prepareStatement("update A_Interactivas_01.dbo.Afiliados " +
					"set nombre = ?," +
					"set domicilio = ?," +
					"set telefono =?," +
					"set tipodoc =?," +
					"set dni =?," +
					"set sexo =?," +
					"set fecnacimiento = ?," +
					"set distribuidora =?," +
					"set estado =?)");
			//agregar campos
			s.setString(2, a.getNombre());
			s.setString(3,a.getDomicilio());
			s.setString(4, a.getTelefono());
			s.setInt(5,a.getTipodoc().getCodigo());
			s.setString(6, a.getNroDoc());
			s.setString(7,a.getSexo());
			s.setTimestamp(8, a.getFechaNac());
			s.setInt(9,a.getDistribuidora().getCodigo());
			s.setInt(11,a.getEstado().getCodigo());
			s.execute();
			PoolConnection.getPoolConnection().realeaseConnection(con);
		}
		catch (Exception e)
		{
			System.out.println();
		}



	}
	public Afiliado buscarAfiliado(long codigo)
	{
		try
		{
			Afiliado a = null;
			Connection con = PoolConnection.getPoolConnection().getConnection();
			PreparedStatement s = con.prepareStatement("select * from A_Interactivas_01.dbo.Afiliados where codigo = ?");			//agregar campos
			s.setLong(1,codigo);
			ResultSet result = s.executeQuery();
			while (result.next())
			{
				long cod = result.getLong(1);
				String nom = result.getString(2);
				String dom = result.getString(3);
				String tel = result.getString(4);
				TipoDoc tip = AdmPersistenciaTipoDoc.getInstancia().buscarTipoDoc(result.getInt(5));
				String nrodoc = result.getString(6);
				String sex = result.getString(7);
				Timestamp fecnac = result.getTimestamp(8);
				Distribuidora dis = AdmPersistenciaDistribuidora.getInstancia().buscarDistribuidora(result.getInt(9));
				Timestamp fecalta = result.getTimestamp(10);
				EstadoAfiliado est = AdmPersistenciaEstadoAfiliado.getInstancia().buscarEstado(result.getInt(11));
				a = new Afiliado(cod,nom,dom,tel,tip, nrodoc,sex,fecnac,dis,fecalta,est);
			}

			PoolConnection.getPoolConnection().realeaseConnection(con);
			return a;
		}
		catch (Exception e)
		{
			System.out.println();
		}
		return null;
	}

}