com.jn.sqlhelper.springjdbc.statement

类 NamedParameterPreparedStatementCreatorFactory

java.lang.Object

org.springframework.jdbc.core.PreparedStatementCreatorFactory

com.jn.sqlhelper.springjdbc.statement.NamedParameterPreparedStatementCreatorFactory

public class NamedParameterPreparedStatementCreatorFactory
extends org.springframework.jdbc.core.PreparedStatementCreatorFactory

构造器概要

构造器

构造器和说明
NamedParameterPreparedStatementCreatorFactory(String sql) Create a new factory.
NamedParameterPreparedStatementCreatorFactory(String sql, int... types) Create a new factory with the given SQL and JDBC types.
NamedParameterPreparedStatementCreatorFactory(String sql, List<org.springframework.jdbc.core.SqlParameter> declaredParameters) Create a new factory with the given SQL and parameters.

方法概要

限定符和类型	方法和说明
List<org.springframework.jdbc.core.SqlParameter>	getDeclaredParameters()
String[]	getGeneratedKeysColumnNames()
int	getResultSetType()
boolean	isReturnGeneratedKeys()
boolean	isUpdatableResults()
org.springframework.jdbc.core.PreparedStatementCreator	newPreparedStatementCreator(List<?> params) Return a new PreparedStatementCreator for the given parameters.
org.springframework.jdbc.core.PreparedStatementCreator	newPreparedStatementCreator(Object[] params) Return a new PreparedStatementCreator for the given parameters.
org.springframework.jdbc.core.PreparedStatementCreator	newPreparedStatementCreator(String sqlToUse, Object[] params) Return a new PreparedStatementCreator for the given parameters.
org.springframework.jdbc.core.PreparedStatementSetter	newPreparedStatementSetter(List<?> params) Return a new PreparedStatementSetter for the given parameters.
org.springframework.jdbc.core.PreparedStatementSetter	newPreparedStatementSetter(Object[] params) Return a new PreparedStatementSetter for the given parameters.
void	setDeclaredParameters(List<org.springframework.jdbc.core.SqlParameter> declaredParameters)
void	setGeneratedKeysColumnNames(String[] generatedKeysColumnNames)
void	setResultSetType(int resultSetType)
void	setReturnGeneratedKeys(boolean returnGeneratedKeys)
void	setSql(String sql)
void	setUpdatableResults(boolean updatableResults)

从类继承的方法 org.springframework.jdbc.core.PreparedStatementCreatorFactory

addParameter, setNativeJdbcExtractor

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

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

构造器详细资料

NamedParameterPreparedStatementCreatorFactory

public NamedParameterPreparedStatementCreatorFactory(String sql)

Create a new factory. Will need to add parameters via the PreparedStatementCreatorFactory.addParameter(org.springframework.jdbc.core.SqlParameter) method or have no parameters.

参数:

sql - the SQL statement to execute

NamedParameterPreparedStatementCreatorFactory

public NamedParameterPreparedStatementCreatorFactory(String sql,
                                                     int... types)

Create a new factory with the given SQL and JDBC types.

参数:

sql - the SQL statement to execute

types - int array of JDBC types

NamedParameterPreparedStatementCreatorFactory

public NamedParameterPreparedStatementCreatorFactory(String sql,
                                                     List<org.springframework.jdbc.core.SqlParameter> declaredParameters)

Create a new factory with the given SQL and parameters.

参数:

sql - the SQL statement to execute

declaredParameters - list of SqlParameter objects

方法详细资料

newPreparedStatementSetter

public org.springframework.jdbc.core.PreparedStatementSetter newPreparedStatementSetter(List<?> params)

Return a new PreparedStatementSetter for the given parameters.

覆盖:

newPreparedStatementSetter 在类中 org.springframework.jdbc.core.PreparedStatementCreatorFactory

参数:

params - list of parameters (may be null)

newPreparedStatementSetter

public org.springframework.jdbc.core.PreparedStatementSetter newPreparedStatementSetter(Object[] params)

Return a new PreparedStatementSetter for the given parameters.

覆盖:

newPreparedStatementSetter 在类中 org.springframework.jdbc.core.PreparedStatementCreatorFactory

参数:

params - the parameter array (may be null)

newPreparedStatementCreator

public org.springframework.jdbc.core.PreparedStatementCreator newPreparedStatementCreator(List<?> params)

Return a new PreparedStatementCreator for the given parameters.

覆盖:

newPreparedStatementCreator 在类中 org.springframework.jdbc.core.PreparedStatementCreatorFactory

参数:

params - list of parameters (may be null)

newPreparedStatementCreator

public org.springframework.jdbc.core.PreparedStatementCreator newPreparedStatementCreator(Object[] params)

Return a new PreparedStatementCreator for the given parameters.

覆盖:

newPreparedStatementCreator 在类中 org.springframework.jdbc.core.PreparedStatementCreatorFactory

参数:

params - the parameter array (may be null)

newPreparedStatementCreator

public org.springframework.jdbc.core.PreparedStatementCreator newPreparedStatementCreator(String sqlToUse,
                                                                                          Object[] params)

Return a new PreparedStatementCreator for the given parameters.

覆盖:

newPreparedStatementCreator 在类中 org.springframework.jdbc.core.PreparedStatementCreatorFactory

参数:

sqlToUse - the actual SQL statement to use (if different from the factory's, for example because of named parameter expanding)

params - the parameter array (may be null)

setSql

public void setSql(String sql)

getDeclaredParameters

public List<org.springframework.jdbc.core.SqlParameter> getDeclaredParameters()

setDeclaredParameters

public void setDeclaredParameters(List<org.springframework.jdbc.core.SqlParameter> declaredParameters)

getResultSetType

public int getResultSetType()

setResultSetType

public void setResultSetType(int resultSetType)

覆盖:

setResultSetType 在类中 org.springframework.jdbc.core.PreparedStatementCreatorFactory

isUpdatableResults

public boolean isUpdatableResults()

setUpdatableResults

public void setUpdatableResults(boolean updatableResults)

覆盖:

setUpdatableResults 在类中 org.springframework.jdbc.core.PreparedStatementCreatorFactory

isReturnGeneratedKeys

public boolean isReturnGeneratedKeys()

setReturnGeneratedKeys

public void setReturnGeneratedKeys(boolean returnGeneratedKeys)

覆盖:

setReturnGeneratedKeys 在类中 org.springframework.jdbc.core.PreparedStatementCreatorFactory

getGeneratedKeysColumnNames

public String[] getGeneratedKeysColumnNames()

setGeneratedKeysColumnNames

public void setGeneratedKeysColumnNames(String[] generatedKeysColumnNames)

覆盖:

setGeneratedKeysColumnNames 在类中 org.springframework.jdbc.core.PreparedStatementCreatorFactory