eu.dnetlib.openaire.user.dao

Class SQLMigrationUserDAO

java.lang.Object

eu.dnetlib.openaire.user.dao.SQLMigrationUserDAO

@Component(value="sqlMigrationUserDAO")
public class SQLMigrationUserDAO
extends Object

Created by sofia on 1/11/2016.

Constructor Summary

Constructors

Constructor and Description
SQLMigrationUserDAO()

Method Summary

Modifier and Type	Method and Description
long	countAll()
boolean	delete(String username)
long	executeCount(String sql)
long	executeCount(String sql, Statement.Initializer init)
protected List<MigrationUser>	executeQuery(String sql)
protected List<MigrationUser>	executeQuery(String sql, Statement.Initializer init)
protected int	executeUpdate(String sql)
protected int	executeUpdate(String sql, Statement.Initializer init)
List<MigrationUser>	fetchAll()
MigrationUser	fetchByEmail(String email)
MigrationUser	fetchByFullname(String fullname)
MigrationUser	fetchById(int id)
List<MigrationUser>	fetchByRoleId(String roleId)
MigrationUser	fetchByUsername(String username)
protected MigrationUser	fromResultSet(ResultSet set)
DataSourceConnector	getDataSourceConnector()
boolean	insert(MigrationUser mUser)
void	setDataSourceConnector(DataSourceConnector dataSourceConnector)
boolean	update(MigrationUser mUser)

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLMigrationUserDAO

public SQLMigrationUserDAO()

Method Detail

fetchAll

public List<MigrationUser> fetchAll()
                             throws SQLException

Throws:

SQLException

fetchById

public MigrationUser fetchById(int id)
                        throws SQLException

Throws:

SQLException

fetchByUsername

public MigrationUser fetchByUsername(String username)
                              throws SQLException

Throws:

SQLException

fetchByFullname

public MigrationUser fetchByFullname(String fullname)
                              throws SQLException

Throws:

SQLException

fetchByEmail

public MigrationUser fetchByEmail(String email)
                           throws SQLException

Throws:

SQLException

fetchByRoleId

public List<MigrationUser> fetchByRoleId(String roleId)
                                  throws SQLException

Throws:

SQLException

countAll

public long countAll()
              throws SQLException

Throws:

SQLException

insert

public boolean insert(MigrationUser mUser)
               throws SQLException

Throws:

SQLException

delete

public boolean delete(String username)
               throws SQLException

Throws:

SQLException

update

public boolean update(MigrationUser mUser)
               throws SQLException

Throws:

SQLException

fromResultSet

protected MigrationUser fromResultSet(ResultSet set)
                               throws SQLException

Throws:

SQLException

executeUpdate

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

Throws:

SQLException

executeQuery

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

Throws:

SQLException

executeUpdate

protected int executeUpdate(String sql)
                     throws SQLException

Throws:

SQLException

executeQuery

protected List<MigrationUser> 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)