Class Select


  • public class Select
    extends Object
    A simple SQL SELECT statement
    • Field Detail

      • dialect

        public final Dialect dialect
    • Constructor Detail

      • Select

        public Select​(Dialect dialect)
    • Method Detail

      • toStatementString

        public String toStatementString()
        Construct an SQL SELECT statement from the given clauses
      • setFromClause

        public Select setFromClause​(String fromClause)
        Sets the fromClause.
        Parameters:
        fromClause - The fromClause to set
      • setOrderByClause

        public Select setOrderByClause​(String orderByClause)
      • setGroupByClause

        public Select setGroupByClause​(String groupByClause)
      • setOuterJoins

        public Select setOuterJoins​(String outerJoinsAfterFrom,
                                    String outerJoinsAfterWhere)
      • setSelectClause

        public Select setSelectClause​(String selectClause)
        Sets the selectClause.
        Parameters:
        selectClause - The selectClause to set
      • setWhereClause

        public Select setWhereClause​(String whereClause)
        Sets the whereClause.
        Parameters:
        whereClause - The whereClause to set
      • getLockMode

        @Deprecated
        public LockMode getLockMode()
        Deprecated.
        Instead use getLockOptions
        Get the current lock mode
        Returns:
        LockMode
      • setLockMode

        @Deprecated
        public Select setLockMode​(LockMode lockMode)
        Deprecated.
        Instead use setLockOptions
        Set the lock mode
        Parameters:
        lockMode -
        Returns:
        this object
      • getLockOptions

        public LockOptions getLockOptions()
        Get the current lock options
        Returns:
        LockOptions
      • setLockOptions

        public Select setLockOptions​(LockOptions lockOptions)
        Set the lock options
        Parameters:
        lockOptions -
        Returns:
        this object