| 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  
PreparedStatements (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.