Package org.opencms.db
Class CmsDbUtil
- java.lang.Object
-
- org.opencms.db.CmsDbUtil
-
public final class CmsDbUtil extends java.lang.Object
Generic database utility functions.- Since:
- 8.0.0
-
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static CmsSimpleQueryFragment
columnEquals(java.lang.String column, java.lang.Object o)
Creates an expression for comparing a column with a constant.static CmsSimpleQueryFragment
columnLike(java.lang.String column, java.lang.String str)
Creates an expression for matching a column with a constant pattern.static void
fillParameters(java.sql.PreparedStatement stmt, java.util.List<java.lang.Object> params)
Fills a given prepared statement with parameters from a list of objects.
-
-
-
Method Detail
-
fillParameters
public static void fillParameters(java.sql.PreparedStatement stmt, java.util.List<java.lang.Object> params) throws java.sql.SQLException
Fills a given prepared statement with parameters from a list of objects.- Parameters:
stmt
- the prepared statementparams
- the parameter objects- Throws:
java.sql.SQLException
- if something goes wrong
-
columnEquals
public static CmsSimpleQueryFragment columnEquals(java.lang.String column, java.lang.Object o)
Creates an expression for comparing a column with a constant.- Parameters:
column
- the column nameo
- the constant- Returns:
- the query expression
-
columnLike
public static CmsSimpleQueryFragment columnLike(java.lang.String column, java.lang.String str)
Creates an expression for matching a column with a constant pattern.- Parameters:
column
- the column namestr
- the pattern string- Returns:
- the query expression
-
-