From 52eeb2d0fe0fb8ab841727fc1d464d871e1b0c6b Mon Sep 17 00:00:00 2001 From: Peter Wu Date: Sat, 10 May 2014 16:10:07 +0200 Subject: NamedPreparedStatement: fix query parameters --- src/database/NamedPreparedStatement.java | 6 +++--- 1 file 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); } -- cgit v1.2.1