com.lucidchart.open.relate

SqlStatement

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
Learn more about member selection
Visibility
  1. Public
  2. All

Instance Constructors

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

Value Members

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

    Definition Classes
    AnyRef

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

    Definition Classes
    Any

  3. final def ##(): Int

    Definition Classes
    AnyRef → Any

  4. final def ==(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef

  5. final def ==(arg0: Any): Boolean

    Definition Classes
    Any

  6. final def asInstanceOf[T0]: T0

    Definition Classes
    Any

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

    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

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

    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

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

    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

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

    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

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

    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

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

    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

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

    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

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

    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

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

    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

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

    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

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

    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

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

    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

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

    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

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

    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

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

    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

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

    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

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

    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

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

    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

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

    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

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

    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

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

    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

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

    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

  29. def clone(): AnyRef

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  30. def date(name: String, value: Date): Unit

    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

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

    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

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

    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

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

    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

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

    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

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

    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

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

    Definition Classes
    AnyRef

  37. def equals(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any

  38. def finalize(): Unit

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )

  39. def float(name: String, value: Float): Unit

    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

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

    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

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

    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

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

    Definition Classes
    AnyRef → Any

  43. def hashCode(): Int

    Definition Classes
    AnyRef → Any

  44. def int(name: String, value: Int): Unit

    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

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

    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

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

    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

  47. final def isInstanceOf[T0]: Boolean

    Definition Classes
    Any

  48. val listParams: Map[String, ListParam]

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

    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

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

    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

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

    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

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

  53. final def ne(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef

  54. final def notify(): Unit

    Definition Classes
    AnyRef

  55. final def notifyAll(): Unit

    Definition Classes
    AnyRef

  56. def short(name: String, value: Short): Unit

    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

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

    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

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

    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

  59. val stmt: PreparedStatement

  60. def string(name: String, value: String): Unit

    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

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

    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

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

    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

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

    Definition Classes
    AnyRef

  64. def timestamp(name: String, value: Timestamp): Unit

    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

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

    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

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

    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

  67. def toString(): String

    Definition Classes
    AnyRef → Any

  68. def uuid(name: String, value: UUID): Unit

    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

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

    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

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

    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

  71. final def wait(): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  72. final def wait(arg0: Long, arg1: Int): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  73. final def wait(arg0: Long): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

Inherited from AnyRef

Inherited from Any

Ungrouped