下面是我的Scala代码，这是Postgres的插入查询，该查询将传递给PreparedStatement

val query =
        s"""
           |insert into structure_products (
           |identifier,"assetClass","name","scoreType",|"field_1","field_2","field_3","field_4",|"field_5","field_6","field_7","field_8",|"field_9","field_10","field_11","field_12")
           |values (
           |?,?,|?,?)
           |""".stripMargin

然后我必须对16个字段进行手动设置。

val statement = connection.prepareStatement(query)

statement.setString(1,identifier)
statement.setString(2,assetClass)
statement.setString(3,name)
...
statement.setTimestamp(15,field_11)
statement.setTimestamp(16,field_12)

那么还有其他方法可以更优雅地做到这一点吗？非常感谢你！