org.apache.shardingsphere.shardingjdbc.jdbc.core.statement

Class ShardingPreparedStatement

java.lang.Object

org.apache.shardingsphere.shardingjdbc.jdbc.adapter.WrapperAdapter

org.apache.shardingsphere.shardingjdbc.jdbc.unsupported.AbstractUnsupportedOperationStatement

org.apache.shardingsphere.shardingjdbc.jdbc.adapter.AbstractStatementAdapter

org.apache.shardingsphere.shardingjdbc.jdbc.unsupported.AbstractUnsupportedOperationPreparedStatement

org.apache.shardingsphere.shardingjdbc.jdbc.adapter.AbstractShardingPreparedStatementAdapter

org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement

All Implemented Interfaces:

AutoCloseable, PreparedStatement, Statement, Wrapper

public final class ShardingPreparedStatement
extends AbstractShardingPreparedStatementAdapter

PreparedStatement that support sharding.

Author:

zhangliang, caohao, maxiaoguang, panjuan

Field Summary

Fields inherited from interface java.sql.Statement

CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

Constructor Summary

Constructors

Constructor and Description
ShardingPreparedStatement(ShardingConnection connection, String sql)
ShardingPreparedStatement(ShardingConnection connection, String sql, int autoGeneratedKeys)
ShardingPreparedStatement(ShardingConnection connection, String sql, int resultSetType, int resultSetConcurrency)
ShardingPreparedStatement(ShardingConnection connection, String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)

Method Summary

Modifier and Type	Method and Description
void	addBatch()
void	clearBatch()
boolean	execute()
int[]	executeBatch()
ResultSet	executeQuery()
int	executeUpdate()
ResultSet	getGeneratedKeys()
ResultSet	getResultSet()
int	getResultSetConcurrency()
int	getResultSetHoldability()
int	getResultSetType()
Collection<PreparedStatement>	getRoutedStatements()
boolean	isAccumulate()

Methods inherited from class org.apache.shardingsphere.shardingjdbc.jdbc.adapter.AbstractShardingPreparedStatementAdapter

clearParameters, replaySetParameter, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL

Methods inherited from class org.apache.shardingsphere.shardingjdbc.jdbc.unsupported.AbstractUnsupportedOperationPreparedStatement

execute, execute, execute, execute, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getMetaData, getParameterMetaData, setArray, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setRef, setRowId

Methods inherited from class org.apache.shardingsphere.shardingjdbc.jdbc.adapter.AbstractStatementAdapter

cancel, clearWarnings, close, getFetchSize, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getUpdateCount, getWarnings, isClosed, isPoolable, setEscapeProcessing, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from class org.apache.shardingsphere.shardingjdbc.jdbc.unsupported.AbstractUnsupportedOperationStatement

addBatch, closeOnCompletion, getFetchDirection, isCloseOnCompletion, setCursorName, setFetchDirection

Methods inherited from class org.apache.shardingsphere.shardingjdbc.jdbc.adapter.WrapperAdapter

isWrapperFor, recordMethodInvocation, replayMethodsInvocation, unwrap

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.sql.PreparedStatement

executeLargeUpdate, setObject, setObject

Methods inherited from interface java.sql.Statement

addBatch, cancel, clearWarnings, close, closeOnCompletion, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getConnection, getFetchDirection, getFetchSize, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Constructor Detail

ShardingPreparedStatement

public ShardingPreparedStatement(ShardingConnection connection,
                                 String sql)
                          throws SQLException

Throws:

SQLException

ShardingPreparedStatement

public ShardingPreparedStatement(ShardingConnection connection,
                                 String sql,
                                 int resultSetType,
                                 int resultSetConcurrency)
                          throws SQLException

Throws:

SQLException

ShardingPreparedStatement

public ShardingPreparedStatement(ShardingConnection connection,
                                 String sql,
                                 int autoGeneratedKeys)
                          throws SQLException

Throws:

SQLException

ShardingPreparedStatement

public ShardingPreparedStatement(ShardingConnection connection,
                                 String sql,
                                 int resultSetType,
                                 int resultSetConcurrency,
                                 int resultSetHoldability)
                          throws SQLException

Throws:

SQLException

Method Detail

executeQuery

public ResultSet executeQuery()
                       throws SQLException

Throws:

SQLException

getResultSet

public ResultSet getResultSet()
                       throws SQLException

Throws:

SQLException

executeUpdate

public int executeUpdate()
                  throws SQLException

Throws:

SQLException

execute

public boolean execute()
                throws SQLException

Throws:

SQLException

getGeneratedKeys

public ResultSet getGeneratedKeys()
                           throws SQLException

Throws:

SQLException

addBatch

public void addBatch()

executeBatch

public int[] executeBatch()
                   throws SQLException

Specified by:

executeBatch in interface Statement

Overrides:

executeBatch in class AbstractUnsupportedOperationStatement

Throws:

SQLException

clearBatch

public void clearBatch()
                throws SQLException

Specified by:

clearBatch in interface Statement

Overrides:

clearBatch in class AbstractUnsupportedOperationStatement

Throws:

SQLException

getResultSetType

public int getResultSetType()

getResultSetConcurrency

public int getResultSetConcurrency()

getResultSetHoldability

public int getResultSetHoldability()

isAccumulate

public boolean isAccumulate()

Specified by:

isAccumulate in class AbstractStatementAdapter

getRoutedStatements

public Collection<PreparedStatement> getRoutedStatements()

Specified by:

getRoutedStatements in class AbstractStatementAdapter