gov.nasa.pds.tracking.tracking.db

Class UserDao

java.lang.Object

gov.nasa.pds.tracking.tracking.db.DBConnector

gov.nasa.pds.tracking.tracking.db.UserDao

public class UserDao
extends DBConnector

Author:

danyu Dan.Yu@jpl.nasa.gov

Field Summary

Fields

Modifier and Type	Field and Description
static String	EMAILCOLUMN
static org.apache.log4j.Logger	logger
static String	NAMECOLUMN

Fields inherited from class gov.nasa.pds.tracking.tracking.db.DBConnector

ARCHIVE_STATUS_TABLE_NAME, CERTIFICATION_STATUS_TABLE_NAME, ISO_BASIC, NSSDCA_STATUS_TABLE_NAME

Constructor Summary

Constructors

Constructor and Description
UserDao()

Method Summary

Modifier and Type	Method and Description
List<User>	getProductRoleUsers(String log_identifer, String tableName) Product instrument/investigation/node Role Query – Query the product, instrument/investigation/node_reference, role and user tables for a list of users with the instrument/investigation/node role for a product.
List<User>	getUserRole(String email) User Role Query - Query the user and role tables for a list of roles for a given user.
List<User>	getUsers() User Query – Query the user table for a list of users.
int	insertUser(User user)
User	updateUser(User user)

Methods inherited from class gov.nasa.pds.tracking.tracking.db.DBConnector

getConnection

Methods inherited from class java.lang.Object

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

Field Detail

logger

public static org.apache.log4j.Logger logger

NAMECOLUMN

public static final String NAMECOLUMN

See Also:

Constant Field Values

EMAILCOLUMN

public static final String EMAILCOLUMN

See Also:

Constant Field Values

Constructor Detail

UserDao

public UserDao()
        throws ClassNotFoundException,
               SQLException

Throws:

ClassNotFoundException

SQLException

Method Detail

getUsers

public List<User> getUsers()

User Query – Query the user table for a list of users.

Returns:

a list of users

getUserRole

public List<User> getUserRole(String email)

User Role Query - Query the user and role tables for a list of roles for a given user.

Parameters:

role -

Returns:

a list of roles for a given user (email)

getProductRoleUsers

public List<User> getProductRoleUsers(String log_identifer,
                                      String tableName)

Product instrument/investigation/node Role Query – Query the product, instrument/investigation/node_reference, role and user tables for a list of users with the instrument/investigation/node role for a product.

Parameters:

log_identifer -

type -

Returns:

a list of users

updateUser

public User updateUser(User user)

Parameters:

user -

insertUser

public int insertUser(User user)

Parameters:

user -