Class ExerciseSessionDao

java.lang.Object

com.serinity.exercicecontrol.dao.ExerciseSessionDao

public class ExerciseSessionDao
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static final record	ExerciseSessionDao.SessionSummary

Constructor Summary

Constructors

Constructor	Description
ExerciseSessionDao()

Method Summary

Modifier and Type	Method	Description
void	delete(int id)
ExerciseSession	findById(int id)
List<ExerciseSession>	findByUserAndExercise(int userId, int exerciseId)
List<ExerciseSession>	findByUserId(int userId)
List<ExerciseSessionDao.SessionSummary>	findRecent(int userId, Integer exerciseId, int days, int limit)
int	insert(ExerciseSession s)
void	update(ExerciseSession s)

Methods inherited from class Object

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

Constructor Details

ExerciseSessionDao

public ExerciseSessionDao()

Method Details

insert

public int insert(ExerciseSession s)
           throws SQLException

Throws:

SQLException

update

public void update(ExerciseSession s)
            throws SQLException

Throws:

SQLException

delete

public void delete(int id)
            throws SQLException

Throws:

SQLException

findById

public ExerciseSession findById(int id)
                         throws SQLException

Throws:

SQLException

findByUserId

public List<ExerciseSession> findByUserId(int userId)
                                   throws SQLException

Throws:

SQLException

findByUserAndExercise

public List<ExerciseSession> findByUserAndExercise(int userId,
 int exerciseId)
                                            throws SQLException

Throws:

SQLException

findRecent

public List<ExerciseSessionDao.SessionSummary> findRecent(int userId,
 Integer exerciseId,
 int days,
 int limit)
                                                   throws SQLException

Throws:

SQLException