Package org.opencms.db

Class 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.

      • Methods inherited from class java.lang.Object

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

    • 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 statement
        params - 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 name
        o - 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 name
        str - the pattern string
        Returns:
        the query expression