JDBC PreparedStatement Replace Value Like PDO

Asked Jul 19 '16 at 14:52

Active Jul 19 '16 at 15:07

Viewed 40 times

I'm programming in Java and i want replace values not with ? but with :name like PDO of PHP. Exemple:
PHP:

$sql = "Insert Into User (name, age) values (:name, :age);";
$insert = $conn->Prepare($sql);
$insert->bindValue(":name", "Pedro");
$insert->bindValue(":age", 21);
$insert->execute();

Edit 01
Java (Current):

PreparedStatement select = conn.prepareStatement("Insert Into User (name, age) values (?, ?);");
select.setString(1, "Pedro");
select.setInt(2, 21);

Java (How I Want):

PreparedStatement select = conn.prepareStatement("Insert Into User (name, age) values (:name, :age);");
select.setString(":name", "Pedro");
select.setInt(":age", 21);

edited Jul 19 '16 at 15:07

Compass

5,867
4
30
42

asked Jul 19 '16 at 14:52

Pedro Soares

What's the question? – Dylan Wheeler Jul 19 '16 at 14:55
Make a custom implementation PreparedStatement to do that. – Compass Jul 19 '16 at 14:57
I edit de question. – Pedro Soares Jul 19 '16 at 15:04
Thanks, is that i looking for. – Pedro Soares Jul 19 '16 at 15:33
This article here offers a quick implementation of such a class: http://www.javaworld.com/article/2077706/core-java/named-parameters-for-preparedstatement.html – Sorin Postelnicu Feb 03 '17 at 18:15

JDBC PreparedStatement Replace Value Like PDO

0 Answers0