Uses of Class
io.github.connellite.jdbc.NamedPreparedStatement
Packages that use NamedPreparedStatement
-
Uses of NamedPreparedStatement in io.github.connellite.jdbc
Methods in io.github.connellite.jdbc that return NamedPreparedStatementModifier and TypeMethodDescriptionstatic NamedPreparedStatementNamedPreparedStatement.of(Connection connection, String sql) Static factory forNamedPreparedStatement.static NamedPreparedStatementNamedPreparedStatement.of(Connection connection, String sql, int autoGeneratedKeys) Static factory forNamedPreparedStatementwith auto-generated keys behavior.static NamedPreparedStatementNamedPreparedStatement.of(Connection connection, String sql, int[] columnIndexes) Static factory forNamedPreparedStatementrequesting generated keys by column indexes.static NamedPreparedStatementNamedPreparedStatement.of(Connection connection, String sql, int[] columnIndexes, SqlParser sqlParser) Static factory forNamedPreparedStatementrequesting generated keys by column indexes with custom SQL parser.static NamedPreparedStatementNamedPreparedStatement.of(Connection connection, String sql, int resultSetType, int resultSetConcurrency) Static factory forNamedPreparedStatementwith result-set type and concurrency.static NamedPreparedStatementNamedPreparedStatement.of(Connection connection, String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) Static factory forNamedPreparedStatementwith result-set type, concurrency and holdability.static NamedPreparedStatementNamedPreparedStatement.of(Connection connection, String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability, SqlParser sqlParser) Static factory forNamedPreparedStatementwith result-set type, concurrency, holdability and custom SQL parser.static NamedPreparedStatementNamedPreparedStatement.of(Connection connection, String sql, int resultSetType, int resultSetConcurrency, SqlParser sqlParser) Static factory forNamedPreparedStatementwith result-set type, concurrency and custom SQL parser.static NamedPreparedStatementNamedPreparedStatement.of(Connection connection, String sql, int autoGeneratedKeys, SqlParser sqlParser) Static factory forNamedPreparedStatementwith auto-generated keys behavior and custom SQL parser.static NamedPreparedStatementNamedPreparedStatement.of(Connection connection, String sql, SqlParser sqlParser) Static factory forNamedPreparedStatementwith a custom SQL parser.static NamedPreparedStatementNamedPreparedStatement.of(Connection connection, String sql, String[] columnNames) Static factory forNamedPreparedStatementrequesting generated keys by column names.static NamedPreparedStatementNamedPreparedStatement.of(Connection connection, String sql, String[] columnNames, SqlParser sqlParser) Static factory forNamedPreparedStatementrequesting generated keys by column names with custom SQL parser.NamedQuery.prepare(Connection connection) Resolves bindings and creates a fully boundNamedPreparedStatement.Binds all entries from map usingsetObject(String, Object).Binds SQL array value.NamedPreparedStatement.setAsciiStream(String name, InputStream value) Binds ASCII stream.NamedPreparedStatement.setAsciiStream(String name, InputStream value, int length) Binds ASCII stream with int length.NamedPreparedStatement.setAsciiStream(String name, InputStream value, long length) Binds ASCII stream with long length.Binds@Bindmembers ofbean.NamedPreparedStatement.setBigDecimal(String name, BigDecimal value) BindsBigDecimalvalue to all occurrences of named parameter.NamedPreparedStatement.setBinaryStream(String name, InputStream value) Binds binary stream.NamedPreparedStatement.setBinaryStream(String name, InputStream value, int length) Binds binary stream with int length.NamedPreparedStatement.setBinaryStream(String name, InputStream value, long length) Binds binary stream with long length.NamedPreparedStatement.setBlob(String name, InputStream inputStream) Binds blob binary stream value.NamedPreparedStatement.setBlob(String name, InputStream inputStream, long length) Binds blob binary stream value with explicit length.BindsBlobvalue.NamedPreparedStatement.setBoolean(String name, boolean value) Binds boolean value to all occurrences of named parameter.Binds byte value to all occurrences of named parameter.Binds byte array value to all occurrences of named parameter.NamedPreparedStatement.setCharacterStream(String name, Reader reader) Binds character stream.NamedPreparedStatement.setCharacterStream(String name, Reader reader, int length) Binds character stream with int length.NamedPreparedStatement.setCharacterStream(String name, Reader reader, long length) Binds character stream with long length.Binds character reader as CLOB.Binds character reader as CLOB with explicit length.BindsClobvalue.BindsDatevalue to all occurrences of named parameter.BindsDatevalue with calendar to all occurrences of named parameter.Binds double value to all occurrences of named parameter.Binds float value to all occurrences of named parameter.Binds int value to all occurrences of named parameter.Binds long value to all occurrences of named parameter.NamedPreparedStatement.setNCharacterStream(String name, Reader value) Binds NCHAR character stream.NamedPreparedStatement.setNCharacterStream(String name, Reader value, long length) Binds NCHAR character stream with explicit length.Binds reader as NCLOB.Binds reader as NCLOB with explicit length.BindsNClobvalue.NamedPreparedStatement.setNString(String name, String value) Binds national character string value.Binds SQL NULL of generic typeTypes.NULL.Binds SQL NULL with explicit JDBC type.Binds SQL NULL with explicit JDBC type and database-specific type name.Binds object value to all occurrences of named parameter.Binds object with explicit JDBC SQL type.Binds object with explicit JDBC SQL type and scale/length.Binds object withSQLType.NamedPreparedStatement.setObject(String name, Object value, SQLType targetSqlType, int scaleOrLength) Binds object withSQLTypeand scale/length.Binds SQL reference value.Binds JDBC row id value.Binds short value to all occurrences of named parameter.Binds SQLXML value.Binds string value to all occurrences of named parameter.BindsTimevalue to all occurrences of named parameter.BindsTimevalue with calendar to all occurrences of named parameter.NamedPreparedStatement.setTimestamp(String name, Timestamp value) BindsTimestampvalue to all occurrences of named parameter.NamedPreparedStatement.setTimestamp(String name, Timestamp value, Calendar cal) BindsTimestampvalue with calendar to all occurrences of named parameter.Binds URL value.Methods in io.github.connellite.jdbc with parameters of type NamedPreparedStatementModifier and TypeMethodDescriptionstatic <T> List<T>ResultSetBeanIterator.getAll(SimpleResultSetBeanMapper<T> mapper, NamedPreparedStatement nps) Reads all mapped rows into an immutable list using provided mapper.static <T> List<T>ResultSetBeanIterator.getAll(Class<T> beanClass, NamedPreparedStatement nps) Reads all mapped rows into an immutable list.ResultSetIterator.getAll(NamedPreparedStatement nps) Reads all rows into an immutable list.ResultSetStringIterator.getAll(NamedPreparedStatement nps) Reads all rows into an immutable list.static <T> Optional<T>ResultSetBeanIterator.getFirst(SimpleResultSetBeanMapper<T> mapper, NamedPreparedStatement nps) Reads the first mapped row, if present, using provided mapper.static <T> Optional<T>ResultSetBeanIterator.getFirst(Class<T> beanClass, NamedPreparedStatement nps) Reads the first mapped row, if present.ResultSetIterator.getFirst(NamedPreparedStatement nps) Reads the first row, if present.ResultSetStringIterator.getFirst(NamedPreparedStatement nps) Reads the first row, if present.static <T> Stream<T>ResultSetBeanStream.stream(SimpleResultSetBeanMapper<T> mapper, NamedPreparedStatement nps) static <T> Stream<T>ResultSetBeanStream.stream(Class<T> beanClass, NamedPreparedStatement nps) ResultSetStream.stream(NamedPreparedStatement nps) ResultSetStringStream.stream(NamedPreparedStatement nps) Constructors in io.github.connellite.jdbc with parameters of type NamedPreparedStatementModifierConstructorDescriptionExecutes a boundNamedPreparedStatementand prepares iteration over rows.Executes a boundNamedPreparedStatementand iterates rows using provided mapper.ResultSetBeanIterator(Class<T> beanClass, NamedPreparedStatement nps) Executes a boundNamedPreparedStatementand iterates rows mapped tobeanClass.Executes a boundNamedPreparedStatement; all named parameters must be bound before use.Executes a boundNamedPreparedStatement; all named parameters must be bound before use.