Slick/JDBC: Support PreparedStatement use in Java DSL

[ihostage]

Extend Java DSL for using java.sql.PreparedStatement

References #2247

[ennru]

Thank you for suggesting this, it's a great improvement for the Java DSL.

I wonder if there is a way to create the prepared statement only once and update it for every element.

Maybe @renatocaval can have a look?

[ihostage]

I wonder if there is a way to create the prepared statement only once and update it for every element.

Yep, I thought about that too. But PreparedStatement bound to Connection and It's a really problem for us 😞
https://stackoverflow.com/questions/4647476/reusing-of-a-preparedstatement-between-methods

Reuse PreparedStatement very easy, when we have a loop and one connection 😄 But it's not our case 🤷‍♂️
Besides, the user can use an external Map<Connection, PreparedStatement> for storing statements and reuse them if it really wants to do that.

[octonato]

Looking good.

I dropped some comments, will continue after lunch.

[ennru]

This becomes a hidden filter feature, but makes sense as a safe-guard.

[ihostage]

Yep. I thought about NPE-safety and I haven’t come up with anything better like this 🤷‍♂️

[ennru]

But it becomes a dangerous mix with the failure handling you suggested in the example...

[ihostage]

I removed this check, rewritten examples in docs, and added test with recover function.
Please, review.

[ennru]

LGTM. Great to finally make this usable from Java!

[ennru]

Thank you @ihostage!