| Constructor and Description |
|---|
SQLUserDAO() |
| 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) |
public User fetchByEmail(String mail)
fetchByEmail in interface UserDAOpublic User fetchByUsername(String username)
fetchByUsername in interface UserDAOpublic User fetchByName(String name)
fetchByName in interface UserDAOpublic User fetchBySurname(String surname)
fetchBySurname in interface UserDAOpublic User fromResultSet(ResultSet set) throws SQLException
fromResultSet in interface UserDAOSQLExceptionpublic int executeUpdate(String sql)
executeUpdate in interface UserDAOpublic int executeUpdate(String sql, Statement.Initializer init)
executeUpdate in interface UserDAOpublic User executeQuery(String sql)
executeQuery in interface UserDAOpublic User executeQuery(String sql, Statement.Initializer init)
executeQuery in interface UserDAOpublic long executeCount(String sql)
executeCount in interface UserDAOpublic long executeCount(String sql, Statement.Initializer init)
executeCount in interface UserDAOCopyright © 2026. All rights reserved.