| Package | Description |
|---|---|
| com.hfg.sql | |
| com.hfg.sql.table |
| Modifier and Type | Class and Description |
|---|---|
class |
FromClause
Container for a SQL FROM clause.
|
class |
JoinClause
Container for a SQL JOIN clause.
|
class |
LimitClause
Container for a SQL limit clause.
|
class |
OffsetClause
Container for a SQL offset clause.
|
class |
OrderByClause
Container for a SQL order by clause.
|
class |
WhereClause
Container for a SQL where clause.
|
| Modifier and Type | Method and Description |
|---|---|
SQLCmd |
SQLCmd.addClause(SQLClause inValue) |
SQLDelete |
SQLDelete.addClause(SQLClause inValue) |
SQLQuery |
SQLQuery.addClause(SQLClause inValue) |
SQLUpdate |
SQLUpdate.addClause(SQLClause inValue) |
| Modifier and Type | Method and Description |
|---|---|
SQLCmd |
SQLCmd.addClauses(Collection<SQLClause> inClauses) |
SQLQuery |
SQLQuery.addClauses(Collection<SQLClause> inClauses) |
static int |
SQLUtil.getRowCount(Connection inConn,
DatabaseTable inTable,
Collection<SQLClause> inClauses)
A convenience method for getting a count of rows that meet a specific criteria.
|
| Modifier and Type | Method and Description |
|---|---|
T |
DatabaseTable.getRow(Connection inConn,
SQLClause inClause) |
int |
DatabaseTable.getRowCount(Connection inConn,
SQLClause inClause) |
List<T> |
DatabaseTable.getRows(Connection inConn,
SQLClause... inClauses) |
List<T> |
DatabaseTable.getRows(Connection inConn,
SQLClause inClause) |
| Modifier and Type | Method and Description |
|---|---|
T |
DatabaseTable.getRow(Connection inConn,
List<SQLClause> inSQLClauses) |
int |
DatabaseTable.getRowCount(Connection inConn,
Collection<SQLClause> inSQLClauses) |
List<T> |
DatabaseTable.getRows(Connection inConn,
List<SQLClause> inSQLClauses) |
jataylor@hairyfatguy.com