com.jn.sqlhelper.springjdbc.statement

类 PreparedStatementCreatorImpl

java.lang.Object

com.jn.sqlhelper.springjdbc.statement.PreparedStatementCreatorImpl

所有已实现的接口:

PagedPreparedParameterSetter, org.springframework.jdbc.core.ParameterDisposer, org.springframework.jdbc.core.PreparedStatementCreator, org.springframework.jdbc.core.PreparedStatementSetter, org.springframework.jdbc.core.SqlProvider

public class PreparedStatementCreatorImpl
extends Object
implements org.springframework.jdbc.core.PreparedStatementCreator, org.springframework.jdbc.core.PreparedStatementSetter, org.springframework.jdbc.core.SqlProvider, org.springframework.jdbc.core.ParameterDisposer, PagedPreparedParameterSetter

嵌套类概要

嵌套类

限定符和类型	类和说明
static class	PreparedStatementCreatorImpl.Factory

构造器概要

构造器

构造器和说明
PreparedStatementCreatorImpl(String actualSql, List<org.springframework.jdbc.core.SqlParameter> declaredParameters, List<?> parameters)

方法概要

限定符和类型	方法和说明
void	cleanupParameters()
PreparedStatement	createPreparedStatement(Connection con)
String	getSql()
int	setAfterSubqueryParameters(PreparedStatement statement, QueryParameters queryParameters, int startIndex)
int	setBeforeSubqueryParameters(PreparedStatement statement, QueryParameters queryParameters, int startIndex)
void	setGeneratedKeysColumnNames(String... names) Set the column names of the auto-generated keys.
int	setOriginalParameters(PreparedStatement statement, QueryParameters queryParameters, int startIndex)
void	setResultSetType(int resultSetType) Set whether to use prepared statements that return a specific type of ResultSet.
void	setReturnGeneratedKeys(boolean returnGeneratedKeys) Set whether prepared statements should be capable of returning auto-generated keys.
int	setSubqueryParameters(PreparedStatement statement, QueryParameters queryParameters, int startIndex)
void	setUpdatableResults(boolean updatableResults) Set whether to use prepared statements capable of returning updatable ResultSets.
void	setValues(PreparedStatement ps)
String	toString()

从类继承的方法 java.lang.Object

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

构造器详细资料

PreparedStatementCreatorImpl

public PreparedStatementCreatorImpl(String actualSql,
                                    List<org.springframework.jdbc.core.SqlParameter> declaredParameters,
                                    List<?> parameters)

方法详细资料

createPreparedStatement

public PreparedStatement createPreparedStatement(Connection con)
                                          throws SQLException

指定者:

createPreparedStatement 在接口中 org.springframework.jdbc.core.PreparedStatementCreator

抛出:

SQLException

setValues

public void setValues(PreparedStatement ps)
               throws SQLException

指定者:

setValues 在接口中 org.springframework.jdbc.core.PreparedStatementSetter

抛出:

SQLException

getSql

public String getSql()

指定者:

getSql 在接口中 org.springframework.jdbc.core.SqlProvider

cleanupParameters

public void cleanupParameters()

指定者:

cleanupParameters 在接口中 org.springframework.jdbc.core.ParameterDisposer

toString

public String toString()

覆盖:

toString 在类中 Object

setResultSetType

public void setResultSetType(int resultSetType)

Set whether to use prepared statements that return a specific type of ResultSet.

参数:

resultSetType - the ResultSet type

另请参阅:

ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.TYPE_SCROLL_SENSITIVE

setUpdatableResults

public void setUpdatableResults(boolean updatableResults)

Set whether to use prepared statements capable of returning updatable ResultSets.

setReturnGeneratedKeys

public void setReturnGeneratedKeys(boolean returnGeneratedKeys)

Set whether prepared statements should be capable of returning auto-generated keys.

setGeneratedKeysColumnNames

public void setGeneratedKeysColumnNames(String... names)

Set the column names of the auto-generated keys.

setBeforeSubqueryParameters

public int setBeforeSubqueryParameters(PreparedStatement statement,
                                       QueryParameters queryParameters,
                                       int startIndex)
                                throws SQLException

指定者:

setBeforeSubqueryParameters 在接口中 PagedPreparedParameterSetter

抛出:

SQLException

setSubqueryParameters

public int setSubqueryParameters(PreparedStatement statement,
                                 QueryParameters queryParameters,
                                 int startIndex)
                          throws SQLException

指定者:

setSubqueryParameters 在接口中 PagedPreparedParameterSetter

抛出:

SQLException

setAfterSubqueryParameters

public int setAfterSubqueryParameters(PreparedStatement statement,
                                      QueryParameters queryParameters,
                                      int startIndex)
                               throws SQLException

指定者:

setAfterSubqueryParameters 在接口中 PagedPreparedParameterSetter

抛出:

SQLException

setOriginalParameters

public int setOriginalParameters(PreparedStatement statement,
                                 QueryParameters queryParameters,
                                 int startIndex)
                          throws SQLException

指定者:

setOriginalParameters 在接口中 PagedPreparedParameterSetter

抛出:

SQLException