little.sql

Creates database connections.

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

Provides factory methods for Execution.

Gets value from ResultSet.

Gets value by index from ResultSet.

Gets value by label from ResultSet.

Provides implicits conversions and extension methods.

Defines value for input parameter.

Provides factory methods for InParam.

Represents result of query.

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 scala.language.implicitConversions

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

// Same as above except use map of parameters
QueryBuilder("select * from users where group = ${group} and enabled = ${enabled}")
 .params("group" -> "staff", "enabled" -> true)
 .maxRows(10)
 .foreach { rs => printf(s"uid=%d%n", rs.getInt("id")) }

Provides QueryBuilder factory.

Represents result of update.