summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPeter Wu <peter@lekensteyn.nl>2014-05-10 16:10:07 +0200
committerPeter Wu <peter@lekensteyn.nl>2014-05-10 16:10:07 +0200
commit52eeb2d0fe0fb8ab841727fc1d464d871e1b0c6b (patch)
treef9e8c941162d4dc84cc12eb747834e70999d87e0
parent6f3248aea98b6e03a5d6586fdb42b29aa6929f13 (diff)
downloadDatafiller-52eeb2d0fe0fb8ab841727fc1d464d871e1b0c6b.tar.gz
NamedPreparedStatement: fix query parameters
-rw-r--r--src/database/NamedPreparedStatement.java6
1 files changed, 3 insertions, 3 deletions
diff --git a/src/database/NamedPreparedStatement.java b/src/database/NamedPreparedStatement.java
index c98edac..4c4485a 100644
--- a/src/database/NamedPreparedStatement.java
+++ b/src/database/NamedPreparedStatement.java
@@ -21,12 +21,12 @@ public class NamedPreparedStatement {
public NamedPreparedStatement(Connection conn, String query) throws SQLException {
fields = new ArrayList<>();
- Pattern pattern = Pattern.compile(":\\w+");
+ Pattern pattern = Pattern.compile(":(\\w+)");
Matcher matcher = pattern.matcher(query);
while (matcher.find()) {
- fields.add(matcher.group());
+ fields.add(matcher.group(1));
}
- String sql = query.replaceAll(pattern.pattern(), "");
+ String sql = query.replaceAll(pattern.pattern(), "?");
stmt = conn.prepareStatement(sql);
}