copying parameters from one PreparedStatement to another

Question

I create a new PreparedStatement like this:

PreparedStatement newPs = origPrepStatement.getConnection().prepareStatement("EXPLAIN " + sql);

origPrepStatement is also Preparedstatement and it contains parameters. I'd like to copy the parameters of origPrepStatement to newPs. Is there away to do that?

that's sad:-( I don't need it for debugging, I need it for other purpose. — Sanyifejű, Mar 21 '13 at 12:16

score 1 · Accepted Answer · answered Mar 21 '13 at 12:48

There seems to be no easy solution; find my clumsy solution below

class PreparedStatementParameters implements InvocationHandler {
    Map<Integer, Object> map = new HashMap<>();
    PreparedStatement ps;

    PreparedStatementParameters(PreparedStatement ps) {
        this.ps = ps;
    }

    public Object invoke(Object proxy, Method method, Object[] args) throws Throwable {
        if (method.getName().startsWith("set")) {

        }
        return method.invoke(proxy, args);
    }

    public void copyParameters(PreparedStatement ps) throws SQLException {
        for (Map.Entry<Integer, Object> e : map.entrySet()) {
            ps.setObject(e.getKey(), e.getValue());
        }
    }
}

public class T2 {
    public static void main(String[] args) throws Exception {
        PreparedStatement ps1 = ...
    PreparedStatementParameters ps1params = new PreparedStatementParameters(ps1);
        PreparedStatement ps1Proxy = (PreparedStatement) Proxy.newProxyInstance(null,
                new Class[] { PreparedStatement.class }, new PreparedStatementParameters(ps1));
        ps1Proxy.setString(1, "test");
        ...
        PreparedStatement ps2 = ...
        ps1params.copyParameters(ps2);
    }
}

What happens here? if (method.getName().startsWith("set")) { } — Sanyifejű, Mar 22 '13 at 11:26
All parameters that you set on ps1 will be saved in PreparedStatementParameters — Evgeniy Dorofeev, Mar 22 '13 at 15:14

copying parameters from one PreparedStatement to another

1 Answers1