package com.hys.home.interceptor;import org.apache.ibatis.executor.statement.StatementHandler;import org.apache.ibatis.mapping.BoundSql;import org.apache.ibatis.plugin.*;import org.slf4j.Logger;import org.slf4j.LoggerFactory;import java.sql.Connection;import java.util.List;import java.util.Map;import java.util.Properties;@Slf4j@Intercepts({ @Signature(type = StatementHandler.class, method = "..

import java.util.List;import java.util.Map;import org.apache.ibatis.mapping.BoundSql;import org.apache.ibatis.mapping.MappedStatement;import org.apache.ibatis.session.Configuration;import org.apache.ibatis.session.SqlSessionFactory;public List> getList(Map where) { // Get the MappedStatement Configuration configuration = sqlSessionFactory.getConfiguration(); MappedStatement mappedStatem..

서비스 쿼리마다 작업해줘야 함@Servicepublic class UserService { private static final Logger logger = LoggerFactory.getLogger(UserService.class); @Autowired private UserMapper userMapper; @Autowired private SqlSessionFactory sqlSessionFactory; public List getUsersOrderedBy(String columnName) { // Prepare parameters Map params = new HashMap(); params.put("columnName", col..

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..

쿼리 쿼리 쿼리