Package | Description |
---|---|
com.absio.database | |
com.absio.database.table |
Modifier and Type | Method and Description |
---|---|
static SqlParameter<Byte> |
SqlParameter.create(String name,
byte value)
Create a
Byte parameter with the given name and value. |
static SqlParameter<byte[]> |
SqlParameter.create(String name,
byte[] value)
Create a
byte[] parameter with the given name and value. |
static SqlParameter<Double> |
SqlParameter.create(String name,
double value)
Create a
Double parameter with the given name and value. |
static SqlParameter<Integer> |
SqlParameter.create(String name,
int value)
Create a
Integer parameter with the given name and value. |
static SqlParameter<Long> |
SqlParameter.create(String name,
long value)
Create a
Long parameter with the given name and value. |
static SqlParameter<String> |
SqlParameter.create(String name,
String value)
Create a
String parameter with the given name and value. |
SqlParameter[] |
ParameterizedSql.getParameters()
Get the parameter array.
|
Modifier and Type | Method and Description |
---|---|
long |
DatabaseWrapper.executeCountQueryWithParameters(String countSql,
SqlParameter... parameters)
This will execute the count query with the given parameters and return the result.
|
int |
DatabaseWrapper.executeUpdateWithParameters(String sql,
SqlParameter... parameters)
The will execute the given sql as an update with the given parameters (insert, update, delete, etc).
|
void |
DatabaseWrapper.fillStatement(PreparedStatement statement,
SqlParameter... parameters)
This is a utility method to help fill
PreparedStatement s (by calling fillStatement(int, PreparedStatement) . |
PreparedStatement |
DatabaseWrapper.prepareStatement(String sql,
SqlParameter... parameters)
Create a
PreparedStatement for the given sql and fill the parameters. |
Constructor and Description |
---|
ParameterizedSql(String sql,
SqlParameter... parameters)
Create with the given sql and parameter array.
|
Modifier and Type | Method and Description |
---|---|
String |
AbstractTable.getCountSql(SqlParameter... parameters)
Get the count sql for this table using the given parameters.
|
static String |
AbstractTable.getCountSql(String tableName,
SqlParameter... parameters)
Get the count sql for a table with the given set of parameters.
|
String |
AbstractTable.getDeleteSql(SqlParameter... parameters)
Get the delete sql for this table using the given set of parameters.
|
String |
AbstractTable.getInsertSql(SqlParameter... parameters)
Get the insert sql for this table using the given set of parameters.
|
static String |
AbstractTable.getInsertSql(String tableName,
SqlParameter... parameters)
Get the insert sql for a table with the given set of parameters
|
String |
AbstractTable.getQueryParameterizedSql(SqlParameter... parameters)
Get the query sql for this table using the given set of parameters.
|
Copyright © 2021. All rights reserved.