Package ece.ing3.java.projet.database.sql.queries

Class SQLUpdate

java.lang.Object

ece.ing3.java.projet.database.sql.queries.SQLWhereQuery<SQLUpdate>

ece.ing3.java.projet.database.sql.queries.SQLUpdate

All Implemented Interfaces:

SQLRequest

public class SQLUpdate
extends SQLWhereQuery<SQLUpdate>

SQL update helper.

Provides a convenient way to build update SQL queries, reactive-style, for a provided model class.

Author:

Virgile, Nicolas, Louis-Félix

Constructor Summary

Constructors

Constructor	Description
SQLUpdate(Class<? extends Model> modelClass)	Creates a new helper for a model class.

Method Summary

Modifier and Type	Method	Description
Class<? extends Model>	getModelClass()
List<Object>	getParameters()	Gets all the request's parameters
SQLUpdate	set(String column, Object value)	Sets a new value for a defined column.
String	toString()	Generate the SQL query for this insert helper.
int	update()	Updates the database according to the provided values and conditions.

Methods inherited from class ece.ing3.java.projet.database.sql.queries.SQLWhereQuery

andWhere, andWhere, andWhere, orWhere, orWhere, orWhere, where, where, where

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Details

SQLUpdate

public SQLUpdate(Class<? extends Model> modelClass)

Creates a new helper for a model class.

Parameters:

modelClass - Model class

Method Details

getModelClass

public Class<? extends Model> getModelClass()

set

public SQLUpdate set(String column,
 Object value)
              throws NullPointerException

Sets a new value for a defined column.

Parameters:

column - Column to target

value - New column value

Returns:

This SQL insert helper

Throws:

NullPointerException - Column or value is null

update

public int update()
           throws IllegalArgumentException,
DatabaseException

Updates the database according to the provided values and conditions.

Returns:

Either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing

Throws:

IllegalArgumentException - No values where set

DatabaseException - Database error

toString

public String toString()
                throws IllegalArgumentException

Generate the SQL query for this insert helper.

Specified by:

toString in interface SQLRequest

Overrides:

toString in class Object

Returns:

Generated SQL query

Throws:

IllegalArgumentException - No values where added

getParameters

public List<Object> getParameters()

Description copied from interface: SQLRequest

Gets all the request's parameters

Specified by:

getParameters in interface SQLRequest

Overrides:

getParameters in class SQLWhereQuery<SQLUpdate>

Returns:

Request parameters