org.hrorm

Class SqlBuilder<ENTITY>

java.lang.Object

org.hrorm.SqlBuilder<ENTITY>

Type Parameters:

ENTITY - The type of the entity being persisted.

All Implemented Interfaces:

Queries

public class SqlBuilder<ENTITY>
extends Object
implements Queries

This class generates SQL strings suitable to be used in PreparedStatements.

Most users of hrorm will have no need to directly use this.

Constructor Summary

Constructors

Constructor and Description
SqlBuilder(DaoDescriptor<ENTITY,?> daoDescriptor)
SqlBuilder(KeylessDaoDescriptor<ENTITY,?> daoDescriptor)

Method Summary

Modifier and Type	Method and Description
String	delete()
String	insert()
String	nextSequence()
String	select()
String	select(Order order)
String	select(Where where)
String	select(Where where, Order order)
String	selectByColumns(ColumnSelection selectColumnList)
String	selectByColumns(ColumnSelection columnSelection, Order order)
String	selectByParentSubSelect(String subSelect)
String	selectChildIds()
String	selectDistinct(Where where, String... columnNames)
String	selectFunction(SqlFunction function, String columnName, Where where)
String	selectPrimaryKey(String subselect)
String	selectPrimaryKey(Where where)
String	selectPrimaryKeyOfJoinedColumn(StatementPopulator statementPopulator, String joinedColumnName)
String	update()

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlBuilder

public SqlBuilder(DaoDescriptor<ENTITY,?> daoDescriptor)

SqlBuilder

public SqlBuilder(KeylessDaoDescriptor<ENTITY,?> daoDescriptor)

Method Detail

select

public String select()

Specified by:

select in interface Queries

selectPrimaryKey

public String selectPrimaryKey(Where where)

selectPrimaryKey

public String selectPrimaryKey(String subselect)

selectPrimaryKeyOfJoinedColumn

public String selectPrimaryKeyOfJoinedColumn(StatementPopulator statementPopulator,
                                             String joinedColumnName)

select

public String select(Order order)

select

public String select(Where where)

Specified by:

select in interface Queries

select

public String select(Where where,
                     Order order)

selectDistinct

public String selectDistinct(Where where,
                             String... columnNames)

selectFunction

public String selectFunction(SqlFunction function,
                             String columnName,
                             Where where)

selectByColumns

public String selectByColumns(ColumnSelection selectColumnList)

selectByColumns

public String selectByColumns(ColumnSelection columnSelection,
                              Order order)

insert

public String insert()

Specified by:

insert in interface Queries

selectChildIds

public String selectChildIds()

selectByParentSubSelect

public String selectByParentSubSelect(String subSelect)

update

public String update()

Specified by:

update in interface Queries

delete

public String delete()

Specified by:

delete in interface Queries

nextSequence

public String nextSequence()