APIdia Launch Partner
Top Fields Constructors Methods
net.ucanaccess.converters

public Class ParametricQuery

extends Object
Class Inheritance
Imports
io.github.spannm.jackcess.impl.query.AppendQueryImpl, .QueryImpl, io.github.spannm.jackcess.query.Query, java.sql.*, java.util.*, java.util.regex.Pattern

Field Summary

Modifier and TypeField and Description
private Map<String, String>
aposMap

private boolean
conversionOk

private String
defaultParameterValues

private Exception
exception

private final Connection
hsqldb

private boolean
isProcedure

private boolean
issueWithParameterName

private boolean
loaded

private StringBuilder
originalParameters

private List<String>
parameterList

private String
parameters

private PreparedStatement
ps

private final QueryImpl
qi

private String
signature

private String
sqlContent

Constructor Summary

AccessConstructor and Description
public
ParametricQuery(Connection hsqldb, QueryImpl qi)

Method Summary

Modifier and TypeMethod and Description
private String
completeTypeName(String type, int i, int j, boolean useDefault)

private String
convertApos(String sql)

private String
convertSQL(String sql)

private String
convertSQL(String sql, List<String> parameters2)

public void
createProcedure()

public void
createSelect()

private void
doParametersEmpiric(Map<String, Integer> psmp, List<String> paramNames, Map<String, String> parem, String sql)

private boolean
exec(String expression)

public Exception
getException()

public String
getSignature()

private String
getSQL()

private String
getTableDefinition()

public boolean
isIssueWithParameterName()

public boolean
loaded()

private void
parametersDeclared()

private void
parametersEmpiric()

private void
parametersEmpiric(boolean partialParDecl)

private List<Integer>
parIndexes(String s)

private List<String>
queryParameters()

private Map<String, Integer>
reorderIndexes(Map<String, Integer> psmp, Map<String, String> parem)

public void
setIssueWithParameterName(boolean issueWithParameterName)

private static String
transalteFormFields(String input)

private String
treatApos(String s)

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait

Field Detail

aposMapback to summary
private Map<String, String> aposMap
conversionOkback to summary
private boolean conversionOk
defaultParameterValuesback to summary
private String defaultParameterValues
exceptionback to summary
private Exception exception
hsqldbback to summary
private final Connection hsqldb
isProcedureback to summary
private boolean isProcedure
issueWithParameterNameback to summary
private boolean issueWithParameterName
loadedback to summary
private boolean loaded
originalParametersback to summary
private StringBuilder originalParameters
parameterListback to summary
private List<String> parameterList
parametersback to summary
private String parameters
psback to summary
private PreparedStatement ps
qiback to summary
private final QueryImpl qi
signatureback to summary
private String signature
sqlContentback to summary
private String sqlContent

Constructor Detail

ParametricQueryback to summary
public ParametricQuery(Connection hsqldb, QueryImpl qi)

Method Detail

completeTypeNameback to summary
private String completeTypeName(String type, int i, int j, boolean useDefault)
convertAposback to summary
private String convertApos(String sql)
convertSQLback to summary
private String convertSQL(String sql)
convertSQLback to summary
private String convertSQL(String sql, List<String> parameters2)
createProcedureback to summary
public void createProcedure()
createSelectback to summary
public void createSelect()
doParametersEmpiricback to summary
private void doParametersEmpiric(Map<String, Integer> psmp, List<String> paramNames, Map<String, String> parem, String sql)
execback to summary
private boolean exec(String expression)
getExceptionback to summary
public Exception getException()
getSignatureback to summary
public String getSignature()
getSQLback to summary
private String getSQL()
getTableDefinitionback to summary
private String getTableDefinition() throws SQLException
isIssueWithParameterNameback to summary
public boolean isIssueWithParameterName()
loadedback to summary
public boolean loaded()
parametersDeclaredback to summary
private void parametersDeclared()
parametersEmpiricback to summary
private void parametersEmpiric()
parametersEmpiricback to summary
private void parametersEmpiric(boolean partialParDecl)
parIndexesback to summary
private List<Integer> parIndexes(String s)
queryParametersback to summary
private List<String> queryParameters()
reorderIndexesback to summary
private Map<String, Integer> reorderIndexes(Map<String, Integer> psmp, Map<String, String> parem)
setIssueWithParameterNameback to summary
public void setIssueWithParameterName(boolean issueWithParameterName)
transalteFormFieldsback to summary
private static String transalteFormFields(String input)
treatAposback to summary
private String treatApos(String s)