de.fraunhofer.igd.klarschiff.dao

Class SqlQueryHelper

java.lang.Object

de.fraunhofer.igd.klarschiff.dao.SqlQueryHelper

public class SqlQueryHelper
extends Object

Mit Hilfe der Klasse wird die Erstellung von korrekten SQL-Anfragen vereinfacht. Dabei werden die Angaben wie Projektion (SelectAttributes), Selektion (WhereConditions) etc. separat nacheinander angegeben. Die SQL-Anfrage kann dann mit der Methode getSqlQuery() ermittelt werden. Analog dazu kann die Anfrage an die DB direkt mit Hilfe der Funktion getResultList(EntityManger) oder getSingleResult(EntityManger) gestellt werden.

Author:

Stefan Audersch (Fraunhofer IGD)

Field Summary

Fields

Modifier and Type	Field and Description
(package private) boolean	distinctEnable
(package private) Integer	firstResult
(package private) Set<String>	fromTables
private static org.apache.commons.logging.Log	logger
(package private) Integer	maxResults
(package private) List<String>	orderByAttributes
(package private) Map<String,Object>	params
(package private) Set<String>	selectAttributes
(package private) Set<String>	whereConditions

Constructor Summary

Constructors

Constructor and Description
SqlQueryHelper()

Method Summary

Modifier and Type	Method and Description
SqlQueryHelper	addFromTables(String table)
SqlQueryHelper	addLikeParameter(String key, String value)
SqlQueryHelper	addParameter(String key, Object value)
SqlQueryHelper	addSelectAttribute(String attribute)
SqlQueryHelper	addWhereConditions(String condition)
SqlQueryHelper	addWhereInConditions(String attribute, Collection<String> values)
SqlQueryHelper	distinct(boolean distinctEnable)
SqlQueryHelper	firstResult(Integer startPosition)
Map<String,Object>	getParameterMap()
List	getResultList(javax.persistence.EntityManager entityManager)
Object	getSingleResult(javax.persistence.EntityManager entityManager)
String	getSqlQuery()
SqlQueryHelper	maxResults(Integer maxResult)
SqlQueryHelper	orderBy(String attribute)

Methods inherited from class java.lang.Object

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

Field Detail

logger

private static final org.apache.commons.logging.Log logger

selectAttributes

Set<String> selectAttributes

fromTables

Set<String> fromTables

whereConditions

Set<String> whereConditions

orderByAttributes

List<String> orderByAttributes

params

Map<String,Object> params

distinctEnable

boolean distinctEnable

firstResult

Integer firstResult

maxResults

Integer maxResults

Constructor Detail

SqlQueryHelper

public SqlQueryHelper()

Method Detail

addSelectAttribute

public SqlQueryHelper addSelectAttribute(String attribute)

addFromTables

public SqlQueryHelper addFromTables(String table)

addWhereConditions

public SqlQueryHelper addWhereConditions(String condition)

addWhereInConditions

public SqlQueryHelper addWhereInConditions(String attribute,
                                           Collection<String> values)

addParameter

public SqlQueryHelper addParameter(String key,
                                   Object value)

addLikeParameter

public SqlQueryHelper addLikeParameter(String key,
                                       String value)

distinct

public SqlQueryHelper distinct(boolean distinctEnable)

firstResult

public SqlQueryHelper firstResult(Integer startPosition)

maxResults

public SqlQueryHelper maxResults(Integer maxResult)

orderBy

public SqlQueryHelper orderBy(String attribute)

getSqlQuery

public String getSqlQuery()

getParameterMap

public Map<String,Object> getParameterMap()

getSingleResult

public Object getSingleResult(javax.persistence.EntityManager entityManager)

getResultList

public List getResultList(javax.persistence.EntityManager entityManager)