Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
com.landawn.abacus.util.AbstractPreparedQuery Maven / Gradle / Ivy
/*
* Copyright (c) 2019, Haiyang Li.
*
* 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 com.landawn.abacus.util;
import java.io.Closeable;
import java.io.InputStream;
import java.io.Reader;
import java.math.BigDecimal;
import java.net.URL;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.SQLType;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Iterator;
import java.util.List;
import java.util.NoSuchElementException;
import java.util.Objects;
import java.util.concurrent.Executor;
import com.landawn.abacus.DataSet;
import com.landawn.abacus.annotation.Beta;
import com.landawn.abacus.exception.DuplicatedResultException;
import com.landawn.abacus.logging.Logger;
import com.landawn.abacus.logging.LoggerFactory;
import com.landawn.abacus.type.Type;
import com.landawn.abacus.type.TypeFactory;
import com.landawn.abacus.util.ExceptionalStream.ExceptionalIterator;
import com.landawn.abacus.util.JdbcUtil.BiParametersSetter;
import com.landawn.abacus.util.JdbcUtil.BiResultExtractor;
import com.landawn.abacus.util.JdbcUtil.BiRowConsumer;
import com.landawn.abacus.util.JdbcUtil.BiRowFilter;
import com.landawn.abacus.util.JdbcUtil.BiRowMapper;
import com.landawn.abacus.util.JdbcUtil.ParametersSetter;
import com.landawn.abacus.util.JdbcUtil.ResultExtractor;
import com.landawn.abacus.util.JdbcUtil.RowConsumer;
import com.landawn.abacus.util.JdbcUtil.RowFilter;
import com.landawn.abacus.util.JdbcUtil.RowMapper;
import com.landawn.abacus.util.StringUtil.Strings;
import com.landawn.abacus.util.u.Nullable;
import com.landawn.abacus.util.u.Optional;
import com.landawn.abacus.util.u.OptionalBoolean;
import com.landawn.abacus.util.u.OptionalByte;
import com.landawn.abacus.util.u.OptionalChar;
import com.landawn.abacus.util.u.OptionalDouble;
import com.landawn.abacus.util.u.OptionalFloat;
import com.landawn.abacus.util.u.OptionalInt;
import com.landawn.abacus.util.u.OptionalLong;
import com.landawn.abacus.util.u.OptionalShort;
/**
* The backed {@code PreparedStatement/CallableStatement} will be closed by default
* after any execution methods(which will trigger the backed {@code PreparedStatement/CallableStatement} to be executed, for example: get/query/queryForInt/Long/../findFirst/findOnlyOne/list/execute/...).
* except the {@code 'closeAfterExecution'} flag is set to {@code false} by calling {@code #closeAfterExecution(false)}.
*
*
* @param
*/
abstract class AbstractPreparedQuery> implements Closeable {
static final Logger logger = LoggerFactory.getLogger(AbstractPreparedQuery.class);
final S stmt;
boolean isFetchDirectionSet = false;
boolean isBatch = false;
boolean isCloseAfterExecution = true;
boolean isClosed = false;
Runnable closeHandler;
AbstractPreparedQuery(S stmt) {
this.stmt = stmt;
}
// /**
// * It's designed to void try-catch.
// * This method should be called immediately after {@code JdbcUtil#prepareCallableQuery/SQLExecutor#prepareQuery}.
// *
// * @return
// */
// public Try tried() {
// assertNotClosed();
//
// return Try.of((Q) this);
// }
/**
*
* @param closeAfterExecution default is {@code true}.
* @return
*/
public Q closeAfterExecution(boolean closeAfterExecution) {
assertNotClosed();
this.isCloseAfterExecution = closeAfterExecution;
return (Q) this;
}
boolean isCloseAfterExecution() {
return isCloseAfterExecution;
}
/**
*
* @param closeHandler A task to execute after this {@code Query} is closed
* @return
*/
public Q onClose(final Runnable closeHandler) {
checkArgNotNull(closeHandler, "closeHandler");
assertNotClosed();
if (this.closeHandler == null) {
this.closeHandler = closeHandler;
} else {
final Runnable tmp = this.closeHandler;
this.closeHandler = () -> {
try {
tmp.run();
} finally {
closeHandler.run();
}
};
}
return (Q) this;
}
/**
* Sets the null.
*
* @param parameterIndex starts from 1, not 0.
* @param sqlType
* @return
* @throws SQLException the SQL exception
*/
public Q setNull(int parameterIndex, int sqlType) throws SQLException {
stmt.setNull(parameterIndex, sqlType);
return (Q) this;
}
/**
* Sets the null.
*
* @param parameterIndex starts from 1, not 0.
* @param sqlType
* @param typeName
* @return
* @throws SQLException the SQL exception
*/
public Q setNull(int parameterIndex, int sqlType, String typeName) throws SQLException {
stmt.setNull(parameterIndex, sqlType, typeName);
return (Q) this;
}
/**
* Sets the boolean.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setBoolean(int parameterIndex, boolean x) throws SQLException {
stmt.setBoolean(parameterIndex, x);
return (Q) this;
}
/**
* Sets the boolean.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setBoolean(int parameterIndex, Boolean x) throws SQLException {
stmt.setBoolean(parameterIndex, N.defaultIfNull(x));
return (Q) this;
}
/**
* Sets the byte.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setByte(int parameterIndex, byte x) throws SQLException {
stmt.setByte(parameterIndex, x);
return (Q) this;
}
/**
* Sets the byte.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setByte(int parameterIndex, Byte x) throws SQLException {
stmt.setByte(parameterIndex, N.defaultIfNull(x));
return (Q) this;
}
/**
* Sets the short.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setShort(int parameterIndex, short x) throws SQLException {
stmt.setShort(parameterIndex, x);
return (Q) this;
}
/**
* Sets the short.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setShort(int parameterIndex, Short x) throws SQLException {
stmt.setShort(parameterIndex, N.defaultIfNull(x));
return (Q) this;
}
/**
* Sets the int.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setInt(int parameterIndex, int x) throws SQLException {
stmt.setInt(parameterIndex, x);
return (Q) this;
}
/**
* Sets the int.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setInt(int parameterIndex, Integer x) throws SQLException {
stmt.setInt(parameterIndex, N.defaultIfNull(x));
return (Q) this;
}
/**
* Sets the int.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setInt(int parameterIndex, char x) throws SQLException {
stmt.setInt(parameterIndex, x);
return (Q) this;
}
/**
* Sets the int.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setInt(int parameterIndex, Character x) throws SQLException {
stmt.setInt(parameterIndex, N.defaultIfNull(x));
return (Q) this;
}
/**
* Sets the long.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setLong(int parameterIndex, long x) throws SQLException {
stmt.setLong(parameterIndex, x);
return (Q) this;
}
/**
* Sets the long.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setLong(int parameterIndex, Long x) throws SQLException {
stmt.setLong(parameterIndex, N.defaultIfNull(x));
return (Q) this;
}
/**
* Sets the float.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setFloat(int parameterIndex, float x) throws SQLException {
stmt.setFloat(parameterIndex, x);
return (Q) this;
}
/**
* Sets the float.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setFloat(int parameterIndex, Float x) throws SQLException {
stmt.setFloat(parameterIndex, N.defaultIfNull(x));
return (Q) this;
}
/**
* Sets the double.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setDouble(int parameterIndex, double x) throws SQLException {
stmt.setDouble(parameterIndex, N.defaultIfNull(x));
return (Q) this;
}
/**
* Sets the double.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setDouble(int parameterIndex, Double x) throws SQLException {
stmt.setDouble(parameterIndex, x);
return (Q) this;
}
/**
* Sets the big decimal.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setBigDecimal(int parameterIndex, BigDecimal x) throws SQLException {
stmt.setBigDecimal(parameterIndex, x);
return (Q) this;
}
/**
* Sets the string.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setString(int parameterIndex, String x) throws SQLException {
stmt.setString(parameterIndex, x);
return (Q) this;
}
/**
* Sets the string.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setString(int parameterIndex, CharSequence x) throws SQLException {
stmt.setString(parameterIndex, x == null ? null : x.toString());
return (Q) this;
}
public Q setString(int parameterIndex, char x) throws SQLException {
stmt.setString(parameterIndex, String.valueOf(x));
return (Q) this;
}
/**
* Sets the String.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setString(int parameterIndex, Character x) throws SQLException {
stmt.setString(parameterIndex, x == null ? null : String.valueOf(x));
return (Q) this;
}
/**
* Sets the date.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setDate(int parameterIndex, java.sql.Date x) throws SQLException {
stmt.setDate(parameterIndex, x);
return (Q) this;
}
/**
* Sets the date.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setDate(int parameterIndex, java.util.Date x) throws SQLException {
stmt.setDate(parameterIndex, x == null ? null : x instanceof java.sql.Date ? (java.sql.Date) x : new java.sql.Date(x.getTime()));
return (Q) this;
}
/**
* Sets the time.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setTime(int parameterIndex, java.sql.Time x) throws SQLException {
stmt.setTime(parameterIndex, x);
return (Q) this;
}
/**
* Sets the time.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setTime(int parameterIndex, java.util.Date x) throws SQLException {
stmt.setTime(parameterIndex, x == null ? null : x instanceof java.sql.Time ? (java.sql.Time) x : new java.sql.Time(x.getTime()));
return (Q) this;
}
/**
* Sets the timestamp.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setTimestamp(int parameterIndex, java.sql.Timestamp x) throws SQLException {
stmt.setTimestamp(parameterIndex, x);
return (Q) this;
}
/**
* Sets the timestamp.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setTimestamp(int parameterIndex, java.util.Date x) throws SQLException {
stmt.setTimestamp(parameterIndex, x == null ? null : x instanceof java.sql.Timestamp ? (java.sql.Timestamp) x : new java.sql.Timestamp(x.getTime()));
return (Q) this;
}
/**
* Sets the bytes.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setBytes(int parameterIndex, byte[] x) throws SQLException {
stmt.setBytes(parameterIndex, x);
return (Q) this;
}
/**
* Sets the ascii stream.
*
* @param parameterIndex
* @param inputStream
* @return
* @throws SQLException the SQL exception
*/
public Q setAsciiStream(int parameterIndex, InputStream inputStream) throws SQLException {
stmt.setAsciiStream(parameterIndex, inputStream);
return (Q) this;
}
/**
* Sets the ascii stream.
*
* @param parameterIndex
* @param inputStream
* @param length
* @return
* @throws SQLException the SQL exception
*/
public Q setAsciiStream(int parameterIndex, InputStream inputStream, long length) throws SQLException {
stmt.setAsciiStream(parameterIndex, inputStream, length);
return (Q) this;
}
/**
* Sets the binary stream.
*
* @param parameterIndex
* @param inputStream
* @return
* @throws SQLException the SQL exception
*/
public Q setBinaryStream(int parameterIndex, InputStream inputStream) throws SQLException {
stmt.setBinaryStream(parameterIndex, inputStream);
return (Q) this;
}
/**
* Sets the binary stream.
*
* @param parameterIndex
* @param inputStream
* @param length
* @return
* @throws SQLException the SQL exception
*/
public Q setBinaryStream(int parameterIndex, InputStream inputStream, long length) throws SQLException {
stmt.setBinaryStream(parameterIndex, inputStream, length);
return (Q) this;
}
/**
* Sets the character stream.
*
* @param parameterIndex
* @param reader
* @return
* @throws SQLException the SQL exception
*/
public Q setCharacterStream(int parameterIndex, Reader reader) throws SQLException {
stmt.setCharacterStream(parameterIndex, reader);
return (Q) this;
}
/**
* Sets the character stream.
*
* @param parameterIndex
* @param reader
* @param length
* @return
* @throws SQLException the SQL exception
*/
public Q setCharacterStream(int parameterIndex, Reader reader, long length) throws SQLException {
stmt.setCharacterStream(parameterIndex, reader, length);
return (Q) this;
}
/**
* Sets the N character stream.
*
* @param parameterIndex
* @param reader
* @return
* @throws SQLException the SQL exception
*/
public Q setNCharacterStream(int parameterIndex, Reader reader) throws SQLException {
stmt.setNCharacterStream(parameterIndex, reader);
return (Q) this;
}
/**
* Sets the N character stream.
*
* @param parameterIndex
* @param reader
* @param length
* @return
* @throws SQLException the SQL exception
*/
public Q setNCharacterStream(int parameterIndex, Reader reader, long length) throws SQLException {
stmt.setNCharacterStream(parameterIndex, reader, length);
return (Q) this;
}
/**
* Sets the blob.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setBlob(int parameterIndex, java.sql.Blob x) throws SQLException {
stmt.setBlob(parameterIndex, x);
return (Q) this;
}
/**
* Sets the blob.
*
* @param parameterIndex
* @param inputStream
* @return
* @throws SQLException the SQL exception
*/
public Q setBlob(int parameterIndex, InputStream inputStream) throws SQLException {
stmt.setBlob(parameterIndex, inputStream);
return (Q) this;
}
/**
* Sets the blob.
*
* @param parameterIndex
* @param inputStream
* @param length
* @return
* @throws SQLException the SQL exception
*/
public Q setBlob(int parameterIndex, InputStream inputStream, long length) throws SQLException {
stmt.setBlob(parameterIndex, inputStream, length);
return (Q) this;
}
/**
* Sets the clob.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setClob(int parameterIndex, java.sql.Clob x) throws SQLException {
stmt.setClob(parameterIndex, x);
return (Q) this;
}
/**
* Sets the clob.
*
* @param parameterIndex
* @param reader
* @return
* @throws SQLException the SQL exception
*/
public Q setClob(int parameterIndex, Reader reader) throws SQLException {
stmt.setClob(parameterIndex, reader);
return (Q) this;
}
/**
* Sets the clob.
*
* @param parameterIndex
* @param reader
* @param length
* @return
* @throws SQLException the SQL exception
*/
public Q setClob(int parameterIndex, Reader reader, long length) throws SQLException {
stmt.setClob(parameterIndex, reader, length);
return (Q) this;
}
/**
* Sets the N clob.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setNClob(int parameterIndex, java.sql.NClob x) throws SQLException {
stmt.setNClob(parameterIndex, x);
return (Q) this;
}
/**
* Sets the N clob.
*
* @param parameterIndex
* @param reader
* @return
* @throws SQLException the SQL exception
*/
public Q setNClob(int parameterIndex, Reader reader) throws SQLException {
stmt.setNClob(parameterIndex, reader);
return (Q) this;
}
/**
* Sets the N clob.
*
* @param parameterIndex
* @param reader
* @param length
* @return
* @throws SQLException the SQL exception
*/
public Q setNClob(int parameterIndex, Reader reader, long length) throws SQLException {
stmt.setNClob(parameterIndex, reader, length);
return (Q) this;
}
/**
* Sets the URL.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setURL(int parameterIndex, URL x) throws SQLException {
stmt.setURL(parameterIndex, x);
return (Q) this;
}
/**
* Sets the array.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setArray(int parameterIndex, java.sql.Array x) throws SQLException {
stmt.setArray(parameterIndex, x);
return (Q) this;
}
/**
* Sets the SQLXML.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setSQLXML(int parameterIndex, java.sql.SQLXML x) throws SQLException {
stmt.setSQLXML(parameterIndex, x);
return (Q) this;
}
/**
* Sets the ref.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setRef(int parameterIndex, java.sql.Ref x) throws SQLException {
stmt.setRef(parameterIndex, x);
return (Q) this;
}
/**
* Sets the row id.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setRowId(int parameterIndex, java.sql.RowId x) throws SQLException {
stmt.setRowId(parameterIndex, x);
return (Q) this;
}
/**
* Sets the object.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException the SQL exception
*/
public Q setObject(int parameterIndex, Object x) throws SQLException {
if (x == null) {
stmt.setObject(parameterIndex, x);
} else {
N.typeOf(x.getClass()).set(stmt, parameterIndex, x);
}
return (Q) this;
}
/**
* Sets the object.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @param sqlType
* @return
* @throws SQLException the SQL exception
*/
public Q setObject(int parameterIndex, Object x, int sqlType) throws SQLException {
stmt.setObject(parameterIndex, x, sqlType);
return (Q) this;
}
/**
* Sets the object.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @param sqlType
* @param scaleOrLength
* @return
* @throws SQLException the SQL exception
*/
public Q setObject(int parameterIndex, Object x, int sqlType, int scaleOrLength) throws SQLException {
stmt.setObject(parameterIndex, x, sqlType, scaleOrLength);
return (Q) this;
}
/**
* Sets the object.
*
* @param parameterIndex
* @param x
* @param sqlType
* @return
* @throws SQLException the SQL exception
*/
public Q setObject(int parameterIndex, Object x, SQLType sqlType) throws SQLException {
stmt.setObject(parameterIndex, x, sqlType);
return (Q) this;
}
/**
* Sets the object.
*
* @param parameterIndex
* @param x
* @param sqlType
* @param scaleOrLength
* @return
* @throws SQLException the SQL exception
*/
public Q setObject(int parameterIndex, Object x, SQLType sqlType, int scaleOrLength) throws SQLException {
stmt.setObject(parameterIndex, x, sqlType, scaleOrLength);
return (Q) this;
}
public Q setObject(int parameterIndex, Object x, Type type) throws SQLException {
type.set(stmt, parameterIndex, x);
return (Q) this;
}
/**
* Sets the parameters.
*
* @param param1
* @param param2
* @return
* @throws SQLException the SQL exception
*/
public Q setParameters(final String param1, final String param2) throws SQLException {
stmt.setString(1, param1);
stmt.setString(2, param2);
return (Q) this;
}
/**
* Sets the parameters.
*
* @param param1
* @param param2
* @param param3
* @return
* @throws SQLException the SQL exception
*/
public Q setParameters(final String param1, final String param2, final String param3) throws SQLException {
stmt.setString(1, param1);
stmt.setString(2, param2);
stmt.setString(3, param3);
return (Q) this;
}
/**
* Sets the parameters.
*
* @param param1
* @param param2
* @param param3
* @param param4
* @return
* @throws SQLException the SQL exception
*/
public Q setParameters(final String param1, final String param2, final String param3, final String param4) throws SQLException {
stmt.setString(1, param1);
stmt.setString(2, param2);
stmt.setString(3, param3);
stmt.setString(4, param4);
return (Q) this;
}
/**
* Sets the parameters.
*
* @param param1
* @param param2
* @param param3
* @param param4
* @param param5
* @return
* @throws SQLException the SQL exception
*/
public Q setParameters(final String param1, final String param2, final String param3, final String param4, final String param5) throws SQLException {
stmt.setString(1, param1);
stmt.setString(2, param2);
stmt.setString(3, param3);
stmt.setString(4, param4);
stmt.setString(5, param5);
return (Q) this;
}
/**
* Sets the parameters.
*
* @param param1
* @param param2
* @param param3
* @param param4
* @param param5
* @param param6
* @return
* @throws SQLException the SQL exception
*/
public Q setParameters(final String param1, final String param2, final String param3, final String param4, final String param5, final String param6)
throws SQLException {
stmt.setString(1, param1);
stmt.setString(2, param2);
stmt.setString(3, param3);
stmt.setString(4, param4);
stmt.setString(5, param5);
stmt.setString(6, param6);
return (Q) this;
}
/**
* Sets the parameters.
*
* @param param1
* @param param2
* @param param3
* @param param4
* @param param5
* @param param6
* @param param7
* @return
* @throws SQLException the SQL exception
*/
public Q setParameters(final String param1, final String param2, final String param3, final String param4, final String param5, final String param6,
final String param7) throws SQLException {
stmt.setString(1, param1);
stmt.setString(2, param2);
stmt.setString(3, param3);
stmt.setString(4, param4);
stmt.setString(5, param5);
stmt.setString(6, param6);
stmt.setString(7, param7);
return (Q) this;
}
/**
* Sets the parameters.
*
* @param param1
* @param param2
* @return
* @throws SQLException the SQL exception
*/
public Q setParameters(final Object param1, final Object param2) throws SQLException {
setObject(1, param1);
setObject(2, param2);
return (Q) this;
}
/**
* Sets the parameters.
*
* @param param1
* @param param2
* @param param3
* @return
* @throws SQLException the SQL exception
*/
public Q setParameters(final Object param1, final Object param2, final Object param3) throws SQLException {
setObject(1, param1);
setObject(2, param2);
setObject(3, param3);
return (Q) this;
}
/**
* Sets the parameters.
*
* @param param1
* @param param2
* @param param3
* @param param4
* @return
* @throws SQLException the SQL exception
*/
public Q setParameters(final Object param1, final Object param2, final Object param3, final Object param4) throws SQLException {
setObject(1, param1);
setObject(2, param2);
setObject(3, param3);
setObject(4, param4);
return (Q) this;
}
/**
* Sets the parameters.
*
* @param param1
* @param param2
* @param param3
* @param param4
* @param param5
* @return
* @throws SQLException the SQL exception
*/
public Q setParameters(final Object param1, final Object param2, final Object param3, final Object param4, final Object param5) throws SQLException {
setObject(1, param1);
setObject(2, param2);
setObject(3, param3);
setObject(4, param4);
setObject(5, param5);
return (Q) this;
}
/**
* Sets the parameters.
*
* @param param1
* @param param2
* @param param3
* @param param4
* @param param5
* @param param6
* @return
* @throws SQLException the SQL exception
*/
public Q setParameters(final Object param1, final Object param2, final Object param3, final Object param4, final Object param5, final Object param6)
throws SQLException {
setObject(1, param1);
setObject(2, param2);
setObject(3, param3);
setObject(4, param4);
setObject(5, param5);
setObject(6, param6);
return (Q) this;
}
/**
* Sets the parameters.
*
* @param param1
* @param param2
* @param param3
* @param param4
* @param param5
* @param param6
* @param param7
* @return
* @throws SQLException the SQL exception
*/
public Q setParameters(final Object param1, final Object param2, final Object param3, final Object param4, final Object param5, final Object param6,
final Object param7) throws SQLException {
setObject(1, param1);
setObject(2, param2);
setObject(3, param3);
setObject(4, param4);
setObject(5, param5);
setObject(6, param6);
setObject(7, param7);
return (Q) this;
}
/**
* Sets the parameters.
*
* @param param1
* @param param2
* @param param3
* @param param4
* @param param5
* @param param6
* @param param7
* @param param8
* @return
* @throws SQLException the SQL exception
*/
public Q setParameters(final Object param1, final Object param2, final Object param3, final Object param4, final Object param5, final Object param6,
final Object param7, final Object param8) throws SQLException {
setObject(1, param1);
setObject(2, param2);
setObject(3, param3);
setObject(4, param4);
setObject(5, param5);
setObject(6, param6);
setObject(7, param7);
setObject(8, param8);
return (Q) this;
}
/**
* Sets the parameters.
*
* @param param1
* @param param2
* @param param3
* @param param4
* @param param5
* @param param6
* @param param7
* @param param8
* @param param9
* @return
* @throws SQLException the SQL exception
*/
public Q setParameters(final Object param1, final Object param2, final Object param3, final Object param4, final Object param5, final Object param6,
final Object param7, final Object param8, final Object param9) throws SQLException {
setObject(1, param1);
setObject(2, param2);
setObject(3, param3);
setObject(4, param4);
setObject(5, param5);
setObject(6, param6);
setObject(7, param7);
setObject(8, param8);
setObject(9, param9);
return (Q) this;
}
/**
* Sets the parameters.
*
* @param parameters
* @return
* @throws IllegalArgumentException if specified {@code parameters} or {@code type} is null.
* @throws SQLException the SQL exception
*/
public Q setParameters(final Object[] parameters) throws IllegalArgumentException, SQLException {
checkArgNotNull(parameters, "parameters");
int idx = 1;
for (Object param : parameters) {
setObject(idx++, param);
}
return (Q) this;
}
/**
* Sets the parameters.
*
* @param startParameterIndex
* @param parameters
* @return
* @throws IllegalArgumentException if specified {@code parameters} or {@code type} is null.
* @throws SQLException the SQL exception
*/
public Q setParameters(final Collection parameters) throws IllegalArgumentException, SQLException {
checkArgNotNull(parameters, "parameters");
int idx = 1;
for (Object param : parameters) {
setObject(idx++, param);
}
return (Q) this;
}
/**
* Sets the parameters.
*
* @param paramSetter
* @return
* @throws SQLException the SQL exception
*/
public Q setParameters(final ParametersSetter paramSetter) throws SQLException {
checkArgNotNull(paramSetter, "paramSetter");
boolean noException = false;
try {
paramSetter.accept(stmt);
noException = true;
} finally {
if (noException == false) {
close();
}
}
return (Q) this;
}
/**
* Sets the parameters.
*
* @param
* @param parameters
* @param paramSetter
* @return
* @throws SQLException the SQL exception
*/
public Q setParameters(final T parameters, final BiParametersSetter paramSetter) throws SQLException {
checkArgNotNull(paramSetter, "paramSetter");
boolean noException = false;
try {
paramSetter.accept(stmt, parameters);
noException = true;
} finally {
if (noException == false) {
close();
}
}
return (Q) this;
}
/**
* Sets the parameters.
*
* @param parameters
* @return
* @throws IllegalArgumentException if specified {@code parameters} or {@code type} is null.
* @throws SQLException the SQL exception
*/
public Q settParameters(final int[] parameters) throws IllegalArgumentException, SQLException {
return settParameters(1, parameters);
}
/**
* Sets the parameters.
*
* @param startParameterIndex
* @param parameters
* @return
* @throws IllegalArgumentException if specified {@code parameters} or {@code type} is null.
* @throws SQLException the SQL exception
*/
public Q settParameters(int startParameterIndex, final int[] parameters) throws IllegalArgumentException, SQLException {
checkArgNotNull(parameters, "parameters");
for (int param : parameters) {
stmt.setInt(startParameterIndex++, param);
}
return (Q) this;
}
/**
* Sets the parameters.
*
* @param parameters
* @return
* @throws IllegalArgumentException if specified {@code parameters} or {@code type} is null.
* @throws SQLException the SQL exception
*/
public Q settParameters(final long[] parameters) throws IllegalArgumentException, SQLException {
return settParameters(1, parameters);
}
/**
* Sets the parameters.
*
* @param startParameterIndex
* @param parameters
* @return
* @throws IllegalArgumentException if specified {@code parameters} or {@code type} is null.
* @throws SQLException the SQL exception
*/
public Q settParameters(int startParameterIndex, final long[] parameters) throws IllegalArgumentException, SQLException {
checkArgNotNull(parameters, "parameters");
for (long param : parameters) {
stmt.setLong(startParameterIndex++, param);
}
return (Q) this;
}
/**
* Sets the parameters.
*
* @param parameters
* @return
* @throws IllegalArgumentException if specified {@code parameters} or {@code type} is null.
* @throws SQLException the SQL exception
*/
public Q settParameters(final String[] parameters) throws IllegalArgumentException, SQLException {
return settParameters(1, parameters);
}
/**
* Sets the parameters.
*
* @param startParameterIndex
* @param parameters
* @return
* @throws IllegalArgumentException if specified {@code parameters} or {@code type} is null.
* @throws SQLException the SQL exception
*/
public Q settParameters(int startParameterIndex, final String[] parameters) throws IllegalArgumentException, SQLException {
checkArgNotNull(parameters, "parameters");
for (String param : parameters) {
stmt.setString(startParameterIndex++, param);
}
return (Q) this;
}
/**
* Sets the parameters.
*
* @param
* @param parameters
* @param type
* @return
* @throws IllegalArgumentException if specified {@code parameters} or {@code type} is null.
* @throws SQLException the SQL exception
*/
public Q settParameters(final T[] parameters, final Class type) throws IllegalArgumentException, SQLException {
return settParameters(1, parameters, type);
}
/**
* Sets the parameters.
*
* @param
* @param startParameterIndex
* @param parameters
* @param type
* @return
* @throws IllegalArgumentException if specified {@code parameters} or {@code type} is null.
* @throws SQLException the SQL exception
*/
public Q settParameters(int startParameterIndex, final T[] parameters, final Class type) throws IllegalArgumentException, SQLException {
checkArgNotNull(parameters, "parameters");
checkArgNotNull(type, "type");
final Type setter = N.typeOf(type);
for (T param : parameters) {
setter.set(stmt, startParameterIndex++, param);
}
return (Q) this;
}
/**
* Sets the parameters.
*
* @param
* @param startParameterIndex
* @param parameters
* @param type
* @return
* @throws IllegalArgumentException if specified {@code parameters} or {@code type} is null.
* @throws SQLException the SQL exception
*/
public Q settParameters(final Collection parameters, final Class type) throws IllegalArgumentException, SQLException {
return settParameters(1, parameters, type);
}
/**
* Sets the parameters.
*
* @param
* @param startParameterIndex
* @param parameters
* @param type
* @return
* @throws IllegalArgumentException if specified {@code parameters} or {@code type} is null.
* @throws SQLException the SQL exception
*/
public Q settParameters(int startParameterIndex, final Collection parameters, final Class type)
throws IllegalArgumentException, SQLException {
checkArgNotNull(parameters, "parameters");
checkArgNotNull(type, "type");
final Type setter = N.typeOf(type);
for (T param : parameters) {
setter.set(stmt, startParameterIndex++, param);
}
return (Q) this;
}
/**
*
* @param paramSetter
* @return
* @throws SQLException the SQL exception
*/
public Q settParameters(ParametersSetter paramSetter) throws SQLException {
checkArgNotNull(paramSetter, "paramSetter");
boolean noException = false;
try {
paramSetter.accept((Q) this);
noException = true;
} finally {
if (noException == false) {
close();
}
}
return (Q) this;
}
/**
*
* @param
* @param parameter
* @param paramSetter
* @return
* @throws SQLException the SQL exception
*/
public Q settParameters(final T parameter, BiParametersSetter paramSetter) throws SQLException {
checkArgNotNull(paramSetter, "paramSetter");
boolean noException = false;
try {
paramSetter.accept((Q) this, parameter);
noException = true;
} finally {
if (noException == false) {
close();
}
}
return (Q) this;
}
// /**
// * @param
// * @param batchParameters
// * @param parametersSetter
// * @return
// * @throws SQLException the SQL exception
// */
// Q setBatchParameters(final Collection batchParameters, BiParametersSetter parametersSetter) throws SQLException {
// return setBatchParameters(batchParameters.iterator(), parametersSetter);
// }
//
// /**
// *
// * @param
// * @param batchParameters
// * @param parametersSetter
// * @return
// * @throws SQLException the SQL exception
// */
// Q setBatchParameters(final Iterator batchParameters, BiParametersSetter parametersSetter) throws SQLException {
// checkArgNotNull(batchParameters, "batchParameters");
// checkArgNotNull(parametersSetter, "parametersSetter");
//
// boolean noException = false;
//
// try {
// if (isBatch) {
// stmt.clearBatch();
// }
//
// final Iterator iter = batchParameters;
//
// while (iter.hasNext()) {
// parametersSetter.accept((Q) this, iter.next());
// stmt.addBatch();
// isBatch = true;
// }
//
// noException = true;
// } finally {
// if (noException == false) {
// close();
// }
// }
//
// return (Q) this;
// }
/**
*
* @param
* @param batchParameters
* @return
* @throws SQLException
*/
@SuppressWarnings("rawtypes")
@Beta
public Q addBatchParameters(final Collection batchParameters) throws SQLException {
checkArgNotNull(batchParameters, "batchParameters");
if (N.isNullOrEmpty(batchParameters)) {
return (Q) this;
}
boolean noException = false;
try {
final T first = N.firstNonNull(batchParameters).orNull();
if (first == null) {
for (int i = 0, size = batchParameters.size(); i < size; i++) {
stmt.setObject(1, null);
stmt.addBatch();
}
} else {
if (first instanceof Collection) {
for (Object parameters : batchParameters) {
setParameters((Collection) parameters);
stmt.addBatch();
}
} else if (first instanceof Object[]) {
for (Object parameters : batchParameters) {
setParameters((Object[]) parameters);
stmt.addBatch();
}
} else {
for (Object obj : batchParameters) {
setObject(1, obj);
stmt.addBatch();
}
}
}
isBatch = batchParameters.size() > 0;
noException = true;
} finally {
if (noException == false) {
close();
}
}
return (Q) this;
}
/**
*
* @param
* @param batchParameters
* @return
* @throws SQLException
*/
@Beta
public Q addBatchParameters(final Iterator batchParameters) throws SQLException {
checkArgNotNull(batchParameters, "batchParameters");
return addBatchParameters(Iterators.toList(batchParameters));
}
/**
*
* @param
* @param batchParameters single batch parameters.
* @param type
* @return
* @throws SQLException
*/
@Beta
public Q addBatchParameters(final Collection batchParameters, final Class type) throws SQLException {
checkArgNotNull(batchParameters, "batchParameters");
checkArgNotNull(type, "type");
boolean noException = false;
final Type setter = N.typeOf(type);
try {
for (T parameter : batchParameters) {
setter.set(stmt, 1, parameter);
stmt.addBatch();
}
isBatch = batchParameters.size() > 0;
noException = true;
} finally {
if (noException == false) {
close();
}
}
return (Q) this;
}
// /**
// *
// * @param batchParameters
// * @return
// * @throws SQLException the SQL exception
// */
// public Q addSingleBatchParameters(final Collection batchParameters) throws SQLException {
// checkArgNotNull(batchParameters, "batchParameters");
//
// if (N.isNullOrEmpty(batchParameters)) {
// return (Q) this;
// }
//
// boolean noException = false;
//
// try {
// for (Object obj : batchParameters) {
// setObject(1, obj);
//
// stmt.addBatch();
// }
//
// isBatch = batchParameters.size() > 0;
//
// noException = true;
// } finally {
// if (noException == false) {
// close();
// }
// }
//
// return (Q) this;
// }
//
// /**
// *
// * @param batchParameters
// * @return
// * @throws SQLException the SQL exception
// */
// public Q addSingleBatchParameters(final Iterator batchParameters) throws SQLException {
// checkArgNotNull(batchParameters, "batchParameters");
//
// return addSingleBatchParameters(Iterators.toList(batchParameters));
// }
/**
* @param
* @param batchParameters
* @param parametersSetter
* @return
* @throws SQLException the SQL exception
*/
@Beta
public Q addBatchParameters(final Collection batchParameters, BiParametersSetter parametersSetter) throws SQLException {
checkArgNotNull(batchParameters, "batchParameters");
checkArgNotNull(parametersSetter, "parametersSetter");
return addBatchParameters(batchParameters.iterator(), parametersSetter);
}
/**
*
* @param
* @param batchParameters
* @param parametersSetter
* @return
* @throws SQLException the SQL exception
*/
@Beta
public Q addBatchParameters(final Iterator batchParameters, BiParametersSetter parametersSetter) throws SQLException {
checkArgNotNull(batchParameters, "batchParameters");
checkArgNotNull(parametersSetter, "parametersSetter");
boolean noException = false;
try {
final Iterator iter = batchParameters;
while (iter.hasNext()) {
parametersSetter.accept((Q) this, iter.next());
stmt.addBatch();
isBatch = true;
}
noException = true;
} finally {
if (noException == false) {
close();
}
}
return (Q) this;
}
/**
* @param
* @param batchParameters
* @param parametersSetter
* @return
* @throws SQLException the SQL exception
*/
@Beta
public Q addBatchParameters(final Collection batchParameters,
Throwables.TriConsumer parametersSetter) throws SQLException {
checkArgNotNull(batchParameters, "batchParameters");
checkArgNotNull(parametersSetter, "parametersSetter");
return addBatchParameters(batchParameters.iterator(), parametersSetter);
}
/**
*
* @param
* @param batchParameters
* @param parametersSetter
* @return
* @throws SQLException the SQL exception
*/
@Beta
public Q addBatchParameters(final Iterator batchParameters,
Throwables.TriConsumer parametersSetter) throws SQLException {
checkArgNotNull(batchParameters, "batchParameters");
checkArgNotNull(parametersSetter, "parametersSetter");
boolean noException = false;
try {
final Iterator iter = batchParameters;
while (iter.hasNext()) {
parametersSetter.accept((Q) this, stmt, iter.next());
stmt.addBatch();
isBatch = true;
}
noException = true;
} finally {
if (noException == false) {
close();
}
}
return (Q) this;
}
/**
* @param
* @param batchParameters
* @param parametersSetter
* @return
* @throws SQLException the SQL exception
*/
@Beta
public Q addBatchParametters(final Collection batchParameters, BiParametersSetter parametersSetter) throws SQLException {
checkArgNotNull(batchParameters, "batchParameters");
checkArgNotNull(parametersSetter, "parametersSetter");
return addBatchParametters(batchParameters.iterator(), parametersSetter);
}
/**
*
* @param
* @param batchParameters
* @param parametersSetter
* @return
* @throws SQLException the SQL exception
*/
@Beta
public Q addBatchParametters(final Iterator batchParameters, BiParametersSetter parametersSetter) throws SQLException {
checkArgNotNull(batchParameters, "batchParameters");
checkArgNotNull(parametersSetter, "parametersSetter");
boolean noException = false;
try {
final Iterator iter = batchParameters;
while (iter.hasNext()) {
parametersSetter.accept(stmt, iter.next());
stmt.addBatch();
isBatch = true;
}
noException = true;
} finally {
if (noException == false) {
close();
}
}
return (Q) this;
}
// /**
// * @param
// * @param batchParameters
// * @param parametersSetter
// * @return
// * @throws SQLException the SQL exception
// * @deprecated replaced by {@code addBatchParametters}
// */
// @Deprecated
// @Beta
// public Q addBatchParameters2(final Collection batchParameters, BiParametersSetter parametersSetter) throws SQLException {
// return addBatchParametters(batchParameters, parametersSetter);
// }
//
// /**
// *
// * @param
// * @param batchParameters
// * @param parametersSetter
// * @return
// * @throws SQLException the SQL exception
// * @deprecated replaced by {@code addBatchParametters}
// */
// @Deprecated
// @Beta
// public Q addBatchParameters2(final Iterator batchParameters, BiParametersSetter parametersSetter) throws SQLException {
// return addBatchParametters(batchParameters, parametersSetter);
// }
/**
* Adds the batch.
*
* @return
* @throws SQLException the SQL exception
*/
public Q addBatch() throws SQLException {
stmt.addBatch();
isBatch = true;
return (Q) this;
}
int defaultFetchDirection = -1;
int defaultFetchSize = -1;
int defaultQueryTimeout = -1;
int defaultMaxFieldSize = -1;
/**
* Sets the fetch direction.
*
* @param direction one of ResultSet.FETCH_FORWARD,
* ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN
* @return
* @throws SQLException the SQL exception
* @see {@link java.sql.Statement#setFetchDirection(int)}
*/
public Q setFetchDirection(FetchDirection direction) throws SQLException {
defaultFetchDirection = stmt.getFetchDirection();
stmt.setFetchDirection(direction.intValue);
isFetchDirectionSet = true;
return (Q) this;
}
/**
* Sets the fetch size.
*
* @param rows
* @return
* @throws SQLException the SQL exception
*/
public Q setFetchSize(int rows) throws SQLException {
defaultFetchSize = stmt.getFetchSize();
stmt.setFetchSize(rows);
return (Q) this;
}
/**
* Sets the max field size.
*
* @param max
* @return
* @throws SQLException the SQL exception
*/
public Q setMaxFieldSize(int max) throws SQLException {
defaultMaxFieldSize = stmt.getMaxFieldSize();
stmt.setMaxFieldSize(max);
return (Q) this;
}
/**
* Sets the max rows.
*
* @param max
* @return
* @throws SQLException the SQL exception
*/
public Q setMaxRows(int max) throws SQLException {
stmt.setMaxRows(max);
return (Q) this;
}
/**
* Sets the large max rows.
*
* @param max
* @return
* @throws SQLException the SQL exception
*/
public Q setLargeMaxRows(long max) throws SQLException {
stmt.setLargeMaxRows(max);
return (Q) this;
}
/**
* Sets the query timeout.
*
* @param seconds
* @return
* @throws SQLException the SQL exception
*/
public Q setQueryTimeout(int seconds) throws SQLException {
defaultQueryTimeout = stmt.getQueryTimeout();
stmt.setQueryTimeout(seconds);
return (Q) this;
}
/**
* Query for boolean.
*
* @return
* @throws SQLException the SQL exception
*/
public OptionalBoolean queryForBoolean() throws SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? OptionalBoolean.of(rs.getBoolean(1)) : OptionalBoolean.empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
private static final Type charType = TypeFactory.getType(char.class);
/**
* Query for char.
*
* @return
* @throws SQLException the SQL exception
*/
public OptionalChar queryForChar() throws SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
if (rs.next()) {
return OptionalChar.of(charType.get(rs, 1));
} else {
return OptionalChar.empty();
}
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Query for byte.
*
* @return
* @throws SQLException the SQL exception
*/
public OptionalByte queryForByte() throws SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? OptionalByte.of(rs.getByte(1)) : OptionalByte.empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Query for short.
*
* @return
* @throws SQLException the SQL exception
*/
public OptionalShort queryForShort() throws SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? OptionalShort.of(rs.getShort(1)) : OptionalShort.empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Query for int.
*
* @return
* @throws SQLException the SQL exception
*/
public OptionalInt queryForInt() throws SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? OptionalInt.of(rs.getInt(1)) : OptionalInt.empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Query for long.
*
* @return
* @throws SQLException the SQL exception
*/
public OptionalLong queryForLong() throws SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? OptionalLong.of(rs.getLong(1)) : OptionalLong.empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Query for float.
*
* @return
* @throws SQLException the SQL exception
*/
public OptionalFloat queryForFloat() throws SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? OptionalFloat.of(rs.getFloat(1)) : OptionalFloat.empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Query for double.
*
* @return
* @throws SQLException the SQL exception
*/
public OptionalDouble queryForDouble() throws SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? OptionalDouble.of(rs.getDouble(1)) : OptionalDouble.empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Query for string.
*
* @return
* @throws SQLException the SQL exception
*/
public Nullable queryForString() throws SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? Nullable.of(rs.getString(1)) : Nullable. empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Query big decimal.
*
* @return
* @throws SQLException the SQL exception
*/
public Nullable queryBigDecimal() throws SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? Nullable.of(rs.getBigDecimal(1)) : Nullable. empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Query for date.
*
* @return
* @throws SQLException the SQL exception
*/
public Nullable queryForDate() throws SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? Nullable.of(rs.getDate(1)) : Nullable. empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Query for time.
*
* @return
* @throws SQLException the SQL exception
*/
public Nullable queryForTime() throws SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? Nullable.of(rs.getTime(1)) : Nullable. empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Query for timestamp.
*
* @return
* @throws SQLException the SQL exception
*/
public Nullable queryForTimestamp() throws SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? Nullable.of(rs.getTimestamp(1)) : Nullable. empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns a {@code Nullable} describing the value in the first row/column if it exists, otherwise return an empty {@code Nullable}.
*
* @param the value type
* @param targetClass
* @return
* @throws SQLException the SQL exception
*/
public Nullable queryForSingleResult(Class targetClass) throws SQLException {
checkArgNotNull(targetClass, "targetClass");
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? Nullable.of(N.convert(JdbcUtil.getColumnValue(rs, 1), targetClass)) : Nullable. empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns an {@code Optional} describing the value in the first row/column if it exists, otherwise return an empty {@code Optional}.
*
* @param the value type
* @param targetClass
* @return
* @throws SQLException the SQL exception
*/
public Optional queryForSingleNonNull(Class targetClass) throws SQLException {
checkArgNotNull(targetClass, "targetClass");
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? Optional.of(N.convert(JdbcUtil.getColumnValue(rs, 1), targetClass)) : Optional. empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns a {@code Nullable} describing the value in the first row/column if it exists, otherwise return an empty {@code Nullable}.
* And throws {@code DuplicatedResultException} if more than one record found.
*
* @param the value type
* @param targetClass
* @return
* @throws DuplicatedResultException if more than one record found by the specified {@code id} (or {@code condition}).
* @throws SQLException the SQL exception
*/
public Nullable queryForUniqueResult(Class targetClass) throws DuplicatedResultException, SQLException {
checkArgNotNull(targetClass, "targetClass");
assertNotClosed();
try (ResultSet rs = executeQuery()) {
final Nullable result = rs.next() ? Nullable.of(N.convert(JdbcUtil.getColumnValue(rs, 1), targetClass)) : Nullable. empty();
if (result.isPresent() && rs.next()) {
throw new DuplicatedResultException(
"At least two results found: " + Strings.concat(result.get(), ", ", N.convert(JdbcUtil.getColumnValue(rs, 1), targetClass)));
}
return result;
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns an {@code Optional} describing the value in the first row/column if it exists, otherwise return an empty {@code Optional}.
* And throws {@code DuplicatedResultException} if more than one record found.
*
* @param the value type
* @param targetClass
* @return
* @throws DuplicatedResultException if more than one record found by the specified {@code id} (or {@code condition}).
* @throws SQLException the SQL exception
*/
public Optional queryForUniqueNonNull(Class targetClass) throws DuplicatedResultException, SQLException {
checkArgNotNull(targetClass, "targetClass");
assertNotClosed();
try (ResultSet rs = executeQuery()) {
final Optional result = rs.next() ? Optional.of(N.convert(JdbcUtil.getColumnValue(rs, 1), targetClass)) : Optional. empty();
if (result.isPresent() && rs.next()) {
throw new DuplicatedResultException(
"At least two results found: " + Strings.concat(result.get(), ", ", N.convert(JdbcUtil.getColumnValue(rs, 1), targetClass)));
}
return result;
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
*
* @param
* @param targetClass
* @param rs
* @return
* @throws SQLException the SQL exception
*/
private T get(Class targetClass, ResultSet rs) throws SQLException {
final List columnLabels = JdbcUtil.getColumnLabelList(rs);
return BiRowMapper.to(targetClass).apply(rs, columnLabels);
}
/**
*
* @return
* @throws SQLException the SQL exception
*/
public DataSet query() throws SQLException {
return query(ResultExtractor.TO_DATA_SET);
}
/**
*
* @param
* @param resultExtrator
* @return
* @throws SQLException the SQL exception
*/
public R query(final ResultExtractor resultExtrator) throws SQLException {
checkArgNotNull(resultExtrator, "resultExtrator");
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return checkNotResultSet(resultExtrator.apply(rs));
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
*
* @param
* @param resultExtrator
* @return
* @throws SQLException the SQL exception
*/
public R query(final BiResultExtractor resultExtrator) throws SQLException {
checkArgNotNull(resultExtrator, "resultExtrator");
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return checkNotResultSet(resultExtrator.apply(rs, JdbcUtil.getColumnLabelList(rs)));
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
*
* @param
* @param targetClass
* @return
* @throws DuplicatedResultException If More than one record found by the query
* @throws SQLException the SQL exception
* @deprecated replaced by {@code findOnlyOne}.
*/
@Deprecated
public Optional get(final Class targetClass) throws DuplicatedResultException, SQLException {
return Optional.ofNullable(gett(targetClass));
}
/**
*
* @param
* @param rowMapper
* @return
* @throws DuplicatedResultException If More than one record found by the query
* @throws SQLException the SQL exception
* @deprecated replaced by {@code findOnlyOne}.
*/
@Deprecated
public Optional get(RowMapper rowMapper) throws DuplicatedResultException, SQLException {
return Optional.ofNullable(gett(rowMapper));
}
/**
*
* @param
* @param rowMapper
* @return
* @throws DuplicatedResultException If More than one record found by the query
* @throws SQLException the SQL exception
* @deprecated replaced by {@code findOnlyOne}.
*/
@Deprecated
public Optional get(BiRowMapper rowMapper) throws DuplicatedResultException, SQLException {
return Optional.ofNullable(gett(rowMapper));
}
/**
* Gets the t.
*
* @param
* @param targetClass
* @return
* @throws DuplicatedResultException If More than one record found by the query
* @throws SQLException the SQL exception
* @deprecated replaced by {@code findOnlyOneOrNull}.
*/
@Deprecated
public T gett(final Class targetClass) throws DuplicatedResultException, SQLException {
return findOnlyOneOrNull(targetClass);
}
/**
* Gets the t.
*
* @param
* @param rowMapper
* @return
* @throws DuplicatedResultException If More than one record found by the query
* @throws SQLException the SQL exception
* @deprecated replaced by {@code findOnlyOneOrNull}.
*/
@Deprecated
public T gett(RowMapper rowMapper) throws DuplicatedResultException, SQLException {
return findOnlyOneOrNull(rowMapper);
}
/**
* Gets the t.
*
* @param
* @param rowMapper
* @return
* @throws DuplicatedResultException If More than one record found by the query
* @throws SQLException the SQL exception
* @deprecated replaced by {@code findOnlyOneOrNull}.
*/
@Deprecated
public T gett(BiRowMapper rowMapper) throws DuplicatedResultException, SQLException {
return findOnlyOneOrNull(rowMapper);
}
/**
*
* @param
* @param targetClass
* @return
* @throws DuplicatedResultException If More than one record found by the query
* @throws SQLException the SQL exception
*/
public Optional findOnlyOne(final Class targetClass) throws DuplicatedResultException, SQLException {
return Optional.ofNullable(findOnlyOneOrNull(targetClass));
}
/**
*
* @param
* @param rowMapper
* @return
* @throws DuplicatedResultException If More than one record found by the query
* @throws SQLException the SQL exception
*/
public Optional findOnlyOne(RowMapper rowMapper) throws DuplicatedResultException, SQLException {
return Optional.ofNullable(findOnlyOneOrNull(rowMapper));
}
/**
*
* @param
* @param rowMapper
* @return
* @throws DuplicatedResultException If More than one record found by the query
* @throws SQLException the SQL exception
*/
public Optional findOnlyOne(BiRowMapper rowMapper) throws DuplicatedResultException, SQLException {
return Optional.ofNullable(findOnlyOneOrNull(rowMapper));
}
/**
* Gets the t.
*
* @param
* @param targetClass
* @return
* @throws DuplicatedResultException If More than one record found by the query
* @throws SQLException the SQL exception
*/
public T findOnlyOneOrNull(final Class targetClass) throws DuplicatedResultException, SQLException {
checkArgNotNull(targetClass, "targetClass");
assertNotClosed();
try (ResultSet rs = executeQuery()) {
if (rs.next()) {
final T result = Objects.requireNonNull(get(targetClass, rs));
if (rs.next()) {
throw new DuplicatedResultException("More than one record found by the query");
}
return result;
} else {
return null;
}
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Gets the t.
*
* @param
* @param rowMapper
* @return
* @throws DuplicatedResultException If More than one record found by the query
* @throws SQLException the SQL exception
*/
public T findOnlyOneOrNull(RowMapper rowMapper) throws DuplicatedResultException, SQLException {
checkArgNotNull(rowMapper, "rowMapper");
assertNotClosed();
try (ResultSet rs = executeQuery()) {
if (rs.next()) {
final T result = Objects.requireNonNull(rowMapper.apply(rs));
if (rs.next()) {
throw new DuplicatedResultException("More than one record found by the query");
}
return result;
} else {
return null;
}
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Gets the t.
*
* @param
* @param rowMapper
* @return
* @throws DuplicatedResultException If More than one record found by the query
* @throws SQLException the SQL exception
*/
public T findOnlyOneOrNull(BiRowMapper rowMapper) throws DuplicatedResultException, SQLException {
checkArgNotNull(rowMapper, "rowMapper");
assertNotClosed();
try (ResultSet rs = executeQuery()) {
if (rs.next()) {
final T result = Objects.requireNonNull(rowMapper.apply(rs, JdbcUtil.getColumnLabelList(rs)));
if (rs.next()) {
throw new DuplicatedResultException("More than one record found by the query");
}
return result;
} else {
return null;
}
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
*
* @param
* @param targetClass
* @return
* @throws SQLException the SQL exception
*/
public Optional findFirst(final Class targetClass) throws SQLException {
return Optional.ofNullable(findFirstOrNull(targetClass));
}
/**
*
* @param
* @param rowMapper
* @return
* @throws SQLException the SQL exception
*/
public Optional findFirst(RowMapper rowMapper) throws SQLException {
return Optional.ofNullable(findFirstOrNull(rowMapper));
}
/**
*
* @param
* @param rowFilter
* @param rowMapper
* @return
* @throws SQLException the SQL exception
* @deprecated Use {@link stream(RowFilter, RowMapper).first()} instead.
*/
@Deprecated
public Optional findFirst(final RowFilter rowFilter, RowMapper rowMapper) throws SQLException {
return Optional.ofNullable(findFirstOrNull(rowFilter, rowMapper));
}
/**
*
* @param
* @param rowMapper
* @return
* @throws SQLException the SQL exception
*/
public Optional findFirst(BiRowMapper rowMapper) throws SQLException {
return Optional.ofNullable(findFirstOrNull(rowMapper));
}
/**
*
* @param
* @param rowFilter
* @param rowMapper
* @return
* @throws SQLException the SQL exception
* @deprecated Use {@link stream(BiRowFilter, BiRowMapper).first()} instead.
*/
@Deprecated
public Optional findFirst(final BiRowFilter rowFilter, BiRowMapper rowMapper) throws SQLException {
return Optional.ofNullable(findFirstOrNull(rowFilter, rowMapper));
}
/**
*
* @param
* @param targetClass
* @return
* @throws SQLException the SQL exception
*/
public T findFirstOrNull(final Class targetClass) throws SQLException {
checkArgNotNull(targetClass, "targetClass");
assertNotClosed();
try (ResultSet rs = executeQuery()) {
if (rs.next()) {
return Objects.requireNonNull(get(targetClass, rs));
}
return null;
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
*
* @param
* @param rowMapper
* @return
* @throws SQLException the SQL exception
*/
public T findFirstOrNull(RowMapper rowMapper) throws SQLException {
checkArgNotNull(rowMapper, "rowMapper");
assertNotClosed();
try (ResultSet rs = executeQuery()) {
if (rs.next()) {
return Objects.requireNonNull(rowMapper.apply(rs));
}
return null;
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
*
* @param
* @param rowFilter
* @param rowMapper
* @return
* @throws SQLException the SQL exception
* @deprecated Use {@link stream(RowFilter, RowMapper).first()} instead.
*/
@Deprecated
public T findFirstOrNull(final RowFilter rowFilter, RowMapper rowMapper) throws SQLException {
checkArgNotNull(rowFilter, "rowFilter");
checkArgNotNull(rowMapper, "rowMapper");
assertNotClosed();
try (ResultSet rs = executeQuery()) {
while (rs.next()) {
if (rowFilter.test(rs)) {
return Objects.requireNonNull(rowMapper.apply(rs));
}
}
return null;
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
*
* @param
* @param rowMapper
* @return
* @throws SQLException the SQL exception
*/
public T findFirstOrNull(BiRowMapper rowMapper) throws SQLException {
checkArgNotNull(rowMapper, "rowMapper");
assertNotClosed();
try (ResultSet rs = executeQuery()) {
if (rs.next()) {
return Objects.requireNonNull(rowMapper.apply(rs, JdbcUtil.getColumnLabelList(rs)));
} else {
return null;
}
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
*
* @param
* @param rowFilter
* @param rowMapper
* @return
* @throws SQLException the SQL exception
* @deprecated Use {@link stream(BiRowFilter, BiRowMapper).first()} instead.
*/
@Deprecated
public T findFirstOrNull(final BiRowFilter rowFilter, BiRowMapper rowMapper) throws SQLException {
checkArgNotNull(rowFilter, "rowFilter");
checkArgNotNull(rowMapper, "rowMapper");
assertNotClosed();
try (ResultSet rs = executeQuery()) {
final List columnLabels = JdbcUtil.getColumnLabelList(rs);
while (rs.next()) {
if (rowFilter.test(rs, columnLabels)) {
return Objects.requireNonNull(rowMapper.apply(rs, columnLabels));
}
}
return null;
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
*
* @param
* @param targetClass
* @return
* @throws SQLException the SQL exception
*/
public List list(final Class targetClass) throws SQLException {
return list(BiRowMapper.to(targetClass));
}
/**
*
* @param
* @param targetClass
* @param maxResult
* @return
* @throws SQLException the SQL exception
* @deprecated the result size should be limited in database server side by sql scripts.
*/
@Deprecated
public List list(final Class targetClass, int maxResult) throws SQLException {
return list(BiRowMapper.to(targetClass), maxResult);
}
/**
*
* @param
* @param rowMapper
* @return
* @throws SQLException the SQL exception
*/
public List list(RowMapper rowMapper) throws SQLException {
return list(rowMapper, Integer.MAX_VALUE);
}
/**
*
* @param
* @param rowMapper
* @param maxResult
* @return
* @throws SQLException the SQL exception
* @deprecated the result size should be limited in database server side by sql scripts.
*/
@Deprecated
public List list(RowMapper rowMapper, int maxResult) throws SQLException {
return list(RowFilter.ALWAYS_TRUE, rowMapper, maxResult);
}
/**
*
* @param
* @param rowFilter
* @param rowMapper
* @return
* @throws SQLException the SQL exception
*/
public List list(final RowFilter rowFilter, RowMapper rowMapper) throws SQLException {
return list(rowFilter, rowMapper, Integer.MAX_VALUE);
}
/**
*
* @param
* @param rowFilter
* @param rowMapper
* @param maxResult
* @return
* @throws SQLException the SQL exception
*/
public List list(final RowFilter rowFilter, RowMapper rowMapper, int maxResult) throws SQLException {
checkArgNotNull(rowFilter, "rowFilter");
checkArgNotNull(rowMapper, "rowMapper");
checkArg(maxResult >= 0, "'maxResult' can' be negative: " + maxResult);
assertNotClosed();
try (ResultSet rs = executeQuery()) {
final List result = new ArrayList<>();
while (maxResult > 0 && rs.next()) {
if (rowFilter.test(rs)) {
result.add(rowMapper.apply(rs));
maxResult--;
}
}
return result;
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
*
* @param
* @param rowMapper
* @return
* @throws SQLException the SQL exception
*/
public List list(BiRowMapper rowMapper) throws SQLException {
return list(rowMapper, Integer.MAX_VALUE);
}
/**
*
* @param
* @param rowMapper
* @param maxResult
* @return
* @throws SQLException the SQL exception
* @deprecated the result size should be limited in database server side by sql scripts.
*/
@Deprecated
public List list(BiRowMapper rowMapper, int maxResult) throws SQLException {
return list(BiRowFilter.ALWAYS_TRUE, rowMapper, maxResult);
}
/**
*
* @param
* @param rowFilter
* @param rowMapper
* @return
* @throws SQLException the SQL exception
*/
public List list(final BiRowFilter rowFilter, BiRowMapper rowMapper) throws SQLException {
return list(rowFilter, rowMapper, Integer.MAX_VALUE);
}
/**
*
* @param
* @param rowFilter
* @param rowMapper
* @param maxResult
* @return
* @throws SQLException the SQL exception
*/
public List list(final BiRowFilter rowFilter, BiRowMapper rowMapper, int maxResult) throws SQLException {
checkArgNotNull(rowFilter, "rowFilter");
checkArgNotNull(rowMapper, "rowMapper");
checkArg(maxResult >= 0, "'maxResult' can' be negative: " + maxResult);
assertNotClosed();
try (ResultSet rs = executeQuery()) {
final List columnLabels = JdbcUtil.getColumnLabelList(rs);
final List result = new ArrayList<>();
while (maxResult > 0 && rs.next()) {
if (rowFilter.test(rs, columnLabels)) {
result.add(rowMapper.apply(rs, columnLabels));
maxResult--;
}
}
return result;
} finally {
closeAfterExecutionIfAllowed();
}
}
// Will it cause confusion if it's called in transaction?
/**
* lazy-execution, lazy-fetch.
*
* @param
* @param targetClass
* @return
* @throws SQLException the SQL exception
*/
public ExceptionalStream stream(final Class targetClass) throws SQLException {
return stream(BiRowMapper.to(targetClass));
}
// Will it cause confusion if it's called in transaction?
/**
* lazy-execution, lazy-fetch.
*
* @param
* @param rowMapper
* @return
* @throws SQLException the SQL exception
*/
public ExceptionalStream stream(final RowMapper rowMapper) throws SQLException {
checkArgNotNull(rowMapper, "rowMapper");
assertNotClosed();
final ExceptionalIterator lazyIter = ExceptionalIterator
.of(new Throwables.Supplier, SQLException>() {
private ExceptionalIterator internalIter;
@Override
public ExceptionalIterator get() throws SQLException {
if (internalIter == null) {
ResultSet rs = null;
try {
rs = executeQuery();
final ResultSet resultSet = rs;
internalIter = new ExceptionalIterator() {
private boolean hasNext;
@Override
public boolean hasNext() throws SQLException {
if (hasNext == false) {
hasNext = resultSet.next();
}
return hasNext;
}
@Override
public T next() throws SQLException {
if (hasNext() == false) {
throw new NoSuchElementException();
}
hasNext = false;
return rowMapper.apply(resultSet);
}
@Override
public void skip(long n) throws SQLException {
N.checkArgNotNegative(n, "n");
final long m = hasNext ? n - 1 : n;
hasNext = false;
JdbcUtil.skip(resultSet, m);
}
@Override
public long count() throws SQLException {
long cnt = hasNext ? 1 : 0;
hasNext = false;
while (resultSet.next()) {
cnt++;
}
return cnt;
}
@Override
public void close() throws SQLException {
try {
JdbcUtil.closeQuietly(resultSet);
} finally {
closeAfterExecutionIfAllowed();
}
}
};
} finally {
if (internalIter == null) {
try {
JdbcUtil.closeQuietly(rs);
} finally {
closeAfterExecutionIfAllowed();
}
}
}
}
return internalIter;
}
});
return ExceptionalStream.newStream(lazyIter).onClose(new Throwables.Runnable() {
@Override
public void run() throws SQLException {
lazyIter.close();
}
});
}
// Will it cause confusion if it's called in transaction?
/**
* lazy-execution, lazy-fetch.
*
* @param
* @param rowMapper
* @return
* @throws SQLException the SQL exception
*/
public ExceptionalStream stream(final BiRowMapper rowMapper) throws SQLException {
checkArgNotNull(rowMapper, "rowMapper");
assertNotClosed();
final ExceptionalIterator 