Class

com.lucidchart.open.relate

SqlStatement

Related Doc: package relate

Permalink

class SqlStatement extends AnyRef

A smart wrapper around the PreparedStatement class that allows inserting parameter values by name rather than by index. Provides methods for inserting all necessary datatypes.

Linear Supertypes
AnyRef, Any
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. SqlStatement
  2. AnyRef
  3. Any
  1. Hide All
  2. Show all
Visibility
  1. Public
  2. All

Instance Constructors

  1. new SqlStatement(stmt: PreparedStatement, names: Map[String, List[Int]], listParams: Map[String, ListParam])

    Permalink

Value Members

  1. final def !=(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any
  2. final def ##(): Int

    Permalink
    Definition Classes
    AnyRef → Any
  3. final def ==(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any
  4. final def asInstanceOf[T0]: T0

    Permalink
    Definition Classes
    Any
  5. def bigDecimal(name: String, value: BigDecimal): Unit

    Permalink

    Set a Java BigDecimal in the PreparedStatement

    Set a Java BigDecimal in the PreparedStatement

    name

    the name of the parameter to put the BigDecimal in

    value

    the BigDecimal to put in the query

  6. def bigDecimal(name: String, value: BigDecimal): Unit

    Permalink

    Set a BigDecimal in the PreparedStatement

    Set a BigDecimal in the PreparedStatement

    name

    the name of the parameter to put the BigDecimal in

    value

    the BigDecimal to put in the query

  7. def bigDecimalOption[A](name: String, value: Option[A])(implicit bd: BigDecimalLike[A]): Unit

    Permalink

    Insert a BigDecimal Option into the PreparedStatement

    Insert a BigDecimal Option into the PreparedStatement

    name

    the name of the parameter to the value into

    value

    the Option to insert

  8. def bigDecimals[X](name: String, values: TraversableOnce[BigDecimal])(implicit arg0: ClassTag[X]): Unit

    Permalink

    Insert multiple Java BigDecimals into the PreparedStatement

    Insert multiple Java BigDecimals into the PreparedStatement

    name

    the name of the parameter to put the values into

    values

    the values to put into the query

  9. def bigDecimals(name: String, values: TraversableOnce[BigDecimal]): Unit

    Permalink

    Insert multiple BigDecimals into the PreparedStatement

    Insert multiple BigDecimals into the PreparedStatement

    name

    the name of the parameter to put the values into

    values

    the values to put into the query

  10. def bigInt(name: String, value: BigInteger): Unit

    Permalink

    Set a Java BigInteger in the PreparedStatement

    Set a Java BigInteger in the PreparedStatement

    name

    the name of the parameter to put the BigInteger in

    value

    the BigInteger to put in the query

  11. def bigInt(name: String, value: BigInt): Unit

    Permalink

    Set a BigInt in the PreparedStatement

    Set a BigInt in the PreparedStatement

    name

    the name of the parameter to put the BigInt in

    value

    the BigInt to put into the query

  12. def bigIntOption[A](name: String, value: Option[A])(implicit bd: BigIntLike[A]): Unit

    Permalink

    Insert a BigInt Option into the PreparedStatement

    Insert a BigInt Option into the PreparedStatement

    name

    the name of the parameter to the value into

    value

    the Option to insert

  13. def bigInts[X](name: String, values: TraversableOnce[BigInteger])(implicit arg0: ClassTag[X]): Unit

    Permalink

    Insert multiple Java BigIntegers into the PreparedStatement

    Insert multiple Java BigIntegers into the PreparedStatement

    name

    the name of the parameter to put the values into

    values

    the values to put into the query

  14. def bigInts(name: String, values: TraversableOnce[BigInt]): Unit

    Permalink

    Insert multiple BigInts into the PreparedStatement

    Insert multiple BigInts into the PreparedStatement

    name

    the name of the parameter to put the values into

    values

    the values to put into the query

  15. def bool(name: String, value: Boolean): Unit

    Permalink

    Set a Boolean in the PreparedStatement

    Set a Boolean in the PreparedStatement

    name

    the name of the parameter to put the Boolean in

    value

    the Boolean to put in the query

  16. def boolOption(name: String, value: Option[Boolean]): Unit

    Permalink

    Insert a Boolean Option into the PreparedStatement

    Insert a Boolean Option into the PreparedStatement

    name

    the name of the parameter to the value into

    value

    the Option to insert

  17. def bools(name: String, values: TraversableOnce[Boolean]): Unit

    Permalink

    Insert multiple Booleans into the PreparedStatement

    Insert multiple Booleans into the PreparedStatement

    name

    the name of the parameter to put the values into

    values

    the values to put into the query

  18. def byte(name: String, value: Byte): Unit

    Permalink

    Set a Byte in the PreparedStatement

    Set a Byte in the PreparedStatement

    name

    the name of the parameter to put the Byte in

    value

    the Byte to put in the query

  19. def byteArray(name: String, value: Array[Byte]): Unit

    Permalink

    Set a ByteArray in the PreparedStatement

    Set a ByteArray in the PreparedStatement

    name

    the name of the parameter to put the ArrayByte in

    value

    the ByteArray to put in the query

  20. def byteArrayOption(name: String, value: Option[Array[Byte]]): Unit

    Permalink

    Insert a Byte Array Option into the PreparedStatement

    Insert a Byte Array Option into the PreparedStatement

    name

    the name of the parameter to the value into

    value

    the Option to insert

  21. def byteArrays(name: String, values: TraversableOnce[Array[Byte]]): Unit

    Permalink

    Insert multiple Byte Arrays into the PreparedStatement

    Insert multiple Byte Arrays into the PreparedStatement

    name

    the name of the parameter to put the values into

    values

    the values to put into the query

  22. def byteOption(name: String, value: Option[Byte]): Unit

    Permalink

    Insert a Byte Option into the PreparedStatement

    Insert a Byte Option into the PreparedStatement

    name

    the name of the parameter to the value into

    value

    the Option to insert

  23. def bytes(name: String, values: TraversableOnce[Byte]): Unit

    Permalink

    Insert multiple Bytes into the PreparedStatement

    Insert multiple Bytes into the PreparedStatement

    name

    the name of the parameter to put the values into

    values

    the values to put into the query

  24. def char(name: String, value: Char): Unit

    Permalink

    Set a Char in the PreparedStatement

    Set a Char in the PreparedStatement

    name

    the name of the parameter to put the Char in

    value

    the Char to put in the query

  25. def charOption(name: String, value: Option[Char]): Unit

    Permalink

    Insert a Char Option into the PreparedStatement

    Insert a Char Option into the PreparedStatement

    name

    the name of the parameter to the value into

    value

    the Option to insert

  26. def chars(name: String, values: TraversableOnce[Char]): Unit

    Permalink

    Insert multiple Chars into the PreparedStatement

    Insert multiple Chars into the PreparedStatement

    name

    the name of the parameter to put the values into

    values

    the values to put into the query

  27. def clone(): AnyRef

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  28. def date(name: String, value: Date): Unit

    Permalink

    Set a Date in the PreparedStatement

    Set a Date in the PreparedStatement

    name

    the name of the parameter to put the Date in

    value

    the Date to put in the query

  29. def dateOption(name: String, value: Option[Date]): Unit

    Permalink

    Insert a Date Option into the PreparedStatement

    Insert a Date Option into the PreparedStatement

    name

    the name of the parameter to the value into

    value

    the Option to insert

  30. def dates(name: String, values: TraversableOnce[Date]): Unit

    Permalink

    Insert multiple Dates into the PreparedStatement

    Insert multiple Dates into the PreparedStatement

    name

    the name of the parameter to put the values into

    values

    the values to put into the query

  31. def double(name: String, value: Double): Unit

    Permalink

    Set a Double in the PreparedStatement

    Set a Double in the PreparedStatement

    name

    the name of the parameter to put the Double in

    value

    the Double to put in the query

  32. def doubleOption(name: String, value: Option[Double]): Unit

    Permalink

    Insert a Double Option into the PreparedStatement

    Insert a Double Option into the PreparedStatement

    name

    the name of the parameter to the value into

    value

    the Option to insert

  33. def doubles(name: String, values: TraversableOnce[Double]): Unit

    Permalink

    Insert multiple Doubles into the PreparedStatement

    Insert multiple Doubles into the PreparedStatement

    name

    the name of the parameter to put the values into

    values

    the values to put into the query

  34. final def eq(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef
  35. def equals(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any
  36. def finalize(): Unit

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  37. def float(name: String, value: Float): Unit

    Permalink

    Set a Float in the PreparedStatement

    Set a Float in the PreparedStatement

    name

    the name of the parameter to put the Float in

    value

    the Float to put in the query

  38. def floatOption(name: String, value: Option[Float]): Unit

    Permalink

    Insert a Float Option into the PreparedStatement

    Insert a Float Option into the PreparedStatement

    name

    the name of the parameter to the value into

    value

    the Option to insert

  39. def floats(name: String, values: TraversableOnce[Float]): Unit

    Permalink

    Insert multiple Floats into the PreparedStatement

    Insert multiple Floats into the PreparedStatement

    name

    the name of the parameter to put the values into

    values

    the values to put into the query

  40. final def getClass(): Class[_]

    Permalink
    Definition Classes
    AnyRef → Any
  41. def hashCode(): Int

    Permalink
    Definition Classes
    AnyRef → Any
  42. def int(name: String, value: Int): Unit

    Permalink

    Set an Int in the PreparedStatement

    Set an Int in the PreparedStatement

    name

    the name of the parameter to put the int in

    value

    the int to put in the query

  43. def intOption(name: String, value: Option[Int]): Unit

    Permalink

    Insert an Int Option into the PreparedStatement

    Insert an Int Option into the PreparedStatement

    name

    the name of the parameter to the value into

    value

    the Option to insert

  44. def ints(name: String, values: TraversableOnce[Int]): Unit

    Permalink

    Insert multiple Ints into the PreparedStatement

    Insert multiple Ints into the PreparedStatement

    name

    the name of the parameter to put the values into

    values

    the values to put into the query

  45. final def isInstanceOf[T0]: Boolean

    Permalink
    Definition Classes
    Any
  46. val listParams: Map[String, ListParam]

    Permalink
  47. def long(name: String, value: Long): Unit

    Permalink

    Set a Long in the PreparedStatement

    Set a Long in the PreparedStatement

    name

    the name of the parameter to put the Long in

    value

    the Long to put in the query

  48. def longOption(name: String, value: Option[Long]): Unit

    Permalink

    Insert a Long Option into the PreparedStatement

    Insert a Long Option into the PreparedStatement

    name

    the name of the parameter to the value into

    value

    the Option to insert

  49. def longs(name: String, values: TraversableOnce[Long]): Unit

    Permalink

    Insert multiple Longs into the PreparedStatement

    Insert multiple Longs into the PreparedStatement

    name

    the name of the parameter to put the values into

    values

    the values to put into the query

  50. val names: Map[String, List[Int]]

    Permalink
  51. final def ne(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef
  52. final def notify(): Unit

    Permalink
    Definition Classes
    AnyRef
  53. final def notifyAll(): Unit

    Permalink
    Definition Classes
    AnyRef
  54. def short(name: String, value: Short): Unit

    Permalink

    Set a Short in the PreparedStatement

    Set a Short in the PreparedStatement

    name

    the name of the parameter to put the Short in

    value

    the Short to put in the query

  55. def shortOption(name: String, value: Option[Short]): Unit

    Permalink

    Insert a Short Option into the PreparedStatement

    Insert a Short Option into the PreparedStatement

    name

    the name of the parameter to the value into

    value

    the Option to insert

  56. def shorts(name: String, values: TraversableOnce[Short]): Unit

    Permalink

    Insert multiple Shorts into the PreparedStatement

    Insert multiple Shorts into the PreparedStatement

    name

    the name of the parameter to put the values into

    values

    the values to put into the query

  57. val stmt: PreparedStatement

    Permalink
  58. def string(name: String, value: String): Unit

    Permalink

    Set a String in the PreparedStatement

    Set a String in the PreparedStatement

    name

    the name of the parameter to put the string in

    value

    the value to put in the query

  59. def stringOption(name: String, value: Option[String]): Unit

    Permalink

    Insert a String Option into the PreparedStatement

    Insert a String Option into the PreparedStatement

    name

    the name of the parameter to the value into

    value

    the Option to insert

  60. def strings(name: String, values: TraversableOnce[String]): Unit

    Permalink

    Insert multiple Strings into the PreparedStatement

    Insert multiple Strings into the PreparedStatement

    name

    the name of the parameter to put the values into

    values

    the values to put into the query

  61. final def synchronized[T0](arg0: ⇒ T0): T0

    Permalink
    Definition Classes
    AnyRef
  62. def timestamp(name: String, value: Timestamp): Unit

    Permalink

    Set a Timestamp in the PreparedStatement

    Set a Timestamp in the PreparedStatement

    name

    the name of the parameter to put the Timestamp in

    value

    the Timestamp to put into the query

  63. def timestampOption(name: String, value: Option[Timestamp]): Unit

    Permalink

    Insert a Timestamp Option into the PreparedStatement

    Insert a Timestamp Option into the PreparedStatement

    name

    the name of the parameter to the value into

    value

    the Option to insert

  64. def timestamps(name: String, values: TraversableOnce[Timestamp]): Unit

    Permalink

    Insert multiple Timestamps into the PreparedStatement

    Insert multiple Timestamps into the PreparedStatement

    name

    the name of the parameter to put the values into

    values

    the values to put into the query

  65. def toString(): String

    Permalink
    Definition Classes
    AnyRef → Any
  66. def uuid(name: String, value: UUID): Unit

    Permalink

    Set a UUID in the PreparedStatement

    Set a UUID in the PreparedStatement

    name

    the name of the parameter to put the UUID in

    value

    the UUID to put in the query

  67. def uuidOption(name: String, value: Option[UUID]): Unit

    Permalink

    Insert an UUID Option into the PreparedStatement

    Insert an UUID Option into the PreparedStatement

    name

    the name of the parameter to the value into

    value

    the Option to insert

  68. def uuids(name: String, values: TraversableOnce[UUID]): Unit

    Permalink

    Insert multiple UUIDs into the PreparedStatement

    Insert multiple UUIDs into the PreparedStatement

    name

    the name of the parameter to put the values into

    values

    the values to put into the query

  69. final def wait(): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  70. final def wait(arg0: Long, arg1: Int): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  71. final def wait(arg0: Long): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

Inherited from AnyRef

Inherited from Any

Ungrouped