A B C D F G I L N O Q R S T W

A

all() - Method in class org.skife.sql.QueryBuilder

Return all columns

B

bind(PreparedStatement, Map) - Method in class org.skife.sql.QueryBuilder

Binds the bindings to the stmt assuming the statement was built with this querybuilder

C

column(String) - Method in class org.skife.sql.QueryBuilder

Specify a column to include in the result set

D

distinct() - Method in class org.skife.sql.QueryBuilder

Specify to return distinct results, ie: "select distinct foo from bar"

F

from(String) - Method in class org.skife.sql.QueryBuilder

Specify a table to query against Joins are added to the same component as From tables

fullOuterJoin(String, String, String) - Method in class org.skife.sql.QueryBuilder

Specify a full outer innerJoin.

G

getBindList(Map) - Method in class org.skife.sql.QueryBuilder

Convenience method used to properly order binding values to the constructed query.

getQueryString() - Method in class org.skife.sql.QueryBuilder

Obtain the query string built thus far.

getQueryStringWithTokens() - Method in class org.skife.sql.QueryBuilder

Obtain the query string without token substitution.

getTokens() - Method in class org.skife.sql.QueryBuilder

Obtain a list of all the tokens in the order they appear in the query

groupBy(String) - Method in class org.skife.sql.QueryBuilder

Specify an "group by" clause

I

in(String, Collection) - Method in class org.skife.sql.QueryBuilder

Specify an SQL "IN" clause to include in the where component.

in(String, String[]) - Method in class org.skife.sql.QueryBuilder

Specify an SQL "IN" clause to include in the where component.

innerJoin(String, String, String) - Method in class org.skife.sql.QueryBuilder

Specify an inner innerJoin.

L

leftOuterJoin(String, String, String) - Method in class org.skife.sql.QueryBuilder

Specify a left outer innerJoin.

N

notIn(String, Collection) - Method in class org.skife.sql.QueryBuilder

Specify an SQL "NOT IN" clause to include in the where component.

notIn(String, String[]) - Method in class org.skife.sql.QueryBuilder

Specify an SQL "NOT IN" clause to include in the where component.

O

orderBy(String) - Method in class org.skife.sql.QueryBuilder

Specify an "order by" clause

org.skife.sql - package org.skife.sql

Q

QueryBuilder - class org.skife.sql.QueryBuilder.

QueryBuilder provides a convenient way to build queries programmatically.

R

rightOuterJoin(String, String, String) - Method in class org.skife.sql.QueryBuilder

Specify a right outer innerJoin.

S

select() - Static method in class org.skife.sql.QueryBuilder

Factory method used to generate a "select..." style query

subSelect(String, QueryBuilder) - Method in class org.skife.sql.QueryBuilder

Specify a sub select for the query of the form "where ([column] in ([query.getQueryString()]))

subSelect(String, String) - Method in class org.skife.sql.QueryBuilder

Specify a sub select for the query of the form "where ([column] in ([query]))

subSelectDisjunction(String, QueryBuilder) - Method in class org.skife.sql.QueryBuilder

Specify a sub select disjunction for the query of the form "where ([column] not in ([query]))

subSelectDisjunction(String, String) - Method in class org.skife.sql.QueryBuilder

Specify a sub select disjunction for the query of the form "where ([column] not in ([query]))

T

TOKEN_PATTERN - Static variable in class org.skife.sql.QueryBuilder

If in doubt as to whether a token is okay or not, here is the regex used to match tokens: "\\{\\s*?(\\w+?)\\s*?\\}"

toString() - Method in class org.skife.sql.QueryBuilder

W

where(String) - Method in class org.skife.sql.QueryBuilder

Add to the where clause of the query

A B C D F G I L N O Q R S T W