Mybatis where절 if문으로 처리

SELECT * FROM your_table AND column1 = #{param1} AND column2 = #{param2} AND column3 LIKE CONCAT('%', #{param3}, '%')

Interceptor 생성import lombok.extern.slf4j.Slf4j;import org.apache.ibatis.executor.parameter.ParameterHandler;import org.apache.ibatis.executor.statement.StatementHandler;import org.apache.ibatis.plugin.*;import org.apache.ibatis.mapping.BoundSql;import java.sql.Connection;import java.util.Properties;@Slf4j@Intercepts({ @Signature(type = StatementHandler.class, method = "prepare", args = {Conne..

쿼리 쿼리 쿼리

// Example: Validate column names and operatorsList validColumns = Arrays.asList("column1", "column2", "column3");List validOperators = Arrays.asList("=", "", "=", "like");for (Map condition : conditions) { String column = (String) condition.get("data"); String operator = (String) condition.get("compare"); if (!validColumns.contains(column)) { throw new IllegalArgumentException("..

Mapper.xml AND ${condition.data} ${condition.compare} CASE WHEN NOT REGEXP_LIKE(#{condition.value}, '^\d+(\.\d+)?$') THEN #{condition.value} ELSE TO_CHAR(TO_NUMBER(#{condition.value})) END에러java.sql.SQLSyntaxErrorException: ORA-00932: 일관성 없는 데이터 유형: CHAR이(가) 필요하지만 NUMBER임쿼리 결과 AND DATA1 = CASE WHEN NOT REGEXP_LIKE('EX', '^\d+(\.\d+)'EX'$') THEN 'EX' ELSE ..