com.lucidchart.open.relate

SqlStatement

Related Doc: package relate

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: Any): Boolean

    Definition Classes
    AnyRef → Any

  2. final def ##(): Int

    Definition Classes
    AnyRef → Any

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

    Definition Classes
    AnyRef → Any

  4. final def asInstanceOf[T0]: T0

    Definition Classes
    Any

  5. 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

  6. 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

  7. 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

  8. 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

  9. 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

  10. 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

  11. 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

  12. 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

  13. 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

  14. 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

  15. 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

  16. 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

  17. 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

  18. 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

  19. 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

  20. 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

  21. 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

  22. 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

  23. 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

  24. 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

  25. 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

  26. 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

  27. def clone(): AnyRef

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

  28. 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

  29. 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

  30. 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

  31. 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

  32. 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

  33. 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

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

    Definition Classes
    AnyRef

  35. def equals(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any

  36. def finalize(): Unit

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

  37. 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

  38. 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

  39. 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

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

    Definition Classes
    AnyRef → Any

  41. def hashCode(): Int

    Definition Classes
    AnyRef → Any

  42. 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

  43. 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

  44. 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

  45. final def isInstanceOf[T0]: Boolean

    Definition Classes
    Any

  46. val listParams: Map[String, ListParam]

  47. 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

  48. 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

  49. 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

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

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

    Definition Classes
    AnyRef

  52. final def notify(): Unit

    Definition Classes
    AnyRef

  53. final def notifyAll(): Unit

    Definition Classes
    AnyRef

  54. 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

  55. 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

  56. 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

  57. val stmt: PreparedStatement

  58. 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

  59. 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

  60. 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

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

    Definition Classes
    AnyRef

  62. 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

  63. 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

  64. 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

  65. def toString(): String

    Definition Classes
    AnyRef → Any

  66. 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

  67. 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

  68. 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

  69. final def wait(): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

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

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

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

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

Inherited from AnyRef

Inherited from Any

Ungrouped