对指定的多个参数执行相同的SQL select

// 导入相关的类和包
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.InputStream;
import java.util.List;

public class DynamicSqlExample {
    public static void main(String[] args) {
        // 加载MyBatis配置文件
        InputStream inputStream = DynamicSqlExample.class.getResourceAsStream("mybatis-config.xml");
        // 创建SqlSessionFactory
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        // 创建SqlSession
        SqlSession sqlSession = sqlSessionFactory.openSession();

        try {
            // 定义参数
            String param1 = "value1";
            String param2 = "value2";
            // 构建查询条件
            String condition = "";
            if (param1 != null) {
                condition += " AND column1 = '" + param1 + "'";
            }
            if (param2 != null) {
                condition += " AND column2 = '" + param2 + "'";
            }
            // 拼接SQL语句
            String sql = "SELECT * FROM table WHERE 1=1" + condition;
            // 执行查询
            List<Object> result = sqlSession.selectList("namespace.select", sql);
            // 处理查询结果
            // ...

        } finally {
            // 关闭SqlSession
            sqlSession.close();
        }
    }
}