Package sk.iway.iwcm.database

Class SimpleQuery

java.lang.Object
sk.iway.iwcm.database.SimpleQuery
public class SimpleQuery extends Object
SimpleQueryResolver.java A class encapsulating some simple database operations, like retrieving a single integer, single object, a list of single columns, etc.

  • Constructor Details

    • SimpleQuery

      public SimpleQuery()

    • SimpleQuery

      public SimpleQuery(String databaseName)

  • Method Details

    • execute

      public void execute(String sql, Object... arguments)

    • executeWithUpdateCount

      public int executeWithUpdateCount(String sql, Object... arguments)
      Execute SQL and returns updateCount (count of changed rows)
      Parameters:
      sql -
      arguments -
      Returns:

    • forInt

      public int forInt(String sql, Object... parameters)

    • forLong

      public long forLong(String sql, Object... parameters)

    • forString

      public String forString(String sql, Object... parameters)

    • forObject

      public Object forObject(String sql, Object... parameters)

    • forDouble

      public double forDouble(String sql, Object... parameters)

    • forBigDecimal

      public BigDecimal forBigDecimal(String sql, Object... parameters)

    • forBoolean

      public Boolean forBoolean(String sql, Object... parameters)

    • forBooleanWithNull

      public Boolean forBooleanWithNull(String sql, Object... parameters)

    • forListInteger

      public List<Integer> forListInteger(String sql, Object... parameters)

    • forListNumber

      public List<Number> forListNumber(String sql, Object... parameters)

    • forListString

      public List<String> forListString(String sql, Object... parameters)

    • forList

      public List forList(String sql, Object... parameters)

    • executeInTransaction

      public boolean executeInTransaction(List<String> sqlCommands, List<Object[]> theirParameters)

    • forDate

      public Date forDate(String sql, Object... parameters)

    • bindParameters

      public static String bindParameters(PreparedStatement ps, Object... parameters) throws SQLException
      Nabinduje parametre pre preparedStatement, Date sa musia bindovat cez setTimestamp, inak sa vracaju zle vysledky vrati String bindnutych parametrov, ak je logLevel DEBUG
      Parameters:
      ps -
      parameters -
      Returns:
      Throws:
      SQLException