Package jp.ecuacion.tool.housekeepdb.util

Class SqlUtil

java.lang.Object

jp.ecuacion.tool.housekeepdb.util.SqlUtil

public class SqlUtil
extends Object

Provides utilities to build sql sentence.

Method Summary

Modifier and Type	Method	Description
static String	getTimestampNow(String protocol)	Provides current date-time string considering database kinds.
static String	getUpdateSet(List<SqlConditionInterface> list)	Creates set clause in update sentence.
static String	getUpdateSet(SqlConditionInterface... array)	Creates set clause in update sentence.
static String	getWhere(List<SqlConditionInterface> list)	Creates where clause.
static String	getWhere(SqlConditionInterface... array)	Creates where clause.

Methods inherited from class java.lang.Object

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

Method Details

getTimestampNow

public static String getTimestampNow(String protocol)

Provides current date-time string considering database kinds.

Parameters:

protocol - database kind like 'postgresql'

Returns:

date-time string

getWhere

public static String getWhere(List<SqlConditionInterface> list)

Creates where clause.

Parameters:

list - a list of SqlConditionInterface

Returns:

where clause

getWhere

public static String getWhere(SqlConditionInterface... array)

Creates where clause.

Parameters:

array - an array of SqlConditionInterface

Returns:

where clause

getUpdateSet

public static String getUpdateSet(List<SqlConditionInterface> list)

Creates set clause in update sentence.

Parameters:

list - a list of SqlConditionInterface

Returns:

set clause

getUpdateSet

public static String getUpdateSet(SqlConditionInterface... array)

Creates set clause in update sentence.

Parameters:

array - an array of SqlConditionInterface

Returns:

set clause