PreparedStatement getPreparedStatementForFilter(Connection conn, String baseQuery, CmsUrlNameMappingFilter filter)
    throws SQLException {

        CmsPair<String, List<I_CmsPreparedStatementParameter>> conditionData = prepareUrlNameMappingConditions(filter);
        String whereClause = "";
        if (!conditionData.getFirst().equals("")) {
            whereClause = " WHERE " + conditionData.getFirst();
        }
        String query = baseQuery + whereClause;
        PreparedStatement stmt = m_sqlManager.getPreparedStatementForSql(conn, query);
        int counter = 1;
        for (I_CmsPreparedStatementParameter param : conditionData.getSecond()) {
            param.insertIntoStatement(stmt, counter);
            counter += 1;
        }
        return stmt;
    }
PreparedStatement getPreparedStatementForFilter ( Connection conn , String baseQuery , CmsUrlNameMappingFilter filter ) throws SQLException { CmsPair < String , List < I_CmsPreparedStatementParameter > > conditionData = prepareUrlNameMappingConditions ( filter ) ; String whereClause = "" ; if ( ! conditionData . getFirst ( ) . equals ( "" ) ) { whereClause = " WHERE " + conditionData . getFirst ( ) ; } String query = baseQuery + whereClause ; PreparedStatement stmt = m_sqlManager . getPreparedStatementForSql ( conn , query ) ; int counter = 1 ; for ( I_CmsPreparedStatementParameter param : conditionData . getSecond ( ) ) { param . insertIntoStatement ( stmt , counter ) ; counter += 1 ; } return stmt ; }
Creates a prepared statement by combining a base query with the generated SQL conditions for a given
URL name mapping filter.<p>

@param conn the connection to use for creating the prepared statement
@param baseQuery the base query to which the conditions should be appended
@param filter the filter from which to generate the conditions

@return the created prepared statement

@throws SQLException if something goes wrong