UserDataAccessObject

java.lang.Object

Database.UserDataAccessObject

public class UserDataAccessObject extends Object

Class representing all the methods to query the user table

Constructor Summary

Constructors

Constructor

Description

UserDataAccessObject()
Method Summary

Modifier and Type

Method

Description

static javafx.collections.ObservableList<User>

getAllUsers()

static User

getUserByUserID(int userId)

static User

getUserByUsername(String username)

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details
- UserDataAccessObject
  
  public UserDataAccessObject()
Method Details
- getUserByUsername
  
  public static User getUserByUsername(String username) throws SQLException, Exception
  
  Parameters:
  
  username - String value
  
  Returns:
  
  the User object
  
  Throws:
  
  SQLException
  
  Exception
- getUserByUserID
  
  public static User getUserByUserID(int userId) throws SQLException
  
  Parameters:
  
  userId - the userID int value
  
  Returns:
  
  the User object
  
  Throws:
  
  SQLException
- getAllUsers
  
  public static javafx.collections.ObservableList<User> getAllUsers() throws SQLException
  
  Returns:
  
  [ObservableList] of User objects
  
  Throws:
  
  SQLException