eu.dnetlib.openaire.user.dao

Class UserVerificationDAO

java.lang.Object

eu.dnetlib.openaire.user.dao.UserVerificationDAO

@Component(value="userVertificationDao")
public class UserVerificationDAO
extends Object

Created by sofia on 3/10/2017.

Constructor Summary

Constructors

Constructor and Description
UserVerificationDAO()

Method Summary

Modifier and Type	Method and Description
long	countAll()
boolean	delete(UserVerification userVerification)
long	executeCount(String sql)
long	executeCount(String sql, Statement.Initializer init)
protected List<UserVerification>	executeQuery(String sql)
protected List<UserVerification>	executeQuery(String sql, Statement.Initializer init)
protected int	executeUpdate(String sql, Statement.Initializer init)
List<UserVerification>	fetchAll()
UserVerification	fetchByDate(String date)
UserVerification	fetchById(int id)
UserVerification	fetchByUsername(String username)
UserVerification	fetchByVerificationCode(String verificationCode)
protected UserVerification	fromResultSet(ResultSet set)
DataSourceConnector	getDataSourceConnector()
boolean	insert(UserVerification userVerification)
void	setDataSourceConnector(DataSourceConnector dataSourceConnector)
boolean	update(UserVerification userVerification)

Methods inherited from class java.lang.Object

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

Constructor Detail

UserVerificationDAO

public UserVerificationDAO()

Method Detail

fetchAll

public List<UserVerification> fetchAll()
                                throws SQLException

Throws:

SQLException

fetchById

public UserVerification fetchById(int id)
                           throws SQLException

Throws:

SQLException

fetchByUsername

public UserVerification fetchByUsername(String username)
                                 throws SQLException

Throws:

SQLException

fetchByVerificationCode

public UserVerification fetchByVerificationCode(String verificationCode)
                                         throws SQLException

Throws:

SQLException

fetchByDate

public UserVerification fetchByDate(String date)
                             throws SQLException

Throws:

SQLException

countAll

public long countAll()
              throws SQLException

Throws:

SQLException

insert

public boolean insert(UserVerification userVerification)
               throws SQLException

Throws:

SQLException

delete

public boolean delete(UserVerification userVerification)
               throws SQLException

Throws:

SQLException

update

public boolean update(UserVerification userVerification)
               throws SQLException

Throws:

SQLException

fromResultSet

protected UserVerification fromResultSet(ResultSet set)
                                  throws SQLException

Throws:

SQLException

executeUpdate

protected int executeUpdate(String sql,
                            Statement.Initializer init)
                     throws SQLException

Throws:

SQLException

executeQuery

protected List<UserVerification> executeQuery(String sql,
                                              Statement.Initializer init)
                                       throws SQLException

Throws:

SQLException

executeQuery

protected List<UserVerification> executeQuery(String sql)
                                       throws SQLException

Throws:

SQLException

executeCount

public long executeCount(String sql)
                  throws SQLException

Throws:

SQLException

executeCount

public long executeCount(String sql,
                         Statement.Initializer init)
                  throws SQLException

Throws:

SQLException

getDataSourceConnector

public DataSourceConnector getDataSourceConnector()

setDataSourceConnector

public void setDataSourceConnector(DataSourceConnector dataSourceConnector)