Module org.seasar.doma.core
Package org.seasar.doma.jdbc.builder

Class UpdateBuilder

java.lang.Object
org.seasar.doma.jdbc.builder.UpdateBuilder
public class UpdateBuilder extends Object
A builder for an SQL UPDATE statement.

This is not thread safe.

Java

 UpdateBuilder builder = UpdateBuilder.newInstance(config);
 builder.sql("update Emp");
 builder.sql("set");
 builder.sql("name = ").param(String.class, "SMIHT").sql(",");
 builder.sql("salary = ").param(BigDecimal.class, new BigDecimal("1000"));
 builder.sql("where");
 builder.sql("id = ").param(int.class, 1000);
 builder.execute();

built SQL

 update Emp
 set
 name = 'SMIHT',
 salary = 1000
 where
 id = 10

  • Method Details

    • newInstance

      public static UpdateBuilder newInstance(Config config)
      Creates a new instance.
      Parameters:
      config - the configuration
      Returns:
      a builder
      Throws:
      DomaNullPointerException - if config is null

    • sql

      public UpdateBuilder sql(String sql)
      Appends an SQL fragment.
      Parameters:
      sql - the SQL fragment
      Returns:
      a builder
      Throws:
      DomaNullPointerException - if sql is null

    • removeLast

      public UpdateBuilder removeLast()
      Removes the last SQL fragment or parameter.
      Returns:
      a builder

    • param

      public <P> UpdateBuilder param(Class<P> paramClass, P param)
      Appends a parameter.

      The parameter type must be one of basic types or holder types.

      Type Parameters:
      P - the parameter type
      Parameters:
      paramClass - the parameter class
      param - the parameter
      Returns:
      a builder
      Throws:
      DomaNullPointerException - if paramClass is null

    • params

      public <E> UpdateBuilder params(Class<E> elementClass, List<E> params)
      Appends a parameter list.

      The element type of the list must be one of basic types or holder types.

      Type Parameters:
      E - the element type of the list
      Parameters:
      elementClass - the element class of the list
      params - the parameter list
      Returns:
      a builder
      Throws:
      DomaNullPointerException - if elementClass or params is null

    • literal

      public <P> UpdateBuilder literal(Class<P> paramClass, P param)
      Appends a parameter as literal.

      The parameter type must be one of basic types or holder types.

      Type Parameters:
      P - the parameter type
      Parameters:
      paramClass - the parameter class
      param - the parameter
      Returns:
      a builder
      Throws:
      DomaNullPointerException - if paramClass is null

    • literals

      public <E> UpdateBuilder literals(Class<E> elementClass, List<E> params)
      Appends a parameter list as literal.

      The element type of the list must be one of basic types or holder types.

      Type Parameters:
      E - the element type of the list
      Parameters:
      elementClass - the element class of the list
      params - the parameter list
      Returns:
      a builder
      Throws:
      DomaNullPointerException - if elementClass or params is null

    • execute

      public int execute()
      Executes an SQL UPDATE statement.
      Returns:
      the affected rows count
      Throws:
      UniqueConstraintException - if an unique constraint violation occurs
      JdbcException - if a JDBC related error occurs

    • queryTimeout

      public void queryTimeout(int queryTimeout)
      Sets the query timeout limit in seconds.

      If not specified, the value of Config.getQueryTimeout() is used.

      Parameters:
      queryTimeout - the query timeout limit in seconds
      See Also:

    • callerClassName

      public void callerClassName(String className)
      Sets the caller class name.

      If not specified, the class name of this instance is used.

      Parameters:
      className - the caller class name
      Throws:
      DomaNullPointerException - if className is null

    • sqlLogType

      public void sqlLogType(SqlLogType sqlLogType)
      Sets the SQL log format.
      Parameters:
      sqlLogType - the SQL log format type

    • callerMethodName

      public void callerMethodName(String methodName)
      Sets the caller method name.

      if not specified, execute is used.

      Parameters:
      methodName - the caller method name
      Throws:
      DomaNullPointerException - if methodName is null

    • getSql

      public Sql<?> getSql()
      Returns the built SQL.
      Returns:
      the built SQL