package fr.esisar.cs420.requete;

import java.sql.PreparedStatement;
import java.sql.ResultSet;

import fr.esisar.cs420.connexionBD.ConnexionBD;

public class TestChoixAlbum
{

	public static Integer main(Integer num_album, Integer type)
	{

		Integer param_retour=num_album;
		if(num_album!=-1)
		{
			try
			{
				PreparedStatement preparedStatement = ConnexionBD.getInstance().prepareStatement("SELECT estpartage FROM albums WHERE num_album=? AND estlivre=?");
			    preparedStatement.setInt(1, num_album);
			    preparedStatement.setInt(2, type);

				ResultSet result = preparedStatement.executeQuery();
				if(result.next())
					param_retour=result.getInt(1);
				else
					param_retour=0;

	            result.close();
	            preparedStatement.close();

			}
			catch (Exception e)
			{
				e.printStackTrace();
			}
			if(param_retour==0)
				param_retour=-2;
			else
				param_retour=num_album;
		}
		return param_retour;
	}
}