Java tutorial
/** * Apache License * Version 2.0, January 2004 * http://www.apache.org/licenses/ * * TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION * * 1. Definitions. * * "License" shall mean the terms and conditions for use, reproduction, * and distribution as defined by Sections 1 through 9 of this document. * * "Licensor" shall mean the copyright owner or entity authorized by * the copyright owner that is granting the License. * * "Legal Entity" shall mean the union of the acting entity and all * other entities that control, are controlled by, or are under common * control with that entity. For the purposes of this definition, * "control" means (i) the power, direct or indirect, to cause the * direction or management of such entity, whether by contract or * otherwise, or (ii) ownership of fifty percent (50%) or more of the * outstanding shares, or (iii) beneficial ownership of such entity. * * "You" (or "Your") shall mean an individual or Legal Entity * exercising permissions granted by this License. * * "Source" form shall mean the preferred form for making modifications, * including but not limited to software source code, documentation * source, and configuration files. * * "Object" form shall mean any form resulting from mechanical * transformation or translation of a Source form, including but * not limited to compiled object code, generated documentation, * and conversions to other media types. * * "Work" shall mean the work of authorship, whether in Source or * Object form, made available under the License, as indicated by a * copyright notice that is included in or attached to the work * (an example is provided in the Appendix below). * * "Derivative Works" shall mean any work, whether in Source or Object * form, that is based on (or derived from) the Work and for which the * editorial revisions, annotations, elaborations, or other modifications * represent, as a whole, an original work of authorship. For the purposes * of this License, Derivative Works shall not include works that remain * separable from, or merely link (or bind by name) to the interfaces of, * the Work and Derivative Works thereof. * * "Contribution" shall mean any work of authorship, including * the original version of the Work and any modifications or additions * to that Work or Derivative Works thereof, that is intentionally * submitted to Licensor for inclusion in the Work by the copyright owner * or by an individual or Legal Entity authorized to submit on behalf of * the copyright owner. For the purposes of this definition, "submitted" * means any form of electronic, verbal, or written communication sent * to the Licensor or its representatives, including but not limited to * communication on electronic mailing lists, source code control systems, * and issue tracking systems that are managed by, or on behalf of, the * Licensor for the purpose of discussing and improving the Work, but * excluding communication that is conspicuously marked or otherwise * designated in writing by the copyright owner as "Not a Contribution." * * "Contributor" shall mean Licensor and any individual or Legal Entity * on behalf of whom a Contribution has been received by Licensor and * subsequently incorporated within the Work. * * 2. Grant of Copyright License. Subject to the terms and conditions of * this License, each Contributor hereby grants to You a perpetual, * worldwide, non-exclusive, no-charge, royalty-free, irrevocable * copyright license to reproduce, prepare Derivative Works of, * publicly display, publicly perform, sublicense, and distribute the * Work and such Derivative Works in Source or Object form. * * 3. Grant of Patent License. Subject to the terms and conditions of * this License, each Contributor hereby grants to You a perpetual, * worldwide, non-exclusive, no-charge, royalty-free, irrevocable * (except as stated in this section) patent license to make, have made, * use, offer to sell, sell, import, and otherwise transfer the Work, * where such license applies only to those patent claims licensable * by such Contributor that are necessarily infringed by their * Contribution(s) alone or by combination of their Contribution(s) * with the Work to which such Contribution(s) was submitted. If You * institute patent litigation against any entity (including a * cross-claim or counterclaim in a lawsuit) alleging that the Work * or a Contribution incorporated within the Work constitutes direct * or contributory patent infringement, then any patent licenses * granted to You under this License for that Work shall terminate * as of the date such litigation is filed. * * 4. Redistribution. You may reproduce and distribute copies of the * Work or Derivative Works thereof in any medium, with or without * modifications, and in Source or Object form, provided that You * meet the following conditions: * * (a) You must give any other recipients of the Work or * Derivative Works a copy of this License; and * * (b) You must cause any modified files to carry prominent notices * stating that You changed the files; and * * (c) You must retain, in the Source form of any Derivative Works * that You distribute, all copyright, patent, trademark, and * attribution notices from the Source form of the Work, * excluding those notices that do not pertain to any part of * the Derivative Works; and * * (d) If the Work includes a "NOTICE" text file as part of its * distribution, then any Derivative Works that You distribute must * include a readable copy of the attribution notices contained * within such NOTICE file, excluding those notices that do not * pertain to any part of the Derivative Works, in at least one * of the following places: within a NOTICE text file distributed * as part of the Derivative Works; within the Source form or * documentation, if provided along with the Derivative Works; or, * within a display generated by the Derivative Works, if and * wherever such third-party notices normally appear. The contents * of the NOTICE file are for informational purposes only and * do not modify the License. You may add Your own attribution * notices within Derivative Works that You distribute, alongside * or as an addendum to the NOTICE text from the Work, provided * that such additional attribution notices cannot be construed * as modifying the License. * * You may add Your own copyright statement to Your modifications and * may provide additional or different license terms and conditions * for use, reproduction, or distribution of Your modifications, or * for any such Derivative Works as a whole, provided Your use, * reproduction, and distribution of the Work otherwise complies with * the conditions stated in this License. * * 5. Submission of Contributions. Unless You explicitly state otherwise, * any Contribution intentionally submitted for inclusion in the Work * by You to the Licensor shall be under the terms and conditions of * this License, without any additional terms or conditions. * Notwithstanding the above, nothing herein shall supersede or modify * the terms of any separate license agreement you may have executed * with Licensor regarding such Contributions. * * 6. Trademarks. This License does not grant permission to use the trade * names, trademarks, service marks, or product names of the Licensor, * except as required for reasonable and customary use in describing the * origin of the Work and reproducing the content of the NOTICE file. * * 7. Disclaimer of Warranty. Unless required by applicable law or * agreed to in writing, Licensor provides the Work (and each * Contributor provides its Contributions) on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or * implied, including, without limitation, any warranties or conditions * of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A * PARTICULAR PURPOSE. You are solely responsible for determining the * appropriateness of using or redistributing the Work and assume any * risks associated with Your exercise of permissions under this License. * * 8. Limitation of Liability. In no event and under no legal theory, * whether in tort (including negligence), contract, or otherwise, * unless required by applicable law (such as deliberate and grossly * negligent acts) or agreed to in writing, shall any Contributor be * liable to You for damages, including any direct, indirect, special, * incidental, or consequential damages of any character arising as a * result of this License or out of the use or inability to use the * Work (including but not limited to damages for loss of goodwill, * work stoppage, computer failure or malfunction, or any and all * other commercial damages or losses), even if such Contributor * has been advised of the possibility of such damages. * * 9. Accepting Warranty or Additional Liability. While redistributing * the Work or Derivative Works thereof, You may choose to offer, * and charge a fee for, acceptance of support, warranty, indemnity, * or other liability obligations and/or rights consistent with this * License. However, in accepting such obligations, You may act only * on Your own behalf and on Your sole responsibility, not on behalf * of any other Contributor, and only if You agree to indemnify, * defend, and hold each Contributor harmless for any liability * incurred by, or claims asserted against, such Contributor by reason * of your accepting any such warranty or additional liability. * * END OF TERMS AND CONDITIONS * * APPENDIX: How to apply the Apache License to your work. * * To apply the Apache License to your work, attach the following * boilerplate notice, with the fields enclosed by brackets "{}" * replaced with your own identifying information. (Don't include * the brackets!) The text should be enclosed in the appropriate * comment syntax for the file format. We also recommend that a * file or class name and description of purpose be included on the * same "printed page" as the copyright notice for easier * identification within third-party archives. * * Copyright 2014 Edgar Espina * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package org.skife.jdbi.v2; import static org.skife.jdbi.rewriter.colon.ColonStatementLexer.DOUBLE_QUOTED_TEXT; import static org.skife.jdbi.rewriter.colon.ColonStatementLexer.ESCAPED_TEXT; import static org.skife.jdbi.rewriter.colon.ColonStatementLexer.LITERAL; import static org.skife.jdbi.rewriter.colon.ColonStatementLexer.NAMED_PARAM; import static org.skife.jdbi.rewriter.colon.ColonStatementLexer.POSITIONAL_PARAM; import static org.skife.jdbi.rewriter.colon.ColonStatementLexer.QUOTED_TEXT; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import java.util.Optional; import org.skife.jdbi.org.antlr.runtime.ANTLRStringStream; import org.skife.jdbi.org.antlr.runtime.Token; import org.skife.jdbi.rewriter.colon.ColonStatementLexer; import org.skife.jdbi.v2.exceptions.UnableToCreateStatementException; import org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException; import org.skife.jdbi.v2.tweak.Argument; import org.skife.jdbi.v2.tweak.RewrittenStatement; import org.skife.jdbi.v2.tweak.StatementRewriter; import com.google.common.base.Strings; /** * <p> * Statement rewriter which replaces named parameter tokens of the form :tokenName * </p> * This is the default statement rewriter. * * This is a copy of the {@link ColonPrefixNamedParamStatementRewriter} with sql expansion for * multi-value argument. * * TODO: find sometime and send a pull request to include these changes. Here we are accessing to * some packages protected classes, which isn't good. */ public class ExpandedStmtRewriter implements StatementRewriter { /** * Munge up the SQL as desired. Responsible for figuring out ow to bind any * arguments in to the resultant prepared statement. * * @param sql The SQL to rewrite * @param params contains the arguments which have been bound to this statement. * @param ctx The statement context for the statement being executed * @return somethign which can provde the actual SQL to prepare a statement from * and which can bind the correct arguments to that prepared statement */ @Override public RewrittenStatement rewrite(final String sql, final Binding params, final StatementContext ctx) { final ParsedStatement stmt = new ParsedStatement(); try { final String parsedSql = parseString(sql, stmt, params); return new MyRewrittenStatement(parsedSql, stmt, ctx); } catch (IllegalArgumentException e) { throw new UnableToCreateStatementException("Exception parsing for named parameter replacement", e, ctx); } } String parseString(final String sql, final ParsedStatement stmt, final Binding params) throws IllegalArgumentException { StringBuilder b = new StringBuilder(); ColonStatementLexer lexer = new ColonStatementLexer(new ANTLRStringStream(sql)); Token t = lexer.nextToken(); int pos = 0; while (t.getType() != ColonStatementLexer.EOF) { switch (t.getType()) { case LITERAL: b.append(t.getText()); break; case NAMED_PARAM: String pname = t.getText().substring(1, t.getText().length()); stmt.addNamedParamAt(pname); Argument arg = params.forName(pname); if (arg instanceof IterableArgument) { // expand iterable int size = ((IterableArgument) arg).size(); b.append(Strings.repeat("?, ", size)); b.setLength(b.length() - 2); } else { b.append("?"); } break; case QUOTED_TEXT: b.append(t.getText()); break; case DOUBLE_QUOTED_TEXT: b.append(t.getText()); break; case POSITIONAL_PARAM: Argument posarg = params.forPosition(pos); if (posarg instanceof IterableArgument) { // expand iterable int size = ((IterableArgument) posarg).size(); b.append(Strings.repeat("?, ", size)); b.setLength(b.length() - 2); pos += size; } else { b.append("?"); pos += 1; } stmt.addPositionalParamAt(); break; case ESCAPED_TEXT: b.append(t.getText().substring(1)); break; default: break; } t = lexer.nextToken(); } return b.toString(); } private static class MyRewrittenStatement implements RewrittenStatement { private final String sql; private final ParsedStatement stmt; private final StatementContext context; public MyRewrittenStatement(final String sql, final ParsedStatement stmt, final StatementContext ctx) { this.context = ctx; this.sql = sql; this.stmt = stmt; } @Override public void bind(final Binding params, final PreparedStatement statement) throws SQLException { if (stmt.positionalOnly) { // no named params, is easy boolean finished = false; int i = 0, p = 0; while (!finished) { final Argument a = params.forPosition(p); if (a != null) { try { this.context.setAttribute("position", null); a.apply(i + 1, statement, this.context); Integer pos = (Integer) this.context.getAttribute("position"); i += Optional.ofNullable(pos).orElse(1); p += 1; this.context.setAttribute("position", null); } catch (SQLException e) { throw new UnableToExecuteStatementException( String.format( "Exception while binding positional param at (0 based) position %d", i), e, context); } } else { finished = true; } } } else { // List<String> named_params = stmt.params; int i = 0; for (String named_param : stmt.params) { if ("*".equals(named_param)) { continue; } Argument a = params.forName(named_param); if (a == null) { a = params.forPosition(i); } if (a == null) { String msg = String.format("Unable to execute, no named parameter matches " + "\"%s\" and no positional param for place %d (which is %d in " + "the JDBC 'start at 1' scheme) has been set.", named_param, i, i + 1); throw new UnableToExecuteStatementException(msg, context); } try { this.context.setAttribute("position", null); a.apply(i + 1, statement, this.context); Integer pos = (Integer) this.context.getAttribute("position"); i += Optional.ofNullable(pos).orElse(1); } catch (SQLException e) { throw new UnableToCreateStatementException( String.format("Exception while binding '%s'", named_param), e, context); } } } } @Override public String getSql() { return sql; } } static class ParsedStatement { private boolean positionalOnly = true; private List<String> params = new ArrayList<>(); public void addNamedParamAt(final String name) { positionalOnly = false; params.add(name); } public void addPositionalParamAt() { params.add("*"); } } }