com.github.brokenswing.comixaire.dao.postgres

Class PostgresClientDAO

java.lang.Object

com.github.brokenswing.comixaire.dao.postgres.PostgresClientDAO

All Implemented Interfaces:

ClientDAO

public class PostgresClientDAO
extends java.lang.Object
implements ClientDAO

Method Summary

Modifier and Type	Method and Description
static Client	clientFromRow(java.sql.ResultSet result)
int	countAll()
int	countCurrentLoans(Client client)
int	countFines(Client client)
int	countLoans(Client client)
int	countVotes(Client client)
Client	create(Client client)
void	delete(Client client)
Client[]	findAll()
Client	findByCardID(java.lang.String cardID)
Client	findById(int idClient)
void	update(Client client)
java.lang.Boolean	validSubscription(Client client)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

clientFromRow

public static Client clientFromRow(java.sql.ResultSet result)
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

create

public Client create(Client client)
              throws InternalException,
                     CardIdAlreadyExist

Specified by:

create in interface ClientDAO

Throws:

InternalException

CardIdAlreadyExist

findById

public Client findById(int idClient)
                throws InternalException,
                       NoClientFoundException

Specified by:

findById in interface ClientDAO

Throws:

InternalException

NoClientFoundException

findByCardID

public Client findByCardID(java.lang.String cardID)
                    throws InternalException,
                           NoClientFoundException

Specified by:

findByCardID in interface ClientDAO

Parameters:

cardID - the card ID of the client to find

Returns:

the client with the given card ID

Throws:

InternalException - if an unexpected error occurs

NoClientFoundException - if no client with the given card ID was found

findAll

public Client[] findAll()
                 throws InternalException

Specified by:

findAll in interface ClientDAO

Throws:

InternalException

update

public void update(Client client)
            throws InternalException,
                   CardIdAlreadyExist

Specified by:

update in interface ClientDAO

Throws:

InternalException

CardIdAlreadyExist

delete

public void delete(Client client)
            throws InternalException

Specified by:

delete in interface ClientDAO

Throws:

InternalException

countLoans

public int countLoans(Client client)
               throws InternalException

Specified by:

countLoans in interface ClientDAO

Throws:

InternalException

countCurrentLoans

public int countCurrentLoans(Client client)
                      throws InternalException

Specified by:

countCurrentLoans in interface ClientDAO

Throws:

InternalException

validSubscription

public java.lang.Boolean validSubscription(Client client)
                                    throws InternalException

Specified by:

validSubscription in interface ClientDAO

Throws:

InternalException

countAll

public int countAll()
             throws InternalException

Specified by:

countAll in interface ClientDAO

Throws:

InternalException

countFines

public int countFines(Client client)
               throws InternalException

Specified by:

countFines in interface ClientDAO

Throws:

InternalException

countVotes

public int countVotes(Client client)
               throws InternalException

Specified by:

countVotes in interface ClientDAO

Throws:

InternalException