Package com.invirgance.convirgance.jdbc.sql

Class BooleanAndStatement<P extends WhereStatement>

java.lang.Object

com.invirgance.convirgance.jdbc.sql.WhereStatement

com.invirgance.convirgance.jdbc.sql.BooleanAndStatement<P>

Type Parameters:

P - The parent WhereStatement type this returns to when done.

All Implemented Interfaces:

ComparisonStatement, SQLStatement

public class BooleanAndStatement<P extends WhereStatement>
extends WhereStatement
implements ComparisonStatement

Creates a logical AND grouping in SQL, combining multiple conditions that all must be true. This wraps conditions in parentheses and joins them with AND keywords.

 DatabaseSchemaLayout layout = getHSQLLayout();
 Table table = layout.getCurrentSchema().getTable("customer");
 
 SQLStatement query = table
     .select()
     .column(table.getColumn("name"))
     .where()
         .equals(column, value)
         .and() // BooleanAndStatement
             .greaterThan(table.getColumn("height"), value)
             .lessThan(table.getColumn("maximum"), value)
         .end()
     .done();
 

Author:

jbanes

Constructor Summary

Constructors

Constructor	Description
BooleanAndStatement(DatabaseSchemaLayout layout)

Method Summary

Modifier and Type	Method	Description
SQLStatement	done()
WhereStatement	end()
SQLRenderer	render(SQLRenderer renderer)
WhereStatement	where()

Methods inherited from class com.invirgance.convirgance.jdbc.sql.WhereStatement

and, equals, equals, equals, equals, equals, filter, filter, filter, filter, filter, getClauses, getParent, greaterThan, greaterThan, greaterThan, greaterThan, greaterThan, greaterThanOrEquals, greaterThanOrEquals, greaterThanOrEquals, greaterThanOrEquals, greaterThanOrEquals, isNotNull, isNotNull, isNotNull, isNotNull, isNull, isNull, isNull, isNull, lessThan, lessThan, lessThan, lessThan, lessThan, lessThanOrEquals, lessThanOrEquals, lessThanOrEquals, lessThanOrEquals, lessThanOrEquals, not, notEquals, notEquals, notEquals, notEquals, notEquals, or, setParent, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface com.invirgance.convirgance.jdbc.sql.SQLStatement

getParent, query, query, setParent

Constructor Details

BooleanAndStatement

public BooleanAndStatement(DatabaseSchemaLayout layout)

Method Details

done

public SQLStatement done()

Overrides:

done in class WhereStatement

end

public WhereStatement end()

Overrides:

end in class WhereStatement

where

public WhereStatement where()

Overrides:

where in class WhereStatement

render

public SQLRenderer render(SQLRenderer renderer)

Specified by:

render in interface SQLStatement

Overrides:

render in class WhereStatement