将包含两个列值的数组传递给查询- SpringJDBC

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementSetter;
import org.springframework.jdbc.core.RowMapper;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

public class ExampleDao {
    private JdbcTemplate jdbcTemplate;

    public List<ExampleEntity> queryByExampleArray(String[] exampleArray) {
        String sql = "SELECT * FROM example_table WHERE column1 = ? AND column2 = ?";
        return jdbcTemplate.query(sql, new PreparedStatementSetter() {
            @Override
            public void setValues(PreparedStatement preparedStatement) throws SQLException {
                preparedStatement.setString(1, exampleArray[0]);
                preparedStatement.setString(2, exampleArray[1]);
            }
        }, new ExampleRowMapper());
    }

    private class ExampleRowMapper implements RowMapper<ExampleEntity> {
        @Override
        public ExampleEntity mapRow(ResultSet resultSet, int i) throws SQLException {
            ExampleEntity entity = new ExampleEntity();
            entity.setColumn1(resultSet.getString("column1"));
            entity.setColumn2(resultSet.getString("column2"));
            // 设置其他属性...
            return entity;
        }
    }
}