Type Members

1.  case class Connector(url: String, user: String, password: String, driverClassName: String) extends Product with Serializable

   Creates database connections.

   Creates database connections.

   url

   database url

   user

   database user

   password

   database password

   driverClassName

   fully qualified class name of JDBC driver

2.  sealed abstract class Execution extends AnyRef

   Represents result of either update or query.

   Represents result of either update or query. If update, result can be obtained via count; otherwise, if query, result can be obtained via resultSet.

   See also

   ConnectionType.execute, StatementType.execute, PreparedStatementType.execute, QueryBuilder.execute

3.  trait GetValue[T] extends GetValueByIndex[T] with GetValueByLabel[T]

   Gets value from ResultSet.

   Gets value from ResultSet.

   See also

   ResultSetType

4.  trait GetValueByIndex[T] extends AnyRef

   Gets value by index from ResultSet.

   Gets value by index from ResultSet.

   See also

   GetValueByLabel, ResultSetType

5.  trait GetValueByLabel[T] extends AnyRef

   Gets value by label from ResultSet.

   Gets value by label from ResultSet.

   See also

   GetValueByIndex, ResultSetType

6.  trait InParam extends AnyRef

   Defines value for input parameter.

7.  final case class Query(resultSet: ResultSet) extends Execution with Product with Serializable

   Represents result of query.

   Represents result of query.

   resultSet

   result set

   See also

   Update, ConnectionType.execute, StatementType.execute, PreparedStatementType.execute, QueryBuilder.execute

8.  trait QueryBuilder extends AnyRef

   Provides interface to incrementally build and execute SQL statements.

   Provides interface to incrementally build and execute SQL statements.

   QueryBuilder is an immutable structure. A new builder is returned with each requested modification, and a new statement and result set are created on each requested execution.

   import java.sql.Connection
   
   import little.sql.Implicits._
   import little.sql.QueryBuilder
   
   implicit val conn: Connection = ???
   
   QueryBuilder("select * from users where group = ? and enabled = ?")
    .params("staff", true) // Set input parameter values
    .maxRows(10) // Limit result set to 10 rows
    .foreach { rs => printf(s"uid=%d%n", rs.getInt("id")) } // Use implicit connection

9.  final case class Update(count: Int) extends Execution with Product with Serializable

   Represents result of update.

   Represents result of update.

   count

   update count

   See also

   Query, ConnectionType.execute, StatementType.execute, PreparedStatementType.execute, QueryBuilder.execute