Package org.opencms.db

Class CmsDbUtil

java.lang.Object

org.opencms.db.CmsDbUtil

public final class CmsDbUtil
extends Object

Generic database utility functions.

Since:

8.0.0

Method Summary

Modifier and Type	Method	Description
static CmsSimpleQueryFragment	columnEquals(String column, Object o)	Creates an expression for comparing a column with a constant.
static CmsSimpleQueryFragment	columnLike(String column, String str)	Creates an expression for matching a column with a constant pattern.
static void	fillParameters(PreparedStatement stmt, List<Object> params)	Fills a given prepared statement with parameters from a list of objects.

Methods inherited from class java.lang.Object

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

Method Details

fillParameters

public static void fillParameters(PreparedStatement stmt,
 List<Object> params)
                           throws SQLException

Fills a given prepared statement with parameters from a list of objects.

Parameters:

stmt - the prepared statement

params - the parameter objects

Throws:

SQLException - if something goes wrong

columnEquals

public static CmsSimpleQueryFragment columnEquals(String column,
 Object o)

Creates an expression for comparing a column with a constant.

Parameters:

column - the column name

o - the constant

Returns:

the query expression

columnLike

public static CmsSimpleQueryFragment columnLike(String column,
 String str)

Creates an expression for matching a column with a constant pattern.

Parameters:

column - the column name

str - the pattern string

Returns:

the query expression