eu.dnetlib.openaire.user.dao

Class SQLUserDAO

java.lang.Object

eu.dnetlib.openaire.user.dao.SQLUserDAO

All Implemented Interfaces:

UserDAO

public class SQLUserDAO
extends Object
implements UserDAO

Created by sofia on 24/6/2016.

Constructor Summary

Constructors

Constructor and Description
SQLUserDAO()

Method Summary

Modifier and Type	Method and Description
int	countAll()
void	delete(User u)
long	executeCount(String sql)
long	executeCount(String sql, Statement.Initializer init)
User	executeQuery(String sql)
User	executeQuery(String sql, Statement.Initializer init)
int	executeUpdate(String sql)
int	executeUpdate(String sql, Statement.Initializer init)
List<User>	fetchAll()
User	fetchByEmail(String mail)
User	fetchById(String id)
User	fetchByName(String name)
User	fetchBySurname(String surname)
User	fetchByUsername(String username)
User	fromResultSet(ResultSet set)
void	insert(User u)
User	update(User u)

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLUserDAO

public SQLUserDAO()

Method Detail

fetchById

public User fetchById(String id)

Specified by:

fetchById in interface UserDAO

fetchByEmail

public User fetchByEmail(String mail)

Specified by:

fetchByEmail in interface UserDAO

fetchByUsername

public User fetchByUsername(String username)

Specified by:

fetchByUsername in interface UserDAO

fetchByName

public User fetchByName(String name)

Specified by:

fetchByName in interface UserDAO

fetchBySurname

public User fetchBySurname(String surname)

Specified by:

fetchBySurname in interface UserDAO

fetchAll

public List<User> fetchAll()

Specified by:

fetchAll in interface UserDAO

countAll

public int countAll()

Specified by:

countAll in interface UserDAO

insert

public void insert(User u)

Specified by:

insert in interface UserDAO

delete

public void delete(User u)

Specified by:

delete in interface UserDAO

update

public User update(User u)

Specified by:

update in interface UserDAO

fromResultSet

public User fromResultSet(ResultSet set)
                   throws SQLException

Specified by:

fromResultSet in interface UserDAO

Throws:

SQLException

executeUpdate

public int executeUpdate(String sql)

Specified by:

executeUpdate in interface UserDAO

executeUpdate

public int executeUpdate(String sql,
                         Statement.Initializer init)

Specified by:

executeUpdate in interface UserDAO

executeQuery

public User executeQuery(String sql)

Specified by:

executeQuery in interface UserDAO

executeQuery

public User executeQuery(String sql,
                         Statement.Initializer init)

Specified by:

executeQuery in interface UserDAO

executeCount

public long executeCount(String sql)

Specified by:

executeCount in interface UserDAO

executeCount

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

Specified by:

executeCount in interface UserDAO