Package net.bugreaper.modules.db.jdbc.builders

Class QueryConditionsBuilder

java.lang.Object
net.bugreaper.modules.db.jdbc.builders.QueryConditionsBuilder
Direct Known Subclasses:
QueryBuilder
public class QueryConditionsBuilder extends Object

  • Constructor Details

    • QueryConditionsBuilder

      public QueryConditionsBuilder(String dbType)

  • Method Details

    • arrayCondition4Mapper

      protected StringBuilder arrayCondition4Mapper(Object[] conditionsArray)
      Used for Oracle Date\DateTime select conditions
      Parameters:
      conditionsArray - array with conditions: Oracle(Date\DateTime) {column, operator, date, enum}

      Oracle:

      {"COLUMN NAME", ">= ", "2020-01-01", "DATE"} will build: COLUMN NAME" >= TO_DATE('2022-01-01’, 'YYYY-MM-DD')

      {"COLUMN NAME", "=", "2022-01-01 10:10:22", "TIMESTAMP"} will build: COLUMN NAME = TO_DATE('2022-01-01 10:10:22’, 'YYYY-MM-DD HH24:MI:SS')

    • arrayCondition3Mapper

      protected StringBuilder arrayCondition3Mapper(Object[] conditionsArray)

    • arrayCondition2Mapper

      protected StringBuilder arrayCondition2Mapper(Object[] conditionsArray)