JdbcValueAccessor

for values(of type T) to passed into Statement or passed out from ResultSet, it should has a contxt bound of JdbcValueAccessor[T]

package wangzx.scala_commons.sql prdefined a lot of pre-defined implementation for the jdbc value types:

• boolean, byte, short, Int, Long, Float, Double, BigDecimal, scala.BigDecimal
• String
• Date, Time, Timestamp
• Blob, Clob, byte[]
• Option[T] if T has JdbcValueAccessor context bounded

developer can define your's value type such as a MyDate which stored as database Date, you need only define an implicit value of JdbcValueAccessor[MyDate], then you can:

• pass in statement using sql"... where date_field = $myDate"
• passout from ResultSet, using rs.get[MyDate](field index or name)
• mapping to a field of other CaseClass such as User, and then using rows[User](sql)
• mapping to a Row object and rows[Row](sql), and then using row.get[MyDate](field index of name).