com.jaxfront.core.util.sql
Interface ISQLTypeMapping


public interface ISQLTypeMapping


Method Summary
 void addValueToSQLStatement(int type, java.sql.PreparedStatement statement, int position, java.lang.Object value)
           
 java.lang.Object convertToDBNativeVal(java.lang.String searchValue, int type)
           
 java.lang.String createSQLValueFieldFor(java.lang.String dataType, java.lang.String value, boolean addPercentage, boolean searchFieldsToUpperCase)
           
 java.lang.String getCurrentDateTimeSQL()
           
 java.lang.String getCurrentDateTimeSQLField()
           
 java.lang.String getNextSequenceValue(java.sql.Connection con, java.lang.String sequenceName, int batchReadCount)
           
 java.lang.String getNextSequenceValue(java.sql.Connection con, java.lang.String tableName, java.lang.String uuidFName, int batchReadCount)
           
 java.lang.String getSQLInNullString()
           
 java.lang.String getStringValueFromDBColumn(java.sql.ResultSetMetaData rMeta, java.sql.ResultSet resultSet, int rCol)
           
 java.lang.Object getValueFromDBColumn(java.sql.ResultSetMetaData rMeta, java.sql.ResultSet resultSet, int rCol)
           
 boolean isSupportedDataType(int type)
           
 

Method Detail

addValueToSQLStatement

void addValueToSQLStatement(int type,
                            java.sql.PreparedStatement statement,
                            int position,
                            java.lang.Object value)
                            throws java.sql.SQLException
Throws:
java.sql.SQLException

convertToDBNativeVal

java.lang.Object convertToDBNativeVal(java.lang.String searchValue,
                                      int type)

createSQLValueFieldFor

java.lang.String createSQLValueFieldFor(java.lang.String dataType,
                                        java.lang.String value,
                                        boolean addPercentage,
                                        boolean searchFieldsToUpperCase)

getCurrentDateTimeSQL

java.lang.String getCurrentDateTimeSQL()

getCurrentDateTimeSQLField

java.lang.String getCurrentDateTimeSQLField()

getNextSequenceValue

java.lang.String getNextSequenceValue(java.sql.Connection con,
                                      java.lang.String sequenceName,
                                      int batchReadCount)
                                      throws java.sql.SQLException
Throws:
java.sql.SQLException

getNextSequenceValue

java.lang.String getNextSequenceValue(java.sql.Connection con,
                                      java.lang.String tableName,
                                      java.lang.String uuidFName,
                                      int batchReadCount)
                                      throws java.sql.SQLException
Throws:
java.sql.SQLException

getSQLInNullString

java.lang.String getSQLInNullString()

getStringValueFromDBColumn

java.lang.String getStringValueFromDBColumn(java.sql.ResultSetMetaData rMeta,
                                            java.sql.ResultSet resultSet,
                                            int rCol)
                                            throws java.sql.SQLException
Throws:
java.sql.SQLException

getValueFromDBColumn

java.lang.Object getValueFromDBColumn(java.sql.ResultSetMetaData rMeta,
                                      java.sql.ResultSet resultSet,
                                      int rCol)
                                      throws java.sql.SQLException
Throws:
java.sql.SQLException

isSupportedDataType

boolean isSupportedDataType(int type)