public class Request extends AbstractDbData<Request>
The different informations of the request are connection or data source, the SQL request and optionally the parameters of the SQL request.
Examples of instantiation :
This Request
point to a request without parameter in a H2 database in memory like indicated in the
Source
.
Source source = new Source("jdbc:h2:mem:test", "sa", "");
Request request = new Request(source, "select title from movie;");
Below the Request
point to a request with 2000
in parameter.
The Request
use a DataSource
instead of a Source
like above.
DataSource dataSource = ...;
Request request = new Request(dataSource, "select title from movie where year > ?;", 2000);
myself
Constructor and Description |
---|
Request()
Default constructor.
|
Request(DataSource dataSource,
String request,
Object... parameters)
Constructor with a data source.
|
Request(Source source,
String request,
Object... parameters)
Constructor with a connection.
|
Modifier and Type | Method and Description |
---|---|
Object[] |
getParameters()
The parameters of the SQL request.
|
String |
getRequest()
Returns the SQL request.
|
protected void |
loadImpl(Connection connection)
Specific implementation of the loading for a
Request . |
Request |
setParameters(Object... parameters)
Sets the parameters of the SQL request.
|
Request |
setPksName(String... pksName)
Sets the primary keys name.
|
Request |
setRequest(String request)
Sets the SQL request.
|
collectRowsFromResultSet, controlIfAllThePksNameExistInTheColumns, getColumn, getColumnsNameList, getDataType, getPksNameList, getRow, getRowFromPksValues, getRowsList, setColumnsNameList, setPksNameList
getCatalog, getConnection, getDataSource, getSchema, getSource, setDataSource, setSource
public Request()
public Request(Source source, String request, Object... parameters)
source
- Source to connect to the database.request
- SQL Request to get the values.parameters
- Parameters of the SQL request.public Request(DataSource dataSource, String request, Object... parameters)
dataSource
- Data source.request
- SQL Request to get the values.parameters
- Parameters of the SQL request.public String getRequest()
getRequest
in class AbstractDbData<Request>
Table.getRequest()
,
getRequest()
public Request setRequest(String request)
request
- The SQL request.NullPointerException
- If the request
field is null
.public Object[] getParameters()
public Request setParameters(Object... parameters)
parameters
- The parameters of the SQL request.public Request setPksName(String... pksName)
pksName
- The primary keys name.this
instance.protected void loadImpl(Connection connection) throws SQLException
Request
.loadImpl
in class AbstractDbData<Request>
connection
- Connection
to the database provided by AbstractDbData.load()
private method.NullPointerException
- If the request
field is null
.SQLException
- SQL Exception.AbstractDbData.loadImpl(Connection)
Copyright © 2015 AssertJ. All Rights Reserved.