diff options
author | Peter Wu <peter@lekensteyn.nl> | 2014-05-10 16:10:07 +0200 |
---|---|---|
committer | Peter Wu <peter@lekensteyn.nl> | 2014-05-10 16:10:07 +0200 |
commit | 52eeb2d0fe0fb8ab841727fc1d464d871e1b0c6b (patch) | |
tree | f9e8c941162d4dc84cc12eb747834e70999d87e0 | |
parent | 6f3248aea98b6e03a5d6586fdb42b29aa6929f13 (diff) | |
download | Datafiller-52eeb2d0fe0fb8ab841727fc1d464d871e1b0c6b.tar.gz |
NamedPreparedStatement: fix query parameters
-rw-r--r-- | src/database/NamedPreparedStatement.java | 6 |
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); } |