替换PreparedStatement中参数的方法

    private String getQueryFromPreparedStatement(String sql, Object... args) {
        int len = sql.length();
        StringBuffer t = new StringBuffer(len * 2);
        
        if (args != null) {
            int i = 0, limit = 0, base = 0;
            
            while ((limit = sql.indexOf('?',limit)) != -1) {
                if (args[i] != null) {
                    t.append(sql.substring(base,limit));
                    t.append("'");
                    t.append(args[i].toString());
                    t.append("'");
                } else {
                    t.append(sql.substring(base,limit));
                    t.append(args[i]);
                }
                i++;
                limit++;
                base = limit;
            }
            if (base < len) {
                t.append(sql.substring(base));
            }
        }
        
        return t.toString();
    }